metadata: contig_metadata: 12 rows where bioproject = "PRJNA688414" and tax

12 rows where bioproject = "PRJNA688414" 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
1943006	1943006	PRJNA688414_P_NODE_6442_length_251_cov_0.876404_g6408_i0	PRJNA688414	6442	251	0.876404	2.19977404	Bacteria	2	Bacteria	Bacteria	152	6.74e-45	NR	HZA54103.1	2665650	g6408	i0	92.5	2.86852589641434	80	6	95.6	0	3	242	104	183	HZA54103.1 (2Fe-2S)-binding protein [Candidatus Udaeobacter sp.]	diamond	720	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
18519095	18519095	PRJNA688414_P_NODE_6115_length_252_cov_0.871508_g6081_i0	PRJNA688414	6115	252	0.871508	2.19620016	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	164	9.79e-49	NR	HJX98481.1	2201154	g6081	i0	97.6	2.96428571428571	83	2	98.8	0	3	251	149	231	HJX98481.1 succinate dehydrogenase/fumarate reductase iron-sulfur subunit [Chthoniobacterales bacterium]	diamond	747	164	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
26682228	26682228	PRJNA688414_P_NODE_6221_length_252_cov_0.871508_g6187_i0	PRJNA688414	6221	252	0.871508	2.19620016	Terrimicrobium	1649503	Bacteria	Bacteria	187	1.33e-53	NR	HEY6676884.1	1965319	g6187	i0	98.8	6	84	1	100	0	1	252	410	493	HEY6676884.1 glycosyltransferase [Terrimicrobium sp.]	diamond	1512	187	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sp.
26967176	26967176	PRJNA688414_P_NODE_6642_length_250_cov_0.881356_g6608_i0	PRJNA688414	6642	250	0.881356	2.20339	Bacteria	2	Bacteria	Bacteria	135	1.88e-36	NR	MFO1511878.1	2026799	g6608	i0	78	1.968	82	18	98.4	0	248	3	278	359	MFO1511878.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Verrucomicrobiota bacterium]	diamond	492	136	0.992647058823529	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28787385	28787385	PRJNA688414_P_NODE_7407_length_246_cov_0.901734_g7373_i0	PRJNA688414	7407	246	0.901734	2.21826564	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	103	1.5099999999999998e-23	NR	MEO7299310.1	2026799	g7373	i0	67.5	0.975609756097561	80	26	97.6	0	5	244	377	456	MEO7299310.1 Calx-beta domain-containing protein [Verrucomicrobiota bacterium]	diamond	240	103	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29766219	29766219	PRJNA688414_P_NODE_7331_length_247_cov_0.873563_g7297_i0	PRJNA688414	7331	247	0.873563	2.15770061	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	160	1.6499999999999999e-43	NR	MCI0538562.1	2026801	g7297	i0	90.2	0.995951417004049	82	8	99.6	0	2	247	54	135	MCI0538562.1 ABC transporter permease [Verrucomicrobiales bacterium]	diamond	246	160	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30714103	30714103	PRJNA688414_P_NODE_7494_length_246_cov_0.901734_g7460_i0	PRJNA688414	7494	246	0.901734	2.21826564	Terrimicrobium sp.	1965319	Bacteria	Bacteria	133	2.2699999999999997e-35	NR	HEY6675672.1	1965319	g7460	i0	82.5	0.975609756097561	80	14	97.6	0	7	246	135	214	HEY6675672.1 gamma-glutamyltransferase [Terrimicrobium sp.]	diamond	240	133	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sp.
30903811	30903811	PRJNA688414_P_NODE_8174_length_243_cov_0.917647_g8140_i0	PRJNA688414	8174	243	0.917647	2.22988221	Pedosphaera sp. Tous-C6FEB	1982324	Bacteria	Bacteria	117	1.45e-28	NR	PAW86756.1	1982324	g8140	i0	73.4	0.975308641975309	79	21	97.5	0	242	6	769	847	PAW86756.1 MAG: hypothetical protein B9S33_07420 [Pedosphaera sp. Tous-C6FEB]	diamond	237	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp. Tous-C6FEB
31061972	31061972	PRJNA688414_P_NODE_7015_length_248_cov_0.891429_g6981_i0	PRJNA688414	7015	248	0.891429	2.21074392	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	139	3.4399999999999997e-37	NR	HEV2843198.1	2201154	g6981	i0	85.4	0.991935483870968	82	11	99.2	1	246	1	71	151	HEV2843198.1 NAD(P)/FAD-dependent oxidoreductase [Chthoniobacterales bacterium]	diamond	246	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32232237	32232237	PRJNA688414_P_NODE_6178_length_252_cov_0.871508_g6144_i0	PRJNA688414	6178	252	0.871508	2.19620016	Terrimicrobium sp.	1965319	Bacteria	Bacteria	92.4	4.09e-20	NR	HEY6675380.1	1965319	g6144	i0	96.3	1.92857142857143	54	2	64.3	0	251	90	283	336	HEY6675380.1 ABC transporter permease [Terrimicrobium sp.]	diamond	486	92.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sp.
32611462	32611462	PRJNA688414_P_NODE_7240_length_247_cov_0.896552_g7206_i0	PRJNA688414	7240	247	0.896552	2.21448344	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	98.2	2.87e-22	NR	MEY2512138.1	2026799	g7206	i0	60.6	0.801619433198381	66	26	80.2	0	245	48	280	345	MEY2512138.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	198	98.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32874827	32874827	PRJNA688414_P_NODE_7480_length_246_cov_0.901734_g7446_i0	PRJNA688414	7480	246	0.901734	2.21826564	PVC group	1783257	Bacteria	Bacteria	144	4.08e-40	NR	MCI0536380.1	2026801	g7446	i0	80.5	5.95121951219512	82	16	100	0	246	1	108	189	MCI0536380.1 fatty acid desaturase [Verrucomicrobiales bacterium]	diamond	1464	145	0.993103448275862	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales 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);;