metadata: contig_metadata: 21 rows where analysis = "diamond", bioproject = "PRJNA188516" and tax

21 rows where analysis = "diamond", bioproject = "PRJNA188516" 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
2916448	2916448	PRJNA188516_P_NODE_2523_length_216_cov_1.245509_g2473_i0	PRJNA188516	2523	216	1.245509	2.69029944	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	129	1.2499999999999998e-32	NR	MCA6491779.1	1869212	g2473	i0	88.7	0.986111111111111	71	8	98.6	0	213	1	9	79	MCA6491779.1 GTP-binding protein [Chitinophagaceae bacterium]	diamond	213	129	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
13119619	13119619	PRJNA188516_P_NODE_5291_length_165_cov_0.896552_g5241_i0	PRJNA188516	5291	165	0.896552	1.4793108	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	92.8	2.82e-20	NR	MCA6491874.1	1869212	g5241	i0	68.5	1.96363636363636	54	17	98.2	0	164	3	286	339	MCA6491874.1 glutamate--tRNA ligase [Chitinophagaceae bacterium]	diamond	324	92.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
20181253	20181253	PRJNA188516_P_NODE_5376_length_164_cov_0.904348_g5326_i0	PRJNA188516	5376	164	0.904348	1.48313072	Bacteroidota bacterium	1898104	Bacteria	Bacteria	111	4.56e-29	NR	MBI3519461.1	1898104	g5326	i0	96.3	5.89024390243902	54	2	98.8	0	164	3	22	75	MBI3519461.1 carbonic anhydrase [Bacteroidota bacterium]	diamond	966	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
26915716	26915716	PRJNA188516_P_NODE_4702_length_167_cov_0.881356_g4652_i0	PRJNA188516	4702	167	0.881356	1.47186452	Alloprevotella sp. oral taxon 473	712469	Bacteria	Bacteria	107	1.07e-26	NR	WP_157049618.1	712469	g4652	i0	98.2	0.988023952095808	55	1	98.8	0	166	2	78	132	WP_157049618.1 energy transducer TonB [Alloprevotella sp. oral taxon 473]	diamond	165	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Alloprevotella	Alloprevotella sp. oral taxon 473
26978997	26978997	PRJNA188516_P_NODE_5342_length_164_cov_1.252174_g5292_i0	PRJNA188516	5342	164	1.252174	2.05356536	Bacteroidales bacterium	2030927	Bacteria	Bacteria	107	2.13e-25	NR	MFO7827122.1	2030927	g5292	i0	98.1	0.98780487804878	54	1	98.8	0	163	2	949	1002	MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium]	diamond	162	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
27073905	27073905	PRJNA188516_P_NODE_5402_length_164_cov_0.904348_g5352_i0	PRJNA188516	5402	164	0.904348	1.48313072	Bacteroidota bacterium	1898104	Bacteria	Bacteria	46.6	5.58e-4	NR	MFM2017040.1	1898104	g5352	i0	52.1	0.878048780487805	48	21	87.8	1	147	4	230	275	MFM2017040.1 hypothetical protein [Bacteroidota bacterium]	diamond	144	46.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27231957	27231957	PRJNA188516_P_NODE_4603_length_167_cov_0.881356_g4553_i0	PRJNA188516	4603	167	0.881356	1.47186452	Bacteroides gallinaceum	1462571	Bacteria	Bacteria	111	1.22e-29	NR	WP_204472533.1	1462571	g4553	i0	100	1.97604790419162	55	0	98.8	0	166	2	81	135	WP_204472533.1 hypothetical protein, partial [Bacteroides gallinaceum]	diamond	330	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides gallinaceum
27295205	27295205	PRJNA188516_P_NODE_5623_length_163_cov_0.912281_g5573_i0	PRJNA188516	5623	163	0.912281	1.48701803	Paracnuella aquatica	2268757	Bacteria	Bacteria	57	1.48e-8	NR	WP_206609844.1	2268757	g5573	i0	100	0.515337423312883	28	0	51.5	0	161	78	98	125	WP_206609844.1 DUF4406 domain-containing protein [Paracnuella aquatica]	diamond	84	57	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Paracnuella	Paracnuella aquatica
28481351	28481351	PRJNA188516_P_NODE_5806_length_163_cov_0.912281_g5756_i0	PRJNA188516	5806	163	0.912281	1.48701803	Pseudomonadati	3379134	Bacteria	Bacteria	72.4	4.19e-13	NR	RKX21216.1	2053527	g5756	i0	62.3	2.92638036809816	53	20	97.5	0	161	3	43	95	RKX21216.1 MAG: hypothetical protein DRP26_00005 [Candidatus Zixiibacteriota bacterium]	diamond	477	72.4	1	Bacteria	FCB group	Pseudomonadati	Candidatus Zixiibacteriota					Candidatus Zixiibacteriota bacterium
28607622	28607622	PRJNA188516_P_NODE_4587_length_167_cov_0.881356_g4537_i0	PRJNA188516	4587	167	0.881356	1.47186452	FCB group	1783270	Bacteria	Bacteria	116	5.630000000000001e-29	NR	WP_376779807.1	976	g4537	i0	87.3	42.4850299401198	55	7	98.8	0	166	2	245	299	WP_376779807.1 MULTISPECIES: IS3 family transposase [Bacteroidota]	diamond	7095	117	0.991452991452991	Bacteria	FCB group	Pseudomonadati	Bacteroidota
28779134	28779134	PRJNA188516_P_NODE_4767_length_167_cov_0.872881_g4717_i0	PRJNA188516	4767	167	0.872881	1.45771127	Alloprevotella sp. oral taxon 473	712469	Bacteria	Bacteria	58.2	3.39e-8	NR	WP_009437126.1	712469	g4717	i0	96.3	0.48502994011976	27	1	48.5	0	85	5	1	27	WP_009437126.1 hypothetical protein [Alloprevotella sp. oral taxon 473]	diamond	81	58.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Alloprevotella	Alloprevotella sp. oral taxon 473
28810476	28810476	PRJNA188516_P_NODE_5808_length_163_cov_0.912281_g5758_i0	PRJNA188516	5808	163	0.912281	1.48701803	Bacteroidota bacterium	1898104	Bacteria	Bacteria	70.9	1.51e-12	NR	MFA6469043.1	1898104	g5758	i0	64.8	3.97546012269939	54	19	99.4	0	162	1	305	358	MFA6469043.1 aminopeptidase P N-terminal domain-containing protein [Bacteroidota bacterium]	diamond	648	70.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28937234	28937234	PRJNA188516_P_NODE_2128_length_237_cov_1.159574_g2078_i0	PRJNA188516	2128	237	1.159574	2.74819038	Salinivirgaceae bacterium	2053305	Bacteria	Bacteria	50.4	4.54e-6	NR	MFO7863651.1	2053305	g2078	i0	57.8	0.569620253164557	45	19	57	0	30	164	29	73	MFO7863651.1 hypothetical protein [Salinivirgaceae bacterium]	diamond	135	50.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Salinivirgaceae		Salinivirgaceae bacterium
29032096	29032096	PRJNA188516_P_NODE_6208_length_158_cov_2.376147_g6158_i0	PRJNA188516	6208	158	2.376147	3.75431226	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	41.2	0.04	NR	MEJ2677623.1	2026742	g6158	i0	46	0.949367088607595	50	27	94.9	0	9	158	33	82	MEJ2677623.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	150	41.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29505356	29505356	PRJNA188516_P_NODE_2970_length_198_cov_1.395973_g2920_i0	PRJNA188516	2970	198	1.395973	2.76402654	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	108	1.35e-25	NR	MCA6491779.1	1869212	g2920	i0	78.5	2.95454545454545	65	14	98.5	0	3	197	455	519	MCA6491779.1 GTP-binding protein [Chitinophagaceae bacterium]	diamond	585	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29631481	29631481	PRJNA188516_P_NODE_4430_length_168_cov_0.873950_g4380_i0	PRJNA188516	4430	168	0.87395	1.468236	Salinivirgaceae bacterium	2053305	Bacteria	Bacteria	40.4	0.0166	NR	MFO7863651.1	2053305	g4380	i0	64.5	0.553571428571429	31	11	55.4	0	26	118	42	72	MFO7863651.1 hypothetical protein [Salinivirgaceae bacterium]	diamond	93	40.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Salinivirgaceae		Salinivirgaceae bacterium
30390329	30390329	PRJNA188516_P_NODE_3013_length_197_cov_1.054054_g2963_i0	PRJNA188516	3013	197	1.054054	2.07648638	Fulvivirga ligni	2904246	Bacteria	Bacteria	73.9	2.02e-13	NR	WP_233769696.1	2904246	g2963	i0	56.9	4.52284263959391	51	22	77.7	0	26	178	374	424	WP_233769696.1 family 43 glycosylhydrolase [Fulvivirga ligni]	diamond	891	73.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga ligni
31021843	31021843	PRJNA188516_P_NODE_4115_length_169_cov_0.866667_g4065_i0	PRJNA188516	4115	169	0.866667	1.46466723	Bacteroides uniformis	820	Bacteria	Bacteria	42.7	0.00218	NR	WP_369075076.1	820	g4065	i0	45.2	0.745562130177515	42	23	74.6	0	2	127	32	73	WP_369075076.1 reverse transcriptase-like protein, partial [Bacteroides uniformis]	diamond	126	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides uniformis
31085014	31085014	PRJNA188516_P_NODE_5755_length_163_cov_0.912281_g5705_i0	PRJNA188516	5755	163	0.912281	1.48701803	uncultured Empedobacter sp.	410844	Bacteria	Bacteria	52	6.93e-6	NR	WP_295677314.1	410844	g5705	i0	52.9	0.938650306748466	51	24	93.9	0	10	162	413	463	WP_295677314.1 hypothetical protein [uncultured Empedobacter sp.]	diamond	153	52	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	uncultured Empedobacter sp.
31432738	31432738	PRJNA188516_P_NODE_5276_length_165_cov_0.896552_g5226_i0	PRJNA188516	5276	165	0.896552	1.4793108	Runella sp.	1960881	Bacteria	Bacteria	86.7	7.19e-20	NR	WP_298360685.1	1960881	g5226	i0	75.5	3.58181818181818	53	13	96.4	0	159	1	1	53	WP_298360685.1 (deoxy)nucleoside triphosphate pyrophosphohydrolase [Runella sp.]	diamond	591	86.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp.
32287248	32287248	PRJNA188516_P_NODE_2459_length_219_cov_1.088235_g2409_i0	PRJNA188516	2459	219	1.088235	2.38323465	Longimicrobium sp.	2029185	Bacteria	Bacteria	42.4	0.0363	NR	HEX8690944.1	2029185	g2409	i0	34.9	0.863013698630137	63	33	86.3	2	212	24	111	165	HEX8690944.1 sialidase family protein [Longimicrobium sp.]	diamond	189	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium 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);;