metadata: contig_metadata: 16 rows where bioproject = "PRJNA1240805", tax_clade = "PVC group" and tax

16 rows where bioproject = "PRJNA1240805", 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
349337	349337	PRJNA1240805_P_NODE_5841_length_189_cov_2.885714_g5792_i0	PRJNA1240805	5841	189	2.885714	5.45399946	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	202	1.5199999999999998e-47	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g5792	i0	90.26	325.386243386243	154	15	81	0	1	154	3261438	3261591	Luteolibacter sp. Populi chromosome, complete genome	blastn	61498	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
349343	349343	PRJNA1240805_P_NODE_6521_length_179_cov_4.746154_g6472_i0	PRJNA1240805	6521	179	4.746154	8.49561566	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	174	3.1e-39	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g6472	i0	86.335	196.469273743017	161	21	89	1	1	160	632190	632030	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	35168	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
2325855	2325855	PRJNA1240805_P_NODE_4462_length_216_cov_15.610778_g4413_i0	PRJNA1240805	4462	216	15.610778	33.71928048	Prosthecobacter	48463	Bacteria	Bacteria	346	7.810000000000001e-91	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g4413	i0	98.964	88.8981481481482	193	2	89	0	24	216	700	892	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	19202	346	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
2325870	2325870	PRJNA1240805_P_NODE_5922_length_188_cov_2.517986_g5873_i0	PRJNA1240805	5922	188	2.517986	4.73381368	Prosthecobacter	48463	Bacteria	Bacteria	287	4.06e-73	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g5873	i0	97.605	251.909574468085	167	4	89	0	22	188	1726	1892	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	47359	287	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
2900278	2900278	PRJNA1240805_P_NODE_4283_length_221_cov_7.441860_g4234_i0	PRJNA1240805	4283	221	7.44186	16.4465106	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	230	8.43e-56	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g4234	i0	87.5	215.493212669683	200	23	90	2	1	199	1058	860	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	47624	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
2900301	2900301	PRJNA1240805_P_NODE_5963_length_187_cov_5.210145_g5914_i0	PRJNA1240805	5963	187	5.210145	9.74297115	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	219	1.4899999999999999e-52	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g5914	i0	91.25	28.1497326203209	160	14	86	0	24	183	2234	2393	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	5264	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
3601067	3601067	PRJNA1240805_P_NODE_3443_length_250_cov_2.776119_g3394_i0	PRJNA1240805	3443	250	2.776119	6.9402975	Prosthecobacter	48463	Bacteria	Bacteria	207	4.57e-49	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g3394	i0	86.154	12.924	195	24	77	3	1	193	363	170	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	3231	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
5452957	5452957	PRJNA1240805_P_NODE_6305_length_182_cov_4.150376_g6256_i0	PRJNA1240805	6305	182	4.150376	7.55368432	Pedosphaera parvula	1032527	Bacteria	Bacteria	219	1.44e-52	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g6256	i0	91.25	76.5054945054945	160	14	88	0	1	160	1185	1026	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	13924	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
13103248	13103248	PRJNA1240805_P_NODE_2791_length_282_cov_15.253219_g2742_i0	PRJNA1240805	2791	282	15.253219	43.01407758	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	436	6.15e-118	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g2742	i0	96.923	263.198581560284	260	8	92	0	1	260	1065	806	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	74222	436	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
13803922	13803922	PRJNA1240805_P_NODE_5371_length_197_cov_3.094595_g5322_i0	PRJNA1240805	5371	197	3.094595	6.09635215	Opitutus	178440	Bacteria	Bacteria	318	1.52e-82	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g5322	i0	98.343	78.4822335025381	181	3	92	0	17	197	1642	1822	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	15461	318	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
15652465	15652465	PRJNA1240805_P_NODE_6913_length_174_cov_9.952000_g6864_i0	PRJNA1240805	6913	174	9.952	17.31648	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	261	2.23e-65	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g6864	i0	97.386	244.425287356322	153	4	88	0	1	153	1804	1652	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	42530	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
19475517	19475517	PRJNA1240805_P_NODE_6976_length_174_cov_2.024000_g6927_i0	PRJNA1240805	6976	174	2.024	3.52176	uncultured Opitutia bacterium	575426	Bacteria	Bacteria	265	1.73e-66	NTclustered	gi\|256858896\|gb\|GQ390240.1\|	575426	g6927	i0	98.026	87.4425287356322	152	3	87	0	23	174	58	209	Uncultured Opitutae bacterium clone eub623B12 16S ribosomal RNA gene, partial sequence	blastn	15215	265	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				uncultured Opitutia bacterium
22026211	22026211	PRJNA1240805_P_NODE_5278_length_198_cov_13.865772_g5229_i0	PRJNA1240805	5278	198	13.865772	27.45422856	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	283	5.589999999999999e-72	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g5229	i0	95.48	27.0656565656566	177	8	89	0	21	197	331	507	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	5359	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
24002523	24002523	PRJNA1240805_P_NODE_4599_length_213_cov_11.256098_g4550_i0	PRJNA1240805	4599	213	11.256098	23.97548874	Verrucomicrobiaceae	203557	Bacteria	Bacteria	363	7.619999999999997e-96	NTclustered	gi\|2889362999\|gb\|CP151838.1\|	454148	g4550	i0	99.01	275.971830985916	202	2	95	0	12	213	782508	782709	Roseibacillus persicicus strain AS69 chromosome, complete genome	blastn	58782	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseibacillus	Roseibacillus persicicus
24575748	24575748	PRJNA1240805_P_NODE_2720_length_286_cov_6.236287_g2671_i0	PRJNA1240805	2720	286	6.236287	17.83578082	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	427	3.76e-115	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g2671	i0	97.967	231.846153846154	246	5	86	0	24	269	493	738	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	66308	427	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
28778785	28778785	PRJNA1240805_P_NODE_1867_length_354_cov_27.659016_g1818_i0	PRJNA1240805	1867	354	27.659016	97.91291664	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.8	0.00236	NR	MBI5385683.1	2026799	g1818	i0	59.5	0.313559322033898	37	15	31.4	0	221	331	895	931	MBI5385683.1 autotransporter-associated beta strand repeat-containing protein [Verrucomicrobiota bacterium]	diamond	111	47.8	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);;