metadata: contig_metadata: 11 rows where bioproject = "PRJNA289590" and tax

11 rows where bioproject = "PRJNA289590" and tax_clade = "PVC group"

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
1647294	1647294	PRJNA289590_P_NODE_22_length_11072_cov_17.623787_g20_i0	PRJNA289590	22	11072	17.623787	1951.30569664	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	878	1.28e-273	NR	MCA9280974.1	2052180	g20	i0	38.2	1.15019869942197	1418	822	37.6	19	5960	1794	1	1393	MCA9280974.1 AAA family ATPase [Phycisphaerales bacterium]	diamond	12735	878	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
5475934	5475934	PRJNA289590_P_NODE_20505_length_196_cov_2.068027_g20281_i0	PRJNA289590	20505	196	2.068027	4.05333292	Oceaniferula spumae	2979115	Bacteria	Bacteria	132	2.12e-26	NTclustered	gi\|2753272999\|dbj\|AP026866.1\|	2979115	g20281	i0	91.579	48.0204081632653	95	8	48	0	1	95	833029	833123	Verrucomicrobiaceae bacterium NT6N DNA, complete genome	blastn	9412	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Oceaniferula	Oceaniferula spumae
5476120	5476120	PRJNA289590_P_NODE_29125_length_165_cov_0.896552_g28901_i0	PRJNA289590	29125	165	0.896552	1.4793108	Opitutales bacterium	2026772	Bacteria	Bacteria	150	4.76e-32	NTclustered	gi\|2814788334\|emb\|OY762281.2\|	2026772	g28901	i0	83.333	10.133333333333301	168	22	100	6	1	165	977513	977677	MAG: Opitutales bacterium isolate 685e4509-010e-4797-9872-a51ee4494a19 genome assembly, chromosome: 1	blastn	1672	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
18224466	18224466	PRJNA289590_P_NODE_6715_length_370_cov_2.246106_g6491_i0	PRJNA289590	6715	370	2.246106	8.3105922	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	169	3.3499999999999996e-37	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g6491	i0	90.625	61.7540540540541	128	10	34	2	245	370	3047506	3047379	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	22849	169	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
23324821	23324821	PRJNA289590_P_NODE_5199_length_432_cov_2.026110_g4975_i0	PRJNA289590	5199	432	2.02611	8.7527952	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|2621703756\|emb\|OY762711.1\|	2813034	g4975	i0	94.286	0.0810185185185185	35	2	8	0	25	59	3671457	3671423	MAG: Sedimentisphaerales bacterium isolate 370b4a7f-3155-49ac-97a8-084c2d75e38e genome assembly, chromosome: 1	blastn	35	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
25285525	25285525	PRJNA289590_P_NODE_29660_length_164_cov_0.904348_g29436_i0	PRJNA289590	29660	164	0.904348	1.48313072	Engelhardtia	139931	Bacteria	Bacteria	195	2.15e-45	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g29436	i0	90.604	160.975609756098	149	10	90	4	1	147	5247535	5247389	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	26400	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
26915958	26915958	PRJNA289590_P_NODE_22622_length_185_cov_1.529412_g22398_i0	PRJNA289590	22622	185	1.529412	2.8294122	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	70.5	2.82e-12	NR	RYD85970.1	2026800	g22398	i0	53.8	0.843243243243243	52	24	84.3	0	30	185	515	566	RYD85970.1 MAG: hypothetical protein EOP84_00610 [Verrucomicrobiaceae bacterium]	diamond	156	70.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27358827	27358827	PRJNA289590_P_NODE_4183_length_499_cov_2.033333_g3964_i0	PRJNA289590	4183	499	2.033333	10.14633167	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	139	2.4899999999999996e-37	NR	HEV2695716.1	2499141	g3964	i0	49.7	0.907815631262525	151	72	90.2	3	493	44	7	154	HEV2695716.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	453	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29902356	29902356	PRJNA289590_P_NODE_24871_length_174_cov_1.112000_g24647_i0	PRJNA289590	24871	174	1.112	1.93488	PVC group	1783257	Bacteria	Bacteria	52	8.33e-6	NR	MEI6675535.1	2026799	g24647	i0	50.9	5	53	26	91.4	0	1	159	2541	2593	MEI6675535.1 cadherin-like beta sandwich domain-containing protein [Verrucomicrobiota bacterium]	diamond	870	52	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32129141	32129141	PRJNA289590_P_NODE_14638_length_236_cov_1.946524_g14414_i0	PRJNA289590	14638	236	1.946524	4.59379664	Gemmataceae bacterium	2052164	Bacteria	Bacteria	50.8	3.83e-5	NR	MCI0681538.1	2052164	g14414	i0	42.7	0.953389830508475	75	42	94.1	1	14	235	122	196	MCI0681538.1 hypothetical protein [Gemmataceae bacterium]	diamond	225	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32431475	32431475	PRJNA289590_P_NODE_27019_length_168_cov_0.873950_g26795_i0	PRJNA289590	27019	168	0.87395	1.468236	Bacteria	2	Bacteria	Bacteria	70.9	9.11e-14	NR	MBL8820106.1	37635	g26795	i0	62.7	11.9464285714286	51	19	91.1	0	3	155	83	133	MBL8820106.1 GNAT family N-acetyltransferase [Planctomyces sp.]	diamond	2007	71.2	0.995786516853933	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.

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);;