metadata: contig_metadata: 20 rows where bioproject = "PRJEB36940", tax_clade = "PVC group" and tax

20 rows where bioproject = "PRJEB36940", 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
988982	988982	PRJEB36940_P_NODE_7041_length_325_cov_2.547619_g6912_i0	PRJEB36940	7041	325	2.547619	8.27976175	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	76.6	8.59e-14	NR	RYD71398.1	2026800	g6912	i0	37.5	0.96	104	64	96	1	13	324	26	128	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	312	76.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
1330980	1330980	PRJEB36940_P_NODE_10802_length_267_cov_6.948454_g10673_i0	PRJEB36940	10802	267	6.948454	18.55237218	Fontisphaera persica	2974023	Bacteria	Bacteria	359	1.29e-94	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g10673	i0	91.078	14.4232209737828	269	18	99	6	1	265	3862996	3863262	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	3851	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
2606661	2606661	PRJEB36940_P_NODE_12883_length_250_cov_4.802260_g12754_i0	PRJEB36940	12883	250	4.80226	12.00565	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	368	1.98e-97	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g12754	i0	93.2	265	250	17	100	0	1	250	17608	17857	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	66250	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
6434960	6434960	PRJEB36940_P_NODE_16506_length_224_cov_6.529801_g16377_i0	PRJEB36940	16506	224	6.529801	14.62675424	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	326	1.06e-84	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g16377	i0	92.857	127.758928571429	224	16	100	0	1	224	3991852	3992075	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	28618	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
8983872	8983872	PRJEB36940_P_NODE_288_length_1349_cov_4.984326_g228_i0	PRJEB36940	288	1349	4.984326	67.23855774	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	290	8.76e-91	NR	RYD71398.1	2026800	g228	i0	45.1	0.789473684210526	355	182	77.6	6	1253	207	14	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	1065	290	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
10259500	10259500	PRJEB36940_P_NODE_169_length_1589_cov_4.757916_g129_i0	PRJEB36940	169	1589	4.757916	75.60328524	Pedosphaera parvula	1032527	Bacteria	Bacteria	1581	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g129	i0	85.041	174.116425424795	1571	215	98	19	21	1583	1559	1	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	276671	1581	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
12810307	12810307	PRJEB36940_P_NODE_3191_length_476_cov_2.734491_g3063_i0	PRJEB36940	3191	476	2.734491	13.01617716	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	577	6.18e-160	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g3063	i0	88.655	299.626050420168	476	51	99	3	2	476	2313	1840	Luteolibacter sp. SL250 chromosome	blastn	142622	577	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
17566818	17566818	PRJEB36940_P_NODE_16134_length_239_cov_2.271084_g16005_i0	PRJEB36940	16134	239	2.271084	5.42789076	Verrucomicrobiaceae	203557	Bacteria	Bacteria	403	5.15e-108	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g16005	i0	97.458	272.782426778243	236	6	99	0	1	236	2412	2647	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	65195	403	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
17908460	17908460	PRJEB36940_P_NODE_675_length_997_cov_2.471861_g578_i0	PRJEB36940	675	997	2.471861	24.64445417	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	730	0	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g578	i0	80.235	69.7753259779338	1022	161	100	38	1	997	2750186	2749181	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	69566	730	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23008765	23008765	PRJEB36940_P_NODE_1299_length_729_cov_2.135671_g1180_i0	PRJEB36940	1299	729	2.135671	15.56904159	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	603	1.6099999999999998e-167	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g1180	i0	82.504	231.772290809328	703	107	95	14	14	707	15550	16245	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	168962	603	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
26621740	26621740	PRJEB36940_P_NODE_9101_length_288_cov_1.502326_g8972_i0	PRJEB36940	9101	288	1.502326	4.32669888	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	75.9	7.5e-15	NR	RYD79446.1	2026800	g8972	i0	57.1	0.729166666666667	70	30	72.9	0	211	2	3	72	RYD79446.1 MAG: hypothetical protein EOP84_13030, partial [Verrucomicrobiaceae bacterium]	diamond	210	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
26811821	26811821	PRJEB36940_P_NODE_13441_length_249_cov_0.880682_g13312_i0	PRJEB36940	13441	249	0.880682	2.19289818	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	86.7	1.3e-17	NR	HEX7861274.1	2499141	g13312	i0	100	0.518072289156627	43	0	51.8	0	129	1	1	43	HEX7861274.1 DUF1800 domain-containing protein [Verrucomicrobiia bacterium]	diamond	129	86.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26969903	26969903	PRJEB36940_P_NODE_14742_length_245_cov_0.906977_g14613_i0	PRJEB36940	14742	245	0.906977	2.22209365	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	100	7.080000000000001e-26	NR	RYD81271.1	2026800	g14613	i0	66.2	0.906122448979592	74	20	84.5	2	208	2	5	78	RYD81271.1 MAG: hypothetical protein EOP84_11270 [Verrucomicrobiaceae bacterium]	diamond	222	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29370237	29370237	PRJEB36940_P_NODE_6169_length_346_cov_1.417582_g6040_i0	PRJEB36940	6169	346	1.417582	4.90483372	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	65.1	1.86e-9	NR	MBL9134505.1	2026801	g6040	i0	38.9	2.69653179190751	108	57	92.8	2	345	25	927	1026	MBL9134505.1 S8 family serine peptidase [Verrucomicrobiales bacterium]	diamond	933	65.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29780592	29780592	PRJEB36940_P_NODE_4211_length_416_cov_2.705539_g4082_i0	PRJEB36940	4211	416	2.705539	11.25504224	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	223	9.67e-70	NR	RYD81270.1	2026800	g4082	i0	73.9	0.995192307692308	138	36	99.5	0	415	2	169	306	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	414	223	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30096394	30096394	PRJEB36940_P_NODE_2512_length_535_cov_2.731602_g2386_i0	PRJEB36940	2512	535	2.731602	14.6140707	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	143	1.0199999999999998e-37	NR	RYD71398.1	2026800	g2386	i0	54.9	0.745794392523364	133	59	74	1	501	106	229	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	399	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30570158	30570158	PRJEB36940_P_NODE_12693_length_251_cov_0.876404_g12564_i0	PRJEB36940	12693	251	0.876404	2.19977404	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	112	4.71e-29	NR	MBA3883211.1	2201154	g12564	i0	82.5	0.752988047808765	63	11	75.3	0	2	190	126	188	MBA3883211.1 RNA polymerase sigma factor [Chthoniobacterales bacterium]	diamond	189	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31803169	31803169	PRJEB36940_P_NODE_2897_length_497_cov_1.205189_g2770_i0	PRJEB36940	2897	497	1.205189	5.98978933	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	226	5.49e-69	NR	RYD76251.1	2026800	g2770	i0	64.8	0.995975855130785	165	58	99.6	0	496	2	140	304	RYD76251.1 MAG: hypothetical protein EOP84_17160, partial [Verrucomicrobiaceae bacterium]	diamond	495	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32183104	32183104	PRJEB36940_P_NODE_258_length_1400_cov_6.782216_g204_i0	PRJEB36940	258	1400	6.782216	94.951024	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	440	8.18e-150	NR	RYD65414.1	2026800	g204	i0	77	0.606428571428571	283	63	60.6	1	1067	219	56	336	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	849	440	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32877519	32877519	PRJEB36940_P_NODE_3860_length_434_cov_2.997230_g3731_i0	PRJEB36940	3860	434	2.99723	13.0079782	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0385	NR	MBV9671622.1	2026799	g3731	i0	37	0.317972350230415	46	29	31.8	0	261	398	8	53	MBV9671622.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	138	42.4	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);;