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

10 rows where analysis = "diamond", bioproject = "PRJNA983838" and tax_phylum = "Verrucomicrobiota"

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
11168012	11168012	PRJNA983838_P_NODE_105789_length_252_cov_0.871508_g103422_i0	PRJNA983838	105789	252	0.871508	2.19620016	Lacunisphaera sp.	1961806	Bacteria	Bacteria	122	2.8799999999999997e-30	NR	HEY0864123.1	1961806	g103422	i0	70.2	1.98809523809524	84	24	98.8	1	250	2	519	602	HEY0864123.1 CHASE3 domain-containing protein [Lacunisphaera sp.]	diamond	501	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
18817785	18817785	PRJNA983838_P_NODE_98735_length_262_cov_1.396825_g96368_i0	PRJNA983838	98735	262	1.396825	3.6596815	Luteolibacter	518753	Bacteria	Bacteria	128	4.219999999999999e-32	NR	MDP3851236.1	1962973	g96368	i0	90	6.46946564885496	70	7	80.2	0	260	51	828	897	MDP3851236.1 DEAD/DEAH box helicase [Luteolibacter sp.]	diamond	1695	129	0.992248062015504	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
27311060	27311060	PRJNA983838_P_NODE_80343_length_299_cov_2.022124_g77976_i0	PRJNA983838	80343	299	2.022124	6.04615076	Opitutaceae bacterium	2006848	Bacteria	Bacteria	85.9	1.48e-18	NR	HKB90181.1	2006848	g77976	i0	46.5	1.0133779264214	101	51	99.3	2	298	2	64	163	HKB90181.1 shikimate kinase [Opitutaceae bacterium]	diamond	303	85.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28706254	28706254	PRJNA983838_P_NODE_90487_length_277_cov_1.348039_g88120_i0	PRJNA983838	90487	277	1.348039	3.73406803	Verrucomicrobiota	74201	Bacteria	Bacteria	162	8.04e-47	NR	MFA6544388.1	2052186	g88120	i0	82.4	2.95667870036101	91	16	98.6	0	275	3	84	174	MFA6544388.1 sialidase family protein [Limisphaerales bacterium]	diamond	819	163	0.993865030674847	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
31226864	31226864	PRJNA983838_P_NODE_46555_length_457_cov_5.156250_g44189_i0	PRJNA983838	46555	457	5.15625	23.5640625	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	189	3.63e-56	NR	RYD65414.1	2026800	g44189	i0	80.4	0.702407002188184	107	21	70.2	0	2	322	230	336	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	321	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32080999	32080999	PRJNA983838_P_NODE_40178_length_517_cov_2.558559_g37817_i0	PRJNA983838	40178	517	2.558559	13.22775003	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	256	2.62e-82	NR	RYD81270.1	2026800	g37817	i0	71	0.940038684719536	162	47	94	0	511	26	177	338	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	486	256	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32176211	32176211	PRJNA983838_P_NODE_99898_length_260_cov_1.443850_g97531_i0	PRJNA983838	99898	260	1.44385	3.75401	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	137	2.46e-35	NR	RYD24189.1	2026800	g97531	i0	75.9	2.00769230769231	87	20	99.2	1	259	2	457	543	RYD24189.1 MAG: hypothetical protein EOP88_01205 [Verrucomicrobiaceae bacterium]	diamond	522	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32334487	32334487	PRJNA983838_P_NODE_72799_length_321_cov_3.346774_g70432_i0	PRJNA983838	72799	321	3.346774	10.74314454	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	145	3.749999999999999e-40	NR	RYD65414.1	2026800	g70432	i0	71	1	107	29	100	1	321	1	135	239	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	321	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32460884	32460884	PRJNA983838_P_NODE_56779_length_388_cov_2.434921_g54412_i0	PRJNA983838	56779	388	2.434921	9.44749348	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	139	4.87e-37	NR	RYD71398.1	2026800	g54412	i0	56.8	0.966494845360825	125	53	95.9	1	15	386	234	358	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	375	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32713097	32713097	PRJNA983838_P_NODE_70420_length_329_cov_4.214844_g68053_i0	PRJNA983838	70420	329	4.214844	13.86683676	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	94	3.9e-20	NR	RYD71398.1	2026800	g68053	i0	48.3	0.811550151975684	89	46	81.2	0	15	281	105	193	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	267	94	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae 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);;