metadata: contig_metadata: 15 rows where bioproject = "PRJNA983838", tax_clade = "PVC group" and tax

15 rows where bioproject = "PRJNA983838", 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
7343272	7343272	PRJNA983838_P_NODE_62626_length_360_cov_1.087108_g60259_i0	PRJNA983838	62626	360	1.087108	3.9135888	Luteolibacter luteus	2728835	Bacteria	Bacteria	654	0	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g60259	i0	99.444	194.488888888889	360	2	100	0	1	360	3804234	3803875	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	70016	654	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
10200119	10200119	PRJNA983838_P_NODE_98368_length_262_cov_2.523810_g96001_i0	PRJNA983838	98368	262	2.52381	6.6123822	Verrucomicrobiaceae	203557	Bacteria	Bacteria	481	2.57e-131	NTclustered	gi\|1969670428\|gb\|MW553372.1\|	670166	g96001	i0	100	100.797709923664	260	0	99	0	1	260	168	427	Uncultured Haloferula sp. clone 49 16S ribosomal RNA gene, partial sequence	blastn	26409	484	0.993801652892562	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	uncultured Haloferula sp.
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.
17542738	17542738	PRJNA983838_P_NODE_119474_length_241_cov_2.315476_g117107_i0	PRJNA983838	119474	241	2.315476	5.58029716	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g117107	i0	97.925	289.141078838174	241	5	100	0	1	241	1320153	1319913	Luteolibacter sp. Populi chromosome, complete genome	blastn	69683	418	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
17543719	17543719	PRJNA983838_P_NODE_84054_length_290_cov_1.437788_g81687_i0	PRJNA983838	84054	290	1.437788	4.1695852	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	353	6.57e-93	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g81687	i0	88.66	1.00344827586207	291	31	100	2	1	290	722518	722807	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	291	353	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
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.
22643188	22643188	PRJNA983838_P_NODE_97638_length_264_cov_1.188482_g95271_i0	PRJNA983838	97638	264	1.188482	3.13759248	Akkermansia muciniphila	239935	Bacteria	Bacteria	477	3.359999999999999e-130	NTclustered	gi\|1554474302\|gb\|CP025823.1\|	239935	g95271	i0	99.242	91.9810606060606	264	2	100	0	1	264	785200	784937	Akkermansia muciniphila strain EB-AMDK-7 chromosome, complete genome	blastn	24283	477	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
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);;