metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA572587" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA572587" and tax_phylum = "Verrucomicrobiota"

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
3109908	3109908	PRJNA572587_P_NODE_3423_length_707_cov_2.784195_g3147_i0	PRJNA572587	3423	707	2.784195	19.68425865	Rariglobus sp.	2706526	Bacteria	Bacteria	147	2.65e-36	NR	HEY8933051.1	2706526	g3147	i0	53.9	1.28995756718529	152	65	62.8	3	699	256	586	736	HEY8933051.1 AAA family ATPase [Rariglobus sp.]	diamond	912	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Rariglobus	Rariglobus sp.
8211744	8211744	PRJNA572587_P_NODE_1647_length_992_cov_12.179215_g1491_i0	PRJNA572587	1647	992	12.179215	120.8178128	Cerasicoccus maritimus	490089	Bacteria	Bacteria	58.9	1.01e-5	NR	WP_309398316.1	490089	g1491	i0	28.8	0.925403225806452	146	93	42.3	4	536	955	30	170	WP_309398316.1 hypothetical protein [Cerasicoccus maritimus]	diamond	918	58.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Cerasicoccus	Cerasicoccus maritimus
10763473	10763473	PRJNA572587_P_NODE_6109_length_501_cov_5.110619_g5788_i0	PRJNA572587	6109	501	5.110619	25.60420119	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	145	1.5499999999999996e-40	NR	MBI4625648.1	2026799	g5788	i0	88	0.497005988023952	83	10	49.7	0	9	257	48	130	MBI4625648.1 DJ-1/PfpI family protein [Verrucomicrobiota bacterium]	diamond	249	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26858384	26858384	PRJNA572587_P_NODE_8501_length_414_cov_76.786301_g8175_i0	PRJNA572587	8501	414	76.786301	317.89528614	Puniceicoccales bacterium	2478473	Bacteria	Bacteria	42.4	0.0288	NR	MDR0742450.1	2478473	g8175	i0	34.9	0.456521739130435	63	35	41.3	2	172	2	2	64	MDR0742450.1 hypothetical protein [Puniceicoccales bacterium]	diamond	189	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales			Puniceicoccales bacterium
28942993	28942993	PRJNA572587_P_NODE_10008_length_376_cov_1.694190_g9681_i0	PRJNA572587	10008	376	1.69419	6.3701544	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	217	1.1999999999999998e-67	NR	MBX9577730.1	2201154	g9681	i0	89	0.941489361702128	118	13	94.1	0	374	21	117	234	MBX9577730.1 23S rRNA (adenine(2503)-C(2))-methyltransferase RlmN [Chthoniobacterales bacterium]	diamond	354	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29384850	29384850	PRJNA572587_P_NODE_19009_length_261_cov_1.509434_g18681_i0	PRJNA572587	19009	261	1.509434	3.93962274	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	82.4	1.57e-17	NR	NJR42023.1	2562705	g18681	i0	41.3	2.14942528735632	104	36	90.8	2	241	5	21	124	NJR42023.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	561	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
29636956	29636956	PRJNA572587_P_NODE_26590_length_217_cov_2.410714_g26262_i0	PRJNA572587	26590	217	2.410714	5.23124938	Prosthecobacter sp.	1965333	Bacteria	Bacteria	48.5	2.33e-4	NR	MEQ1747904.1	1965333	g26262	i0	70.3	0.511520737327189	37	11	51.2	0	79	189	7	43	MEQ1747904.1 thiamine pyrophosphate-dependent enzyme [Prosthecobacter sp.]	diamond	111	48.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30111072	30111072	PRJNA572587_P_NODE_30352_length_201_cov_32.013158_g30024_i0	PRJNA572587	30352	201	32.013158	64.34644758	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	104	1.12e-26	NR	MBS0628409.1	2026799	g30024	i0	80	0.895522388059702	60	12	89.6	0	3	182	30	89	MBS0628409.1 disulfide bond formation protein B [Verrucomicrobiota bacterium]	diamond	180	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30901075	30901075	PRJNA572587_P_NODE_33974_length_190_cov_1.042553_g33646_i0	PRJNA572587	33974	190	1.042553	1.9808507	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	51.6	5.26e-6	NR	NJR42023.1	2562705	g33646	i0	52.5	0.631578947368421	40	19	63.2	0	187	68	124	163	NJR42023.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	120	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
31121776	31121776	PRJNA572587_P_NODE_30735_length_200_cov_11.158940_g30407_i0	PRJNA572587	30735	200	11.15894	22.31788	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	117	5.3e-29	NR	MCX7713884.1	2201154	g30407	i0	100	0.84	56	0	84	0	3	170	95	150	MCX7713884.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	168	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31375213	31375213	PRJNA572587_P_NODE_3076_length_746_cov_37.383070_g2818_i0	PRJNA572587	3076	746	37.38307	278.8777022	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	63.9	2.66e-9	NR	NJR41398.1	2562705	g2818	i0	66	0.189008042895442	47	15	18.5	1	408	545	32	78	NJR41398.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	141	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
31976016	31976016	PRJNA572587_P_NODE_2158_length_881_cov_33.518029_g1965_i0	PRJNA572587	2158	881	33.518029	295.29383549	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.4	0.0133	NR	PWU09965.1	2026799	g1965	i0	32	1.0522133938706	103	67	34.7	2	785	480	49	149	PWU09965.1 MAG: 30S ribosomal protein S7 [Verrucomicrobiota bacterium]	diamond	927	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32514278	32514278	PRJNA572587_P_NODE_11579_length_344_cov_43.698305_g11252_i0	PRJNA572587	11579	344	43.698305	150.3221692	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	94	3.04e-20	NR	HYG83408.1	2499141	g11252	i0	48.1	0.706395348837209	81	42	70.6	0	33	275	139	219	HYG83408.1 Kiwa anti-phage protein KwaB-like domain-containing protein [Verrucomicrobiia bacterium]	diamond	243	94	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32716726	32716726	PRJNA572587_P_NODE_22120_length_240_cov_6.821990_g21792_i0	PRJNA572587	22120	240	6.8219900000000004	16.372776000000002	Bacteria	2	Bacteria	Bacteria	85.9	2.16e-18	NR	MCD6049068.1	2026799	g21792	i0	84.4	1.275	45	7	56.3	0	83	217	186	230	MCD6049068.1 Hydroxypyruvate isomerase [Verrucomicrobiota bacterium]	diamond	306	86.7	0.990772779700115	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;