metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA688414" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA688414" 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
667014	667014	PRJNA688414_P_NODE_5881_length_253_cov_0.866667_g5847_i0	PRJNA688414	5881	253	0.866667	2.19266751	Flavitalea sp.	1909289	Bacteria	Bacteria	125	8.89e-35	NR	HKH63569.1	1909289	g5847	i0	96.8	0.735177865612648	62	2	73.5	0	251	66	81	142	HKH63569.1 GNAT family N-acetyltransferase [Flavitalea sp.]	diamond	186	125	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavitalea	Flavitalea sp.
14695969	14695969	PRJNA688414_P_NODE_7172_length_247_cov_0.896552_g7138_i0	PRJNA688414	7172	247	0.896552	2.21448344	Bacteria	2	Bacteria	Bacteria	131	1.9e-34	NR	HJU74115.1	2026741	g7138	i0	90.1	2.58704453441296	71	7	86.2	0	2	214	349	419	HJU74115.1 amidohydrolase family protein [Gemmatimonadaceae bacterium]	diamond	639	132	0.992424242424242	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
17754667	17754667	PRJNA688414_P_NODE_6834_length_249_cov_0.886364_g6800_i0	PRJNA688414	6834	249	0.886364	2.20704636	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	173	2.74e-50	NR	HKO82294.1	1869212	g6800	i0	95.2	5	83	4	100	0	1	249	226	308	HKO82294.1 2-oxoacid:acceptor oxidoreductase subunit alpha [Chitinophagaceae bacterium]	diamond	1245	173	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
26861078	26861078	PRJNA688414_P_NODE_7621_length_245_cov_0.906977_g7587_i0	PRJNA688414	7621	245	0.906977	2.22209365	Bacteroidetes bacterium SW_9_63_38	1919118	Bacteria	Bacteria	62.8	1.9e-9	NR	PSQ95989.1	1919118	g7587	i0	42.1	2.80408163265306	76	39	90.6	2	5	226	102	174	PSQ95989.1 MAG: type I-E CRISPR-associated protein Cas6/Cse3/CasE [Bacteroidetes bacterium SW_9_63_38]	diamond	687	62.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium SW_9_63_38
27587851	27587851	PRJNA688414_P_NODE_4484_length_287_cov_1.210280_g4450_i0	PRJNA688414	4484	287	1.21028	3.4735036	Bacteroidota bacterium	1898104	Bacteria	Bacteria	171	8.2e-51	NR	MES2134560.1	1898104	g4450	i0	92.6	0.993031358885017	95	7	99.3	0	287	3	57	151	MES2134560.1 hypothetical protein [Bacteroidota bacterium]	diamond	285	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27998394	27998394	PRJNA688414_P_NODE_6805_length_249_cov_0.886364_g6771_i0	PRJNA688414	6805	249	0.886364	2.20704636	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	86.7	8.66e-18	NR	HET9826812.1	1869212	g6771	i0	56.6	1	83	35	98.8	1	3	248	21	103	HET9826812.1 S8 family serine peptidase [Chitinophagaceae bacterium]	diamond	249	86.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
28092914	28092914	PRJNA688414_P_NODE_6585_length_250_cov_0.881356_g6551_i0	PRJNA688414	6585	250	0.881356	2.20339	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	97.4	4.98e-22	NR	MBX9780615.1	1869212	g6551	i0	87	0.648	54	7	64.8	0	87	248	1	54	MBX9780615.1 alpha/beta hydrolase [Chitinophagaceae bacterium]	diamond	162	97.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
28124559	28124559	PRJNA688414_P_NODE_6165_length_252_cov_0.871508_g6131_i0	PRJNA688414	6165	252	0.871508	2.19620016	Ferruginibacter yonginensis	1310416	Bacteria	Bacteria	47.4	6.17e-5	NR	WP_379708971.1	1310416	g6131	i0	55.9	0.404761904761905	34	15	40.5	0	1	102	20	53	WP_379708971.1 DUF2158 domain-containing protein [Ferruginibacter yonginensis]	diamond	102	47.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter yonginensis
30113748	30113748	PRJNA688414_P_NODE_7092_length_248_cov_0.891429_g7058_i0	PRJNA688414	7092	248	0.891429	2.21074392	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	133	2.33e-34	NR	HEY8259192.1	2448054	g7058	i0	82.9	3.96774193548387	82	14	99.2	0	1	246	497	578	HEY8259192.1 ABC transporter ATP-binding protein [Gemmatimonadales bacterium]	diamond	984	133	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30176926	30176926	PRJNA688414_P_NODE_7432_length_246_cov_0.901734_g7398_i0	PRJNA688414	7432	246	0.901734	2.21826564	Prevotella sp.	59823	Bacteria	Bacteria	175	2.59e-53	NR	MBP7856725.1	59823	g7398	i0	97.6	1	82	2	100	0	246	1	108	189	MBP7856725.1 ribonuclease HII [Prevotella sp.]	diamond	246	175	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
30367022	30367022	PRJNA688414_P_NODE_6232_length_252_cov_0.871508_g6198_i0	PRJNA688414	6232	252	0.871508	2.19620016	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	125	1.9099999999999998e-31	NR	NQW27890.1	2026740	g6198	i0	69.3	0.892857142857143	75	23	89.3	0	4	228	486	560	NQW27890.1 DUF2779 domain-containing protein [Flammeovirgaceae bacterium]	diamond	225	125	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
31187753	31187753	PRJNA688414_P_NODE_8035_length_243_cov_0.917647_g8001_i0	PRJNA688414	8035	243	0.917647	2.22988221	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	50.4	6.83e-5	NR	MCS7176967.1	2447898	g8001	i0	44.1	0.839506172839506	68	35	84	1	39	242	3	67	MCS7176967.1 HAF repeat-containing protein [Candidatus Kapaibacterium sp.]	diamond	204	50.4	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
32800214	32800214	PRJNA688414_P_NODE_7440_length_246_cov_0.901734_g7406_i0	PRJNA688414	7440	246	0.901734	2.21826564	Terrimonas ginsenosidimutans	2908004	Bacteria	Bacteria	94.7	1.03e-21	NR	WP_237875516.1	2908004	g7406	i0	70.9	1.29268292682927	55	16	67.1	0	21	185	183	237	WP_237875516.1 DUF5131 family protein [Terrimonas ginsenosidimutans]	diamond	318	94.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Terrimonas	Terrimonas ginsenosidimutans

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