metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA352850" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA352850" 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
4222235	4222235	PRJNA352850_P_NODE_19964_length_650_cov_6.128120_g17203_i0	PRJNA352850	19964	650	6.12812	39.83278	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	337	3.659999999999999e-112	NR	MBC8002191.1	2026801	g17203	i0	75.2	7.86	214	51	98.8	1	2	643	220	431	MBC8002191.1 L-fuconate dehydratase [Verrucomicrobiales bacterium]	diamond	5109	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
24621994	24621994	PRJNA352850_P_NODE_47420_length_354_cov_2.573770_g44587_i0	PRJNA352850	47420	354	2.57377	9.1111458	Singulisphaera sp. Ch	1906241	Bacteria	Bacteria	129	8.159999999999999e-32	NR	WP_406700929.1	3120278	g44587	i0	78.5	1.57627118644068	93	20	78.8	0	350	72	897	989	WP_406700929.1 beta strand repeat-containing protein [Singulisphaera sp. Ch08]	diamond	558	129	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
27201048	27201048	PRJNA352850_P_NODE_78722_length_252_cov_1.004926_g75889_i0	PRJNA352850	78722	252	1.004926	2.53241352	Novipirellula caenicola	1536901	Bacteria	Bacteria	121	7.789999999999999e-31	NR	WP_345689132.1	1536901	g75889	i0	73.8	5	84	22	100	0	252	1	18	101	WP_345689132.1 2-amino-4-hydroxy-6-hydroxymethyldihydropteridine diphosphokinase [Novipirellula caenicola]	diamond	1260	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Novipirellula	Novipirellula caenicola
27990929	27990929	PRJNA352850_P_NODE_46825_length_357_cov_2.636364_g43992_i0	PRJNA352850	46825	357	2.636364	9.41181948	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	44.7	0.0142	NR	MCH1506043.1	2026801	g43992	i0	39	0.991596638655462	59	32	47.1	2	349	182	78	135	MCH1506043.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	354	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28053839	28053839	PRJNA352850_P_NODE_56465_length_313_cov_2.166667_g53632_i0	PRJNA352850	56465	313	2.166667	6.78166771	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	99	1.6e-21	NR	MEZ6130026.1	2026779	g53632	i0	65.2	0.853035143769968	89	31	85.3	0	296	30	2966	3054	MEZ6130026.1 YDG domain-containing protein [Planctomycetaceae bacterium]	diamond	267	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29018615	29018615	PRJNA352850_P_NODE_55908_length_315_cov_2.808271_g53075_i0	PRJNA352850	55908	315	2.808271	8.84605365	Tautonia	2680020	Bacteria	Bacteria	118	1.79e-28	NR	WP_152049823.1	2653855	g53075	i0	83.1	1.46666666666667	77	13	73.3	0	83	313	2	78	WP_152049823.1 AI-2E family transporter [Tautonia marina]	diamond	462	118	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia marina
29032970	29032970	PRJNA352850_P_NODE_60388_length_298_cov_2.911647_g57555_i0	PRJNA352850	60388	298	2.911647	8.67670806	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	84.3	2.26e-17	NR	HLJ10262.1	2026779	g57555	i0	46.4	0.845637583892617	84	45	84.6	0	252	1	141	224	HLJ10262.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	252	84.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29600790	29600790	PRJNA352850_P_NODE_67410_length_275_cov_3.951327_g64577_i0	PRJNA352850	67410	275	3.951327	10.86614925	Planctomycetes bacterium Pla133	2528011	Bacteria	Bacteria	145	1.11e-40	NR	QDU66550.1	2528011	g64577	i0	76.4	2.89090909090909	89	21	97.1	0	274	8	208	296	QDU66550.1 putative 3-hydroxybutyryl-CoA dehydrogenase [Planctomycetes bacterium Pla133]	diamond	795	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
29965673	29965673	PRJNA352850_P_NODE_12491_length_919_cov_4.281609_g10016_i0	PRJNA352850	12491	919	4.2816090000000004	39.34798671	Planctomycetaceae	126	Bacteria	Bacteria	212	8.910000000000001e-59	NR	WP_310821170.1	2527980	g10016	i0	46.5	1.67791077257889	254	128	81.9	4	2	754	280	528	WP_310821170.1 peroxidase family protein [Stratiformator vulcanicus]	diamond	1542	212	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
29980057	29980057	PRJNA352850_P_NODE_58971_length_304_cov_1.203922_g56138_i0	PRJNA352850	58971	304	1.203922	3.65992288	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	103	2.94e-23	NR	HNQ23619.1	2026778	g56138	i0	59	0.769736842105263	78	31	76	1	234	4	21	98	HNQ23619.1 aspartate aminotransferase family protein [Phycisphaerae bacterium]	diamond	234	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30738220	30738220	PRJNA352850_P_NODE_58514_length_305_cov_3.246094_g55681_i0	PRJNA352850	58514	305	3.246094	9.9005867	Chlamydiales bacterium	2047757	Bacteria	Bacteria	87.8	2.41e-18	NR	MBN9377724.1	2047757	g55681	i0	47	0.983606557377049	100	51	96.4	2	304	11	184	283	MBN9377724.1 hypothetical protein [Chlamydiales bacterium]	diamond	300	87.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31560403	31560403	PRJNA352850_P_NODE_81836_length_246_cov_2.111675_g79003_i0	PRJNA352850	81836	246	2.111675	5.1947205	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	51.6	2.81e-5	NR	HYE19843.1	2876886	g79003	i0	41.8	0.817073170731707	67	39	81.7	0	203	3	58	124	HYE19843.1 HlyD family efflux transporter periplasmic adaptor subunit [Tepidisphaeraceae bacterium]	diamond	201	51.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31592009	31592009	PRJNA352850_P_NODE_65536_length_281_cov_2.241379_g62703_i0	PRJNA352850	65536	281	2.241379	6.29827499	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	62.4	6.85e-10	NR	MDP9291775.1	2026799	g62703	i0	75	0.875444839857651	40	10	42.7	0	281	162	76	115	MDP9291775.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	246	62.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32256552	32256552	PRJNA352850_P_NODE_34678_length_441_cov_4.563776_g31847_i0	PRJNA352850	34678	441	4.563776	20.12625216	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.5	4.6e-5	NR	NRA95951.1	2026780	g31847	i0	39.5	0.551020408163265	81	47	55.1	2	11	253	203	281	NRA95951.1 hypothetical protein [Planctomycetota bacterium]	diamond	243	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32494991	32494991	PRJNA352850_P_NODE_7099_length_1419_cov_6.465693_g5141_i0	PRJNA352850	7099	1419	6.465693	91.74818367	Pseudomonadati	3379134	Bacteria	Bacteria	401	1.86e-132	NR	TDJ68285.1	2026780	g5141	i0	45.2	19.6384778012685	442	236	93	3	1417	98	28	465	TDJ68285.1 MAG: M20/M25/M40 family metallo-hydrolase [Planctomycetota bacterium]	diamond	27867	401	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32635282	32635282	PRJNA352850_P_NODE_65140_length_283_cov_1.111111_g62307_i0	PRJNA352850	65140	283	1.111111	3.14444413	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	65.1	7.43e-10	NR	MFC1510138.1	2035772	g62307	i0	37.3	5.26855123674912	83	52	88	0	3	251	304	386	MFC1510138.1 8-amino-7-oxononanoate synthase [Candidatus Omnitrophota bacterium]	diamond	1491	65.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota 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);;