metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1105232" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1105232" and tax_clade = "FCB 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
1487255	1487255	PRJNA1105232_S_NODE_15722_length_167_cov_1.762712_g15506_i0	PRJNA1105232	15722	167	1.762712	2.94372904	Chryseobacterium scophthalmum	59733	Bacteria	Bacteria	176	7.969999999999999e-40	NTclustered	gi\|2653363380\|gb\|CP142423.1\|	59733	g15506	i0	85.629	1	167	24	100	0	1	167	4578219	4578053	Chryseobacterium scophthalmum strain JUb44 chromosome	blastn	167	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium scophthalmum
9948582	9948582	PRJNA1105232_S_NODE_13108_length_180_cov_1.572519_g12892_i0	PRJNA1105232	13108	180	1.572519	2.8305341999999998	Bacteroides	816	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2202814649\|gb\|CP092641.1\|	818	g12892	i0	96.875	6.04444444444444	32	0	18	1	106	137	3950871	3950901	Bacteroides thetaiotaomicron strain VPI 5482 chromosome, complete genome	blastn	1088	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides thetaiotaomicron
12499241	12499241	PRJNA1105232_S_NODE_13750_length_176_cov_2.047244_g13534_i0	PRJNA1105232	13750	176	2.047244	3.60314944	Fluviicola	332102	Bacteria	Bacteria	243	8.21e-60	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g13534	i0	91.477	13.9375	176	15	100	0	1	176	378	203	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	2453	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
16322922	16322922	PRJNA1105232_S_NODE_13453_length_178_cov_1.503876_g13237_i0	PRJNA1105232	13453	178	1.503876	2.67689928	Chryseobacterium	59732	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|1494289966\|gb\|CP033070.1\|	2478663	g13237	i0	99.438	455.808988764045	178	1	100	0	1	178	1907515	1907692	Chryseobacterium sp. 3008163 chromosome, complete genome	blastn	81134	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. 3008163
16789704	16789704	PRJNA1105232_S_NODE_13414_length_178_cov_2.015504_g13198_i0	PRJNA1105232	13414	178	2.015504	3.58759712	Flavobacterium sangjuense	2518177	Bacteria	Bacteria	113	6.81e-21	NTclustered	gi\|1616390602\|gb\|CP038810.1\|	2518177	g13198	i0	78.09	12.8202247191011	178	39	100	0	1	178	3059877	3059700	Flavobacterium sangjuense strain GS03 chromosome, complete genome	blastn	2282	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sangjuense
16789743	16789743	PRJNA1105232_S_NODE_494_length_645_cov_3.491611_g299_i0	PRJNA1105232	494	645	3.491611	22.52089095	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	1120	0	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g299	i0	97.984	537.556589147287	645	13	100	0	1	645	1906803	1906159	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	346724	1120	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
21422425	21422425	PRJNA1105232_S_NODE_10857_length_195_cov_1.424658_g10641_i0	PRJNA1105232	10857	195	1.424658	2.7780831	Fluviicola	332102	Bacteria	Bacteria	350	5.34e-92	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g10641	i0	98.974	263.189743589744	195	2	100	0	1	195	1469	1275	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	51322	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis

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