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

10 rows where analysis = "diamond", bioproject = "PRJNA293022" 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
1648215	1648215	PRJNA293022_P_NODE_73722_length_165_cov_0.896552_g72985_i0	PRJNA293022	73722	165	0.896552	1.4793108	Limisphaerales bacterium	2052186	Bacteria	Bacteria	119	1.36e-29	NR	KAF0175639.1	2052186	g72985	i0	96.3	1.96363636363636	54	2	98.2	0	3	164	340	393	KAF0175639.1 MAG: folate hydrolase-like protein [Limisphaerales bacterium]	diamond	324	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
26631040	26631040	PRJNA293022_P_NODE_41841_length_216_cov_0.892216_g41104_i0	PRJNA293022	41841	216	0.892216	1.92718656	Luteolibacter pohnpeiensis	454153	Bacteria	Bacteria	42.4	0.0349	NR	WP_200270805.1	454153	g41104	i0	34.5	0.763888888888889	55	36	76.4	0	42	206	64	118	WP_200270805.1 hypothetical protein [Luteolibacter pohnpeiensis]	diamond	165	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter pohnpeiensis
27548090	27548090	PRJNA293022_P_NODE_75424_length_164_cov_0.904348_g74687_i0	PRJNA293022	75424	164	0.904348	1.48313072	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	76.3	1.94e-14	NR	MBI4658885.1	2026799	g74687	i0	71.2	0.951219512195122	52	11	95.1	1	5	160	715	762	MBI4658885.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	156	76.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28653275	28653275	PRJNA293022_P_NODE_62167_length_176_cov_1.606299_g61430_i0	PRJNA293022	62167	176	1.606299	2.82708624	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	41.2	0.0344	NR	MFL6553260.1	2201154	g61430	i0	52.5	0.681818181818182	40	16	66.5	2	18	134	121	158	MFL6553260.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	120	41.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29190135	29190135	PRJNA293022_P_NODE_69289_length_168_cov_0.873950_g68552_i0	PRJNA293022	69289	168	0.87395	1.468236	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	62	2.16e-10	NR	HEV2319410.1	2499141	g68552	i0	61.1	0.964285714285714	54	20	94.6	1	160	2	1	54	HEV2319410.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	162	62	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29252895	29252895	PRJNA293022_P_NODE_49489_length_198_cov_1.536913_g48752_i0	PRJNA293022	49489	198	1.536913	3.04308774	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.00815	NR	MEY4199220.1	2026799	g48752	i0	43.1	0.772727272727273	51	23	77.3	2	16	168	248	292	MEY4199220.1 nuclease superfamily [Verrucomicrobiota bacterium]	diamond	153	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30011151	30011151	PRJNA293022_P_NODE_69031_length_168_cov_0.873950_g68294_i0	PRJNA293022	69031	168	0.87395	1.468236	Limisphaerales bacterium	2052186	Bacteria	Bacteria	110	1.85e-26	NR	TXT50969.1	2052186	g68294	i0	98.2	0.982142857142857	55	1	98.2	0	3	167	2327	2381	TXT50969.1 MAG: hypothetical protein FD140_2031 [Limisphaerales bacterium]	diamond	165	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
30863991	30863991	PRJNA293022_P_NODE_68834_length_168_cov_1.008403_g68097_i0	PRJNA293022	68834	168	1.008403	1.69411704	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	41.2	0.0462	NR	HYY24259.1	2665650	g68097	i0	38.3	0.839285714285714	47	28	83.9	1	152	12	136	181	HYY24259.1 alpha/beta hydrolase [Candidatus Udaeobacter sp.]	diamond	141	41.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
30863993	30863993	PRJNA293022_P_NODE_75594_length_164_cov_0.904348_g74857_i0	PRJNA293022	75594	164	0.904348	1.48313072	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	97.8	4.500000000000001e-22	NR	MEI6358247.1	2026799	g74857	i0	86.8	1.9390243902439	53	7	97	0	162	4	262	314	MEI6358247.1 NPCBM/NEW2 domain-containing protein [Verrucomicrobiota bacterium]	diamond	318	97.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32572160	32572160	PRJNA293022_P_NODE_68059_length_169_cov_0.866667_g67322_i0	PRJNA293022	68059	169	0.866667	1.46466723	Opitutaceae bacterium	2006848	Bacteria	Bacteria	68.9	8e-12	NR	MBL9207199.1	2006848	g67322	i0	71.2	2.84023668639053	52	15	92.3	0	168	13	140	191	MBL9207199.1 hypothetical protein [Opitutaceae bacterium]	diamond	480	68.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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);;