metadata: contig_metadata: 5 rows where bioproject = "PRJNA512103" and tax_clade = "Cyanobacteriota/Melainabacteria group"

5 rows where bioproject = "PRJNA512103" 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
5590220	5590220	PRJNA512103_P_NODE_5345_length_632_cov_2.404803_g4961_i0	PRJNA512103	5345	632	2.404803	15.19835496	Cylindrospermum stagnale	142864	Bacteria	Bacteria	1007	0	NTclustered	gi\|485099135\|ref\|NR_102530.1\|	56107	g4961	i0	95.833	296.466772151899	624	25	99	1	10	632	2495	1872	Cylindrospermum stagnale PCC 7417 strain PCC 7417 23S ribosomal RNA, complete sequence	blastn	187367	1007	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
11964885	11964885	PRJNA512103_P_NODE_29270_length_173_cov_1.000000_g28858_i0	PRJNA512103	29270	173	1	1.73	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	252	1.33e-62	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g28858	i0	95.541	132.878612716763	157	7	91	0	9	165	3682357	3682201	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	22988	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
20237299	20237299	PRJNA512103_P_NODE_8676_length_422_cov_2.372654_g8265_i0	PRJNA512103	8676	422	2.372654	10.01259988	Nostocaceae	1162	Bacteria	Bacteria	595	1.5e-165	NTclustered	gi\|75699950\|gb\|CP000117.1\|	240292	g8265	i0	92.736	285.758293838863	413	29	98	1	1	413	1005440	1005029	Anabaena variabilis ATCC 29413, complete genome	blastn	120590	595	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus variabilis
25337264	25337264	PRJNA512103_P_NODE_1760_length_1349_cov_2.340769_g1565_i0	PRJNA512103	1760	1349	2.340769	31.57697381	Nostocales	1161	Bacteria	Bacteria	1013	0	NTclustered	gi\|2316438351\|gb\|CP064879.1\|	1188	g1565	i0	96.135	263.352853965901	621	22	86	2	9	629	8016240	8015622	Tolypothrix sp. PCC 7601 chromosome, complete genome	blastn	355263	1018	0.995088408644401	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. PCC 7601
29744855	29744855	PRJNA512103_P_NODE_17990_length_231_cov_1.005495_g17578_i0	PRJNA512103	17990	231	1.005495	2.32269345	root	1	Root_unresolved	Root_unresolved	107	1.39e-25	NR	WP_219045841.1	1219	g17578	i0	72.6	5.67532467532468	73	20	94.8	0	229	11	298	370	WP_219045841.1 sulfate adenylyltransferase [Prochlorococcus marinus]	diamond	1311	108	0.990740740740741	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);;