metadata: contig_metadata: 25 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax

25 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax_phylum = "Fusobacteriota"

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
5128428	5128428	PRJEB2925_P_NODE_11985_length_313_cov_2.219424_g10709_i0	PRJEB2925	11985	313	2.219424	6.94679712	Cetobacterium somerae	188913	Bacteria	Bacteria	182	9.649999999999999e-54	NR	WP_023051507.1	188913	g10709	i0	85.4	0.987220447284345	103	15	98.7	0	311	3	113	215	WP_023051507.1 cysteine desulfurase family protein [Cetobacterium somerae]	diamond	309	182	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10228912	10228912	PRJEB2925_P_NODE_4169_length_681_cov_2.702786_g3256_i0	PRJEB2925	4169	681	2.702786	18.40597266	unclassified Cetobacterium	2630983	Bacteria	Bacteria	445	1.01e-155	NR	WP_047382551.1	2630983	g3256	i0	100	0.995594713656388	226	0	99.6	0	2	679	38	263	WP_047382551.1 MULTISPECIES: 3-deoxy-7-phosphoheptulonate synthase [unclassified Cetobacterium]	diamond	678	445	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
11504211	11504211	PRJEB2925_P_NODE_6310_length_520_cov_4.754639_g5191_i0	PRJEB2925	6310	520	4.754639	24.7241228	Cetobacterium sp. ZWU	2071632	Bacteria	Bacteria	324	1.46e-111	NR	WP_052191665.1	1340502	g5191	i0	99.4	0.940384615384615	163	1	94	0	31	519	2	164	WP_052191665.1 pyridoxamine 5'-phosphate oxidase family protein [Cetobacterium sp. ZWU0022]	diamond	489	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZWU0022
14054210	14054210	PRJEB2925_P_NODE_12212_length_308_cov_1.802198_g10936_i0	PRJEB2925	12212	308	1.802198	5.55076984	Cetobacterium sp.	2071632	Bacteria	Bacteria	183	6.99e-52	NR	WP_332485160.1	2071632	g10936	i0	85.3	0.993506493506494	102	15	99.4	0	306	1	381	482	WP_332485160.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase, partial [Cetobacterium sp.]	diamond	306	183	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp.
21390224	21390224	PRJEB2925_P_NODE_12337_length_305_cov_5.100000_g11061_i0	PRJEB2925	12337	305	5.1	15.555	unclassified Cetobacterium	2630983	Bacteria	Bacteria	204	6.74e-65	NR	WP_047381341.1	2630983	g11061	i0	100	0.934426229508197	95	0	93.4	0	285	1	1	95	WP_047381341.1 MULTISPECIES: alkyl hydroperoxide reductase subunit C [unclassified Cetobacterium]	diamond	285	204	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
24251861	24251861	PRJEB2925_P_NODE_12100_length_310_cov_7.007273_g10824_i0	PRJEB2925	12100	310	7.007273	21.7225463	unclassified Cetobacterium	2630983	Bacteria	Bacteria	187	2.1e-53	NR	WP_047381582.1	2630983	g10824	i0	100	0.929032258064516	96	0	92.9	0	309	22	639	734	WP_047381582.1 MULTISPECIES: ferrous iron transport protein B [unclassified Cetobacterium]	diamond	288	187	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
27222694	27222694	PRJEB2925_P_NODE_8903_length_404_cov_2.414634_g7643_i0	PRJEB2925	8903	404	2.414634	9.75512136	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	196	2.53e-62	NR	WP_047394936.1	1339239	g7643	i0	100	0.75	101	0	75	0	43	345	1	101	WP_047394936.1 hypothetical protein [Cetobacterium sp. ZOR0034]	diamond	303	196	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
28170299	28170299	PRJEB2925_P_NODE_16566_length_240_cov_2.380488_g15288_i0	PRJEB2925	16566	240	2.380488	5.7131712	unclassified Cetobacterium	2630983	Bacteria	Bacteria	114	1.9599999999999997e-30	NR	WP_047384607.1	2630983	g15288	i0	100	0.7	56	0	70	0	168	1	67	122	WP_047384607.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium]	diamond	168	114	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
28170302	28170302	PRJEB2925_P_NODE_9846_length_371_cov_5.860119_g8574_i0	PRJEB2925	9846	371	5.860119	21.74104149	unclassified Cetobacterium	2630983	Bacteria	Bacteria	232	1.58e-76	NR	WP_047383851.1	2630983	g8574	i0	98.3	0.962264150943396	119	2	96.2	0	15	371	1	119	WP_047383851.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium]	diamond	357	232	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
28289927	28289927	PRJEB2925_P_NODE_14186_length_272_cov_2.506329_g12908_i0	PRJEB2925	14186	272	2.506329	6.81721488	Cetobacterium	180162	Bacteria	Bacteria	43.5	0.0246	NR	WP_052193983.1	1339239	g12908	i0	100	0.485294117647059	22	0	24.3	0	54	119	1	22	WP_052193983.1 outer membrane beta-barrel protein [Cetobacterium sp. ZOR0034]	diamond	132	43.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
28612371	28612371	PRJEB2925_P_NODE_13787_length_278_cov_2.205761_g12509_i0	PRJEB2925	13787	278	2.205761	6.13201558	unclassified Cetobacterium	2630983	Bacteria	Bacteria	144	6.61e-42	NR	WP_047381194.1	2630983	g12509	i0	67.9	1.20863309352518	112	1	83.1	1	278	48	56	167	WP_047381194.1 MULTISPECIES: flavodoxin [unclassified Cetobacterium]	diamond	336	144	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
28644071	28644071	PRJEB2925_P_NODE_10227_length_359_cov_2.851852_g8955_i0	PRJEB2925	10227	359	2.851852	10.23814868	unclassified Cetobacterium	2630983	Bacteria	Bacteria	128	8.95e-36	NR	WP_047381601.1	2630983	g8955	i0	100	0.768802228412256	92	0	76.9	0	20	295	1	92	WP_047381601.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium]	diamond	276	128	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
29464430	29464430	PRJEB2925_P_NODE_10310_length_357_cov_3.164596_g9038_i0	PRJEB2925	10310	357	3.164596	11.29760772	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	230	1.98e-75	NR	WP_047395902.1	1339239	g9038	i0	100	0.983193277310924	117	0	98.3	0	353	3	24	140	WP_047395902.1 hypothetical protein [Cetobacterium sp. ZOR0034]	diamond	351	230	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
29496390	29496390	PRJEB2925_P_NODE_8950_length_402_cov_8.425068_g7689_i0	PRJEB2925	8950	402	8.425068	33.86877336	Cetobacterium sp.	2071632	Bacteria	Bacteria	245	7.54e-81	NR	WP_291944692.1	2071632	g7689	i0	95.3	0.955223880597015	128	6	95.5	0	1	384	43	170	WP_291944692.1 hypothetical protein [Cetobacterium sp.]	diamond	384	245	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp.
29685506	29685506	PRJEB2925_P_NODE_6070_length_535_cov_3.464000_g4971_i0	PRJEB2925	6070	535	3.464	18.5324	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	382	6.249999999999998e-133	NR	WP_052193983.1	1339239	g4971	i0	100	0.998130841121495	178	0	99.8	0	1	534	63	240	WP_052193983.1 outer membrane beta-barrel protein [Cetobacterium sp. ZOR0034]	diamond	534	382	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
29875385	29875385	PRJEB2925_P_NODE_16831_length_232_cov_2.832487_g15553_i0	PRJEB2925	16831	232	2.832487	6.57136984	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	125	9.16e-32	NR	WP_081982797.1	1339239	g15553	i0	100	0.853448275862069	66	0	85.3	0	232	35	409	474	WP_081982797.1 sodium-dependent transporter [Cetobacterium sp. ZOR0034]	diamond	198	125	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
30033372	30033372	PRJEB2925_P_NODE_13031_length_292_cov_1.945525_g11754_i0	PRJEB2925	13031	292	1.945525	5.680933	unclassified Cetobacterium	2630983	Bacteria	Bacteria	134	2.43e-38	NR	WP_197053425.1	2630983	g11754	i0	100	0.678082191780822	66	0	67.8	0	292	95	54	119	WP_197053425.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium]	diamond	198	134	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
30159379	30159379	PRJEB2925_P_NODE_8432_length_423_cov_2.260309_g7193_i0	PRJEB2925	8432	423	2.260309	9.56110707	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	110	1.95e-28	NR	WP_294094058.1	527638	g7193	i0	80.7	0.588652482269504	83	16	58.9	0	106	354	1	83	WP_294094058.1 glycine zipper domain-containing protein [uncultured Cetobacterium sp.]	diamond	249	110	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
30318171	30318171	PRJEB2925_P_NODE_16872_length_232_cov_2.000000_g15594_i0	PRJEB2925	16872	232	2	4.64	unclassified Cetobacterium	2630983	Bacteria	Bacteria	83.2	1.78e-16	NR	WP_047381822.1	2630983	g15594	i0	62	1.02155172413793	79	28	99.6	1	231	1	107	185	WP_047381822.1 MULTISPECIES: ABC transporter substrate-binding protein [unclassified Cetobacterium]	diamond	237	83.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
30696644	30696644	PRJEB2925_P_NODE_16674_length_237_cov_2.559406_g15396_i0	PRJEB2925	16674	237	2.559406	6.06579222	unclassified Cetobacterium	2630983	Bacteria	Bacteria	105	6.5e-27	NR	WP_047380360.1	2630983	g15396	i0	100	0.658227848101266	52	0	65.8	0	158	3	38	89	WP_047380360.1 MULTISPECIES: transcription antitermination factor NusB [unclassified Cetobacterium]	diamond	156	105	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
30886348	30886348	PRJEB2925_P_NODE_10414_length_354_cov_2.109718_g9142_i0	PRJEB2925	10414	354	2.109718	7.46840172	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	167	1.4899999999999999e-46	NR	WP_047395762.1	1339239	g9142	i0	100	0.73728813559322	87	0	73.7	0	3	263	368	454	WP_047395762.1 FAD-dependent oxidoreductase [Cetobacterium sp. ZOR0034]	diamond	261	167	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
31328778	31328778	PRJEB2925_P_NODE_10896_length_340_cov_1.967213_g9622_i0	PRJEB2925	10896	340	1.967213	6.6885242	unclassified Cetobacterium	2630983	Bacteria	Bacteria	112	1.13e-28	NR	WP_047381194.1	2630983	g9622	i0	100	0.476470588235294	54	0	47.6	0	338	177	3	56	WP_047381194.1 MULTISPECIES: flavodoxin [unclassified Cetobacterium]	diamond	162	112	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
31392251	31392251	PRJEB2925_P_NODE_5236_length_590_cov_22.981982_g4213_i0	PRJEB2925	5236	590	22.981982	135.5936938	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	312	1.8299999999999997e-106	NR	WP_294095876.1	527638	g4213	i0	94.6	0.854237288135593	168	9	85.4	0	540	37	1	168	WP_294095876.1 hypothetical protein [uncultured Cetobacterium sp.]	diamond	504	312	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
32056323	32056323	PRJEB2925_P_NODE_15518_length_254_cov_2.429224_g14240_i0	PRJEB2925	15518	254	2.429224	6.17022896	unclassified Cetobacterium	2630983	Bacteria	Bacteria	63.9	1.13e-9	NR	WP_047381536.1	2630983	g14240	i0	100	0.354330708661417	30	0	35.4	0	91	2	219	248	WP_047381536.1 MULTISPECIES: NAD(P)/FAD-dependent oxidoreductase [unclassified Cetobacterium]	diamond	90	63.9	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
32751534	32751534	PRJEB2925_P_NODE_14340_length_270_cov_1.612766_g13062_i0	PRJEB2925	14340	270	1.612766	4.3544682	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	81.6	5.88e-17	NR	WP_294094651.1	527638	g13062	i0	94.9	0.433333333333333	39	2	43.3	0	268	152	76	114	WP_294094651.1 tetratricopeptide repeat protein [uncultured Cetobacterium sp.]	diamond	117	81.6	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.

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