metadata: contig_metadata: 12 rows where bioproject = "PRJNA971593" and tax

12 rows where bioproject = "PRJNA971593" and tax_phylum = "Gemmatimonadota"

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
6047475	6047475	PRJNA971593_P_NODE_25085_length_247_cov_0.885057_g24936_i0	PRJNA971593	25085	247	0.885057	2.18609079	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	69.3	1.68e-11	NR	HSR42517.1	2910168	g24936	i0	47.2	0.874493927125506	72	36	87.4	1	4	219	32	101	HSR42517.1 serine/threonine-protein kinase [Longimicrobiales bacterium]	diamond	216	69.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
22943995	22943995	PRJNA971593_P_NODE_26118_length_245_cov_1.343023_g25969_i0	PRJNA971593	26118	245	1.343023	3.29040635	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	114	1.3999999999999996e-29	NR	HEX3868160.1	2026741	g25969	i0	69.2	6.68571428571429	78	24	95.5	0	235	2	1	78	HEX3868160.1 superoxide dismutase [Gemmatimonadaceae bacterium]	diamond	1638	114	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28036807	28036807	PRJNA971593_P_NODE_20785_length_259_cov_1.241935_g20636_i0	PRJNA971593	20785	259	1.241935	3.21661165	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	60.8	1.81e-8	NR	HJR41425.1	2026741	g20636	i0	38.8	0.926640926640927	80	45	92.7	1	1	240	234	309	HJR41425.1 N-methyl-L-tryptophan oxidase [Gemmatimonadaceae bacterium]	diamond	240	60.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28194357	28194357	PRJNA971593_P_NODE_19486_length_269_cov_1.862245_g19337_i0	PRJNA971593	19486	269	1.862245	5.00943905	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	94.7	2.67e-20	NR	MBI4514071.1	2026742	g19337	i0	57.1	0.858736059479554	77	33	85.9	0	19	249	51	127	MBI4514071.1 penicillin acylase family protein [Gemmatimonadota bacterium]	diamond	231	94.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28920605	28920605	PRJNA971593_P_NODE_27768_length_243_cov_0.905882_g27619_i0	PRJNA971593	27768	243	0.905882	2.20129326	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	63.9	9.73e-10	NR	HKJ92093.1	2910168	g27619	i0	51.9	0.666666666666667	54	26	66.7	0	78	239	6	59	HKJ92093.1 PorV/PorQ family protein [Longimicrobiales bacterium]	diamond	162	63.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
30215381	30215381	PRJNA971593_P_NODE_6392_length_481_cov_2.009804_g6244_i0	PRJNA971593	6392	481	2.009804	9.66715724	Longimicrobium sp.	2029185	Bacteria	Bacteria	91.3	7.13e-19	NR	HEX2210215.1	2029185	g6244	i0	46.3	0.673596673596674	108	57	66.7	1	321	1	135	242	HEX2210215.1 DUF2382 domain-containing protein [Longimicrobium sp.]	diamond	324	91.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30626107	30626107	PRJNA971593_P_NODE_6373_length_482_cov_1.381418_g6225_i0	PRJNA971593	6373	482	1.381418	6.65843476	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	74.3	2.01e-13	NR	HWA59702.1	2448054	g6225	i0	33.3	2.38381742738589	126	62	78.4	2	381	4	11	114	HWA59702.1 Hsp20/alpha crystallin family protein [Gemmatimonadales bacterium]	diamond	1149	74.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30885307	30885307	PRJNA971593_P_NODE_28014_length_243_cov_0.888235_g27865_i0	PRJNA971593	28014	243	0.888235	2.15841105	FCB group	1783270	Bacteria	Bacteria	81.3	9.97e-16	NR	MFN0179410.1	2448054	g27865	i0	48.8	7.50617283950617	80	41	98.8	0	3	242	166	245	MFN0179410.1 polysaccharide biosynthesis protein [Gemmatimonadales bacterium]	diamond	1824	81.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31163104	31163104	PRJNA971593_P_NODE_21695_length_252_cov_1.720670_g21546_i0	PRJNA971593	21695	252	1.72067	4.3360884	Longimicrobium sp.	2029185	Bacteria	Bacteria	59.7	4.27e-8	NR	HEX8433399.1	2029185	g21546	i0	38.6	1.98809523809524	83	51	98.8	0	1	249	200	282	HEX8433399.1 DUF2382 domain-containing protein [Longimicrobium sp.]	diamond	501	59.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32049017	32049017	PRJNA971593_P_NODE_26318_length_245_cov_0.895349_g26169_i0	PRJNA971593	26318	245	0.895349	2.19360505	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	149	1.16e-40	NR	MBI4500952.1	2026742	g26169	i0	81.5	0.991836734693878	81	15	99.2	0	2	244	354	434	MBI4500952.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	243	149	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32744412	32744412	PRJNA971593_P_NODE_5040_length_540_cov_0.980728_g4894_i0	PRJNA971593	5040	540	0.980728	5.2959312	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	52	3.8e-4	NR	HWB40674.1	2448054	g4894	i0	32.8	0.711111111111111	128	76	67.2	4	530	168	416	540	HWB40674.1 invasin domain 3-containing protein [Gemmatimonadales bacterium]	diamond	384	52	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32870195	32870195	PRJNA971593_P_NODE_26920_length_244_cov_0.900585_g26771_i0	PRJNA971593	26920	244	0.900585	2.1974274	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	45.4	0.00423	NR	HVP70043.1	2026741	g26771	i0	83.3	2.36065573770492	24	4	29.5	0	1	72	556	579	HVP70043.1 ABC transporter permease [Gemmatimonadaceae bacterium]	diamond	576	45.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae 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);;