metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJEB48872" and tax

14 rows where analysis = "diamond", bioproject = "PRJEB48872" 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
26875578	26875578	PRJEB48872_P_NODE_546561_length_181_cov_1.154930_g530749_i0	PRJEB48872	546561	181	1.15493	2.0904233	Pedobacter sp.	1411316	Bacteria	Bacteria	56.6	1.71e-7	NR	MDQ8036505.1	1411316	g530749	i0	52.9	0.845303867403315	51	23	84.5	1	177	25	100	149	MDQ8036505.1 transglutaminase-like cysteine peptidase [Pedobacter sp.]	diamond	153	56.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp.
27254669	27254669	PRJEB48872_P_NODE_572643_length_174_cov_2.488889_g556831_i0	PRJEB48872	572643	174	2.488889	4.33066686	Ginsengibacter sp.	2806034	Bacteria	Bacteria	62	2.43e-9	NR	MEP7231867.1	2806034	g556831	i0	50	1	58	29	100	0	1	174	1755	1812	MEP7231867.1 neuraminidase-like domain-containing protein [Ginsengibacter sp.]	diamond	174	62	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ginsengibacter	Ginsengibacter sp.
27349819	27349819	PRJEB48872_P_NODE_550883_length_180_cov_1.163121_g535071_i0	PRJEB48872	550883	180	1.163121	2.0936178	Hydrobacter penzbergensis	1235997	Bacteria	Bacteria	122	1.08e-30	NR	WP_092721303.1	1235997	g535071	i0	100	1	60	0	100	0	1	180	499	558	WP_092721303.1 phosphoenolpyruvate synthase [Hydrobacter penzbergensis]	diamond	180	122	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hydrobacter	Hydrobacter penzbergensis
27728889	27728889	PRJEB48872_P_NODE_458084_length_207_cov_1.869048_g442272_i0	PRJEB48872	458084	207	1.869048	3.86892936	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	137	3.7599999999999997e-38	NR	MBN8856691.1	2044944	g442272	i0	100	1	69	0	100	0	1	207	73	141	MBN8856691.1 efflux RND transporter permease subunit [Sphingobacteriales bacterium]	diamond	207	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
29023402	29023402	PRJEB48872_P_NODE_652008_length_158_cov_1.378151_g636196_i0	PRJEB48872	652008	158	1.378151	2.17747858	Bacteroidales bacterium	2030927	Bacteria	Bacteria	41.2	0.0413	NR	MBR6423569.1	2030927	g636196	i0	41.5	0.778481012658228	41	24	77.8	0	125	3	107	147	MBR6423569.1 DUF4249 domain-containing protein [Bacteroidales bacterium]	diamond	123	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29300539	29300539	PRJEB48872_P_NODE_650509_length_158_cov_1.731092_g634697_i0	PRJEB48872	650509	158	1.731092	2.73512536	Chitinophagaceae	563835	Bacteria	Bacteria	84	3.47e-17	NR	WP_072359616.1	1004	g634697	i0	72.7	10.6898734177215	44	12	83.5	0	1	132	369	412	WP_072359616.1 glycoside hydrolase family 2 protein [Chitinophaga sancti]	diamond	1689	84.3	0.99644128113879	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sancti
29307151	29307151	PRJEB48872_P_NODE_696289_length_150_cov_1.477477_g680477_i0	PRJEB48872	696289	150	1.477477	2.2162155	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	97.4	5.59e-22	NR	MBX9778929.1	1869212	g680477	i0	100	1.96	49	0	98	0	148	2	710	758	MBX9778929.1 DNA gyrase/topoisomerase IV subunit A [Chitinophagaceae bacterium]	diamond	294	97.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29401922	29401922	PRJEB48872_P_NODE_662149_length_156_cov_1.495726_g646337_i0	PRJEB48872	662149	156	1.4957260000000001	2.33333256	Deminuibacter soli	2291815	Bacteria	Bacteria	43.9	0.00442	NR	WP_116847473.1	2291815	g646337	i0	60.6	0.634615384615385	33	13	63.5	0	154	56	572	604	WP_116847473.1 glycoside hydrolase family 2 protein [Deminuibacter soli]	diamond	99	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Deminuibacter	Deminuibacter soli
29932262	29932262	PRJEB48872_P_NODE_679591_length_153_cov_1.438596_g663779_i0	PRJEB48872	679591	153	1.438596	2.20105188	Bacteroidota	976	Bacteria	Bacteria	85.5	1.51e-18	NR	NLD23840.1	2030927	g663779	i0	70	8.80392156862745	50	15	98	0	3	152	98	147	NLD23840.1 DUF1080 domain-containing protein [Bacteroidales bacterium]	diamond	1347	85.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30096579	30096579	PRJEB48872_P_NODE_561612_length_177_cov_1.586957_g545800_i0	PRJEB48872	561612	177	1.586957	2.80891389	Dyadobacter sp. OTU695	3043860	Bacteria	Bacteria	108	4.39e-27	NR	WP_342084873.1	3043860	g545800	i0	87.9	0.983050847457627	58	7	98.3	0	1	174	167	224	WP_342084873.1 3-hydroxyacyl-CoA dehydrogenase [Dyadobacter sp. OTU695]	diamond	174	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. OTU695
30602092	30602092	PRJEB48872_P_NODE_455593_length_208_cov_1.644970_g439781_i0	PRJEB48872	455593	208	1.64497	3.4215376	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	42.7	0.0241	NR	MFK8056944.1	2202734	g439781	i0	57.9	0.548076923076923	38	16	54.8	0	94	207	13	50	MFK8056944.1 M13 family metallopeptidase [Saprospiraceae bacterium]	diamond	114	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
30918331	30918331	PRJEB48872_P_NODE_526234_length_186_cov_1.843537_g510422_i0	PRJEB48872	526234	186	1.843537	3.42897882	Bacteroidales bacterium	2030927	Bacteria	Bacteria	73.9	1.72e-13	NR	NSW93609.1	2030927	g510422	i0	52.6	0.919354838709677	57	27	91.9	0	184	14	367	423	NSW93609.1 response regulator [Bacteroidales bacterium]	diamond	171	73.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31455660	31455660	PRJEB48872_P_NODE_679656_length_153_cov_1.438596_g663844_i0	PRJEB48872	679656	153	1.438596	2.20105188	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	91.3	2.7500000000000003e-21	NR	MBX9780850.1	1869212	g663844	i0	100	1	51	0	100	0	1	153	117	167	MBX9780850.1 helix-turn-helix domain-containing protein [Chitinophagaceae bacterium]	diamond	153	91.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32688684	32688684	PRJEB48872_P_NODE_382060_length_239_cov_1.265000_g366248_i0	PRJEB48872	382060	239	1.265	3.02335	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	67.8	5.2e-11	NR	MFQ5447616.1	2202734	g366248	i0	47.8	1.61924686192469	69	31	85.4	3	36	239	176	240	MFQ5447616.1 PA14 domain-containing protein [Saprospiraceae bacterium]	diamond	387	67.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae 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);;