metadata: contig_metadata: 5 rows where bioproject = "PRJNA340009" and tax

5 rows where bioproject = "PRJNA340009" and tax_phylum = "Candidatus Wolfeibacteriota"

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_phylum	tax_species
28243090	28243090	PRJNA340009_P_NODE_2146_length_668_cov_247.972536_g1866_i0	PRJNA340009	2146	668	247.972536	1656.45654048	Candidatus Wolfebacteria bacterium GW2	2030812	Bacteria	Bacteria	145	9.28e-39	NR	KKS81875.1	1619011	g1866	i0	65.5	0.520958083832335	116	38	51.6	2	276	620	77	191	KKS81875.1 MAG: hypothetical protein UV58_C0015G0009 [Candidatus Wolfebacteria bacterium GW2011_GWC1_43_10]	diamond	348	145	1	Bacteria	Bacteria candidate phyla	Candidatus Wolfeibacteriota	Candidatus Wolfebacteria bacterium GW2011_GWC1_43_10
30074562	30074562	PRJNA340009_P_NODE_72192_length_163_cov_0.894737_g71885_i0	PRJNA340009	72192	163	0.894737	1.45842131	Candidatus Wolfebacteria bacterium RIFOXYB1_FULL_54_12	1802559	Bacteria	Bacteria	84.3	4.79e-18	NR	OGM92917.1	1802559	g71885	i0	68.5	0.993865030674847	54	17	99.4	0	1	162	111	164	OGM92917.1 MAG: hypothetical protein A2372_03665 [Candidatus Wolfebacteria bacterium RIFOXYB1_FULL_54_12]	diamond	162	84.3	1	Bacteria	Bacteria candidate phyla	Candidatus Wolfeibacteriota	Candidatus Wolfebacteria bacterium RIFOXYB1_FULL_54_12
30485473	30485473	PRJNA340009_P_NODE_19173_length_275_cov_1.663717_g18866_i0	PRJNA340009	19173	275	1.663717	4.57522175	Candidatus Wolfebacteria bacterium	2030812	Bacteria	Bacteria	65.5	5.07e-10	NR	MBI4993484.1	2030812	g18866	i0	50.8	1.30909090909091	65	31	70.9	1	233	39	331	394	MBI4993484.1 glycosyltransferase [Candidatus Wolfebacteria bacterium]	diamond	360	65.5	1	Bacteria	Bacteria candidate phyla	Candidatus Wolfeibacteriota	Candidatus Wolfebacteria bacterium
30959460	30959460	PRJNA340009_P_NODE_59714_length_169_cov_5.550000_g59407_i0	PRJNA340009	59714	169	5.55	9.3795	Candidatus Wolfebacteria bacterium	2030812	Bacteria	Bacteria	46.2	1.98e-4	NR	NCN52857.1	2030812	g59407	i0	84.6	0.461538461538462	26	4	46.2	0	89	166	2	27	NCN52857.1 50S ribosomal protein L17 [Candidatus Wolfebacteria bacterium]	diamond	78	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Wolfeibacteriota	Candidatus Wolfebacteria bacterium
32887131	32887131	PRJNA340009_P_NODE_34560_length_214_cov_1.672727_g34253_i0	PRJNA340009	34560	214	1.672727	3.57963578	Candidatus Wolfebacteria bacterium	2030812	Bacteria	Bacteria	40.8	0.0474	NR	MCI0619563.1	2030812	g34253	i0	39.7	0.813084112149533	58	30	78.5	2	39	206	42	96	MCI0619563.1 hypothetical protein [Candidatus Wolfebacteria bacterium]	diamond	174	40.8	1	Bacteria	Bacteria candidate phyla	Candidatus Wolfeibacteriota	Candidatus Wolfebacteria 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);;