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

10 rows where analysis = "diamond", bioproject = "PRJNA473824" 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
7474734	7474734	PRJNA473824_P_NODE_95446_length_173_cov_2.860294_g94808_i0	PRJNA473824	95446	173	2.860294	4.94830862	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	83.6	5.9e-17	NR	HUF36126.1	2448054	g94808	i0	66.7	1.2485549132948	72	9	98.8	1	3	173	171	242	HUF36126.1 UvrD-helicase domain-containing protein [Gemmatimonadales bacterium]	diamond	216	83.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
26633059	26633059	PRJNA473824_P_NODE_19541_length_267_cov_3.960870_g18903_i0	PRJNA473824	19541	267	3.96087	10.5755229	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	44.3	0.012	NR	MDE2808462.1	2026742	g18903	i0	33.3	0.640449438202247	57	38	64	0	75	245	21	77	MDE2808462.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	171	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
26759591	26759591	PRJNA473824_P_NODE_22661_length_248_cov_4.345972_g22023_i0	PRJNA473824	22661	248	4.345972	10.77801056	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	57.4	2.71e-7	NR	MBN63744.1	2026742	g22023	i0	44.4	0.870967741935484	72	40	87.1	0	240	25	534	605	MBN63744.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	216	57.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27581715	27581715	PRJNA473824_P_NODE_93784_length_173_cov_2.897059_g93146_i0	PRJNA473824	93784	173	2.897059	5.01191207	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	46.6	6.34e-4	NR	HMU61204.1	2448054	g93146	i0	60.5	0.745664739884393	43	15	71.1	1	171	49	185	227	HMU61204.1 cation-translocating P-type ATPase [Gemmatimonadales bacterium]	diamond	129	46.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28339562	28339562	PRJNA473824_P_NODE_73506_length_173_cov_3.713235_g72868_i0	PRJNA473824	73506	173	3.713235	6.42389655	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	47.8	2.39e-4	NR	MEJ2504437.1	2026742	g72868	i0	47.1	0.884393063583815	51	22	79.8	1	36	173	184	234	MEJ2504437.1 alpha-E domain-containing protein [Gemmatimonadota bacterium]	diamond	153	47.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28434289	28434289	PRJNA473824_P_NODE_144166_length_151_cov_4.526316_g143528_i0	PRJNA473824	144166	151	4.526316	6.83473716	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	50.8	1.42e-5	NR	MEW5917283.1	2026742	g143528	i0	80.8	1.01324503311258	26	5	51.7	0	3	80	224	249	MEW5917283.1 multicopper oxidase family protein [Gemmatimonadota bacterium]	diamond	153	50.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29034392	29034392	PRJNA473824_P_NODE_171348_length_150_cov_2.938053_g170710_i0	PRJNA473824	171348	150	2.938053	4.4070795	Gemmatimonas sp.	1962908	Bacteria	Bacteria	47.4	2.48e-4	NR	MEO7521361.1	1962908	g170710	i0	42.5	1.46	73	19	100	1	150	1	10	82	MEO7521361.1 hypothetical protein [Gemmatimonas sp.]	diamond	219	47.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
29318228	29318228	PRJNA473824_P_NODE_159309_length_151_cov_2.973684_g158671_i0	PRJNA473824	159309	151	2.973684	4.49026284	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	48.5	3.67e-5	NR	MEO7965276.1	2026741	g158671	i0	75.9	2.86092715231788	29	7	57.6	0	87	1	107	135	MEO7965276.1 glycosyltransferase [Gemmatimonadaceae bacterium]	diamond	432	48.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30613203	30613203	PRJNA473824_P_NODE_109353_length_173_cov_2.580882_g108715_i0	PRJNA473824	109353	173	2.580882	4.46492586	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	52.8	3.11e-6	NR	HXE57277.1	2448054	g108715	i0	88	0.433526011560694	25	3	43.4	0	99	173	171	195	HXE57277.1 7-cyano-7-deazaguanine synthase QueC [Gemmatimonadales bacterium]	diamond	75	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31340198	31340198	PRJNA473824_P_NODE_68096_length_173_cov_4.066176_g67458_i0	PRJNA473824	68096	173	4.066176	7.03448448	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	53.1	1.85e-7	NR	HIC16017.1	2026742	g67458	i0	57.4	12.7976878612717	47	18	78	1	38	172	7	53	HIC16017.1 AAA family ATPase [Gemmatimonadota bacterium]	diamond	2214	53.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;