metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1174207" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1174207" 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
315906	315906	PRJNA1174207_P_NODE_38461_length_245_cov_0.895349_g37932_i0	PRJNA1174207	38461	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	124	1.06e-30	NR	HXJ58072.1	2499141	g37932	i0	76.6	1.93469387755102	77	17	93.1	1	17	244	748	824	HXJ58072.1 response regulator [Verrucomicrobiia bacterium]	diamond	474	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
11794217	11794217	PRJNA1174207_P_NODE_26370_length_280_cov_1.193237_g25841_i0	PRJNA1174207	26370	280	1.193237	3.3410636	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	83.6	1.05e-18	NR	HEY6169472.1	2499141	g25841	i0	87	0.492857142857143	46	6	49.3	0	279	142	44	89	HEY6169472.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	138	83.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27230099	27230099	PRJNA1174207_P_NODE_30023_length_264_cov_2.649215_g29494_i0	PRJNA1174207	30023	264	2.649215	6.9939276	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.4	0.00558	NR	MCX6922885.1	2026799	g29494	i0	34.1	0.965909090909091	85	53	94.3	2	261	13	674	757	MCX6922885.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	255	45.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27281094	27281094	PRJNA1174207_P_NODE_34803_length_249_cov_1.590909_g34274_i0	PRJNA1174207	34803	249	1.590909	3.96136341	Pseudomonadati	3379134	Bacteria	Bacteria	43.5	0.0209	NR	MBQ8480518.1	1872421	g34274	i0	64.7	0.867469879518072	34	12	41	0	229	128	326	359	MBQ8480518.1 ankyrin repeat domain-containing protein [Akkermansia sp.]	diamond	216	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
27439275	27439275	PRJNA1174207_P_NODE_34063_length_250_cov_1.378531_g33534_i0	PRJNA1174207	34063	250	1.378531	3.4463275	Pseudomonadati	3379134	Bacteria	Bacteria	81.6	8.44e-16	NR	PAW85177.1	1982324	g33534	i0	49.4	2.844	79	36	93.6	2	249	16	1173	1248	PAW85177.1 MAG: hypothetical protein B9S33_10250 [Pedosphaera sp. Tous-C6FEB]	diamond	711	81.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp. Tous-C6FEB
27577648	27577648	PRJNA1174207_P_NODE_34184_length_250_cov_0.870056_g33655_i0	PRJNA1174207	34184	250	0.870056	2.17514	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	103	1.33e-26	NR	MBL9176239.1	2026801	g33655	i0	91.2	0.684	57	5	68.4	0	248	78	37	93	MBL9176239.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	171	103	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28872102	28872102	PRJNA1174207_P_NODE_32768_length_253_cov_1.544444_g32239_i0	PRJNA1174207	32768	253	1.544444	3.90744332	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	58.2	1.49e-7	NR	RYD24165.1	2026800	g32239	i0	45.9	5.58498023715415	61	32	71.1	1	30	209	371	431	RYD24165.1 MAG: hypothetical protein EOP88_01315 [Verrucomicrobiaceae bacterium]	diamond	1413	58.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29711960	29711960	PRJNA1174207_P_NODE_30570_length_262_cov_1.650794_g30041_i0	PRJNA1174207	30570	262	1.650794	4.32508028	Bacteria	2	Bacteria	Bacteria	110	9.78e-26	NR	WP_107835717.1	2161864	g30041	i0	67.1	2.88549618320611	82	27	93.9	0	16	261	234	315	WP_107835717.1 immunoglobulin domain-containing protein [Opitutus sp. ER46]	diamond	756	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. ER46
30134978	30134978	PRJNA1174207_P_NODE_25592_length_283_cov_1.466667_g25063_i0	PRJNA1174207	25592	283	1.466667	4.15066761	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.2	0.00331	NR	MEI6395524.1	2026799	g25063	i0	32.3	1.35689045936396	65	44	68.9	0	271	77	208	272	MEI6395524.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	384	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32221874	32221874	PRJNA1174207_P_NODE_34498_length_250_cov_0.870056_g33969_i0	PRJNA1174207	34498	250	0.870056	2.17514	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	137	4.11e-36	NR	KAB2643361.1	2026799	g33969	i0	85.4	0.984	82	12	98.4	0	2	247	444	525	KAB2643361.1 MAG: phosphoglycerate dehydrogenase [Verrucomicrobiota bacterium]	diamond	246	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32695717	32695717	PRJNA1174207_P_NODE_33460_length_251_cov_0.865169_g32931_i0	PRJNA1174207	33460	251	0.865169	2.17157419	Candidatus Methylacidithermus pantelleriae	2744239	Bacteria	Bacteria	122	1.2699999999999998e-31	NR	WP_174581898.1	2744239	g32931	i0	66.3	2.92828685258964	83	28	99.2	0	1	249	132	214	WP_174581898.1 ABC transporter ATP-binding protein [Candidatus Methylacidithermus pantelleriae]	diamond	735	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Candidatus Methylacidithermus	Candidatus Methylacidithermus pantelleriae
32884608	32884608	PRJNA1174207_P_NODE_26340_length_280_cov_1.386473_g25811_i0	PRJNA1174207	26340	280	1.386473	3.8821244	Pedosphaera sp.	2024890	Bacteria	Bacteria	70.1	1.29e-11	NR	MSU62111.1	2024890	g25811	i0	85.7	0.9	42	6	45	0	154	279	1	42	MSU62111.1 cation:proton antiporter [Pedosphaera sp.]	diamond	252	70.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.

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);;