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

26 rows where analysis = "diamond", bioproject = "PRJEB48872" and tax_clade = "FCB group"

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
21764241	21764241	PRJEB48872_P_NODE_627178_length_163_cov_0.991935_g611366_i0	PRJEB48872	627178	163	0.991935	1.61685405	Bacteria	2	Bacteria	Bacteria	87	3e-18	NR	MBP2648438.1	2026742	g611366	i0	86.8	12.680981595092	53	7	97.5	0	3	161	436	488	MBP2648438.1 hppA [Gemmatimonadota bacterium]	diamond	2067	87.4	0.995423340961098	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
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
27911010	27911010	PRJEB48872_P_NODE_456685_length_208_cov_0.970414_g440873_i0	PRJEB48872	456685	208	0.970414	2.01846112	Bacteria	2	Bacteria	Bacteria	110	5.28e-27	NR	OGU35775.1	1798419	g440873	i0	78.3	2.98557692307692	69	15	99.5	0	2	208	62	130	OGU35775.1 MAG: hypothetical protein A2058_14460 [Ignavibacteria bacterium GWA2_36_19]	diamond	621	110	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium GWA2_36_19
28479664	28479664	PRJEB48872_P_NODE_613926_length_165_cov_2.047619_g598114_i0	PRJEB48872	613926	165	2.047619	3.37857135	Pseudomonadati	3379134	Bacteria	Bacteria	87	3.13e-18	NR	HMF88267.1	2026741	g598114	i0	69.8	7.43636363636364	53	16	96.4	0	6	164	250	302	HMF88267.1 PAS domain-containing protein [Gemmatimonadaceae bacterium]	diamond	1227	87	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae 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
29307150	29307150	PRJEB48872_P_NODE_674769_length_154_cov_1.417391_g658957_i0	PRJEB48872	674769	154	1.417391	2.18278214	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	85.5	2.16e-18	NR	MFS8637494.1	2026742	g658957	i0	78.4	12.8766233766234	51	11	99.4	0	153	1	78	128	MFS8637494.1 alpha/beta hydrolase [Gemmatimonadota bacterium]	diamond	1983	85.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
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
29489802	29489802	PRJEB48872_P_NODE_660970_length_156_cov_2.034188_g645158_i0	PRJEB48872	660970	156	2.034188	3.17333328	Pseudomonadati	3379134	Bacteria	Bacteria	82	1.52e-17	NR	HEV2752177.1	2448054	g645158	i0	75.5	6.07692307692308	53	12	100	1	1	156	66	118	HEV2752177.1 response regulator [Gemmatimonadales bacterium]	diamond	948	82	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29591006	29591006	PRJEB48872_P_NODE_692230_length_151_cov_1.214286_g676418_i0	PRJEB48872	692230	151	1.214286	1.83357186	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.7	0.00215	NR	HVH08349.1	2448054	g676418	i0	63.2	0.754966887417219	38	14	75.5	0	3	116	317	354	HVH08349.1 MASE1 domain-containing protein [Gemmatimonadales bacterium]	diamond	114	44.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29932261	29932261	PRJEB48872_P_NODE_632011_length_162_cov_1.138211_g616199_i0	PRJEB48872	632011	162	1.138211	1.84390182	Pseudomonadati	3379134	Bacteria	Bacteria	89	1.85e-20	NR	HEX7595213.1	2026741	g616199	i0	83.3	3.98148148148148	54	9	100	0	162	1	82	135	HEX7595213.1 plasmid mobilization relaxosome protein MobC [Gemmatimonadaceae bacterium]	diamond	645	89	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
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
30500749	30500749	PRJEB48872_P_NODE_574973_length_174_cov_1.348148_g559161_i0	PRJEB48872	574973	174	1.348148	2.34577752	Pseudomonadati	3379134	Bacteria	Bacteria	50.8	1.96e-5	NR	HEX9248110.1	2026741	g559161	i0	51.1	3.43103448275862	47	23	81	0	33	173	30	76	HEX9248110.1 alpha/beta hydrolase [Gemmatimonadaceae bacterium]	diamond	597	51.2	0.9921875	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
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
30823398	30823398	PRJEB48872_P_NODE_644214_length_159_cov_2.266667_g628402_i0	PRJEB48872	644214	159	2.266667	3.60400053	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	53.5	1.86e-6	NR	MDP9178993.1	2026742	g628402	i0	45.1	0.962264150943396	51	28	96.2	0	156	4	75	125	MDP9178993.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	153	53.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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
32025027	32025027	PRJEB48872_P_NODE_642398_length_160_cov_1.140496_g626586_i0	PRJEB48872	642398	160	1.140496	1.8247936	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	55.8	2.66e-7	NR	MEO7102188.1	2026741	g626586	i0	53.8	0.975	52	21	97.5	1	158	3	56	104	MEO7102188.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	156	55.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32088245	32088245	PRJEB48872_P_NODE_696318_length_150_cov_1.477477_g680506_i0	PRJEB48872	696318	150	1.477477	2.2162155	Fodinibius sp.	1872440	Bacteria	Bacteria	83.6	4.15e-17	NR	WP_322574636.1	1872440	g680506	i0	75.5	0.98	49	12	98	0	2	148	374	422	WP_322574636.1 sulfatase-like hydrolase/transferase [Fodinibius sp.]	diamond	147	83.6	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sp.
32688682	32688682	PRJEB48872_P_NODE_346160_length_257_cov_6.362385_g330348_i0	PRJEB48872	346160	257	6.362385	16.35132945	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	42.7	0.0421	NR	MBI4420926.1	2026742	g330348	i0	37.1	0.723735408560311	62	39	72.4	0	227	42	255	316	MBI4420926.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	186	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;