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

12 rows where bioproject = "PRJNA770361" 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
26736294	26736294	PRJNA770361_P_NODE_7481_length_343_cov_2.007407_g7386_i0	PRJNA770361	7481	343	2.007407	6.88540601	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	157	1.0600000000000001e-44	NR	MCC5848856.1	2026799	g7386	i0	78.5	0.813411078717201	93	20	81.3	0	279	1	1	93	MCC5848856.1 malate dehydrogenase [Verrucomicrobiota bacterium]	diamond	279	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27590541	27590541	PRJNA770361_P_NODE_14484_length_251_cov_0.876404_g14389_i0	PRJNA770361	14484	251	0.876404	2.19977404	Rubritalea tangerina	430798	Bacteria	Bacteria	84	1.28e-16	NR	WP_377090215.1	430798	g14389	i0	47.6	2.91633466135458	82	42	98	1	251	6	504	584	WP_377090215.1 bifunctional alpha,alpha-trehalose-phosphate synthase (UDP-forming)/trehalose-phosphatase [Rubritalea tangerina]	diamond	732	84	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Rubritaleaceae	Rubritalea	Rubritalea tangerina
28316625	28316625	PRJNA770361_P_NODE_8746_length_319_cov_1.199187_g8651_i0	PRJNA770361	8746	319	1.199187	3.82540653	Opitutaceae bacterium	2006848	Bacteria	Bacteria	111	3.3600000000000003e-29	NR	HEX9782639.1	2006848	g8651	i0	53.4	1.93730407523511	103	44	96.9	1	310	2	3	101	HEX9782639.1 hypothetical protein [Opitutaceae bacterium]	diamond	618	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28727027	28727027	PRJNA770361_P_NODE_15967_length_248_cov_0.891429_g15872_i0	PRJNA770361	15967	248	0.891429	2.21074392	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	68.2	3.98e-11	NR	HST79166.1	2499141	g15872	i0	73.9	0.556451612903226	46	12	55.6	0	108	245	3	48	HST79166.1 M28 family peptidase [Verrucomicrobiia bacterium]	diamond	138	68.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29421431	29421431	PRJNA770361_P_NODE_14649_length_251_cov_0.876404_g14554_i0	PRJNA770361	14649	251	0.876404	2.19977404	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	63.5	1.88e-9	NR	SPE61380.1	2026799	g14554	i0	52.4	2.35458167330677	63	28	75.3	1	191	3	23	83	SPE61380.1 PhoPQ-activated pathogenicity-related protein [Verrucomicrobiota bacterium]	diamond	591	63.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29800418	29800418	PRJNA770361_P_NODE_10491_length_291_cov_1.110092_g10396_i0	PRJNA770361	10491	291	1.110092	3.23036772	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	66.2	1.2e-10	NR	HVK82012.1	2499141	g10396	i0	39.8	1.11340206185567	108	49	94.8	2	290	15	23	130	HVK82012.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	324	66.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30116305	30116305	PRJNA770361_P_NODE_15852_length_249_cov_0.886364_g15757_i0	PRJNA770361	15852	249	0.886364	2.20704636	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	57.8	2.08e-7	NR	HYR21765.1	2201154	g15757	i0	76.3	0.91566265060241	38	9	45.8	0	136	249	5	42	HYR21765.1 response regulator [Chthoniobacterales bacterium]	diamond	228	57.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30716640	30716640	PRJNA770361_P_NODE_6554_length_366_cov_1.563140_g6459_i0	PRJNA770361	6554	366	1.56314	5.7210924	Prosthecobacter sp.	1965333	Bacteria	Bacteria	140	4.7999999999999997e-39	NR	HRH95331.1	1965333	g6459	i0	59	1	122	48	98.4	2	2	361	38	159	HRH95331.1 PEP-CTERM sorting domain-containing protein [Prosthecobacter sp.]	diamond	366	140	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
32202957	32202957	PRJNA770361_P_NODE_16658_length_247_cov_0.896552_g16563_i0	PRJNA770361	16658	247	0.896552	2.21448344	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	148	1.93e-39	NR	MBI5688149.1	2026799	g16563	i0	76.5	1.96761133603239	81	19	98.4	0	2	244	168	248	MBI5688149.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	486	148	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32266457	32266457	PRJNA770361_P_NODE_18018_length_244_cov_0.912281_g17923_i0	PRJNA770361	18018	244	0.912281	2.22596564	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	83.6	1.51e-17	NR	NCC59565.1	2499141	g17923	i0	97.7	0.528688524590164	43	1	52.9	0	129	1	1	43	NCC59565.1 (d)CMP kinase [Verrucomicrobiia bacterium]	diamond	129	83.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32456247	32456247	PRJNA770361_P_NODE_14519_length_251_cov_0.876404_g14424_i0	PRJNA770361	14519	251	0.876404	2.19977404	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	153	6.11e-42	NR	MFM1767729.1	2026799	g14424	i0	88	0.99203187250996006	83	10	99.2	0	1	249	248	330	MFM1767729.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	249	153	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32519607	32519607	PRJNA770361_P_NODE_18559_length_243_cov_0.917647_g18464_i0	PRJNA770361	18559	243	0.917647	2.22988221	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	105	1.7699999999999998e-24	NR	NCC61292.1	2499141	g18464	i0	62.9	0.864197530864197	70	26	86.4	0	240	31	348	417	NCC61292.1 phage portal protein [Verrucomicrobiia bacterium]	diamond	210	105	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;