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

23 rows where bioproject = "PRJEB81327" 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
6518036	6518036	PRJEB81327_P_NODE_38866_length_263_cov_1.552632_g38258_i0	PRJEB81327	38866	263	1.552632	4.08342216	Fusobacterium animalis	76859	Bacteria	Bacteria	481	2.58e-131	NTclustered	gi\|2706483138\|gb\|CP084144.1\|	76859	g38258	i0	99.62	99.5969581749049	263	1	100	0	1	263	977984	978246	Fusobacterium animalis strain KCOM2952 chromosome, complete genome	blastn	26194	481	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
6518290	6518290	PRJEB81327_P_NODE_57986_length_245_cov_0.895349_g57378_i0	PRJEB81327	57986	245	0.895349	2.19360505	Leptotrichia wadei	157687	Bacteria	Bacteria	451	1.87e-122	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g57378	i0	100	19.2040816326531	244	0	99	0	1	244	1502651	1502408	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	4705	451	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
7374409	7374409	PRJEB81327_P_NODE_23206_length_291_cov_1.564220_g22598_i0	PRJEB81327	23206	291	1.56422	4.5518802	Cetobacterium	180162	Bacteria	Bacteria	444	3.8099999999999997e-120	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g22598	i0	94.218	5.05154639175258	294	12	100	5	1	291	761603	761894	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1470	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7792108	7792108	PRJEB81327_P_NODE_37747_length_265_cov_1.385417_g37139_i0	PRJEB81327	37747	265	1.385417	3.67135505	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	405	1.61e-108	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g37139	i0	94.318	38.8301886792453	264	15	99	0	1	264	886082	885819	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	10290	405	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
9067190	9067190	PRJEB81327_P_NODE_41408_length_259_cov_1.268817_g40800_i0	PRJEB81327	41408	259	1.268817	3.28623603	Fusobacterium polymorphum	76857	Bacteria	Bacteria	468	1.98e-127	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g40800	i0	99.228	129.135135135135	259	2	100	0	1	259	494360	494618	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	33446	468	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
9925222	9925222	PRJEB81327_P_NODE_60128_length_244_cov_0.883041_g59520_i0	PRJEB81327	60128	244	0.883041	2.15462004	Leptotrichia	32067	Bacteria	Bacteria	422	1.46e-113	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g59520	i0	97.942	19.6311475409836	243	5	99	0	2	244	1241146	1240904	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	4790	424	0.995283018867924	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
10342631	10342631	PRJEB81327_P_NODE_19229_length_310_cov_3.919831_g18621_i0	PRJEB81327	19229	310	3.919831	12.1514761	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	268	2.64e-67	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g18621	i0	99.324	0.47741935483871	148	1	48	0	1	148	272449	272302	Leptotrichia sp. oral taxon 498, complete genome	blastn	148	268	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
10342824	10342824	PRJEB81327_P_NODE_36569_length_267_cov_1.448454_g35961_i0	PRJEB81327	36569	267	1.448454	3.86737218	Cetobacterium somerae	188913	Bacteria	Bacteria	261	3.73e-65	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g35961	i0	84.559	5.00374531835206	272	32	100	10	1	267	270738	271004	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1336	261	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11618374	11618374	PRJEB81327_P_NODE_36890_length_266_cov_2.181347_g36282_i0	PRJEB81327	36890	266	2.181347	5.80238302	unclassified Cetobacterium	2630983	Bacteria	Bacteria	171	2.55e-52	NR	WP_047384116.1	2630983	g36282	i0	100	1.98496240601504	88	0	99.2	0	3	266	76	163	WP_047384116.1 MULTISPECIES: peptide deformylase [unclassified Cetobacterium]	diamond	528	171	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
12893357	12893357	PRJEB81327_P_NODE_38991_length_263_cov_1.273684_g38383_i0	PRJEB81327	38991	263	1.273684	3.34978892	Leptotrichia wadei	157687	Bacteria	Bacteria	484	1.9999999999999993e-132	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g38383	i0	100	16.9315589353612	262	0	99	0	2	263	2174190	2174451	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	4453	484	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
12893682	12893682	PRJEB81327_P_NODE_61071_length_243_cov_0.905882_g60463_i0	PRJEB81327	61071	243	0.905882	2.20129326	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g60463	i0	99.177	11.0946502057613	243	2	100	0	1	243	1546791	1546549	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	2696	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
13750667	13750667	PRJEB81327_P_NODE_69251_length_210_cov_5.839416_g68643_i0	PRJEB81327	69251	210	5.839416	12.2627736	Fusobacterium	848	Bacteria	Bacteria	388	1.24e-103	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g68643	i0	100	99.9857142857143	210	0	100	0	1	210	2319284	2319493	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	20997	388	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
15442521	15442521	PRJEB81327_P_NODE_49633_length_249_cov_1.602273_g49025_i0	PRJEB81327	49633	249	1.602273	3.98965977	Leptotrichia wadei	157687	Bacteria	Bacteria	431	2.4799999999999995e-116	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g49025	i0	97.984	32.6104417670683	248	5	99	0	2	249	697592	697345	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	8120	431	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
16716570	16716570	PRJEB81327_P_NODE_38254_length_264_cov_1.575916_g37646_i0	PRJEB81327	38254	264	1.575916	4.16041824	Fusobacterium mortiferum	850	Bacteria	Bacteria	226	1.3399999999999998e-54	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g37646	i0	91.617	0.632575757575758	167	9	63	4	99	264	2292959	2292797	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	167	226	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
17991264	17991264	PRJEB81327_P_NODE_27775_length_282_cov_1.952153_g27167_i0	PRJEB81327	27775	282	1.952153	5.50507146	Leptotrichia wadei	157687	Bacteria	Bacteria	521	1.6499999999999996e-143	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g27167	i0	100	17.9290780141844	282	0	100	0	1	282	2321433	2321152	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	5056	521	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
17991557	17991557	PRJEB81327_P_NODE_49715_length_249_cov_1.443182_g49107_i0	PRJEB81327	49715	249	1.443182	3.59352318	Leptotrichia wadei	157687	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g49107	i0	100	4.91164658634538	249	0	100	0	1	249	284328	284080	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	1223	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19265431	19265431	PRJEB81327_P_NODE_42416_length_257_cov_1.635870_g41808_i0	PRJEB81327	42416	257	1.63587	4.2041859	Leptotrichia wadei	157687	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g41808	i0	100	2.99610894941634	257	0	100	0	1	257	139074	138818	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	770	475	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19265493	19265493	PRJEB81327_P_NODE_48216_length_250_cov_0.870056_g47608_i0	PRJEB81327	48216	250	0.870056	2.17514	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g47608	i0	100	10.984	250	0	100	0	1	250	683365	683116	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	2746	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
20540802	20540802	PRJEB81327_P_NODE_38597_length_263_cov_2.315789_g37989_i0	PRJEB81327	38597	263	2.315789	6.09052507	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	420	5.71e-113	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g37989	i0	95.437	8.23954372623574	263	12	100	0	1	263	2496387	2496649	Leptotrichia sp. SK-5 DNA, complete genome	blastn	2167	420	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
23091982	23091982	PRJEB81327_P_NODE_54219_length_247_cov_0.885057_g53611_i0	PRJEB81327	54219	247	0.885057	2.18609079	Fusobacterium polymorphum	76857	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2706496642\|gb\|CP084152.1\|	76857	g53611	i0	100	849.886639676113	247	0	100	0	1	247	2158499	2158253	Fusobacterium polymorphum strain KCOM2594 chromosome, complete genome	blastn	209922	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
24365801	24365801	PRJEB81327_P_NODE_48780_length_250_cov_0.870056_g48172_i0	PRJEB81327	48780	250	0.870056	2.17514	Leptotrichia wadei	157687	Bacteria	Bacteria	449	6.87e-122	NTclustered	gi\|1791353085\|dbj\|AP019829.2\|	157687	g48172	i0	99.2	4	250	1	100	1	1	250	2130275	2130027	Leptotrichia wadei JCM16777 DNA, complete genome	blastn	1000	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
26907704	26907704	PRJEB81327_P_NODE_62362_length_242_cov_1.816568_g61754_i0	PRJEB81327	62362	242	1.816568	4.39609456	unclassified Cetobacterium	2630983	Bacteria	Bacteria	125	7.3699999999999995e-34	NR	WP_047383167.1	2630983	g61754	i0	100	0.830578512396694	67	0	83.1	0	240	40	171	237	WP_047383167.1 MULTISPECIES: basic amino acid ABC transporter substrate-binding protein [unclassified Cetobacterium]	diamond	201	125	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
27287123	27287123	PRJEB81327_P_NODE_49043_length_250_cov_0.870056_g48435_i0	PRJEB81327	49043	250	0.870056	2.17514	Leptotrichia trevisanii	109328	Bacteria	Bacteria	158	4.0399999999999996e-46	NR	WP_304181554.1	109328	g48435	i0	89	0.984	82	9	98.4	0	3	248	63	144	WP_304181554.1 nucleotidyltransferase [Leptotrichia trevisanii]	diamond	246	158	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii

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