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

5 rows where bioproject = "PRJNA380660" 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
1074294	1074294	PRJNA380660_P_NODE_9461_length_216_cov_7.502674_g9061_i0	PRJNA380660	9461	216	7.502674	16.20577584	root	1	Root_unresolved	Root_unresolved	383	5.95e-102	NTclustered	gi\|781846478\|emb\|LN807669.1\|	1211	g9061	i0	99.061	100.587962962963	213	2	99	0	4	216	260	48	Uncultured cyanobacterium partial 16S rRNA gene, clone FJ628262	blastn	21727	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
27359654	27359654	PRJNA380660_P_NODE_12003_length_169_cov_1.357143_g11603_i0	PRJNA380660	12003	169	1.357143	2.29357167	Prochlorococcus marinus	1219	Bacteria	Bacteria	61.6	3e-9	NR	WP_269622964.1	1219	g11603	i0	48.1	0.923076923076923	52	27	92.3	0	166	11	361	412	WP_269622964.1 threonine ammonia-lyase, biosynthetic [Prochlorococcus marinus]	diamond	156	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
27422910	27422910	PRJNA380660_P_NODE_3743_length_423_cov_3.718274_g3354_i0	PRJNA380660	3743	423	3.718274	15.72829902	Nostoc sp.	1180	Bacteria	Bacteria	84.3	8.16e-16	NR	WP_335051028.1	1180	g3354	i0	37.1	0.99290780141844	140	83	98.6	5	4	420	46	181	WP_335051028.1 hypothetical protein [Nostoc sp.]	diamond	420	84.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
27787170	27787170	PRJNA380660_P_NODE_6944_length_279_cov_2.308000_g6544_i0	PRJNA380660	6944	279	2.308	6.43932	Bacteria	2	Bacteria	Bacteria	119	5.33e-29	NR	OGB89762.1	1802564	g6544	i0	59.1	22.3763440860215	93	38	100	0	1	279	1336	1428	OGB89762.1 MAG: glutamate synthase subunit alpha [candidate division WOR-1 bacterium RIFCSPHIGHO2_01_FULL_53_15]	diamond	6243	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati						candidate division WOR-1 bacterium RIFCSPHIGHO2_01_FULL_53_15
32635477	32635477	PRJNA380660_P_NODE_9900_length_209_cov_1.466667_g9500_i0	PRJNA380660	9900	209	1.466667	3.06533403	Geminocystis sp. GBBB	2664100	Bacteria	Bacteria	58.9	8.5e-9	NR	WP_308255855.1	2604140	g9500	i0	67.6	1.62200956937799	37	12	53.1	0	172	62	116	152	WP_308255855.1 hypothetical protein [Geminocystis sp. GBBB08]	diamond	339	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. GBBB08

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);;