metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA994052" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA994052" 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
21378421	21378421	PRJNA994052_P_NODE_25237_length_294_cov_26.185520_g24000_i0	PRJNA994052	25237	294	26.18552	76.9854288	Cetobacterium	180162	Bacteria	Bacteria	180	3.95e-52	NR	WP_297407828.1	527638	g24000	i0	96.8	2.87755102040816	94	3	95.9	0	292	11	398	491	WP_297407828.1 lysine--tRNA ligase [uncultured Cetobacterium sp.]	diamond	846	181	0.994475138121547	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
26937303	26937303	PRJNA994052_P_NODE_37002_length_265_cov_7.510417_g35756_i0	PRJNA994052	37002	265	7.510417	19.90260505	Cetobacterium	180162	Bacteria	Bacteria	131	3.29e-33	NR	WP_281700265.1	188913	g35756	i0	88.8	1.8	80	9	90.6	0	263	24	609	688	WP_281700265.1 ATP-dependent zinc metalloprotease FtsH [Cetobacterium somerae]	diamond	477	131	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
27759265	27759265	PRJNA994052_P_NODE_66364_length_217_cov_28.645833_g65108_i0	PRJNA994052	66364	217	28.645833	62.16145761	Cetobacterium	180162	Bacteria	Bacteria	152	5.91e-42	NR	WP_266188097.1	188913	g65108	i0	98.6	2.98617511520737	72	1	99.5	0	216	1	215	286	WP_266188097.1 arginine--tRNA ligase, partial [Cetobacterium somerae]	diamond	648	153	0.993464052287582	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
27879381	27879381	PRJNA994052_P_NODE_76525_length_204_cov_143.206107_g75268_i0	PRJNA994052	76525	204	143.206107	292.14045828	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	119	2.41e-31	NR	WP_047393946.1	1339239	g75268	i0	93.9	0.970588235294118	66	4	97.1	0	202	5	33	98	WP_047393946.1 ThiF family adenylyltransferase [Cetobacterium sp. ZOR0034]	diamond	198	119	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
28005872	28005872	PRJNA994052_P_NODE_29245_length_284_cov_4.753555_g28003_i0	PRJNA994052	29245	284	4.753555	13.5000962	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	111	1.01e-26	NR	WP_297404590.1	527638	g28003	i0	91.4	1.83802816901408	58	5	61.3	0	279	106	174	231	WP_297404590.1 cysteine desulfurase family protein [uncultured Cetobacterium sp.]	diamond	522	111	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
29805325	29805325	PRJNA994052_P_NODE_43391_length_252_cov_35.877095_g42143_i0	PRJNA994052	43391	252	35.877095	90.4102794	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	167	3.87e-48	NR	WP_047393961.1	1339239	g42143	i0	100	0.988095238095238	83	0	98.8	0	2	250	199	281	WP_047393961.1 glutamate-1-semialdehyde 2,1-aminomutase [Cetobacterium sp. ZOR0034]	diamond	249	167	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
31100594	31100594	PRJNA994052_P_NODE_31755_length_277_cov_32.210784_g30511_i0	PRJNA994052	31755	277	32.210784	89.22387168	uncultured Fusobacterium sp.	159267	Bacteria	Bacteria	146	1.02e-39	NR	WP_294530256.1	159267	g30511	i0	77.5	2.89169675090253	89	20	96.4	0	272	6	1	89	WP_294530256.1 AAA family ATPase [uncultured Fusobacterium sp.]	diamond	801	146	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	uncultured Fusobacterium sp.
31827948	31827948	PRJNA994052_P_NODE_70837_length_211_cov_52.775362_g69581_i0	PRJNA994052	70837	211	52.775362	111.35601382	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	95.9	1.3299999999999995e-23	NR	WP_047395296.1	1339239	g69581	i0	93.8	0.909952606635071	64	4	91	0	208	17	25	88	WP_047395296.1 hypothetical protein [Cetobacterium sp. ZOR0034]	diamond	192	95.9	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
31859613	31859613	PRJNA994052_P_NODE_26937_length_290_cov_6.580645_g25697_i0	PRJNA994052	26937	290	6.580645	19.0838705	Cetobacterium sp. ZWU	2071632	Bacteria	Bacteria	167	1.51e-46	NR	WP_047384298.1	1340502	g25697	i0	90.2	1.0551724137931	102	4	99.3	1	290	3	232	333	WP_047384298.1 peptidylprolyl isomerase [Cetobacterium sp. ZWU0022]	diamond	306	167	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZWU0022
31891374	31891374	PRJNA994052_P_NODE_83097_length_197_cov_40.250000_g81840_i0	PRJNA994052	83097	197	40.25	79.2925	unclassified Cetobacterium	2630983	Bacteria	Bacteria	125	1.68e-35	NR	WP_047383851.1	2630983	g81840	i0	100	0.974619289340102	64	0	97.5	0	2	193	7	70	WP_047383851.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium]	diamond	192	125	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
32303037	32303037	PRJNA994052_P_NODE_69459_length_213_cov_22.128571_g68203_i0	PRJNA994052	69459	213	22.128571	47.13385623	Fusobacterium necrophorum	859	Bacteria	Bacteria	55.1	1.17e-7	NR	WP_187105689.1	859	g68203	i0	55.9	1.94366197183099	68	24	88.7	2	213	25	5	71	WP_187105689.1 hypothetical protein, partial [Fusobacterium necrophorum]	diamond	414	55.1	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum

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