metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1160211" 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_species
27451486	27451486	PRJNA1160211_S_NODE_263263_length_251_cov_2.511236_g262030_i0	PRJNA1160211	263263	251	2.511236	6.30320236	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	100	4.63e-25	NR	MDQ2768724.1	2026742	g262030	i0	65.4	0.932270916334661	78	18	82.5	1	25	231	30	107	MDQ2768724.1 DEAD/DEAH box helicase [Gemmatimonadota bacterium]	diamond	234	100	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
28859663	28859663	PRJNA1160211_S_NODE_130268_length_404_cov_7.921450_g129036_i0	PRJNA1160211	130268	404	7.92145	32.002658	Bacteria	2	Bacteria	Bacteria	169	4.58e-46	NR	MFH1571213.1	2026742	g129036	i0	75.2	19.3514851485149	121	24	89.9	1	6	368	312	426	MFH1571213.1 AAA family ATPase [Gemmatimonadota bacterium]	diamond	7818	169	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
30325330	30325330	PRJNA1160211_S_NODE_23112_length_689_cov_9.730519_g22078_i0	PRJNA1160211	23112	689	9.730519	67.04327591	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	197	1.88e-60	NR	HKU60607.1	2448054	g22078	i0	60.8	2.61683599419448	148	56	64.4	1	644	201	9	154	HKU60607.1 GNAT family N-acetyltransferase [Gemmatimonadales bacterium]	diamond	1803	197	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
30502075	30502075	PRJNA1160211_S_NODE_256353_length_257_cov_0.891304_g255120_i0	PRJNA1160211	256353	257	0.891304	2.29065128	Pseudomonadati	3379134	Bacteria	Bacteria	80.5	1.98e-15	NR	NUP54222.1	2026741	g255120	i0	57.3	5.94163424124514	75	31	87.5	1	27	251	164	237	NUP54222.1 ATP-binding protein [Gemmatimonadaceae bacterium]	diamond	1527	80.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
31323571	31323571	PRJNA1160211_S_NODE_111895_length_435_cov_5.395028_g110666_i0	PRJNA1160211	111895	435	5.395028	23.4683718	Bacteria	2	Bacteria	Bacteria	153	4.57e-41	NR	HEU4585318.1	2026741	g110666	i0	57.6	8.62068965517241	125	53	86.2	0	9	383	359	483	HEU4585318.1 AlkA N-terminal domain-containing protein [Gemmatimonadaceae bacterium]	diamond	3750	154	0.993506493506494	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);;