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

15 rows where analysis = "blastn", bioproject = "PRJNA797475" 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
1216873	1216873	PRJNA797475_P_NODE_22481_length_250_cov_0.870056_g22382_i0	PRJNA797475	22481	250	0.870056	2.17514	Fusobacterium	848	Bacteria	Bacteria	411	3.239999999999999e-110	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g22382	i0	99.558	92.336	226	0	90	1	26	250	2226795	2226570	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	23084	411	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
1216895	1216895	PRJNA797475_P_NODE_29841_length_241_cov_1.392857_g29742_i0	PRJNA797475	29841	241	1.392857	3.35678537	Fusobacterium	848	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g29742	i0	98.34	101.954356846473	241	4	100	0	1	241	2288978	2288738	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	24571	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
5045046	5045046	PRJNA797475_P_NODE_14384_length_287_cov_1.177570_g14285_i0	PRJNA797475	14384	287	1.17757	3.3796259	Leptotrichia	32067	Bacteria	Bacteria	383	8.29e-102	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g14285	i0	98.611	295.108013937282	216	3	99	0	1	216	119215	119430	Leptotrichia buccalis DSM 1135, complete genome	blastn	84696	383	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
6320986	6320986	PRJNA797475_P_NODE_25505_length_246_cov_2.260116_g25406_i0	PRJNA797475	25505	246	2.260116	5.55988536	Fusobacterium	848	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2706060613\|gb\|CP077190.1\|	76859	g25406	i0	100	87.9430894308943	246	0	100	0	1	246	218800	219045	Fusobacterium animalis strain SB026 chromosome, complete genome	blastn	21634	455	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
7159717	7159717	PRJNA797475_P_NODE_16666_length_275_cov_1.326733_g16567_i0	PRJNA797475	16666	275	1.326733	3.64851575	Leptotrichia buccalis	40542	Bacteria	Bacteria	497	2.7e-136	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g16567	i0	99.273	4.96363636363636	275	2	100	0	1	275	1727401	1727127	Leptotrichia buccalis DSM 1135, complete genome	blastn	1365	497	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
7159733	7159733	PRJNA797475_P_NODE_18306_length_266_cov_2.367876_g18207_i0	PRJNA797475	18306	266	2.367876	6.29855016	Fusobacterium vincentii	155615	Bacteria	Bacteria	436	5.749999999999999e-118	NTclustered	gi\|2706461406\|gb\|CP084075.1\|	155615	g18207	i0	96.241	100	266	10	100	0	1	266	1924687	1924952	Fusobacterium vincentii strain SB055 plasmid pSB055A, complete sequence	blastn	26600	436	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium vincentii
10145431	10145431	PRJNA797475_P_NODE_16988_length_273_cov_1.540000_g16889_i0	PRJNA797475	16988	273	1.54	4.2042	Leptotrichia	32067	Bacteria	Bacteria	401	2.1599999999999994e-107	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g16889	i0	96.311	17.6849816849817	244	9	89	0	30	273	982941	983184	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	4828	405	0.990123456790123	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
11420845	11420845	PRJNA797475_P_NODE_25029_length_247_cov_0.885057_g24930_i0	PRJNA797475	25029	247	0.885057	2.18609079	Fusobacterium	848	Bacteria	Bacteria	390	4.1699999999999997e-104	NTclustered	gi\|2706454938\|gb\|CP084065.1\|	76859	g24930	i0	95.161	47.4008097165992	248	11	100	1	1	247	1944765	1945012	Fusobacterium animalis strain SB059 chromosome, complete genome	blastn	11708	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
12260817	12260817	PRJNA797475_P_NODE_15190_length_282_cov_2.454545_g15091_i0	PRJNA797475	15190	282	2.454545	6.9218169	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	521	1.6499999999999996e-143	NTclustered	gi\|1708589347\|dbj\|AP019847.1\|	554406	g15091	i0	100	3	282	0	100	0	1	282	12189	12470	Leptotrichia hongkongensis JMUB5056 plasmid pJMUB5056 DNA, complete genome	blastn	846	521	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
14809935	14809935	PRJNA797475_P_NODE_21952_length_251_cov_0.865169_g21853_i0	PRJNA797475	21952	251	0.865169	2.17157419	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	418	1.9499999999999994e-112	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g21853	i0	96.813	7.8406374501992	251	7	100	1	1	251	220180	219931	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	1968	418	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
14810063	14810063	PRJNA797475_P_NODE_30612_length_240_cov_2.215569_g30513_i0	PRJNA797475	30612	240	2.215569	5.3173656	Leptotrichia trevisanii	109328	Bacteria	Bacteria	298	2.51e-76	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g30513	i0	90.393	0.954166666666667	229	19	94	2	15	240	546481	546709	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	229	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
14810116	14810116	PRJNA797475_P_NODE_9552_length_338_cov_1.116981_g9453_i0	PRJNA797475	9552	338	1.116981	3.77539578	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	586	7.07e-163	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g9453	i0	97.929	508.949704142012	338	7	100	0	1	338	52373	52036	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	172025	586	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
17359706	17359706	PRJNA797475_P_NODE_13494_length_292_cov_1.826484_g13395_i0	PRJNA797475	13494	292	1.826484	5.33333328	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	512	1.03e-140	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g13395	i0	98.288	99.4212328767123	292	5	100	0	1	292	1184306	1184597	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	29031	512	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
21183900	21183900	PRJNA797475_P_NODE_26577_length_245_cov_0.895349_g26478_i0	PRJNA797475	26577	245	0.895349	2.19360505	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	392	1.15e-104	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g26478	i0	95.51	1	245	11	100	0	1	245	973763	974007	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	245	392	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
25007707	25007707	PRJNA797475_P_NODE_13880_length_290_cov_0.944700_g13781_i0	PRJNA797475	13880	290	0.9447	2.73963	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	514	2.85e-141	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g13781	i0	98.621	497.827586206897	290	4	100	0	1	290	2227741	2228030	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	144370	514	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii

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