metadata: contig_metadata: 14 rows where bioproject = "PRJEB29441" and tax

14 rows where bioproject = "PRJEB29441" and tax_kingdom = "Fusobacteriati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2576673	2576673	PRJEB29441_P_NODE_45183_length_162_cov_1.371681_g44742_i0	PRJEB29441	45183	162	1.371681	2.22212322	Fusobacterium mortiferum	850	Bacteria	Bacteria	207	2.72e-49	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g44742	i0	90.506	280.160493827161	158	13	97	2	4	160	104186	104030	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	45386	207	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
2576805	2576805	PRJEB29441_P_NODE_843_length_1329_cov_5.054688_g695_i0	PRJEB29441	843	1329	5.054688	67.176803520000007	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	1351	0	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g695	i0	85.957	464.785553047404	1296	144	96	33	45	1323	1713153	1714427	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	617700	1351	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
4816287	4816287	PRJEB29441_P_NODE_6624_length_456_cov_17.714988_g6185_i0	PRJEB29441	6624	456	17.714988	80.78034528	Fusobacterium	848	Bacteria	Bacteria	743	0	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g6185	i0	96.07	449.449561403509	458	15	100	2	1	456	462034	461578	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	204949	749	0.991989319092123	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
10229637	10229637	PRJEB29441_P_NODE_5009_length_534_cov_3.806186_g4584_i0	PRJEB29441	5009	534	3.806186	20.32503324	Leptotrichia hofstadii	157688	Bacteria	Bacteria	948	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g4584	i0	98.689	227.677902621723	534	7	100	0	1	534	497715	498248	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	121580	948	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
11504736	11504736	PRJEB29441_P_NODE_350_length_1923_cov_12.266275_g266_i1	PRJEB29441	350	1923	12.266275	235.88046825	Fusobacterium polymorphum	76857	Bacteria	Bacteria	3408	0	NTclustered	gi\|2704883040\|gb\|CP056004.1\|	76857	g266	i1	98.649	476.91887675507	1925	23	100	2	1	1923	2319007	2320930	Fusobacterium polymorphum strain SB016 chromosome, complete genome	blastn	917115	3408	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
12779875	12779875	PRJEB29441_P_NODE_17211_length_260_cov_1.412322_g16770_i0	PRJEB29441	17211	260	1.412322	3.6720372	Sneathia vaginalis	187101	Bacteria	Bacteria	477	3.3e-130	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g16770	i0	100	385.538461538462	258	0	99	0	1	258	161146	161403	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	100240	477	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
15016035	15016035	PRJEB29441_P_NODE_15392_length_277_cov_10.864035_g14951_i0	PRJEB29441	15392	277	10.864035	30.09337695	Cetobacterium	180162	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g14951	i0	100	535.523465703971	277	0	100	0	1	277	280770	280494	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	148340	512	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17566171	17566171	PRJEB29441_P_NODE_35134_length_176_cov_1.606299_g34693_i0	PRJEB29441	35134	176	1.606299	2.82708624	Leptotrichia	32067	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|33860342\|gb\|AY349385.1\|	242674	g34693	i0	100	104.164772727273	176	0	100	0	1	176	315	140	Leptotrichia sp. oral clone GT020 16S ribosomal RNA gene, partial sequence	blastn	18333	326	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral clone GT020
19152013	19152013	PRJEB29441_P_NODE_27696_length_199_cov_2.013333_g27255_i0	PRJEB29441	27696	199	2.013333	4.00653267	Leptotrichia trevisanii	109328	Bacteria	Bacteria	344	2.5399999999999993e-90	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g27255	i0	97.98	212.120603015075	198	4	99	0	2	199	572359	572162	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	42212	344	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
19152284	19152284	PRJEB29441_P_NODE_43936_length_163_cov_1.096491_g43495_i0	PRJEB29441	43936	163	1.096491	1.78728033	Leptotrichia wadei	157687	Bacteria	Bacteria	279	5.73e-71	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g43495	i0	97.561	243.852760736196	164	2	100	2	1	163	2368806	2368968	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	39748	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19152360	19152360	PRJEB29441_P_NODE_48696_length_152_cov_2.310680_g48255_i0	PRJEB29441	48696	152	2.31068	3.5122336	Leptotrichia wadei	157687	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g48255	i0	100	384.401315789474	152	0	100	0	1	152	1693990	1694141	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	58429	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
21703567	21703567	PRJEB29441_P_NODE_48378_length_154_cov_4.600000_g47937_i0	PRJEB29441	48378	154	4.6	7.084	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	185	1.1899999999999997e-42	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g47937	i0	89.189	221.435064935065	148	16	96	0	7	154	397264	397117	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	34101	185	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
24252195	24252195	PRJEB29441_P_NODE_21640_length_227_cov_2.724719_g21199_i0	PRJEB29441	21640	227	2.724719	6.18511213	Fusobacterium mortiferum	850	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g21199	i0	100	523.066079295154	227	0	100	0	1	227	104448	104674	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	118736	420	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
24252642	24252642	PRJEB29441_P_NODE_6740_length_452_cov_2.136476_g6301_i0	PRJEB29441	6740	452	2.136476	9.65687152	Leptotrichia trevisanii	109328	Bacteria	Bacteria	797	0	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g6301	i0	98.455	479.37610619469	453	5	100	2	1	452	160212	159761	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	216678	797	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii

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