metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1002816" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1002816" 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
21829561	21829561	PRJNA1002816_P_NODE_10698_length_341_cov_0.985075_g10538_i0	PRJNA1002816	10698	341	0.985075	3.35910575	Bacteria	2	Bacteria	Bacteria	199	3.57e-59	NR	MBN2729061.1	2030927	g10538	i0	82.3	24.7741935483871	113	20	99.4	0	339	1	303	415	MBN2729061.1 NADP-dependent malic enzyme [Bacteroidales bacterium]	diamond	8448	199	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
27065937	27065937	PRJNA1002816_P_NODE_16322_length_265_cov_1.005208_g16162_i0	PRJNA1002816	16322	265	1.005208	2.6638012	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	61.6	3.35e-10	NR	MFM7855049.1	2026740	g16162	i0	87.9	0.373584905660377	33	4	37.4	0	189	91	31	63	MFM7855049.1 epiplasmin family protein [Flammeovirgaceae bacterium]	diamond	99	61.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
27571578	27571578	PRJNA1002816_P_NODE_20124_length_243_cov_0.905882_g19964_i0	PRJNA1002816	20124	243	0.905882	2.20129326	Tidjanibacter sp.	1929085	Bacteria	Bacteria	43.5	0.0194	NR	MBR4850700.1	1929085	g19964	i0	32.7	0.679012345679012	55	37	67.9	0	193	29	406	460	MBR4850700.1 C10 family peptidase [Tidjanibacter sp.]	diamond	165	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Tidjanibacter	Tidjanibacter sp.
27785385	27785385	PRJNA1002816_P_NODE_14564_length_286_cov_1.117371_g14404_i0	PRJNA1002816	14564	286	1.117371	3.19568106	Bacteria	2	Bacteria	Bacteria	102	1.48e-23	NR	MDP4205870.1	1898104	g14404	i0	51.6	2.96853146853147	95	46	99.7	0	286	2	76	170	MDP4205870.1 ADP-forming succinate--CoA ligase subunit beta [Bacteroidota bacterium]	diamond	849	103	0.990291262135922	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29395463	29395463	PRJNA1002816_P_NODE_18209_length_249_cov_0.875000_g18049_i0	PRJNA1002816	18209	249	0.875	2.17875	FCB group	1783270	Bacteria	Bacteria	129	1.47e-32	NR	WP_091510171.1	998	g18049	i0	78.2	29.2771084337349	78	17	94	0	234	1	596	673	WP_091510171.1 aminomethyl-transferring glycine dehydrogenase [Flexibacter flexilis]	diamond	7290	130	0.992307692307692	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flexibacteraceae	Flexibacter	Flexibacter flexilis
30160591	30160591	PRJNA1002816_P_NODE_19452_length_245_cov_0.895349_g19292_i0	PRJNA1002816	19452	245	0.895349	2.19360505	Bacteroidales bacterium	2030927	Bacteria	Bacteria	42.7	0.0273	NR	MEE0429485.1	2030927	g19292	i0	41.7	0.587755102040816	48	28	58.8	0	145	2	30	77	MEE0429485.1 lysophospholipid acyltransferase family protein [Bacteroidales bacterium]	diamond	144	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31424840	31424840	PRJNA1002816_P_NODE_15756_length_272_cov_0.914573_g15596_i0	PRJNA1002816	15756	272	0.914573	2.48763856	Crocinitomicaceae bacterium	2026728	Bacteria	Bacteria	167	1.09e-51	NR	MDD2984732.1	2026728	g15596	i0	94.9	0.871323529411765	79	4	87.1	0	3	239	1	79	MDD2984732.1 hypothetical protein [Crocinitomicaceae bacterium]	diamond	237	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae		Crocinitomicaceae bacterium
32405691	32405691	PRJNA1002816_P_NODE_14179_length_290_cov_1.336406_g14019_i0	PRJNA1002816	14179	290	1.336406	3.8755774	Crocinitomicaceae bacterium	2026728	Bacteria	Bacteria	172	6.79e-52	NR	MDD2984733.1	2026728	g14019	i0	93.8	0.993103448275862	96	5	99.3	1	2	289	89	183	MDD2984733.1 hypothetical protein [Crocinitomicaceae bacterium]	diamond	288	172	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae		Crocinitomicaceae bacterium
32626685	32626685	PRJNA1002816_P_NODE_19420_length_245_cov_1.093023_g19260_i0	PRJNA1002816	19420	245	1.093023	2.67790635	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.1	0.028	NR	RLD79385.1	1898104	g19260	i0	34.8	0.808163265306122	66	40	80.8	1	243	46	552	614	RLD79385.1 MAG: RNA-binding transcriptional accessory protein [Bacteroidota bacterium]	diamond	198	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32689658	32689658	PRJNA1002816_P_NODE_18740_length_247_cov_1.701149_g18580_i0	PRJNA1002816	18740	247	1.701149	4.20183803	Salinivirgaceae bacterium	2053305	Bacteria	Bacteria	80.9	3.63e-16	NR	HON18569.1	2053305	g18580	i0	46.9	1.54251012145749	64	34	77.7	0	194	3	1	64	HON18569.1 purine-nucleoside phosphorylase [Salinivirgaceae bacterium]	diamond	381	80.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Salinivirgaceae		Salinivirgaceae 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);;