metadata: contig_metadata: 23 rows where bioproject = "PRJNA407368" and tax

23 rows where bioproject = "PRJNA407368" 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
415146	415146	PRJNA407368_S_NODE_941_length_659_cov_48.453968_g869_i0	PRJNA407368	941	659	48.453968	319.31164912	Cetobacterium somerae	188913	Bacteria	Bacteria	898	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g869	i0	98.066	412.846737481032	517	9	78	1	1	517	49407	48892	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	272066	898	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1081753	1081753	PRJNA407368_S_NODE_3401_length_319_cov_125.693103_g3299_i0	PRJNA407368	3401	319	125.693103	400.96099857	Cetobacterium	180162	Bacteria	Bacteria	505	1.91e-138	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g3299	i0	95.298	522.545454545455	319	13	100	1	1	319	278997	279313	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	166692	505	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8734512	8734512	PRJNA407368_S_NODE_1567_length_502_cov_74.217759_g1473_i0	PRJNA407368	1567	502	74.217759	372.57315018	Fusobacterium	848	Bacteria	Bacteria	761	0	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g1473	i0	94.545	476.272908366534	495	23	98	4	10	502	177620	177128	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	239089	761	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
11284957	11284957	PRJNA407368_S_NODE_10149_length_154_cov_1045.272000_g10047_i0	PRJNA407368	10149	154	1045.272	1609.71888	Streptobacillus	34104	Bacteria	Bacteria	285	1.14e-72	NTclustered	gi\|470485174\|ref\|NR_076688.1\|	34105	g10047	i0	100	453	154	0	100	0	1	154	1956	2109	Streptobacillus moniliformis strain DSM 12112 23S ribosomal RNA gene, complete sequence	blastn	69762	285	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
12560395	12560395	PRJNA407368_S_NODE_5070_length_246_cov_173.442396_g4968_i0	PRJNA407368	5070	246	173.442396	426.66829416	Cetobacterium	180162	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g4968	i0	99.593	503.012195121951	246	1	100	0	1	246	278918	278673	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	123741	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13168784	13168784	PRJNA407368_S_NODE_1551_length_505_cov_12.813025_g1457_i0	PRJNA407368	1551	505	12.813025	64.70577625	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	835	0	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g1457	i0	96.62	326.265346534653	503	17	99	0	1	503	2083834	2083332	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	164764	835	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
13835211	13835211	PRJNA407368_S_NODE_471_length_916_cov_39.527621_g430_i0	PRJNA407368	471	916	39.527621	362.07300836	Fusobacterium	848	Bacteria	Bacteria	665	0	NTclustered	gi\|2706076557\|gb\|CP077115.1\|	76857	g430	i0	98.163	371.577510917031	381	7	52	0	536	916	1461852	1462232	Fusobacterium polymorphum strain KCOM1271 chromosome, complete genome	blastn	340365	665	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
14443924	14443924	PRJNA407368_S_NODE_10132_length_155_cov_1.944444_g10030_i0	PRJNA407368	10132	155	1.944444	3.0138882	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	185	1.2e-42	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g10030	i0	88.462	19.1290322580645	156	15	100	3	1	155	53072	53225	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2965	185	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14444063	14444063	PRJNA407368_S_NODE_6592_length_206_cov_7.875706_g6490_i0	PRJNA407368	6592	206	7.875706	16.22395436	Leptotrichia hofstadii	157688	Bacteria	Bacteria	375	9.41e-100	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g6490	i0	99.515	80.8398058252427	206	1	100	0	1	206	2374575	2374780	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	16653	375	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
15109441	15109441	PRJNA407368_S_NODE_4592_length_264_cov_181.187234_g4490_i0	PRJNA407368	4592	264	181.187234	478.33429776	Cetobacterium	180162	Bacteria	Bacteria	470	5.62e-128	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g4490	i0	98.859	524.931818181818	263	3	99	0	2	264	279536	279274	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	138582	470	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18933184	18933184	PRJNA407368_S_NODE_4795_length_256_cov_77.484581_g4693_i0	PRJNA407368	4795	256	77.484581	198.36052736	Fusobacteriaceae	203492	Bacteria	Bacteria	407	4.31e-109	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g4693	i0	99.552	459.57421875	223	1	87	0	34	256	156255	156477	Fusobacterium varium strain SB069 chromosome	blastn	117651	407	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
18933211	18933211	PRJNA407368_S_NODE_8575_length_173_cov_12.041667_g8473_i0	PRJNA407368	8575	173	12.041667	20.83208391	Streptobacillus	34104	Bacteria	Bacteria	303	3.63e-78	NTclustered	gi\|470485174\|ref\|NR_076688.1\|	34105	g8473	i0	98.266	355.341040462428	173	3	100	0	1	173	2250	2078	Streptobacillus moniliformis strain DSM 12112 23S ribosomal RNA gene, complete sequence	blastn	61474	303	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
20207881	20207881	PRJNA407368_S_NODE_2516_length_383_cov_33.245763_g2414_i0	PRJNA407368	2516	383	33.245763	127.33127229	Fusobacterium	848	Bacteria	Bacteria	503	8.39e-138	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g2414	i0	90.674	494.861618798956	386	24	100	8	1	383	462454	462078	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	189532	503	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
20207884	20207884	PRJNA407368_S_NODE_2576_length_377_cov_181.097701_g2474_i0	PRJNA407368	2576	377	181.097701	682.73833277	Fusobacterium	848	Bacteria	Bacteria	664	0	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g2474	i0	98.413	487.729442970822	378	5	100	1	1	377	894	517	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	183874	669	0.992526158445441	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
21483392	21483392	PRJNA407368_S_NODE_10157_length_154_cov_71.640000_g10055_i0	PRJNA407368	10157	154	71.64	110.3256	Fusobacterium	848	Bacteria	Bacteria	265	1.4899999999999998e-66	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g10055	i0	100	455.019480519481	143	0	93	0	1	143	93070	92928	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	70073	265	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
21483410	21483410	PRJNA407368_S_NODE_2437_length_390_cov_38.919668_g2335_i0	PRJNA407368	2437	390	38.919668	151.7867052	Fusobacterium	848	Bacteria	Bacteria	704	0	NTclustered	gi\|2445153921\|gb\|CP117797.1\|	851	g2335	i0	99.231	487.730769230769	390	3	100	0	1	390	2296774	2297163	Fusobacterium nucleatum strain FNA chromosome, complete genome	blastn	190215	710	0.991549295774648	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
23367118	23367118	PRJNA407368_S_NODE_1799_length_465_cov_4.518349_g1702_i0	PRJNA407368	1799	465	4.518349	21.01032285	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	292	5.5499999999999996e-95	NR	WP_297487257.1	527638	g1702	i0	89.6	1.98709677419355	154	16	99.4	0	2	463	165	318	WP_297487257.1 YgiQ family radical SAM protein, partial [uncultured Cetobacterium sp.]	diamond	924	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
23367226	23367226	PRJNA407368_S_NODE_7599_length_187_cov_5.873418_g7497_i0	PRJNA407368	7599	187	5.873418	10.98329166	Leptotrichia hofstadii	157688	Bacteria	Bacteria	340	3.0499999999999998e-89	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g7497	i0	99.465	260.588235294118	187	1	100	0	1	187	2374956	2374770	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	48730	340	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
24033406	24033406	PRJNA407368_S_NODE_2999_length_344_cov_5.082540_g2897_i0	PRJNA407368	2999	344	5.08254	17.4839376	Fusobacterium	848	Bacteria	Bacteria	592	1.5499999999999996e-164	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g2897	i0	98.795	11.5813953488372	332	4	97	0	13	344	2128754	2129085	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	3984	597	0.991624790619765	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
24033412	24033412	PRJNA407368_S_NODE_3399_length_319_cov_177.565517_g3297_i0	PRJNA407368	3399	319	177.565517	566.43399923	Cetobacterium	180162	Bacteria	Bacteria	590	5.1299999999999986e-164	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g3297	i0	100	514.028213166144	319	0	100	0	1	319	279313	278995	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	163975	590	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25307826	25307826	PRJNA407368_S_NODE_2460_length_388_cov_25.688022_g2358_i0	PRJNA407368	2460	388	25.688022	99.66952536	Fusobacterium	848	Bacteria	Bacteria	684	0	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g2358	i0	98.953	475.420103092784	382	4	98	0	1	382	462106	461725	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	184463	689	0.992743105950653	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
27043844	27043844	PRJNA407368_S_NODE_7762_length_185_cov_2.121795_g7660_i0	PRJNA407368	7762	185	2.121795	3.92532075	Leptotrichia hofstadii F	157688	Bacteria	Bacteria	41.2	0.0217	NR	EEX74124.1	634994	g7660	i0	50	0.713513513513514	44	22	71.4	0	48	179	47	90	EEX74124.1 hypothetical protein GCWU000323_01827 [Leptotrichia hofstadii F0254]	diamond	132	41.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
30707293	30707293	PRJNA407368_S_NODE_7374_length_192_cov_2.061350_g7272_i0	PRJNA407368	7374	192	2.06135	3.957792	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	76.3	2.94e-14	NR	MBP6468532.1	2053555	g7272	i0	71.4	1.984375	63	17	98.4	1	192	4	32	93	MBP6468532.1 IS21 family transposase [Fusobacteriaceae bacterium]	diamond	381	76.3	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium

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