metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1068513" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1068513" 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
24407699	24407699	PRJNA1068513_S_NODE_12500_length_249_cov_1.329545_g12454_i0	PRJNA1068513	12500	249	1.329545	3.31056705	Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8	1797601	Bacteria	Bacteria	103	2.6999999999999997e-25	NR	OGN59821.1	1797601	g12454	i0	56.3	1.95180722891566	80	35	96.4	0	240	1	101	180	OGN59821.1 MAG: superoxide dismutase [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8]	diamond	486	103	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8
28614820	28614820	PRJNA1068513_S_NODE_8187_length_316_cov_5.481481_g8141_i0	PRJNA1068513	8187	316	5.481481	17.32147996	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	73.2	7.8e-13	NR	MDX1565183.1	2026777	g8141	i0	54.1	1.20569620253165	61	28	57.9	0	18	200	223	283	MDX1565183.1 aldolase/citrate lyase family protein [Phycisphaeraceae bacterium]	diamond	381	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
29088481	29088481	PRJNA1068513_S_NODE_9428_length_293_cov_1.259091_g9382_i0	PRJNA1068513	9428	293	1.259091	3.68913663	Planctomycetota bacterium	2026780	Bacteria	Bacteria	70.1	1.58e-11	NR	MFT7557815.1	2026780	g9382	i0	68.2	0.450511945392491	44	14	45.1	0	47	178	437	480	MFT7557815.1 asparaginyl-tRNA synthetase [Planctomycetota bacterium]	diamond	132	70.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29846186	29846186	PRJNA1068513_S_NODE_6491_length_358_cov_3.589474_g6445_i0	PRJNA1068513	6491	358	3.589474	12.85031692	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	68.2	1.43e-10	NR	MCU0702928.1	1914235	g6445	i0	46.7	3.82122905027933	75	40	62.8	0	9	233	306	380	MCU0702928.1 cysteine desulfurase [Fimbriiglobus sp.]	diamond	1368	68.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
29941091	29941091	PRJNA1068513_S_NODE_13151_length_244_cov_0.859649_g13105_i0	PRJNA1068513	13151	244	0.859649	2.09754356	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	43.1	0.0276	NR	MBR2982784.1	2212473	g13105	i0	39	0.94672131147541	77	39	94.7	1	11	241	352	420	MBR2982784.1 murein biosynthesis integral membrane protein MurJ [Kiritimatiellia bacterium]	diamond	231	43.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31006741	31006741	PRJNA1068513_S_NODE_11114_length_266_cov_1.212435_g11068_i0	PRJNA1068513	11114	266	1.212435	3.2250771	Planctomycetota	203682	Bacteria	Bacteria	55.1	2.31e-6	NR	PHS07368.1	2024826	g11068	i0	63	4.68045112781955	46	17	51.9	0	1	138	1750	1795	PHS07368.1 MAG: hypothetical protein COA78_13480, partial [Blastopirellula sp.]	diamond	1245	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sp.
32090444	32090444	PRJNA1068513_S_NODE_11338_length_262_cov_2.486772_g11292_i0	PRJNA1068513	11338	262	2.486772	6.51534264	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	107	1.71e-27	NR	MAH13224.1	2026799	g11292	i0	56.3	2.74809160305344	80	35	91.6	0	2	241	81	160	MAH13224.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	720	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32565355	32565355	PRJNA1068513_S_NODE_10799_length_271_cov_1.393939_g10753_i0	PRJNA1068513	10799	271	1.393939	3.77757469	Omnitrophica bacterium GWA2_5	2035772	Bacteria	Bacteria	44.7	0.00734	NR	OGW68872.1	1801815	g10753	i0	29	0.686346863468635	62	44	68.6	0	186	1	45	106	OGW68872.1 MAG: hypothetical protein A2036_01175 [Omnitrophica bacterium GWA2_50_21]	diamond	186	44.7	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Omnitrophica bacterium GWA2_50_21

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