metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA663960" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA663960" 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
26606416	26606416	PRJNA663960_S_NODE_42421_length_187_cov_1.142857_g42185_i0	PRJNA663960	42421	187	1.142857	2.13714259	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	52.8	4.98e-6	NR	MBR3856713.1	2212467	g42185	i0	100	0.385026737967914	24	0	38.5	0	2	73	308	331	MBR3856713.1 hypothetical protein [Bacteroidaceae bacterium]	diamond	72	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
26891848	26891848	PRJNA663960_S_NODE_8941_length_345_cov_2.174497_g8705_i0	PRJNA663960	8941	345	2.174497	7.50201465	Prevotellaceae	171552	Bacteria	Bacteria	99.8	2.18e-24	NR	WP_074759972.1	171552	g8705	i0	66.7	1.3304347826087	75	25	65.2	0	119	343	3	77	WP_074759972.1 MULTISPECIES: DUF4134 domain-containing protein [Prevotellaceae]	diamond	459	99.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae
26954728	26954728	PRJNA663960_S_NODE_8742_length_347_cov_4.250000_g8506_i0	PRJNA663960	8742	347	4.25	14.7475	Bacteroidales bacterium	2030927	Bacteria	Bacteria	212	2.68e-67	NR	MEE0236624.1	2030927	g8506	i0	92.2	0.994236311239193	115	9	99.4	0	3	347	92	206	MEE0236624.1 CDP-alcohol phosphatidyltransferase family protein [Bacteroidales bacterium]	diamond	345	212	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
26986422	26986422	PRJNA663960_S_NODE_46962_length_177_cov_1.569231_g46726_i0	PRJNA663960	46962	177	1.569231	2.77753887	Flavobacterium psychrophilum	96345	Bacteria	Bacteria	117	3.98e-29	NR	GAW90657.1	96345	g46726	i0	100	4	59	0	100	0	177	1	10	68	GAW90657.1 hypothetical protein FPS14_contig00081-0008 [Flavobacterium psychrophilum]	diamond	708	117	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
27018164	27018164	PRJNA663960_S_NODE_39682_length_193_cov_2.280822_g39446_i0	PRJNA663960	39682	193	2.280822	4.40198646	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	41.6	0.0457	NR	RYZ13587.1	2044944	g39446	i0	37	0.839378238341969	54	34	83.9	0	179	18	64	117	RYZ13587.1 MAG: type I polyketide synthase, partial [Sphingobacteriales bacterium]	diamond	162	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
27207671	27207671	PRJNA663960_S_NODE_10362_length_330_cov_5.024735_g10126_i0	PRJNA663960	10362	330	5.024735	16.5816255	Larkinella punicea	2315727	Bacteria	Bacteria	46.6	0.00393	NR	WP_114404768.1	2315727	g10126	i0	35	0.727272727272727	80	51	71.8	1	238	2	21	100	WP_114404768.1 nucleotide-diphospho-sugar transferase [Larkinella punicea]	diamond	240	46.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Larkinella	Larkinella punicea
27997573	27997573	PRJNA663960_S_NODE_36025_length_203_cov_0.980769_g35789_i0	PRJNA663960	36025	203	0.980769	1.99096107	Bacteroidales bacterium	2030927	Bacteria	Bacteria	43.1	0.0164	NR	MDR1112562.1	2030927	g35789	i0	34.1	1.30049261083744	44	29	65	0	149	18	530	573	MDR1112562.1 fibronectin type III domain-containing protein [Bacteroidales bacterium]	diamond	264	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28186652	28186652	PRJNA663960_S_NODE_60346_length_159_cov_1.366071_g60110_i0	PRJNA663960	60346	159	1.366071	2.17205289	Bacteroidales bacterium	2030927	Bacteria	Bacteria	110	5.4300000000000006e-27	NR	MDY6463363.1	2030927	g60110	i0	98.1	1.9622641509434	52	1	98.1	0	3	158	166	217	MDY6463363.1 serine hydrolase domain-containing protein [Bacteroidales bacterium]	diamond	312	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28407952	28407952	PRJNA663960_S_NODE_19946_length_265_cov_4.114679_g19710_i0	PRJNA663960	19946	265	4.114679	10.90389935	Prevotella lacticifex	2854755	Bacteria	Bacteria	174	2.08e-48	NR	WP_223927114.1	2854755	g19710	i0	96.6	1.96981132075472	87	3	98.5	0	3	263	966	1052	WP_223927114.1 leucine-rich repeat domain-containing protein [Prevotella lacticifex]	diamond	522	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella lacticifex
28407953	28407953	PRJNA663960_S_NODE_36926_length_200_cov_2.000000_g36690_i0	PRJNA663960	36926	200	2	4	Bacteroidales bacterium	2030927	Bacteria	Bacteria	77	1.72e-14	NR	MBQ7899139.1	2030927	g36690	i0	85.4	0.615	41	6	61.5	0	123	1	520	560	MBQ7899139.1 hypothetical protein [Bacteroidales bacterium]	diamond	123	77	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29071153	29071153	PRJNA663960_S_NODE_11188_length_323_cov_2.873188_g10952_i0	PRJNA663960	11188	323	2.873188	9.28039724	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.9	0.0368	NR	MFH0894705.1	1898104	g10952	i0	40	0.557275541795666	60	33	52.9	1	75	245	194	253	MFH0894705.1 TonB-dependent receptor [Bacteroidota bacterium]	diamond	180	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29102653	29102653	PRJNA663960_S_NODE_12468_length_313_cov_1.917293_g12232_i0	PRJNA663960	12468	313	1.917293	6.00112709	Cecembia rubra	1485585	Bacteria	Bacteria	115	3.57e-29	NR	WP_304518276.1	1485585	g12232	i0	95	0.575079872204473	60	3	57.5	0	134	313	111	170	WP_304518276.1 MFS transporter, partial [Cecembia rubra]	diamond	180	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cecembia	Cecembia rubra
30081265	30081265	PRJNA663960_S_NODE_44572_length_182_cov_1.540741_g44336_i0	PRJNA663960	44572	182	1.540741	2.80414862	Bacteroidales bacterium	2030927	Bacteria	Bacteria	43.9	0.00574	NR	MCQ2327712.1	2030927	g44336	i0	55.3	0.774725274725275	47	19	74.2	2	24	158	125	171	MCQ2327712.1 endonuclease/exonuclease/phosphatase family protein [Bacteroidales bacterium]	diamond	141	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30713345	30713345	PRJNA663960_S_NODE_57114_length_162_cov_1.226087_g56878_i0	PRJNA663960	57114	162	1.226087	1.98626094	Cecembia calidifontis	1187080	Bacteria	Bacteria	101	5.55e-26	NR	WP_130274696.1	1187080	g56878	i0	98.1	0.981481481481482	53	1	98.1	0	2	160	14	66	WP_130274696.1 hypothetical protein [Cecembia calidifontis]	diamond	159	101	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cecembia	Cecembia calidifontis
31187007	31187007	PRJNA663960_S_NODE_36215_length_202_cov_1.645161_g35979_i0	PRJNA663960	36215	202	1.645161	3.32322522	Cecembia rubra	1485585	Bacteria	Bacteria	95.5	1.9e-22	NR	WP_106566092.1	1485585	g35979	i0	86.3	2.25742574257426	51	7	75.7	0	200	48	21	71	WP_106566092.1 ROK family protein [Cecembia rubra]	diamond	456	95.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cecembia	Cecembia rubra
32294835	32294835	PRJNA663960_S_NODE_11299_length_322_cov_3.178182_g11063_i0	PRJNA663960	11299	322	3.178182	10.23374604	Porphyromonadaceae bacterium	2049046	Bacteria	Bacteria	46.6	0.00138	NR	HAR37924.1	2049046	g11063	i0	50	0.354037267080745	38	19	35.4	0	10	123	83	120	HAR37924.1 hypothetical protein [Porphyromonadaceae bacterium]	diamond	114	46.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae		Porphyromonadaceae bacterium
32358020	32358020	PRJNA663960_S_NODE_29279_length_224_cov_2.881356_g29043_i0	PRJNA663960	29279	224	2.881356	6.45423744	Cecembia rubra	1485585	Bacteria	Bacteria	139	2.38e-37	NR	WP_106568352.1	1485585	g29043	i0	95.9	0.991071428571429	74	3	99.1	0	223	2	92	165	WP_106568352.1 acyclic terpene utilization AtuA family protein [Cecembia rubra]	diamond	222	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cecembia	Cecembia rubra
32496620	32496620	PRJNA663960_S_NODE_6039_length_388_cov_4.621701_g5803_i0	PRJNA663960	6039	388	4.621701	17.93219988	Candidatus Scybalocola (ex Gilroy et al. 2022)	3082845	Bacteria	Bacteria	257	1.84e-85	NR	MEE1063605.1	2748031	g5803	i0	99.2	1.97938144329897	128	1	99	0	385	2	1	128	MEE1063605.1 3-deoxy-manno-octulosonate cytidylyltransferase [Paludibacteraceae bacterium]	diamond	768	257	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
32547858	32547858	PRJNA663960_S_NODE_30379_length_220_cov_2.364162_g30143_i0	PRJNA663960	30379	220	2.364162	5.2011564	Fibrivirga algicola	2950420	Bacteria	Bacteria	125	1.2499999999999999e-34	NR	WP_208295512.1	2950420	g30143	i0	98.5	1.77272727272727	65	1	88.6	0	2	196	105	169	WP_208295512.1 ribosome maturation factor RimP [Fibrivirga algicola]	diamond	390	125	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Fibrivirga	Fibrivirga algicola

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