metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA382357" 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
1678139	1678139	PRJNA382357_P_NODE_171422_length_168_cov_4.009346_g170683_i0	PRJNA382357	171422	168	4.009346	6.73570128	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	198	1.7099999999999997e-46	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g170683	i0	100	229.672619047619	107	0	99	0	62	168	54373	54267	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	38585	198	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
1679204	1679204	PRJNA382357_P_NODE_77042_length_271_cov_4.500000_g76303_i0	PRJNA382357	77042	271	4.5	12.195	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	398	2.7699999999999993e-106	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g76303	i0	100	328.059040590406	215	0	100	0	57	271	52765	52551	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	88904	398	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
5506747	5506747	PRJNA382357_P_NODE_150605_length_204_cov_0.909091_g149866_i0	PRJNA382357	150605	204	0.909091	1.85454564	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	202	1.67e-47	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g149866	i0	100	8.45588235294118	109	0	100	0	96	204	1624025	1624133	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	1725	202	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
6782006	6782006	PRJNA382357_P_NODE_7186_length_756_cov_59.873381_g6524_i0	PRJNA382357	7186	756	59.873381	452.64276036	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	1219	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g6524	i0	100	442.822751322751	660	0	100	0	1	660	52863	53522	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	334774	1219	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
7452884	7452884	PRJNA382357_P_NODE_169926_length_172_cov_4.072072_g169187_i0	PRJNA382357	169926	172	4.072072	7.00396384	Fusobacteriaceae	203492	Bacteria	Bacteria	209	8.09e-50	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g169187	i0	100	371.889534883721	113	0	66	0	1	113	156665	156777	Fusobacterium varium strain SB069 chromosome	blastn	63965	209	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
9330941	9330941	PRJNA382357_P_NODE_137048_length_210_cov_0.872483_g136309_i0	PRJNA382357	137048	210	0.872483	1.8322143	Fusobacterium nucleatum	851	Bacteria	Bacteria	283	6e-72	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g136309	i0	100	22.8095238095238	153	0	93	0	43	195	1341612	1341460	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	4790	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
9331148	9331148	PRJNA382357_P_NODE_151728_length_203_cov_14.007042_g150989_i0	PRJNA382357	151728	203	14.007042	28.43429526	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	158	3.6399999999999997e-34	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g150989	i0	97.802	96.1871921182266	91	2	45	0	103	193	398452	398542	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	19526	158	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
13156629	13156629	PRJNA382357_P_NODE_14051_length_571_cov_4.335294_g13330_i0	PRJNA382357	14051	571	4.335294	24.75452874	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	484	4.689999999999999e-132	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g13330	i0	100	94.3485113835377	262	0	96	0	5	266	51593	51854	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	53873	484	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14431991	14431991	PRJNA382357_P_NODE_16212_length_539_cov_2.443515_g15486_i0	PRJNA382357	16212	539	2.443515	13.17054585	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	952	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g15486	i0	98.521	712.502782931354	541	4	100	4	1	539	54109	53571	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	384039	952	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
15103168	15103168	PRJNA382357_P_NODE_62952_length_296_cov_7.710638_g62213_i0	PRJNA382357	62952	296	7.710638	22.82348848	Fusobacteriaceae	203492	Bacteria	Bacteria	259	1.51e-64	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g62213	i0	100	468.155405405405	140	0	100	0	157	296	157906	158045	Fusobacterium varium strain SB069 chromosome	blastn	138574	259	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
16981482	16981482	PRJNA382357_P_NODE_61994_length_298_cov_3.292479_g61255_i0	PRJNA382357	61994	298	3.292479	9.81158742	Leptotrichia wadei	157687	Bacteria	Bacteria	540	4.85e-149	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g61255	i0	99.329	145.694630872483	298	2	100	0	1	298	2368717	2368420	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	43417	540	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
17652543	17652543	PRJNA382357_P_NODE_171634_length_167_cov_7.905660_g170895_i0	PRJNA382357	171634	167	7.90566	13.2024522	Fusobacterium	848	Bacteria	Bacteria	113	6.34e-21	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g170895	i0	100	502.874251497006	61	0	100	0	1	61	107863	107803	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	83980	113	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
17652821	17652821	PRJNA382357_P_NODE_49974_length_328_cov_3.651685_g49235_i0	PRJNA382357	49974	328	3.651685	11.9775268	Leptotrichia	32067	Bacteria	Bacteria	595	1.1399999999999998e-165	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g49235	i0	99.39	692.670731707317	328	2	100	0	1	328	71251	71578	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	227196	595	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
17653147	17653147	PRJNA382357_P_NODE_90894_length_252_cov_28.821990_g90155_i0	PRJNA382357	90894	252	28.82199	72.6314148	Fusobacterium	848	Bacteria	Bacteria	283	7.44e-72	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g90155	i0	100	470.964285714286	153	0	99	0	100	252	1939	1787	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	118683	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
18926829	18926829	PRJNA382357_P_NODE_6215_length_803_cov_2.250674_g5569_i0	PRJNA382357	6215	803	2.250674	18.07291222	Leptotrichia	32067	Bacteria	Bacteria	1264	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g5569	i0	95.037	395.39103362391	806	36	100	4	1	803	1029	225	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	317499	1269	0.996059889676911	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
19529633	19529633	PRJNA382357_P_NODE_41656_length_356_cov_1.616949_g40917_i0	PRJNA382357	41656	356	1.616949	5.75633844	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	555	2.1099999999999994e-153	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g40917	i0	100	173.370786516854	300	0	100	0	1	300	2083766	2083467	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	61720	555	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
19529956	19529956	PRJNA382357_P_NODE_61456_length_299_cov_4.525210_g60717_i0	PRJNA382357	61456	299	4.52521	13.5303779	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	484	2.3099999999999998e-132	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g60717	i0	98.893	393.28762541806	271	3	91	0	29	299	1994447	1994717	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	117593	484	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
25301497	25301497	PRJNA382357_P_NODE_560_length_2081_cov_3.967822_g258_i0	PRJNA382357	560	2081	3.967822	82.57037582	Fusobacterium	848	Bacteria	Bacteria	1997	0	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g258	i0	99.908	467.592023065834	1084	1	98	0	71	1154	688638	687555	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	973059	1997	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum

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