metadata: contig_metadata: 11 rows where bioproject = "PRJNA781196" and tax

11 rows where bioproject = "PRJNA781196" 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
759289	759289	PRJNA781196_P_NODE_40261_length_282_cov_1.492823_g39884_i0	PRJNA781196	40261	282	1.492823	4.20976086	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	514	2.76e-141	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g39884	i0	99.644	259.617021276596	281	1	99	0	2	282	4722	4442	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	73212	514	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
2035312	2035312	PRJNA781196_P_NODE_38122_length_289_cov_1.083333_g37745_i0	PRJNA781196	38122	289	1.083333	3.13083237	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	462	1.04e-125	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g37745	i0	95.517	142.826989619377	290	12	100	1	1	289	3046326	3046615	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	41277	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
4587880	4587880	PRJNA781196_P_NODE_58104_length_248_cov_0.891429_g57727_i0	PRJNA781196	58104	248	0.891429	2.21074392	Chthoniobacter flavus	191863	Bacteria	Bacteria	368	1.96e-97	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g57727	i0	95.279	270.915322580645	233	10	94	1	1	233	2418	2187	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	67187	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
19886487	19886487	PRJNA781196_P_NODE_59996_length_246_cov_1.676301_g59619_i0	PRJNA781196	59996	246	1.676301	4.12370046	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g59619	i0	98.78	98.7845528455285	246	3	100	0	1	246	869	624	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	24301	438	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
27780229	27780229	PRJNA781196_P_NODE_63484_length_244_cov_0.912281_g63107_i0	PRJNA781196	63484	244	0.912281	2.22596564	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	77.4	2.33e-14	NR	MDA7930803.1	2562705	g63107	i0	50.6	8.11475409836066	77	37	94.7	1	3	233	22	97	MDA7930803.1 ubiquitin-like protein [Akkermansiaceae bacterium]	diamond	1980	77.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
29011771	29011771	PRJNA781196_P_NODE_25288_length_343_cov_1.722222_g24911_i0	PRJNA781196	25288	343	1.722222	5.90722146	Phragmitibacter flavus	2576071	Bacteria	Bacteria	48.1	0.00139	NR	WP_138088455.1	2576071	g24911	i0	29.9	1.02332361516035	117	63	97.1	3	337	5	3	106	WP_138088455.1 hypothetical protein [Phragmitibacter flavus]	diamond	351	48.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Phragmitibacter	Phragmitibacter flavus
29295609	29295609	PRJNA781196_P_NODE_45969_length_264_cov_1.528796_g45592_i0	PRJNA781196	45969	264	1.528796	4.03602144	Opitutaceae bacterium	2006848	Bacteria	Bacteria	83.6	3.71e-17	NR	HEX9784778.1	2006848	g45592	i0	70.5	0.693181818181818	61	18	69.3	0	185	3	1	61	HEX9784778.1 pantoate--beta-alanine ligase [Opitutaceae bacterium]	diamond	183	83.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29958746	29958746	PRJNA781196_P_NODE_6591_length_607_cov_1.215356_g6220_i0	PRJNA781196	6591	607	1.215356	7.37721092	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	92.4	9.35e-18	NR	MCU0772034.1	2026799	g6220	i0	36.1	0.958813838550247	194	102	95.4	8	17	595	526	698	MCU0772034.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	582	92.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31412342	31412342	PRJNA781196_P_NODE_12776_length_456_cov_1.629243_g12399_i0	PRJNA781196	12776	456	1.629243	7.42934808	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	83.2	2.87e-15	NR	PYJ08782.1	2026799	g12399	i0	42.4	1.98026315789474	139	69	89.5	3	452	45	156	286	PYJ08782.1 MAG: hypothetical protein DME25_00550 [Verrucomicrobiota bacterium]	diamond	903	83.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32235192	32235192	PRJNA781196_P_NODE_59358_length_247_cov_0.896552_g58981_i0	PRJNA781196	59358	247	0.896552	2.21448344	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	99.4	4.22e-22	NR	HAB15996.1	2026801	g58981	i0	77.6	1.44534412955466	58	13	70.4	0	1	174	481	538	HAB15996.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	357	99.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32708713	32708713	PRJNA781196_P_NODE_62000_length_245_cov_0.906977_g61623_i0	PRJNA781196	62000	245	0.906977	2.22209365	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	132	2.57e-35	NR	MES2595503.1	2026799	g61623	i0	81.5	1.98367346938776	81	15	99.2	0	1	243	9	89	MES2595503.1 ABC transporter substrate-binding protein [Verrucomicrobiota bacterium]	diamond	486	132	1	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);;