metadata: contig_metadata: 6 rows where bioproject = "PRJEB64798" and tax

6 rows where bioproject = "PRJEB64798" and tax_phylum = "Candidatus Berkelbacteria"

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
6507000	6507000	PRJEB64798_P_NODE_3606_length_989_cov_25.764894_g79_i38	PRJEB64798	3606	989	25.764894	254.81480166	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	363	4.08e-95	NTclustered	gi\|1950822261\|gb\|CP066697.1\|	2053521	g79	i38	79.924	221.721941354904	528	78	51	24	329	834	518776	519297	Candidatus Berkelbacteria bacterium isolate NC_groundwater_1597_Pr3_B-0.1um_51_91 chromosome	blastn	219283	363	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium
15428822	15428822	PRJEB64798_P_NODE_105913_length_211_cov_7.462963_g104147_i0	PRJEB64798	105913	211	7.462963	15.74685193	Berkelbacteria bacterium GW2011_GWE1_39_12	1618337	Bacteria	Bacteria	91.6	3.93e-14	NTclustered	gi\|837351782\|gb\|CP011213.1\|	1618337	g104147	i0	94.828	23.2748815165877	58	3	27	0	112	169	137064	137121	Berkelbacteria bacterium GW2011_GWE1_39_12, complete genome	blastn	4911	91.6	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Berkelbacteria bacterium GW2011_GWE1_39_12
19255157	19255157	PRJEB64798_P_NODE_76576_length_220_cov_4.456140_g74810_i0	PRJEB64798	76576	220	4.45614	9.803508	uncultured Candidatus Berkelbacteria bacterium	1664347	Bacteria	Bacteria	135	1.88e-27	NTclustered	gi\|2874253682\|emb\|OY969116.1\|	1664347	g74810	i0	79.894	99.4318181818182	189	34	84	4	31	215	7699	7511	MAG: uncultured Candidatus Berkelbacteria bacterium isolate MFD04408.bin.c.6 genome assembly, chromosome: 1	blastn	21875	135	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	uncultured Candidatus Berkelbacteria bacterium
31045047	31045047	PRJEB64798_P_NODE_100915_length_212_cov_2.920245_g99149_i0	PRJEB64798	100915	212	2.920245	6.1909194	Candidatus Berkelbacteria bacterium RIFOXYA2_FULL_43_1	2053521	Bacteria	Bacteria	72.8	1.25e-13	NR	OGD62003.1	1797472	g99149	i0	60	0.990566037735849	70	22	94.8	2	205	5	82	148	OGD62003.1 MAG: hypothetical protein A2215_04550 [Candidatus Berkelbacteria bacterium RIFOXYA2_FULL_43_10]	diamond	210	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium RIFOXYA2_FULL_43_10
32468360	32468360	PRJEB64798_P_NODE_101719_length_212_cov_2.773006_g99953_i0	PRJEB64798	101719	212	2.773006	5.87877272	Candidatus Berkelbacteria bacterium RIFOXYA2_FULL_43_1	2053521	Bacteria	Bacteria	81.6	3.21e-16	NR	OGD63164.1	1797472	g99953	i0	52.4	1.16037735849057	82	24	94.8	1	210	10	85	166	OGD63164.1 MAG: rod shape-determining protein RodA [Candidatus Berkelbacteria bacterium RIFOXYA2_FULL_43_10]	diamond	246	81.6	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium RIFOXYA2_FULL_43_10
32500165	32500165	PRJEB64798_P_NODE_81839_length_213_cov_18.981707_g80073_i0	PRJEB64798	81839	213	18.981707	40.43103591	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	50.1	5.51e-5	NR	MCR4308198.1	2053521	g80073	i0	66.7	0.464788732394366	33	11	46.5	0	114	212	180	212	MCR4308198.1 hypothetical protein [Candidatus Berkelbacteria bacterium]	diamond	99	50.1	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria 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);;