metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax

15 rows where analysis = "diamond", bioproject = "PRJEB58983" 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
12878844	12878844	PRJEB58983_P_NODE_751_length_1501_cov_13.788515_g546_i0	PRJEB58983	751	1501	13.788515	206.96561015	Bacteria	2	Bacteria	Bacteria	236	1.35e-71	NR	RYD62314.1	2026800	g546	i0	71.7	0.667554963357762	166	43	32.4	1	1013	1498	1	166	RYD62314.1 MAG: hypothetical protein EOP83_14915 [Verrucomicrobiaceae bacterium]	diamond	1002	236	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
16701596	16701596	PRJEB58983_P_NODE_23594_length_271_cov_3.535354_g23179_i0	PRJEB58983	23594	271	3.535354	9.58080934	Bacteria	2	Bacteria	Bacteria	118	4.36e-31	NR	MCB1108575.1	2052156	g23179	i0	64.9	1.63837638376384	74	26	81.9	0	269	48	126	199	MCB1108575.1 superoxide dismutase [Chlamydiia bacterium]	diamond	444	118	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
26716641	26716641	PRJEB58983_P_NODE_12841_length_352_cov_5.501792_g12426_i0	PRJEB58983	12841	352	5.501792	19.36630784	Chlamydiales bacterium	2047757	Bacteria	Bacteria	108	1.68e-27	NR	MCP5470420.1	2047757	g12426	i0	48.3	1.98579545454545	116	60	98.9	0	351	4	2	117	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	699	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28644394	28644394	PRJEB58983_P_NODE_22347_length_277_cov_2.887255_g21932_i0	PRJEB58983	22347	277	2.887255	7.99769635	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	47	0.00184	NR	MDW8349389.1	2499141	g21932	i0	34.8	0.714801444043321	66	41	69.3	1	212	21	1676	1741	MDW8349389.1 putative Ig domain-containing protein [Verrucomicrobiia bacterium]	diamond	198	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28675958	28675958	PRJEB58983_P_NODE_33687_length_234_cov_2.093168_g33272_i0	PRJEB58983	33687	234	2.093168	4.89801312	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47	2.97e-4	NR	MBM4038888.1	2026780	g33272	i0	38.4	0.935897435897436	73	44	92.3	1	5	220	55	127	MBM4038888.1 hypothetical protein [Planctomycetota bacterium]	diamond	219	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29464772	29464772	PRJEB58983_P_NODE_23550_length_272_cov_1.190955_g23135_i0	PRJEB58983	23550	272	1.190955	3.2393976	Planctomycetota bacterium	2026780	Bacteria	Bacteria	61.2	1.69e-8	NR	MEM9942907.1	2026780	g23135	i0	35.2	1.94117647058824	88	56	96	1	9	269	668	755	MEM9942907.1 hypothetical protein [Planctomycetota bacterium]	diamond	528	61.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29464792	29464792	PRJEB58983_P_NODE_9390_length_406_cov_5.945946_g8976_i0	PRJEB58983	9390	406	5.945946	24.14054076	Candidatus Brocadiales bacterium	2760054	Bacteria	Bacteria	68.2	7.01e-11	NR	MBC8550112.1	2760054	g8976	i0	36.4	0.731527093596059	99	60	70.9	1	2	289	1	99	MBC8550112.1 hypothetical protein [Candidatus Brocadiales bacterium]	diamond	297	68.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales			Candidatus Brocadiales bacterium
29907400	29907400	PRJEB58983_P_NODE_9731_length_400_cov_1.311927_g9317_i0	PRJEB58983	9731	400	1.311927	5.247708	Candidatus Methylacidiphilales bacterium	2720631	Bacteria	Bacteria	108	1.43e-24	NR	MCE0483121.1	2720631	g9317	i0	47.3	0.9825	131	68	98.3	1	395	3	224	353	MCE0483121.1 AAA family ATPase [Candidatus Methylacidiphilales bacterium]	diamond	393	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
30152959	30152959	PRJEB58983_P_NODE_31512_length_244_cov_1.035088_g31097_i0	PRJEB58983	31512	244	1.035088	2.52561472	Pseudomonadati	3379134	Bacteria	Bacteria	73.9	3.97e-13	NR	MDA0323257.1	2026799	g31097	i0	51.2	3	82	38	99.6	2	243	1	231	311	MDA0323257.1 C25 family cysteine peptidase [Verrucomicrobiota bacterium]	diamond	732	73.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30563634	30563634	PRJEB58983_P_NODE_1893_length_924_cov_2.030552_g1551_i0	PRJEB58983	1893	924	2.030552	18.76230048	Pseudomonadati	3379134	Bacteria	Bacteria	247	3.42e-72	NR	MFA6961216.1	2006848	g1551	i0	45.2	3.02272727272727	310	148	99.4	7	924	7	329	620	MFA6961216.1 TonB-dependent siderophore receptor [Opitutaceae bacterium]	diamond	2793	247	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30728678	30728678	PRJEB58983_P_NODE_28874_length_250_cov_1.740113_g28459_i0	PRJEB58983	28874	250	1.740113	4.3502825	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	108	2.82e-25	NR	HEV8605080.1	2876886	g28459	i0	60.8	1.92	79	31	94.8	0	245	9	2830	2908	HEV8605080.1 proprotein convertase P-domain-containing protein [Tepidisphaeraceae bacterium]	diamond	480	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30823501	30823501	PRJEB58983_P_NODE_29374_length_249_cov_1.329545_g28959_i0	PRJEB58983	29374	249	1.329545	3.31056705	Pedosphaera sp.	2024890	Bacteria	Bacteria	85.9	2.67e-17	NR	MSU31824.1	2024890	g28959	i0	55.7	2.85542168674699	79	35	95.2	0	237	1	549	627	MSU31824.1 type IV pilus assembly protein PilM [Pedosphaera sp.]	diamond	711	85.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
31487531	31487531	PRJEB58983_P_NODE_30376_length_247_cov_0.867816_g29961_i0	PRJEB58983	30376	247	0.867816	2.14350552	Planctomycetota bacterium	2026780	Bacteria	Bacteria	76.6	6.95e-15	NR	MFP6738218.1	2026780	g29961	i0	53.9	0.923076923076923	76	34	91.1	1	243	19	109	184	MFP6738218.1 hypothetical protein [Planctomycetota bacterium]	diamond	228	76.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32563216	32563216	PRJEB58983_P_NODE_28699_length_251_cov_0.876404_g28284_i0	PRJEB58983	28699	251	0.876404	2.19977404	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	164	6.29e-51	NR	MCG3176942.1	2035772	g28284	i0	97.6	0.9800796812749	82	2	98	0	246	1	1	82	MCG3176942.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	246	164	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
32563222	32563222	PRJEB58983_P_NODE_5399_length_529_cov_1.092105_g4986_i0	PRJEB58983	5399	529	1.092105	5.77723545	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	53.5	1.09e-4	NR	MEX2174072.1	2699754	g4986	i0	54.8	0.793950850661626	42	19	23.8	0	390	515	198	239	MEX2174072.1 hypothetical protein [Pirellulaceae bacterium]	diamond	420	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae 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);;