metadata: contig_metadata: 10 rows where bioproject = "PRJNA694557" and tax

10 rows where bioproject = "PRJNA694557" 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
27683172	27683172	PRJNA694557_P_NODE_16584_length_315_cov_2.611570_g16364_i0	PRJNA694557	16584	315	2.61157	8.2264455	Puniceicoccaceae bacterium TMED149	1986788	Bacteria	Bacteria	105	9.08e-26	NR	OUV90112.1	1986788	g16364	i0	60.8	0.752380952380952	79	31	75.2	0	4	240	112	190	OUV90112.1 MAG: crossover junction endodeoxyribonuclease RuvC [Puniceicoccaceae bacterium TMED149]	diamond	237	105	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Puniceicoccaceae		Puniceicoccaceae bacterium TMED149
28799013	28799013	PRJNA694557_P_NODE_26407_length_233_cov_4.256250_g26187_i0	PRJNA694557	26407	233	4.25625	9.9170625	Bacteria	2	Bacteria	Bacteria	95.1	1.19e-20	NR	SPE54725.1	2026799	g26187	i0	59.7	5.90987124463519	77	31	99.1	0	3	233	265	341	SPE54725.1 conserved membrane hypothetical protein [Verrucomicrobiota bacterium]	diamond	1377	95.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28850833	28850833	PRJNA694557_P_NODE_5628_length_620_cov_2.665448_g5410_i0	PRJNA694557	5628	620	2.665448	16.5257776	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	103	8.71e-22	NR	MCC6232171.1	2026801	g5410	i0	63.5	0.803225806451613	85	28	39.7	1	1	246	424	508	MCC6232171.1 MFS transporter [Verrucomicrobiales bacterium]	diamond	498	103	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30156860	30156860	PRJNA694557_P_NODE_20792_length_272_cov_2.201005_g20572_i0	PRJNA694557	20792	272	2.201005	5.9867336	Bacteria	2	Bacteria	Bacteria	57.8	2.65e-7	NR	MEY2480002.1	2026799	g20572	i0	79.5	1.29044117647059	39	8	43	0	257	141	466	504	MEY2480002.1 recombination protein RecA [Verrucomicrobiota bacterium]	diamond	351	58.2	0.993127147766323	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30304234	30304234	PRJNA694557_P_NODE_11952_length_386_cov_2.690096_g11732_i0	PRJNA694557	11952	386	2.690096	10.38377056	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	144	6.619999999999999e-37	NR	MFT5404217.1	2026801	g11732	i0	54.1	0.948186528497409	122	56	94.8	0	366	1	501	622	MFT5404217.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	366	144	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30777742	30777742	PRJNA694557_P_NODE_17334_length_306_cov_5.957082_g17114_i0	PRJNA694557	17334	306	5.957082	18.22867092	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	179	1.44e-52	NR	MBS0651961.1	2026799	g17114	i0	94.5	1.7843137254902	91	5	89.2	0	295	23	106	196	MBS0651961.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	546	179	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31188100	31188100	PRJNA694557_P_NODE_24895_length_245_cov_0.895349_g24675_i0	PRJNA694557	24895	245	0.895349	2.19360505	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	124	8.52e-32	NR	MBU6446839.1	2026799	g24675	i0	77.8	0.991836734693878	81	18	99.2	0	1	243	115	195	MBU6446839.1 oxygen-independent coproporphyrinogen III oxidase [Verrucomicrobiota bacterium]	diamond	243	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31283179	31283179	PRJNA694557_P_NODE_10735_length_412_cov_5.156342_g10515_i0	PRJNA694557	10735	412	5.156342	21.24412904	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	85.5	8.63e-17	NR	HXI85285.1	2499141	g10515	i0	51.9	0.589805825242718	81	37	58.3	2	264	25	8	87	HXI85285.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	243	85.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32105720	32105720	PRJNA694557_P_NODE_7338_length_525_cov_10.856195_g7118_i0	PRJNA694557	7338	525	10.856195	56.99502375	Verrucomicrobia bacterium 12-59-8	1970608	Bacteria	Bacteria	45.8	0.0285	NR	OYW71022.1	1970608	g7118	i0	36.9	0.371428571428571	65	40	36.6	1	386	195	159	223	OYW71022.1 MAG: hypothetical protein B7Z37_28885 [Verrucomicrobia bacterium 12-59-8]	diamond	195	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium 12-59-8
32800542	32800542	PRJNA694557_P_NODE_20400_length_276_cov_1.394089_g20180_i0	PRJNA694557	20400	276	1.394089	3.84768564	Pedosphaera sp.	2024890	Bacteria	Bacteria	147	1.42e-41	NR	MSU20587.1	2024890	g20180	i0	75	2	92	23	100	0	276	1	61	152	MSU20587.1 MFS transporter [Pedosphaera sp.]	diamond	552	147	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);;