metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax

19 rows where analysis = "diamond", bioproject = "PRJEB29441" 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
8641442	8641442	PRJEB29441_P_NODE_27787_length_199_cov_1.360000_g27346_i0	PRJEB29441	27787	199	1.36	2.7064	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	72.8	1.5e-13	NR	MEY3000757.1	2026799	g27346	i0	55.6	0.949748743718593	63	28	95	0	9	197	98	160	MEY3000757.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	189	72.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
21703072	21703072	PRJEB29441_P_NODE_17918_length_254_cov_1.482927_g17477_i0	PRJEB29441	17918	254	1.482927	3.76663458	Bacteria	2	Bacteria	Bacteria	148	3.61e-44	NR	MBM4098314.1	2026780	g17477	i0	92.9	12.8976377952756	84	6	99.2	0	253	2	37	120	MBM4098314.1 phosphoglycerate kinase [Planctomycetota bacterium]	diamond	3276	149	0.993288590604027	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
21703525	21703525	PRJEB29441_P_NODE_45418_length_162_cov_0.902655_g44977_i0	PRJEB29441	45418	162	0.902655	1.4623011	Singulisphaera sp. GP187	1882752	Bacteria	Bacteria	73.9	3.15e-15	NR	WP_074309795.1	1882752	g44977	i0	84.4	2.5	45	7	83.3	0	136	2	1	45	WP_074309795.1 50S ribosomal protein L18 [Singulisphaera sp. GP187]	diamond	405	73.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. GP187
26805134	26805134	PRJEB29441_P_NODE_41721_length_165_cov_0.879310_g41280_i0	PRJEB29441	41721	165	0.87931	1.4508615	Pseudomonadati	3379134	Bacteria	Bacteria	45.8	0.00108	NR	MDP7348638.1	2026777	g41280	i0	50	3.47272727272727	46	23	83.6	0	1	138	97	142	MDP7348638.1 cation:proton antiporter [Phycisphaeraceae bacterium]	diamond	573	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
27500897	27500897	PRJEB29441_P_NODE_40183_length_166_cov_0.871795_g39742_i0	PRJEB29441	40183	166	0.871795	1.4471797	root	1	Root_unresolved	Root_unresolved	73.2	2.12e-13	NR	MBP8256567.1	2006848	g39742	i0	53	14.7831325301205	66	19	97.6	2	4	165	146	211	MBP8256567.1 multicopper oxidase domain-containing protein [Opitutaceae bacterium]	diamond	2454	73.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27665294	27665294	PRJEB29441_P_NODE_41824_length_165_cov_0.879310_g41383_i0	PRJEB29441	41824	165	0.87931	1.4508615	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.00483	NR	MBS0625518.1	2026799	g41383	i0	52.6	0.690909090909091	38	18	69.1	0	159	46	203	240	MBS0625518.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	114	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27917584	27917584	PRJEB29441_P_NODE_31365_length_187_cov_1.260870_g30924_i0	PRJEB29441	31365	187	1.26087	2.3578269	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	79.3	1.45e-15	NR	RYD71398.1	2026800	g30924	i0	59	0.978609625668449	61	25	97.9	0	3	185	247	307	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	183	79.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28580870	28580870	PRJEB29441_P_NODE_33427_length_181_cov_1.469697_g32986_i0	PRJEB29441	33427	181	1.469697	2.66015157	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	61.2	4.75e-9	NR	MCO6455093.1	2699754	g32986	i0	55.6	1.04419889502762	63	23	97.8	2	3	179	1431	1492	MCO6455093.1 choice-of-anchor D domain-containing protein [Pirellulaceae bacterium]	diamond	189	61.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
28801585	28801585	PRJEB29441_P_NODE_41608_length_165_cov_0.879310_g41167_i0	PRJEB29441	41608	165	0.87931	1.4508615	Pirellulales bacterium	2715253	Bacteria	Bacteria	63.9	4.38e-10	NR	MEX2317847.1	2715253	g41167	i0	54.5	1	55	25	100	0	1	165	172	226	MEX2317847.1 glycosyltransferase family 39 protein [Pirellulales bacterium]	diamond	165	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29811997	29811997	PRJEB29441_P_NODE_47631_length_161_cov_0.901786_g47190_i0	PRJEB29441	47631	161	0.901786	1.45187546	Planctomycetia bacterium	2052181	Bacteria	Bacteria	48.1	1.52e-4	NR	MBL8824214.1	2052181	g47190	i0	47.2	0.987577639751553	53	27	98.8	1	2	160	209	260	MBL8824214.1 hypothetical protein [Planctomycetia bacterium]	diamond	159	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
29907033	29907033	PRJEB29441_P_NODE_42971_length_164_cov_0.886957_g42530_i0	PRJEB29441	42971	164	0.886957	1.45460948	Pirellulales bacterium	2715253	Bacteria	Bacteria	105	7.38e-25	NR	MFO0921869.1	2715253	g42530	i0	100	0.98780487804878	54	0	98.8	0	162	1	250	303	MFO0921869.1 Gldg family protein [Pirellulales bacterium]	diamond	162	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30286442	30286442	PRJEB29441_P_NODE_45432_length_162_cov_0.902655_g44991_i0	PRJEB29441	45432	162	0.902655	1.4623011	Planctomycetota bacterium	2026780	Bacteria	Bacteria	40.8	0.0444	NR	MEO1619295.1	2026780	g44991	i0	33.3	0.944444444444444	51	34	94.4	0	156	4	81	131	MEO1619295.1 hypothetical protein [Planctomycetota bacterium]	diamond	153	40.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30318182	30318182	PRJEB29441_P_NODE_39012_length_167_cov_0.864407_g38571_i0	PRJEB29441	39012	167	0.864407	1.44355969	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	41.6	0.035	NR	HEX5218075.1	2499141	g38571	i0	44.4	0.970059880239521	54	26	91.6	3	167	15	956	1008	HEX5218075.1 Ig-like domain-containing protein [Verrucomicrobiia bacterium]	diamond	162	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30823132	30823132	PRJEB29441_P_NODE_42954_length_164_cov_0.886957_g42513_i0	PRJEB29441	42954	164	0.886957	1.45460948	Planctomycetota bacterium	2026780	Bacteria	Bacteria	77.8	5.55e-15	NR	MCK4958412.1	2026780	g42513	i0	71.4	2.6890243902439	49	14	89.6	0	2	148	1	49	MCK4958412.1 hypothetical protein [Planctomycetota bacterium]	diamond	441	77.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30879768	30879768	PRJEB29441_P_NODE_44834_length_163_cov_0.894737_g44393_i0	PRJEB29441	44834	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	43.9	0.00499	NR	MEI6177523.1	2026799	g44393	i0	51.4	1.93251533742331	35	17	64.4	0	58	162	273	307	MEI6177523.1 complex I subunit 1 family protein [Verrucomicrobiota bacterium]	diamond	315	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31138766	31138766	PRJEB29441_P_NODE_33775_length_180_cov_1.450382_g33334_i0	PRJEB29441	33775	180	1.450382	2.6106876	Gemmataceae bacterium	2052164	Bacteria	Bacteria	97.8	1.78e-22	NR	MFO0936440.1	2052164	g33334	i0	71.2	0.983333333333333	59	17	98.3	0	179	3	247	305	MFO0936440.1 Ldh family oxidoreductase [Gemmataceae bacterium]	diamond	177	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31575477	31575477	PRJEB29441_P_NODE_47176_length_161_cov_0.910714_g46735_i0	PRJEB29441	47176	161	0.910714	1.46624954	Pirellula	123	Bacteria	Bacteria	72.4	7.38e-14	NR	MCE2753777.1	117	g46735	i0	67.3	3.83850931677019	52	17	96.9	0	156	1	93	144	MCE2753777.1 transposase [Pirellula sp.]	diamond	618	72.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
32024767	32024767	PRJEB29441_P_NODE_27838_length_199_cov_1.093333_g27397_i0	PRJEB29441	27838	199	1.093333	2.17573267	Neorhodopirellula lusitana	445327	Bacteria	Bacteria	42	0.0383	NR	WP_283435201.1	445327	g27397	i0	35.6	0.889447236180904	59	31	82.9	2	170	6	395	450	WP_283435201.1 ArnT family glycosyltransferase [Neorhodopirellula lusitana]	diamond	177	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Neorhodopirellula	Neorhodopirellula lusitana
32650310	32650310	PRJEB29441_P_NODE_47440_length_161_cov_0.910714_g46999_i0	PRJEB29441	47440	161	0.910714	1.46624954	Prosthecobacter	48463	Bacteria	Bacteria	75.9	2.53e-14	NR	WP_184343614.1	48466	g46999	i0	60.4	2.94409937888199	53	21	98.8	0	160	2	37	89	WP_184343614.1 LTA synthase family protein [Prosthecobacter vanneervenii]	diamond	474	76.3	0.99475753604194	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii

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