metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA675042" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA675042" 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
646691	646691	PRJNA675042_P_NODE_2541_length_837_cov_2.155759_g2164_i0	PRJNA675042	2541	837	2.155759	18.04370283	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	1363	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g2164	i0	96.062	465.560334528076	838	31	100	2	1	837	52439	53275	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	389674	1363	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
1922237	1922237	PRJNA675042_P_NODE_136142_length_247_cov_0.885057_g135692_i0	PRJNA675042	136142	247	0.885057	2.18609079	Cetobacterium somerae	188913	Bacteria	Bacteria	60.2	1.33e-4	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g135692	i0	100	0.129554655870445	32	0	13	0	183	214	994443	994474	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	32	60.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1922767	1922767	PRJNA675042_P_NODE_2002_length_939_cov_4.558891_g1656_i0	PRJNA675042	2002	939	4.558891	42.80798649	Leptotrichia alba	3239304	Bacteria	Bacteria	1661	0	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g1656	i0	98.718	479.42385516506903	936	10	99	2	4	939	88208	89141	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	450179	1661	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
3197748	3197748	PRJNA675042_P_NODE_30383_length_371_cov_5.234899_g29933_i0	PRJNA675042	30383	371	5.234899	19.42147529	Leptotrichia hofstadii	157688	Bacteria	Bacteria	508	1.74e-139	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g29933	i0	97.324	403.865229110512	299	8	98	0	66	364	578058	578356	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	149834	508	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
4474021	4474021	PRJNA675042_P_NODE_130884_length_248_cov_0.880000_g130434_i0	PRJNA675042	130884	248	0.88	2.1824	Cetobacterium somerae	188913	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2865364873\|gb\|CP122287.1\|	188913	g130434	i0	100	0.225806451612903	28	0	11	0	213	240	34108	34135	Cetobacterium somerae strain MSU49 plasmid p49_t8, complete sequence	blastn	56	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8299336	8299336	PRJNA675042_P_NODE_126407_length_248_cov_0.942857_g125957_i0	PRJNA675042	126407	248	0.942857	2.33828536	uncultured Ilyobacter sp.	544433	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621703980\|emb\|OY762935.1\|	544433	g125957	i0	100	0.112903225806452	28	0	11	0	3	30	995111	995138	MAG: uncultured Ilyobacter sp. isolate b034904b-4944-4ecc-b743-47c946c9bc96 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Ilyobacter	uncultured Ilyobacter sp.
9576137	9576137	PRJNA675042_P_NODE_87848_length_271_cov_3.398990_g87398_i0	PRJNA675042	87848	271	3.39899	9.2112629	uncultured Leptotrichia sp.	159271	Bacteria	Bacteria	451	2.0999999999999997e-122	NTclustered	gi\|442738856\|gb\|KC203062.1\|	159271	g87398	i0	99.595	105.036900369004	247	1	91	0	25	271	27	273	Uncultured Leptotrichia sp. clone CP4_C6 16S ribosomal RNA gene, partial sequence	blastn	28465	451	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	uncultured Leptotrichia sp.
11371607	11371607	PRJNA675042_P_NODE_181609_length_235_cov_2.962963_g181159_i0	PRJNA675042	181609	235	2.962963	6.96296305	Leptotrichia	32067	Bacteria	Bacteria	429	8.33e-116	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g181159	i0	99.574	391.697872340426	235	1	100	0	1	235	1206	972	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	92049	429	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
13921840	13921840	PRJNA675042_P_NODE_153091_length_245_cov_0.895349_g152641_i0	PRJNA675042	153091	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	54.7	0.006	NTclustered	gi\|2704998788\|gb\|CP077147.1\|	851	g152641	i0	100	0.473469387755102	29	0	12	0	217	245	610973	611001	Fusobacterium nucleatum strain KCOM2373 chromosome, complete genome	blastn	116	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
13921881	13921881	PRJNA675042_P_NODE_1651_length_1038_cov_5.862176_g1335_i0	PRJNA675042	1651	1038	5.862176	60.84938688	Cetobacterium	180162	Bacteria	Bacteria	1901	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g1335	i0	99.711	522.465317919075	1038	3	100	0	1	1038	1577911	1576874	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	542319	1901	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13922238	13922238	PRJNA675042_P_NODE_61291_length_306_cov_0.991416_g60841_i0	PRJNA675042	61291	306	0.991416	3.03373296	Fusobacterium	848	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2707713825\|gb\|CP077160.1\|	76857	g60841	i0	100	0.581699346405229	28	0	9	0	185	212	1568476	1568503	Fusobacterium polymorphum strain SB051 chromosome, complete genome	blastn	178	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
15196208	15196208	PRJNA675042_P_NODE_102252_length_255_cov_1.269231_g101802_i0	PRJNA675042	102252	255	1.269231	3.23653905	Fusobacterium	848	Bacteria	Bacteria	472	1.5e-128	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g101802	i0	100	100	255	0	100	0	1	255	305690	305944	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	25500	472	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
19773161	19773161	PRJNA675042_P_NODE_149436_length_245_cov_0.895349_g148986_i0	PRJNA675042	149436	245	0.895349	2.19360505	Fusobacterium mortiferum	850	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g148986	i0	100	0.114285714285714	28	0	11	0	75	102	567799	567826	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
19773753	19773753	PRJNA675042_P_NODE_33796_length_360_cov_1.961672_g33346_i0	PRJNA675042	33796	360	1.961672	7.0620192	Leptotrichia trevisanii	109328	Bacteria	Bacteria	259	1.87e-64	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g33346	i0	80.11	7.80277777777778	362	61	99	10	3	360	394391	394745	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	2809	259	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
19773821	19773821	PRJNA675042_P_NODE_39256_length_345_cov_4.409091_g38806_i0	PRJNA675042	39256	345	4.409091	15.21136395	Leptotrichia shahii	157691	Bacteria	Bacteria	621	1.98e-173	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g38806	i0	99.13	225.040579710145	345	3	100	0	1	345	105571	105227	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	77639	621	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
20294210	20294210	PRJNA675042_P_NODE_130816_length_248_cov_0.880000_g130366_i0	PRJNA675042	130816	248	0.88	2.1824	Leptotrichia	32067	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1708579770\|dbj\|AP019840.1\|	109328	g130366	i0	94.118	0.274193548387097	34	2	14	0	14	47	867705	867672	Leptotrichia trevisanii JMUB3935 DNA, complete genome	blastn	68	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
20294216	20294216	PRJNA675042_P_NODE_132136_length_248_cov_0.880000_g131686_i0	PRJNA675042	132136	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	52.8	0.022	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g131686	i0	96.774	0.25	31	1	13	0	164	194	2348444	2348474	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	62	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
21049153	21049153	PRJNA675042_P_NODE_182417_length_203_cov_4.038462_g181967_i0	PRJNA675042	182417	203	4.038462	8.19807786	Fusobacterium mortiferum	850	Bacteria	Bacteria	351	1.56e-92	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g181967	i0	98.02	523.004926108374	202	4	99	0	1	202	103795	103594	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	106170	351	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
23599683	23599683	PRJNA675042_P_NODE_34519_length_358_cov_1.575439_g34069_i0	PRJNA675042	34519	358	1.575439	5.64007162	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g34069	i0	100	0.159217877094972	29	0	8	0	5	33	1371681	1371709	Leptotrichia sp. SK-5 DNA, complete genome	blastn	57	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
23600104	23600104	PRJNA675042_P_NODE_6739_length_568_cov_4.250505_g6301_i0	PRJNA675042	6739	568	4.250505	24.1428684	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	928	0	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g6301	i0	96.29	477.795774647887	566	19	100	2	1	565	1064070	1064634	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	271388	928	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum

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