metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1169999" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1169999" and tax_phylum = "Bacteroidota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
18166834	18166834	PRJNA1169999_P_NODE_3955_length_243_cov_0.905882_g3919_i0	PRJNA1169999	3955	243	0.905882	2.20129326	Chryseobacterium artocarpi	1414727	Bacteria	Bacteria	160	1.7199999999999998e-47	NR	WP_123862043.1	1414727	g3919	i0	96.3	1.97530864197531	80	3	98.8	0	2	241	4	83	WP_123862043.1 hypothetical protein [Chryseobacterium artocarpi]	diamond	480	160	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium artocarpi
24541166	24541166	PRJNA1169999_P_NODE_3180_length_248_cov_0.880000_g3144_i0	PRJNA1169999	3180	248	0.88	2.1824	Sphingobacterium sp. CZ-UAM	1933868	Bacteria	Bacteria	163	9.59e-45	NR	WP_077437622.1	1933868	g3144	i0	92.7	2.9758064516129	82	6	99.2	0	247	2	261	342	WP_077437622.1 glycosyltransferase [Sphingobacterium sp. CZ-UAM]	diamond	738	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp. CZ-UAM
27956584	27956584	PRJNA1169999_P_NODE_2725_length_251_cov_0.865169_g2689_i0	PRJNA1169999	2725	251	0.865169	2.17157419	Bacteroidetes bacterium 47-18	1895926	Bacteria	Bacteria	85.1	4.48e-18	NR	OJU78040.1	1895926	g2689	i0	72	0.597609561752988	50	14	59.8	0	99	248	44	93	OJU78040.1 MAG: hypothetical protein BGO09_02325 [Bacteroidetes bacterium 47-18]	diamond	150	85.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium 47-18
27988142	27988142	PRJNA1169999_P_NODE_3905_length_243_cov_0.905882_g3869_i0	PRJNA1169999	3905	243	0.905882	2.20129326	Alistipes sp.	1872444	Bacteria	Bacteria	41.2	0.042	NR	MBQ2008698.1	1872444	g3869	i0	37.3	0.62962962962963	51	30	60.5	1	13	159	36	86	MBQ2008698.1 hypothetical protein [Alistipes sp.]	diamond	153	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes sp.
28165230	28165230	PRJNA1169999_P_NODE_3565_length_246_cov_0.890173_g3529_i0	PRJNA1169999	3565	246	0.890173	2.18982558	Flavobacteriales	200644	Bacteria	Bacteria	165	2.84e-45	NR	HCC94653.1	1871037	g3529	i0	100	2	82	0	100	0	1	246	50	131	HCC94653.1 hypothetical protein [Flavobacteriaceae bacterium]	diamond	492	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
28619767	28619767	PRJNA1169999_P_NODE_1867_length_281_cov_1.240385_g1831_i0	PRJNA1169999	1867	281	1.240385	3.48548185	Soonwooa buanensis	619805	Bacteria	Bacteria	186	4.399999999999999e-58	NR	WP_245797170.1	619805	g1831	i0	95.7	0.99288256227758	93	4	99.3	0	280	2	27	119	WP_245797170.1 GNAT family N-acetyltransferase [Soonwooa buanensis]	diamond	279	186	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Soonwooa	Soonwooa buanensis
29787642	29787642	PRJNA1169999_P_NODE_3911_length_243_cov_0.905882_g3875_i0	PRJNA1169999	3911	243	0.905882	2.20129326	Chryseobacterium ureilyticum	373668	Bacteria	Bacteria	163	6.06e-49	NR	WP_076552738.1	373668	g3875	i0	97.5	0.987654320987654	80	2	98.8	0	241	2	78	157	WP_076552738.1 protein-tyrosine-phosphatase [Chryseobacterium ureilyticum]	diamond	240	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium ureilyticum
30134968	30134968	PRJNA1169999_P_NODE_2572_length_254_cov_1.160221_g2536_i0	PRJNA1169999	2572	254	1.160221	2.94696134	Sphingobacterium sp.	341027	Bacteria	Bacteria	59.3	5.9e-8	NR	WP_309362700.1	341027	g2536	i0	100	0.354330708661417	30	0	35.4	0	165	254	1	30	WP_309362700.1 thioredoxin-like domain-containing protein [Sphingobacterium sp.]	diamond	90	59.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp.
30703968	30703968	PRJNA1169999_P_NODE_4114_length_242_cov_0.911243_g4078_i0	PRJNA1169999	4114	242	0.911243	2.20520806	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.5	0.00542	NR	BCX01359.1	1898104	g4078	i0	54.3	0.433884297520661	35	15	42.1	1	139	38	2	36	BCX01359.1 MAG: hypothetical protein KatS3mg041_1405 [Bacteroidota bacterium]	diamond	105	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30925414	30925414	PRJNA1169999_P_NODE_3634_length_245_cov_0.895349_g3598_i0	PRJNA1169999	3634	245	0.895349	2.19360505	Chryseobacterium artocarpi	1414727	Bacteria	Bacteria	153	5.859999999999998e-41	NR	WP_065393759.1	1414727	g3598	i0	98.8	0.991836734693878	81	1	99.2	0	1	243	477	557	WP_065393759.1 choice-of-anchor L domain-containing protein [Chryseobacterium artocarpi]	diamond	243	153	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium artocarpi
31051843	31051843	PRJNA1169999_P_NODE_1475_length_301_cov_0.807018_g1439_i0	PRJNA1169999	1475	301	0.807018	2.42912418	Bacteroidales bacterium	2030927	Bacteria	Bacteria	43.5	0.0366	NR	MDO4715580.1	2030927	g1439	i0	41.2	0.508305647840532	51	28	48.8	1	108	254	200	250	MDO4715580.1 glycoside hydrolase family 127 protein [Bacteroidales bacterium]	diamond	153	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31589299	31589299	PRJNA1169999_P_NODE_3196_length_248_cov_0.880000_g3160_i0	PRJNA1169999	3196	248	0.88	2.1824	Chitinophaga sp.	1869181	Bacteria	Bacteria	170	3.83e-48	NR	MBA4196790.1	1869181	g3160	i0	100	0.991935483870968	82	0	99.2	0	246	1	169	250	MBA4196790.1 carbamoyltransferase [Chitinophaga sp.]	diamond	246	170	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sp.
31747159	31747159	PRJNA1169999_P_NODE_1677_length_288_cov_1.148837_g1641_i0	PRJNA1169999	1677	288	1.148837	3.30865056	Hydrotalea sp. AMD	2501297	Bacteria	Bacteria	141	2.88e-38	NR	WP_287101355.1	2501297	g1641	i0	86.1	0.822916666666667	79	11	82.3	0	1	237	290	368	WP_287101355.1 hypothetical protein [Hydrotalea sp. AMD]	diamond	237	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hydrotalea	Hydrotalea sp. AMD
31968618	31968618	PRJNA1169999_P_NODE_3478_length_246_cov_0.890173_g3442_i0	PRJNA1169999	3478	246	0.890173	2.18982558	Leadbetterella sp. DM7	3235085	Bacteria	Bacteria	162	4.109999999999999e-47	NR	WP_367913542.1	3235085	g3442	i0	96.3	1	82	3	100	0	246	1	63	144	WP_367913542.1 beta-ketoacyl-ACP synthase III [Leadbetterella sp. DM7]	diamond	246	162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Leadbetterella	Leadbetterella sp. DM7
32632593	32632593	PRJNA1169999_P_NODE_4200_length_241_cov_0.916667_g4164_i0	PRJNA1169999	4200	241	0.916667	2.20916747	Chryseolinea sp.	2059303	Bacteria	Bacteria	135	3.67e-36	NR	HKZ38968.1	2059303	g4164	i0	83.5	0.983402489626556	79	13	98.3	0	2	238	239	317	HKZ38968.1 SusD/RagB family nutrient-binding outer membrane lipoprotein [Chryseolinea sp.]	diamond	237	135	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Chryseolinea	Chryseolinea 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);;