metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA635397" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA635397" 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
3156584	3156584	PRJNA635397_P_NODE_26443_length_310_cov_1.675105_g25989_i0	PRJNA635397	26443	310	1.675105	5.1928255	Bacteria	2	Bacteria	Bacteria	165	2.21e-50	NR	MBM4098314.1	2026780	g25989	i0	85	10.6258064516129	100	15	96.8	0	2	301	23	122	MBM4098314.1 phosphoglycerate kinase [Planctomycetota bacterium]	diamond	3294	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
24105594	24105594	PRJNA635397_P_NODE_19419_length_367_cov_1.363946_g18965_i0	PRJNA635397	19419	367	1.363946	5.00568182	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	65.9	2.07e-11	NR	RYD71399.1	2026800	g18965	i0	50.7	0.596730245231608	73	36	59.7	0	262	44	6	78	RYD71399.1 MAG: hypothetical protein EOP84_24950, partial [Verrucomicrobiaceae bacterium]	diamond	219	65.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
26891355	26891355	PRJNA635397_P_NODE_40941_length_250_cov_0.870056_g40487_i0	PRJNA635397	40941	250	0.870056	2.17514	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	62.4	4.89e-9	NR	MEI6343602.1	2026799	g40487	i0	47.5	0.732	61	26	70.8	2	249	73	202	258	MEI6343602.1 glycosyltransferase [Verrucomicrobiota bacterium]	diamond	183	62.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27049435	27049435	PRJNA635397_P_NODE_42182_length_248_cov_0.885714_g41728_i0	PRJNA635397	42182	248	0.885714	2.19657072	Planctomycetota bacterium	2026780	Bacteria	Bacteria	156	4.53e-44	NR	MCE9566415.1	2026780	g41728	i0	86.4	3.94354838709677	81	11	98	0	3	245	311	391	MCE9566415.1 phage portal protein [Planctomycetota bacterium]	diamond	978	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27491805	27491805	PRJNA635397_P_NODE_41363_length_249_cov_0.886364_g40909_i0	PRJNA635397	41363	249	0.886364	2.20704636	Crateriforma spongiae	2724528	Bacteria	Bacteria	42.4	0.0473	NR	WP_168564633.1	2724528	g40909	i0	41.2	0.614457831325301	51	29	60.2	1	156	7	46	96	WP_168564633.1 adenylyl-sulfate kinase [Crateriforma spongiae]	diamond	153	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Crateriforma	Crateriforma spongiae
27965262	27965262	PRJNA635397_P_NODE_36205_length_263_cov_1.368421_g35751_i0	PRJNA635397	36205	263	1.368421	3.59894723	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	112	1.15e-26	NR	MDZ4742534.1	2026799	g35751	i0	64.6	1.87072243346008	82	29	93.5	0	262	17	94	175	MDZ4742534.1 thiamine pyrophosphate-binding protein [Verrucomicrobiota bacterium]	diamond	492	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28565250	28565250	PRJNA635397_P_NODE_32927_length_276_cov_2.024631_g32473_i0	PRJNA635397	32927	276	2.024631	5.58798156	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	152	2.2499999999999993e-43	NR	RYD69104.1	2026800	g32473	i0	84.6	0.989130434782609	91	14	98.9	0	274	2	138	228	RYD69104.1 MAG: MFS transporter, partial [Verrucomicrobiaceae bacterium]	diamond	273	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28924930	28924930	PRJNA635397_P_NODE_21548_length_346_cov_1.864469_g21094_i0	PRJNA635397	21548	346	1.864469	6.45106274	Bacteria	2	Bacteria	Bacteria	46.6	0.00549	NR	MBX3402345.1	2026777	g21094	i0	31.8	4.70809248554913	110	72	94.5	2	334	8	786	893	MBX3402345.1 alanine--tRNA ligase [Phycisphaeraceae bacterium]	diamond	1629	47	0.991489361702128	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
29809052	29809052	PRJNA635397_P_NODE_41911_length_248_cov_1.394286_g41457_i0	PRJNA635397	41911	248	1.394286	3.45782928	Bacteria	2	Bacteria	Bacteria	70.9	6.27e-13	NR	WP_105336449.1	124	g41457	i0	54.7	1.24596774193548	53	24	64.1	0	2	160	132	184	WP_105336449.1 hypothetical protein [Blastopirellula marina]	diamond	309	70.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula marina
29923090	29923090	PRJNA635397_P_NODE_46091_length_242_cov_2.899408_g45637_i0	PRJNA635397	46091	242	2.899408	7.01656736	Stieleria neptunia	2527979	Bacteria	Bacteria	41.6	0.0284	NR	WP_145386459.1	2527979	g45637	i0	40	0.557851239669422	45	27	55.8	0	226	92	35	79	WP_145386459.1 hypothetical protein [Stieleria neptunia]	diamond	135	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria neptunia
29998826	29998826	PRJNA635397_P_NODE_39091_length_253_cov_0.866667_g38637_i0	PRJNA635397	39091	253	0.866667	2.19266751	Bacteria	2	Bacteria	Bacteria	123	2.3e-31	NR	PYJ03686.1	2026799	g38637	i0	73.5	3.88932806324111	83	22	98.4	0	3	251	141	223	PYJ03686.1 MAG: hypothetical protein DME25_11515 [Verrucomicrobiota bacterium]	diamond	984	124	0.991935483870968	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30365735	30365735	PRJNA635397_P_NODE_8832_length_601_cov_1.886364_g8385_i0	PRJNA635397	8832	601	1.886364	11.33704764	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	205	1.07e-61	NR	RYD65414.1	2026800	g8385	i0	78.7	0.608985024958403	122	26	60.9	0	2	367	199	320	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	366	205	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30681026	30681026	PRJNA635397_P_NODE_35313_length_266_cov_2.253886_g34859_i0	PRJNA635397	35313	266	2.253886	5.99533676	Limisphaera sp.	2838792	Bacteria	Bacteria	43.5	0.0253	NR	MEJ5238961.1	2838792	g34859	i0	32.5	0.93609022556391	83	55	93.6	1	14	262	135	216	MEJ5238961.1 FIST N-terminal domain-containing protein [Limisphaera sp.]	diamond	249	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Limisphaeraceae	Limisphaera	Limisphaera sp.
31123196	31123196	PRJNA635397_P_NODE_29155_length_294_cov_3.800905_g28701_i0	PRJNA635397	29155	294	3.800905	11.1746607	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	43.5	0.0369	NR	MCL4203912.1	2699754	g28701	i0	28.6	0.857142857142857	84	59	85.7	1	286	35	285	367	MCL4203912.1 DEAD/DEAH box helicase [Pirellulaceae bacterium]	diamond	252	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
31534880	31534880	PRJNA635397_P_NODE_35816_length_264_cov_2.136126_g35362_i0	PRJNA635397	35816	264	2.136126	5.63937264	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	41.2	0.0315	NR	HSZ57079.1	2876886	g35362	i0	35.8	0.602272727272727	53	32	60.2	1	48	206	30	80	HSZ57079.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	159	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
32009218	32009218	PRJNA635397_P_NODE_21558_length_346_cov_1.710623_g21104_i0	PRJNA635397	21558	346	1.710623	5.91875558	Singulisphaera acidiphila	466153	Bacteria	Bacteria	44.3	0.035	NR	WP_015245602.1	466153	g21104	i0	38.8	0.69364161849711	80	46	68.5	2	77	313	181	258	WP_015245602.1 serine/threonine-protein kinase [Singulisphaera acidiphila]	diamond	240	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
32230884	32230884	PRJNA635397_P_NODE_24378_length_324_cov_1.215139_g23924_i0	PRJNA635397	24378	324	1.215139	3.93705036	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	88.2	1.18e-18	NR	MBY0308879.1	2052180	g23924	i0	92.9	0.388888888888889	42	3	38.9	0	130	5	191	232	MBY0308879.1 hypothetical protein [Phycisphaerales bacterium]	diamond	126	88.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32610165	32610165	PRJNA635397_P_NODE_24220_length_325_cov_1.198413_g23766_i0	PRJNA635397	24220	325	1.198413	3.89484225	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.0162	NR	TAH36757.1	2026780	g23766	i0	36.4	0.710769230769231	77	40	67.4	3	319	101	64	135	TAH36757.1 MAG: ribonuclease PH [Planctomycetota bacterium]	diamond	231	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;