metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA722925" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA722925" 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
710252	710252	PRJNA722925_S_NODE_4401_length_214_cov_1.836158_g4338_i0	PRJNA722925	4401	214	1.836158	3.92937812	Cetobacterium somerae	188913	Bacteria	Bacteria	176	1.07e-39	NTclustered	gi\|2201062200\|gb\|CP092522.1\|	188913	g4338	i0	87.261	3.66822429906542	157	17	73	2	1	157	36553	36706	Cetobacterium somerae strain CS2105-BJ plasmid unnamed3, complete sequence	blastn	785	176	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1193685	1193685	PRJNA722925_S_NODE_4961_length_203_cov_8.698795_g4898_i0	PRJNA722925	4961	203	8.698795	17.65855385	root	1	Root_unresolved	Root_unresolved	375	9.24e-100	NTclustered	gi\|1973571794\|gb\|MW567136.1\|	851	g4898	i0	100	108	203	0	100	0	1	203	713	511	Fusobacterium nucleatum strain c15Ua_6_AN 16S ribosomal RNA gene, partial sequence	blastn	21924	375	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
1986312	1986312	PRJNA722925_S_NODE_802_length_461_cov_4.945755_g740_i0	PRJNA722925	802	461	4.945755	22.79993055	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	806	0	NTclustered	gi\|1276716588\|gb\|CP024703.1\|	2663009	g740	i0	98.265	481.488069414317	461	6	99	2	1	460	1342040	1342499	Fusobacterium pseudoperiodonticum strain KCOM 2305 chromosome, complete genome	blastn	221966	806	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
3261581	3261581	PRJNA722925_S_NODE_603_length_530_cov_4.563895_g544_i0	PRJNA722925	603	530	4.563895	24.1886435	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	977	0	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g544	i0	100	382.366037735849	529	0	99	0	2	530	2083166	2083694	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	202654	977	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
5813828	5813828	PRJNA722925_S_NODE_2005_length_305_cov_2.895522_g1942_i0	PRJNA722925	2005	305	2.895522	8.8313421	Leptotrichia shahii	157691	Bacteria	Bacteria	542	1.38e-149	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g1942	i0	98.689	471.432786885246	305	4	100	0	1	305	96085	96389	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	143787	542	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
7089071	7089071	PRJNA722925_S_NODE_6426_length_183_cov_1.602740_g6363_i0	PRJNA722925	6426	183	1.60274	2.9330142	Cetobacterium somerae	188913	Bacteria	Bacteria	182	1.91e-41	NTclustered	gi\|2201062200\|gb\|CP092522.1\|	188913	g6363	i0	88.125	4.51912568306011	160	9	84	9	1	153	36559	36403	Cetobacterium somerae strain CS2105-BJ plasmid unnamed3, complete sequence	blastn	827	182	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7089074	7089074	PRJNA722925_S_NODE_686_length_496_cov_8.723312_g625_i0	PRJNA722925	686	496	8.723312	43.26762752	Fusobacterium polymorphum	76857	Bacteria	Bacteria	917	0	NTclustered	gi\|2706506546\|gb\|CP084156.1\|	76857	g625	i0	100	481.137096774194	496	0	100	0	1	496	1238616	1239111	Fusobacterium polymorphum strain KCOM2510 chromosome	blastn	238644	917	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
8363553	8363553	PRJNA722925_S_NODE_2147_length_295_cov_3.604651_g2084_i0	PRJNA722925	2147	295	3.604651	10.63372045	Leptotrichia shahii	157691	Bacteria	Bacteria	507	4.86e-139	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g2084	i0	97.627	151.454237288136	295	7	100	0	1	295	94554	94260	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	44679	507	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
10914281	10914281	PRJNA722925_S_NODE_2129_length_296_cov_7.915058_g2066_i0	PRJNA722925	2129	296	7.915058	23.42857168	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	514	2.92e-141	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g2066	i0	98.294	479.219594594595	293	5	100	0	1	293	1622033	1622325	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	141849	514	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
17288298	17288298	PRJNA722925_S_NODE_1174_length_386_cov_5.217765_g1111_i0	PRJNA722925	1174	386	5.217765	20.1405729	Leptotrichia wadei	157687	Bacteria	Bacteria	647	0	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g1111	i0	97.368	355.054404145078	380	10	98	0	7	386	2368881	2368502	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	137051	647	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19045471	19045471	PRJNA722925_S_NODE_1495_length_347_cov_4.706452_g1432_i0	PRJNA722925	1495	347	4.706452	16.33138844	Leptotrichia	32067	Bacteria	Bacteria	614	3.3399999999999992e-171	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g1432	i0	98.559	495.668587896254	347	5	100	0	1	347	2075078	2074732	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	171997	614	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
19837216	19837216	PRJNA722925_S_NODE_596_length_535_cov_5.136546_g537_i0	PRJNA722925	596	535	5.136546	27.4805211	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	965	0	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g537	i0	99.252	363.018691588785	535	3	99	1	2	535	1994752	1995286	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	194215	965	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
20320104	20320104	PRJNA722925_S_NODE_3736_length_229_cov_7.833333_g3673_i0	PRJNA722925	3736	229	7.833333	17.93833257	Fusobacterium	848	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|2573686249\|gb\|CP133474.1\|	851	g3673	i0	100	481.786026200873	229	0	100	0	1	229	322039	322267	Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome	blastn	110329	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
23663300	23663300	PRJNA722925_S_NODE_4499_length_212_cov_1.691429_g4436_i0	PRJNA722925	4499	212	1.691429	3.58582948	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	387	4.5e-103	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g4436	i0	99.528	5	212	1	100	0	1	212	52020	51809	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	1060	387	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
24145226	24145226	PRJNA722925_S_NODE_499_length_580_cov_6.151013_g443_i0	PRJNA722925	499	580	6.151013	35.6758754	Fusobacterium	848	Bacteria	Bacteria	1061	0	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g443	i0	99.655	475.963793103448	580	2	100	0	1	580	243295	242716	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	276059	1061	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum

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