metadata: contig_metadata: 19 rows where bioproject = "PRJNA1108487" and tax

19 rows where bioproject = "PRJNA1108487" 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
213405	213405	PRJNA1108487_P_NODE_2401_length_437_cov_1.505495_g2335_i0	PRJNA1108487	2401	437	1.505495	6.57901315	Verrucomicrobiaceae	203557	Bacteria	Bacteria	174	6.62e-50	NR	WP_146854420.1	748831	g2335	i0	59.6	11.2379862700229	136	55	93.4	0	418	11	17	152	WP_146854420.1 nucleoside monophosphate kinase [Brevifollis gellanilyticus]	diamond	4911	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
1488088	1488088	PRJNA1108487_P_NODE_222_length_1237_cov_3.182131_g184_i0	PRJNA1108487	222	1237	3.182131	39.36296047	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	418	5.19e-142	NR	RYD65414.1	2026800	g184	i0	67.9	0.76394502829426	315	93	75.2	3	1027	98	25	336	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	945	418	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
18065097	18065097	PRJNA1108487_P_NODE_2675_length_415_cov_1.596491_g2609_i0	PRJNA1108487	2675	415	1.596491	6.62543765	Pseudomonadati	3379134	Bacteria	Bacteria	144	1.22e-40	NR	MBS0615710.1	2026799	g2609	i0	69.5	6.96144578313253	105	29	75.9	1	317	3	11	112	MBS0615710.1 superoxide dismutase [Verrucomicrobiota bacterium]	diamond	2889	144	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26846469	26846469	PRJNA1108487_P_NODE_1261_length_591_cov_1.204633_g1196_i0	PRJNA1108487	1261	591	1.204633	7.1193810300000004	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	274	5.839999999999999e-89	NR	RYD65414.1	2026800	g1196	i0	73.7	0.908629441624365	179	45	90.9	1	590	54	160	336	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	537	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27099268	27099268	PRJNA1108487_P_NODE_11262_length_242_cov_0.923077_g11196_i0	PRJNA1108487	11262	242	0.923077	2.23384634	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	84.7	5.93e-17	NR	RYD77031.1	2026800	g11196	i0	50.7	0.90495867768595	73	36	90.5	0	242	24	165	237	RYD77031.1 MAG: hypothetical protein EOP84_16100, partial [Verrucomicrobiaceae bacterium]	diamond	219	84.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27825960	27825960	PRJNA1108487_P_NODE_8444_length_253_cov_0.866667_g8378_i0	PRJNA1108487	8444	253	0.866667	2.19266751	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	57	3.99e-7	NR	MBX9743397.1	2201154	g8378	i0	45.9	1.00790513833992	85	40	93.7	3	15	251	770	854	MBX9743397.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	255	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28867753	28867753	PRJNA1108487_P_NODE_11228_length_242_cov_0.923077_g11162_i0	PRJNA1108487	11228	242	0.923077	2.23384634	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	72.4	1.03e-12	NR	RYD71398.1	2026800	g11162	i0	49.2	0.805785123966942	65	33	80.6	0	3	197	137	201	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	195	72.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29278086	29278086	PRJNA1108487_P_NODE_9769_length_247_cov_2.517241_g9703_i0	PRJNA1108487	9769	247	2.517241	6.21758527	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47	0.00122	NR	MBS0646964.1	2026799	g9703	i0	31.3	0.813765182186235	67	46	81.4	0	5	205	108	174	MBS0646964.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	201	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29656731	29656731	PRJNA1108487_P_NODE_10070_length_246_cov_1.190751_g10004_i0	PRJNA1108487	10070	246	1.190751	2.92924746	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	139	5.15e-38	NR	RYD81270.1	2026800	g10004	i0	77.5	0.975609756097561	80	18	97.6	0	241	2	169	248	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	240	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29783370	29783370	PRJNA1108487_P_NODE_2011_length_480_cov_1.181818_g1945_i0	PRJNA1108487	2011	480	1.181818	5.6727264	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	52.4	9.37e-5	NR	HEX3818319.1	2201154	g1945	i0	37.6	0.63125	101	53	61.3	5	3	296	129	222	HEX3818319.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	303	52.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29783376	29783376	PRJNA1108487_P_NODE_5311_length_308_cov_1.017021_g5245_i0	PRJNA1108487	5311	308	1.017021	3.13242468	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	162	1.35e-46	NR	RYD81270.1	2026800	g5245	i0	71.6	0.993506493506494	102	29	99.4	0	3	308	26	127	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	306	162	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30216871	30216871	PRJNA1108487_P_NODE_7572_length_264_cov_1.225131_g7506_i0	PRJNA1108487	7572	264	1.225131	3.23434584	Bacteria	2	Bacteria	Bacteria	52.4	2.07e-5	NR	MBL9135107.1	2026801	g7506	i0	38.2	1.79545454545455	89	53	98.9	1	264	4	1582	1670	MBL9135107.1 tandem-95 repeat protein [Verrucomicrobiales bacterium]	diamond	474	52.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30469952	30469952	PRJNA1108487_P_NODE_1593_length_529_cov_2.550439_g1527_i0	PRJNA1108487	1593	529	2.550439	13.49182231	Verrucomicrobiota	74201	Bacteria	Bacteria	47	0.00134	NR	HEY9153814.1	2006848	g1527	i0	47.4	0.941398865784499	57	26	30.1	1	288	130	13	69	HEY9153814.1 hypothetical protein [Opitutaceae bacterium]	diamond	498	47.4	0.991561181434599	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30636253	30636253	PRJNA1108487_P_NODE_3653_length_359_cov_1.727273_g3587_i0	PRJNA1108487	3653	359	1.727273	6.20091007	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	118	4.3e-29	NR	RYD71398.1	2026800	g3587	i0	51.7	1.00278551532033	120	47	96.1	4	2	346	169	282	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	360	118	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30636258	30636258	PRJNA1108487_P_NODE_613_length_823_cov_1.993333_g555_i0	PRJNA1108487	613	823	1.993333	16.40513059	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	201	1.02e-58	NR	MBS0605284.1	2026799	g555	i0	50	0.765492102065614	210	97	75.1	3	819	202	113	318	MBS0605284.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	630	201	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31426533	31426533	PRJNA1108487_P_NODE_4376_length_333_cov_1.800000_g4310_i0	PRJNA1108487	4376	333	1.8	5.994	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	48.5	0.00101	NR	MCX6889954.1	2026799	g4310	i0	43.9	0.513513513513513	57	29	48.6	1	232	71	132	188	MCX6889954.1 Ig-like domain repeat protein [Verrucomicrobiota bacterium]	diamond	171	48.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31869302	31869302	PRJNA1108487_P_NODE_2017_length_479_cov_1.660099_g1951_i0	PRJNA1108487	2017	479	1.660099	7.95187421	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	113	1.02e-26	NR	RYD71398.1	2026800	g1951	i0	52.3	0.695198329853862	111	51	68.9	2	479	150	252	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	333	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32208738	32208738	PRJNA1108487_P_NODE_7298_length_268_cov_1.600000_g7232_i0	PRJNA1108487	7298	268	1.6	4.288	Pseudomonadati	3379134	Bacteria	Bacteria	109	1.21e-25	NR	MBL4576092.1	2006848	g7232	i0	64.9	6.26865671641791	77	27	86.2	0	231	1	395	471	MBL4576092.1 glycine--tRNA ligase [Opitutaceae bacterium]	diamond	1680	110	0.990909090909091	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32745818	32745818	PRJNA1108487_P_NODE_9920_length_247_cov_0.896552_g9854_i0	PRJNA1108487	9920	247	0.896552	2.21448344	Bacteria	2	Bacteria	Bacteria	43.5	0.021	NR	MEI6819236.1	2026799	g9854	i0	30.5	1.79757085020243	82	53	96	2	10	246	384	464	MEI6819236.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	444	43.9	0.990888382687927	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);;