metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1046144" and tax_clade = "Cyanobacteriota/Melainabacteria group"

8 rows where analysis = "blastn", bioproject = "PRJNA1046144" and tax_clade = "Cyanobacteriota/Melainabacteria group"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
172151	172151	PRJNA1046144_P_NODE_32421_length_297_cov_1.228070_g32126_i0	PRJNA1046144	32421	297	1.22807	3.6473679	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	278	4.18e-70	NTclustered	gi\|225696213\|gb\|FJ805880.1\|	259957	g32126	i0	84.354	115.86531986532	294	35	98	9	8	297	2986	2700	Uncultured Chroococcidiopsis sp. clone A3_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34412	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
172948	172948	PRJNA1046144_P_NODE_71281_length_216_cov_2.551020_g70986_i0	PRJNA1046144	71281	216	2.55102	5.5102032	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	202	1.7899999999999995e-47	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g70986	i0	83.636	183.435185185185	220	30	100	4	1	216	3681580	3681797	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	39622	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
1446765	1446765	PRJNA1046144_P_NODE_27742_length_317_cov_1.161290_g27447_i0	PRJNA1046144	27742	317	1.16129	3.6812893	Geminocystis sp. NIES-3708	1615909	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|770466698\|dbj\|AP014815.1\|	1615909	g27447	i0	100	0.0883280757097792	28	0	9	0	108	135	5574	5547	Geminocystis sp. NIES-3708 DNA, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3708
7825291	7825291	PRJNA1046144_P_NODE_58147_length_234_cov_0.872727_g57852_i0	PRJNA1046144	58147	234	0.872727	2.04218118	Planktothrix agardhii	1160	Bacteria	Bacteria	303	5.24e-78	NTclustered	gi\|2261157456\|emb\|LR882949.1\|	1160	g57852	i0	90.129	0.995726495726496	233	23	99	0	2	234	931000	930768	Planktothrix agardhii strain No.758 genome assembly, chromosome: I	blastn	233	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
11650591	11650591	PRJNA1046144_P_NODE_26690_length_322_cov_1.707510_g26395_i0	PRJNA1046144	26690	322	1.70751	5.4981822	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	331	3.47e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g26395	i0	87.762	20.7639751552795	286	32	88	3	1	284	2594040	2594324	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	6686	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
14201261	14201261	PRJNA1046144_P_NODE_532_length_1753_cov_12.915677_g486_i0	PRJNA1046144	532	1753	12.915677	226.41181781	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1919	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g486	i0	86.505	98.9771819737593	1771	210	100	28	1	1753	3682670	3680911	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	173507	1919	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
16749451	16749451	PRJNA1046144_P_NODE_50794_length_246_cov_1.412429_g50499_i0	PRJNA1046144	50794	246	1.412429	3.47457534	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	407	4.12e-109	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g50499	i0	97.107	148.459349593496	242	5	98	2	7	246	2219	2460	Uncultured Chroococcidiopsis sp. clone A1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36521	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21848746	21848746	PRJNA1046144_P_NODE_14218_length_425_cov_4.081461_g13923_i0	PRJNA1046144	14218	425	4.081461	17.34620925	Prochlorococcus marinus	1219	Bacteria	Bacteria	58.4	8.8e-4	NTclustered	gi\|2417453587\|gb\|CP114777.1\|	3015000	g13923	i0	97.059	0.08	34	1	8	0	3	36	405164	405131	Prochlorococcus marinus str. MIT 1214 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;