metadata: contig_metadata: 10 rows where bioproject = "PRJNA473201", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJNA473201", tax_clade = "PVC group" 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
15746704	15746704	PRJNA473201_P_NODE_52573_length_285_cov_17.165094_g51831_i0	PRJNA473201	52573	285	17.165094	48.9205179	Opitutus terrae	107709	Bacteria	Bacteria	143	1.52e-29	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g51831	i0	92.929	33.4842105263158	99	5	34	2	15	112	2052834	2052931	Opitutus terrae PB90-1, complete genome	blastn	9543	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
22120714	22120714	PRJNA473201_P_NODE_62298_length_260_cov_1.299465_g61556_i0	PRJNA473201	62298	260	1.299465	3.378609	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	94.7	2.32e-20	NR	RYD77759.1	2026800	g61556	i0	64.9	0.888461538461538	77	27	88.8	0	259	29	447	523	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	231	94.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27739898	27739898	PRJNA473201_P_NODE_32124_length_349_cov_1.623188_g31382_i0	PRJNA473201	32124	349	1.623188	5.66492612	Candidatus Didemnitutus sp.	2814259	Bacteria	Bacteria	64.7	2.61e-9	NR	MBP6863799.1	2814259	g31382	i0	39.1	0.988538681948424	115	66	97.1	3	10	348	764	876	MBP6863799.1 immunoglobulin domain-containing protein [Candidatus Didemnitutus sp.]	diamond	345	64.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Candidatus Didemnitutus	Candidatus Didemnitutus sp.
29034347	29034347	PRJNA473201_P_NODE_77968_length_245_cov_0.895349_g77226_i0	PRJNA473201	77968	245	0.895349	2.19360505	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	75.1	1.58e-13	NR	PWU11941.1	2026799	g77226	i0	46.2	1.9469387755102	78	40	95.5	1	235	2	1941	2016	PWU11941.1 MAG: hypothetical protein C5B50_22285 [Verrucomicrobiota bacterium]	diamond	477	75.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30076050	30076050	PRJNA473201_P_NODE_16732_length_486_cov_12.397094_g15990_i0	PRJNA473201	16732	486	12.397094	60.24987684	Luteolibacter sp.	1962973	Bacteria	Bacteria	75.5	5.03e-13	NR	MEP5351923.1	1962973	g15990	i0	51.6	0.574074074074074	93	43	56.8	2	85	360	84	175	MEP5351923.1 reverse transcriptase domain-containing protein [Luteolibacter sp.]	diamond	279	75.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
30138979	30138979	PRJNA473201_P_NODE_61712_length_261_cov_19.271277_g60970_i0	PRJNA473201	61712	261	19.271277	50.29803297	Opitutia bacterium	2026771	Bacteria	Bacteria	106	1.5600000000000002e-26	NR	HBO57038.1	2026771	g60970	i0	61.2	0.977011494252874	85	33	97.7	0	256	2	71	155	HBO57038.1 endonuclease [Opitutia bacterium]	diamond	255	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
30787491	30787491	PRJNA473201_P_NODE_72114_length_248_cov_0.880000_g71372_i0	PRJNA473201	72114	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	159	3e-43	NR	MEN9573094.1	2026799	g71372	i0	92.7	3.96774193548387	82	6	99.2	0	246	1	849	930	MEN9573094.1 Concanavalin A-like lectin/glucanase superfamily [Verrucomicrobiota bacterium]	diamond	984	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31308419	31308419	PRJNA473201_P_NODE_67955_length_250_cov_0.870056_g67213_i0	PRJNA473201	67955	250	0.870056	2.17514	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	52.8	1.26e-5	NR	HTL47411.1	2499141	g67213	i0	46.3	0.648	54	29	64.8	0	50	211	2711	2764	HTL47411.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	162	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31687996	31687996	PRJNA473201_P_NODE_28537_length_369_cov_1.753378_g27795_i0	PRJNA473201	28537	369	1.753378	6.46996482	Chthoniobacter sp.	2510640	Bacteria	Bacteria	231	1.36e-71	NR	MDR3405335.1	2510640	g27795	i0	87	2	123	16	100	0	369	1	280	402	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	738	231	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
32762778	32762778	PRJNA473201_P_NODE_35700_length_333_cov_1.184615_g34958_i0	PRJNA473201	35700	333	1.184615	3.94476795	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	66.2	1.15e-10	NR	GDY20741.1	2026799	g34958	i0	37.7	2.74774774774775	106	58	93.7	4	333	22	77	176	GDY20741.1 NUDIX hydrolase [Verrucomicrobiota bacterium]	diamond	915	66.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;