metadata: contig_metadata: 20 rows where analysis = "diamond", bioproject = "PRJNA608894" and tax

20 rows where analysis = "diamond", bioproject = "PRJNA608894" 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
585894	585894	PRJNA608894_P_NODE_7061_length_1058_cov_4.724873_g6674_i0	PRJNA608894	7061	1058	4.724873	49.98915634	Chthoniobacter sp.	2510640	Bacteria	Bacteria	556	9.869999999999999e-196	NR	MDR3405335.1	2510640	g6674	i0	85.3	0.870510396975425	307	45	87.1	0	1057	137	158	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	921	556	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
13339546	13339546	PRJNA608894_P_NODE_37271_length_294_cov_1.619910_g36772_i0	PRJNA608894	37271	294	1.61991	4.7625354	Pseudomonadati	3379134	Bacteria	Bacteria	156	1.3499999999999997e-42	NR	OUU59431.1	1986793	g36772	i0	73.2	11.8571428571429	97	26	99	0	2	292	417	513	OUU59431.1 MAG: glycine dehydrogenase (aminomethyl-transferring), partial [Verrucomicrobia bacterium TMED60]	diamond	3486	156	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium TMED60
14613952	14613952	PRJNA608894_P_NODE_13852_length_609_cov_5.759328_g13373_i0	PRJNA608894	13852	609	5.759328	35.07430752	root	1	Root_unresolved	Root_unresolved	219	5.08e-69	NR	MCF7962295.1	117	g13373	i0	60.7	9.65024630541872	178	65	85.7	3	66	587	22	198	MCF7962295.1 peptidylprolyl isomerase [Pirellula sp.]	diamond	5877	221	0.990950226244344	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
19711899	19711899	PRJNA608894_P_NODE_30896_length_329_cov_0.898438_g30397_i0	PRJNA608894	30896	329	0.898438	2.95586102	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	171	5.39e-50	NR	RYD65414.1	2026800	g30397	i0	77.2	0.9209726443769	101	23	92.1	0	3	305	235	335	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	303	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
26840393	26840393	PRJNA608894_P_NODE_55441_length_245_cov_2.232558_g54942_i0	PRJNA608894	55441	245	2.232558	5.4697671	Bacteria	2	Bacteria	Bacteria	47.4	8.69e-4	NR	PYI86484.1	2026799	g54942	i0	36.7	2.90204081632653	79	45	95.5	2	234	1	38	112	PYI86484.1 MAG: succinate-semialdehyde dehydrogenase (NADP(+)), partial [Verrucomicrobiota bacterium]	diamond	711	47.8	0.99163179916318	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26858974	26858974	PRJNA608894_P_NODE_60361_length_241_cov_0.916667_g59862_i0	PRJNA608894	60361	241	0.916667	2.20916747	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	84	1.15e-18	NR	MDD5085221.1	2035772	g59862	i0	52.5	0.995850622406639	80	38	99.6	0	2	241	39	118	MDD5085221.1 30S ribosomal protein S11 [Candidatus Omnitrophota bacterium]	diamond	240	84	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
27093253	27093253	PRJNA608894_P_NODE_29682_length_338_cov_1.739623_g29183_i0	PRJNA608894	29682	338	1.739623	5.87992574	root	1	Root_unresolved	Root_unresolved	47.8	2.8e-4	NR	MCB1084366.1	34094	g29183	i0	41.1	1.47337278106509	56	33	49.7	0	313	146	46	101	MCB1084366.1 hypothetical protein [Simkania sp.]	diamond	498	47.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28185295	28185295	PRJNA608894_P_NODE_23346_length_403_cov_6.924242_g22849_i0	PRJNA608894	23346	403	6.924242	27.90469526	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.4	0.0236	NR	MCH8042360.1	2026780	g22849	i0	40.5	0.550868486352357	74	39	52.1	2	66	275	875	947	MCH8042360.1 organic solvent tolerance protein OstA [Planctomycetota bacterium]	diamond	222	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28419882	28419882	PRJNA608894_P_NODE_18666_length_481_cov_1.833333_g18170_i0	PRJNA608894	18666	481	1.833333	8.81833173	Bacteria	2	Bacteria	Bacteria	123	7.7e-30	NR	MFT5050156.1	2047757	g18170	i0	45	5.75051975051975	129	71	80.5	0	84	470	259	387	MFT5050156.1 acetylornithine deacetylase/succinyl-diaminopimelate desuccinylase-like protein [Chlamydiales bacterium]	diamond	2766	124	0.991935483870968	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28469859	28469859	PRJNA608894_P_NODE_27126_length_360_cov_1.609756_g26627_i0	PRJNA608894	27126	360	1.609756	5.7951216	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.0286	NR	MEM6473951.1	2026780	g26627	i0	29.1	0.658333333333333	79	54	65.8	1	24	260	640	716	MEM6473951.1 hypothetical protein [Planctomycetota bacterium]	diamond	237	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29605999	29605999	PRJNA608894_P_NODE_43590_length_270_cov_2.340102_g43091_i0	PRJNA608894	43590	270	2.340102	6.3182754	Persicirhabdus sediminis	454144	Bacteria	Bacteria	43.9	0.0199	NR	WP_200312416.1	454144	g43091	i0	48.9	0.5	45	20	47.8	3	256	128	377	420	WP_200312416.1 membrane protein insertase YidC [Persicirhabdus sediminis]	diamond	135	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Persicirhabdus	Persicirhabdus sediminis
30648583	30648583	PRJNA608894_P_NODE_14033_length_603_cov_3.281132_g13551_i0	PRJNA608894	14033	603	3.281132	19.785225959999998	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	87	3.5e-17	NR	MEO5753320.1	2201154	g13551	i0	30.2	0.955223880597015	192	106	87.6	6	535	8	34	213	MEO5753320.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	576	87	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30775371	30775371	PRJNA608894_P_NODE_59554_length_241_cov_2.047619_g59055_i0	PRJNA608894	59554	241	2.047619	4.93476179	Planctomycetota bacterium	2026780	Bacteria	Bacteria	79.3	1.05e-16	NR	MBM4055472.1	2026780	g59055	i0	51.3	2.83817427385892	80	37	99.6	2	1	240	36	113	MBM4055472.1 hemin receptor [Planctomycetota bacterium]	diamond	684	79.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31198648	31198648	PRJNA608894_P_NODE_55355_length_246_cov_0.884393_g54856_i0	PRJNA608894	55355	246	0.884393	2.17560678	Verrucomicrobiota	74201	Bacteria	Bacteria	87.8	7.46e-20	NR	NBV85467.1	2026799	g54856	i0	54.2	3.01219512195122	83	37	100	1	1	246	56	138	NBV85467.1 L,D-transpeptidase [Verrucomicrobiota bacterium]	diamond	741	87.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31344136	31344136	PRJNA608894_P_NODE_43536_length_271_cov_1.040404_g43037_i0	PRJNA608894	43536	271	1.040404	2.81949484	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	60.1	4.12e-8	NR	HYG84357.1	2499141	g43037	i0	50.7	0.74169741697417	67	33	74.2	0	270	70	231	297	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	201	60.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31641758	31641758	PRJNA608894_P_NODE_61576_length_230_cov_2.726115_g61077_i0	PRJNA608894	61576	230	2.726115	6.2700645	root	1	Root_unresolved	Root_unresolved	42	0.0477	NR	MEM8873732.1	2026780	g61077	i0	35.4	1.09565217391304	48	31	62.6	0	51	194	42	89	MEM8873732.1 PH domain-containing protein [Planctomycetota bacterium]	diamond	252	42.4	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32198220	32198220	PRJNA608894_P_NODE_18798_length_478_cov_31.629630_g18302_i0	PRJNA608894	18798	478	31.62963	151.1896314	Chlamydiales bacterium	2047757	Bacteria	Bacteria	111	9e-28	NR	MCP5470420.1	2047757	g18302	i0	49.2	1.53138075313808	124	62	77.2	1	473	105	1	124	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	732	111	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32388018	32388018	PRJNA608894_P_NODE_38219_length_290_cov_1.119816_g37720_i0	PRJNA608894	38219	290	1.119816	3.2474664	Gemmataceae bacterium	2052164	Bacteria	Bacteria	81.6	8.87e-17	NR	MFO0803182.1	2052164	g37720	i0	86.4	0.951724137931034	44	6	45.5	0	1	132	151	194	MFO0803182.1 hypothetical protein [Gemmataceae bacterium]	diamond	276	81.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32546468	32546468	PRJNA608894_P_NODE_33079_length_314_cov_1.701245_g32580_i0	PRJNA608894	33079	314	1.701245	5.3419093	Planctomycetota bacterium	2026780	Bacteria	Bacteria	138	2.44e-37	NR	MBA4683692.1	2026780	g32580	i0	64.1	1.96815286624204	103	37	98.4	0	2	310	207	309	MBA4683692.1 NAD(P)-dependent oxidoreductase [Planctomycetota bacterium]	diamond	618	138	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32703654	32703654	PRJNA608894_P_NODE_24320_length_390_cov_5.394322_g23823_i0	PRJNA608894	24320	390	5.394322	21.0378558	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	47.8	0.00153	NR	MDX2200837.1	2026778	g23823	i0	41.4	0.446153846153846	58	34	44.6	0	338	165	117	174	MDX2200837.1 lipocalin family protein [Phycisphaerae bacterium]	diamond	174	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae 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);;