metadata: contig_metadata: 24 rows where analysis = "diamond", bioproject = "PRJNA1087264" and tax

24 rows where analysis = "diamond", bioproject = "PRJNA1087264" 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
194151	194151	PRJNA1087264_P_NODE_9081_length_209_cov_1.218750_g8999_i0	PRJNA1087264	9081	209	1.21875	2.5471875	Bacteria	2	Bacteria	Bacteria	75.5	6.79e-14	NR	MEY4483817.1	2026799	g8999	i0	55.9	8.75598086124402	68	23	97.6	1	206	3	352	412	MEY4483817.1 glutamate synthase large subunit [Verrucomicrobiota bacterium]	diamond	1830	75.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
10397448	10397448	PRJNA1087264_P_NODE_9089_length_209_cov_1.112500_g9007_i0	PRJNA1087264	9089	209	1.1125	2.325125	Simkania sp.	34094	Bacteria	Bacteria	126	4.13e-34	NR	MCB1084310.1	34094	g9007	i0	88.4	0.990430622009569	69	8	99	0	1	207	31	99	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	207	126	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
20595136	20595136	PRJNA1087264_P_NODE_297_length_1139_cov_3.261468_g254_i0	PRJNA1087264	297	1139	3.261468	37.14812052	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	359	8.899999999999997e-113	NR	MCX7871735.1	2499141	g254	i0	50.5	6.80860403863038	376	176	99	2	1137	10	475	840	MCX7871735.1 magnesium-translocating P-type ATPase [Verrucomicrobiia bacterium]	diamond	7755	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26814451	26814451	PRJNA1087264_P_NODE_1181_length_612_cov_1.298401_g1107_i0	PRJNA1087264	1181	612	1.298401	7.94621412	Chlamydiales bacterium	2047757	Bacteria	Bacteria	62.8	1.19e-7	NR	MDF2577680.1	2047757	g1107	i0	28.2	2.00980392156863	216	122	98	6	3	602	145	343	MDF2577680.1 hypothetical protein [Chlamydiales bacterium]	diamond	1230	62.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27058952	27058952	PRJNA1087264_P_NODE_5862_length_264_cov_0.948837_g5780_i0	PRJNA1087264	5862	264	0.948837	2.50492968	root	1	Root_unresolved	Root_unresolved	42.7	0.0356	NR	MCB1125209.1	2499141	g5780	i0	31.6	1.52272727272727	76	48	83	2	37	255	59	133	MCB1125209.1 acyltransferase [Verrucomicrobiia bacterium]	diamond	402	43.1	0.990719257540603	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27130320	27130320	PRJNA1087264_P_NODE_15122_length_167_cov_0.864407_g15040_i0	PRJNA1087264	15122	167	0.864407	1.44355969	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	42.4	0.0182	NR	MFA6916993.1	2052178	g15040	i0	52.5	1.47305389221557	40	19	71.9	0	123	4	201	240	MFA6916993.1 hypothetical protein [Parachlamydiales bacterium]	diamond	246	42.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
27193826	27193826	PRJNA1087264_P_NODE_13962_length_168_cov_1.285714_g13880_i0	PRJNA1087264	13962	168	1.285714	2.15999952	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	68.9	5.99e-12	NR	MDX2199290.1	2026778	g13880	i0	54.5	1.96428571428571	55	23	98.2	1	3	167	83	135	MDX2199290.1 NAD(P)-dependent alcohol dehydrogenase [Phycisphaerae bacterium]	diamond	330	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27320468	27320468	PRJNA1087264_P_NODE_17603_length_165_cov_0.879310_g17521_i0	PRJNA1087264	17603	165	0.87931	1.4508615	Fuerstiella sp.	1936112	Bacteria	Bacteria	55.8	2.2e-7	NR	MCP4511687.1	1936112	g17521	i0	36.4	1.83636363636364	55	35	100	0	1	165	119	173	MCP4511687.1 hypothetical protein [Fuerstiella sp.]	diamond	303	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella sp.
27573049	27573049	PRJNA1087264_P_NODE_8264_length_219_cov_1.764706_g8182_i0	PRJNA1087264	8264	219	1.764706	3.86470614	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	66.2	1.23e-10	NR	RYD71398.1	2026800	g8182	i0	49.3	1	73	36	98.6	1	2	217	272	344	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	219	66.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27699673	27699673	PRJNA1087264_P_NODE_20684_length_162_cov_0.902655_g20602_i0	PRJNA1087264	20684	162	0.902655	1.4623011	Gemmataceae bacterium	2052164	Bacteria	Bacteria	45.1	8.53e-4	NR	MFO0849856.1	2052164	g20602	i0	45.3	0.981481481481482	53	27	96.3	2	157	2	36	87	MFO0849856.1 BPSL0067 family protein [Gemmataceae bacterium]	diamond	159	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29593380	29593380	PRJNA1087264_P_NODE_20950_length_162_cov_0.858407_g20868_i0	PRJNA1087264	20950	162	0.858407	1.39061934	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	52	6.92e-6	NR	HOW35386.1	2035772	g20868	i0	63.6	3.51851851851852	33	12	61.1	0	64	162	218	250	HOW35386.1 glutamine synthetase III [Candidatus Omnitrophota bacterium]	diamond	570	52	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
29656515	29656515	PRJNA1087264_P_NODE_2530_length_419_cov_1.851351_g2449_i0	PRJNA1087264	2530	419	1.851351	7.75716069	Pirellula sp.	117	Bacteria	Bacteria	50.4	4.76e-4	NR	MFM7931657.1	117	g2449	i0	34.8	1.91169451073986	89	57	63	1	6	269	48	136	MFM7931657.1 SdrD B-like domain-containing protein [Pirellula sp.]	diamond	801	50.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
29656518	29656518	PRJNA1087264_P_NODE_7050_length_238_cov_1.301587_g6968_i0	PRJNA1087264	7050	238	1.301587	3.09777706	Chlamydiales bacterium	2047757	Bacteria	Bacteria	45.4	0.00189	NR	MCP5470420.1	2047757	g6968	i0	70.4	0.340336134453782	27	8	34	0	1	81	53	79	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	81	45.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29878098	29878098	PRJNA1087264_P_NODE_7551_length_229_cov_1.533333_g7469_i0	PRJNA1087264	7551	229	1.533333	3.51133257	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	127	2.04e-33	NR	RYD65414.1	2026800	g7469	i0	84	0.982532751091703	75	12	98.3	0	1	225	87	161	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	225	127	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31078731	31078731	PRJNA1087264_P_NODE_8495_length_216_cov_2.107784_g8413_i0	PRJNA1087264	8495	216	2.107784	4.55281344	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0276	NR	SPE54920.1	2026799	g8413	i0	43.6	0.763888888888889	55	29	76.4	1	180	16	461	513	SPE54920.1 hypothetical protein SBV1_1980011 [Verrucomicrobiota bacterium]	diamond	165	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31109985	31109985	PRJNA1087264_P_NODE_5835_length_264_cov_2.200000_g5753_i0	PRJNA1087264	5835	264	2.2	5.808	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	101	1.01e-25	NR	RYD73501.1	2026800	g5753	i0	77.4	1.43181818181818	62	14	70.5	0	203	18	3	64	RYD73501.1 MAG: fructose-bisphosphate aldolase class I [Verrucomicrobiaceae bacterium]	diamond	378	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31268255	31268255	PRJNA1087264_P_NODE_20395_length_162_cov_0.902655_g20313_i0	PRJNA1087264	20395	162	0.902655	1.4623011	Pelagicoccus albus	415222	Bacteria	Bacteria	78.2	2.1e-15	NR	WP_185658533.1	415222	g20313	i0	68.5	2.98148148148148	54	17	100	0	1	162	105	158	WP_185658533.1 cysteine synthase A [Pelagicoccus albus]	diamond	483	78.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Pelagicoccaceae	Pelagicoccus	Pelagicoccus albus
31331401	31331401	PRJNA1087264_P_NODE_5476_length_273_cov_1.580357_g5394_i0	PRJNA1087264	5476	273	1.580357	4.31437461	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	47.4	0.00124	NR	MDF1753436.1	2026801	g5394	i0	34.5	0.923076923076923	84	45	87.9	3	31	270	322	399	MDF1753436.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	252	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31331403	31331403	PRJNA1087264_P_NODE_6956_length_240_cov_1.068063_g6874_i0	PRJNA1087264	6956	240	1.068063	2.5633512	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	53.9	4.01e-6	NR	MEO0797117.1	2026799	g6874	i0	36.5	0.7875	63	40	78.8	0	51	239	7	69	MEO0797117.1 serine/threonine-protein kinase [Verrucomicrobiota bacterium]	diamond	189	53.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31363253	31363253	PRJNA1087264_P_NODE_12076_length_182_cov_0.842105_g11994_i0	PRJNA1087264	12076	182	0.842105	1.5326311	Planctomycetes bacterium DG_23	1703414	Bacteria	Bacteria	55.1	4.95e-7	NR	KPJ58283.1	1703414	g11994	i0	46	1.81318681318681	50	27	82.4	0	178	29	62	111	KPJ58283.1 MAG: hypothetical protein AMS15_08795 [Planctomycetes bacterium DG_23]	diamond	330	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium DG_23
31900828	31900828	PRJNA1087264_P_NODE_7857_length_225_cov_0.869318_g7775_i0	PRJNA1087264	7857	225	0.869318	1.9559655	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	48.5	2.6e-4	NR	MEY4445816.1	2026799	g7775	i0	46.7	0.8	60	26	77.3	2	44	217	92	147	MEY4445816.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	180	48.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32122477	32122477	PRJNA1087264_P_NODE_16898_length_165_cov_0.879310_g16816_i0	PRJNA1087264	16898	165	0.87931	1.4508615	Pirellulales bacterium	2715253	Bacteria	Bacteria	60.8	5.37e-9	NR	MBN1912441.1	2715253	g16816	i0	50.9	3.89090909090909	55	27	100	0	165	1	213	267	MBN1912441.1 sulfatase [Pirellulales bacterium]	diamond	642	60.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32785554	32785554	PRJNA1087264_P_NODE_19440_length_163_cov_0.894737_g19358_i0	PRJNA1087264	19440	163	0.894737	1.45842131	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	81.3	1.97e-16	NR	MFU8779755.1	2212473	g19358	i0	63	0.993865030674847	54	20	99.4	0	1	162	148	201	MFU8779755.1 tRNA-dihydrouridine synthase family protein [Kiritimatiellia bacterium]	diamond	162	81.3	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32817147	32817147	PRJNA1087264_P_NODE_1620_length_529_cov_1.900000_g1541_i0	PRJNA1087264	1620	529	1.9	10.051	Planctomycetota bacterium	2026780	Bacteria	Bacteria	58.5	1.76e-6	NR	MCP3904936.1	2026780	g1541	i0	37	0.56710775047259	100	55	53.3	3	443	162	324	421	MCP3904936.1 protein kinase [Planctomycetota bacterium]	diamond	300	58.5	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);;