metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Kaiseribacteriota"

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
364670	364670	PRJNA168635_P_NODE_5941_length_347_cov_4.942953_g5534_i0	PRJNA168635	5941	347	4.942953	17.15204691	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	340	6.259999999999999e-89	NTclustered	gi\|1995742126\|gb\|CP070993.1\|	2030810	g5534	i0	84.593	21.8674351585014	344	51	99	2	2	344	403338	403680	MAG: Candidatus Kaiserbacteria bacterium isolate FR12parc1 chromosome, complete genome	blastn	7588	340	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
1639229	1639229	PRJNA168635_P_NODE_19062_length_185_cov_5.632353_g18646_i0	PRJNA168635	19062	185	5.632353	10.41985305	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	202	1.48e-47	NTclustered	gi\|1950807631\|gb\|CP066682.1\|	2030810	g18646	i0	86.631	141.832432432432	187	19	99	5	1	184	649	466	MAG: Candidatus Kaiserbacteria bacterium isolate NC_groundwater_79_Ag_B-0.1um_58_26 chromosome	blastn	26239	202	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
5467627	5467627	PRJNA168635_P_NODE_14545_length_211_cov_3.617284_g14129_i0	PRJNA168635	14545	211	3.617284	7.63246924	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	91.6	3.93e-14	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g14129	i0	86.207	0.862559241706161	87	9	41	3	124	209	952832	952916	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	182	91.6	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
9292833	9292833	PRJNA168635_P_NODE_7508_length_308_cov_19.575290_g7096_i0	PRJNA168635	7508	308	19.57529	60.2918932	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	180	1.26e-40	NTclustered	gi\|1950807631\|gb\|CP066682.1\|	2030810	g7096	i0	80.658	112.876623376623	243	38	76	5	29	263	395	636	MAG: Candidatus Kaiserbacteria bacterium isolate NC_groundwater_79_Ag_B-0.1um_58_26 chromosome	blastn	34766	180	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
11843193	11843193	PRJNA168635_P_NODE_29430_length_164_cov_3.486957_g29014_i0	PRJNA168635	29430	164	3.486957	5.71860948	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	241	2.72e-59	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g29014	i0	93.827	87.0609756097561	162	7	97	2	4	162	954309	954148	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	14278	241	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
18216046	18216046	PRJNA168635_P_NODE_14075_length_215_cov_2.765060_g13659_i0	PRJNA168635	14075	215	2.76506	5.944879	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	224	3.8e-54	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g13659	i0	85.782	67.6790697674419	211	30	98	0	5	215	888805	889015	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	14551	224	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
19490472	19490472	PRJNA168635_P_NODE_24916_length_169_cov_2.541667_g24500_i0	PRJNA168635	24916	169	2.541667	4.29541723	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	219	1.3099999999999999e-52	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g24500	i0	90	2.36094674556213	170	16	100	1	1	169	954058	953889	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	399	219	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
22730983	22730983	PRJNA168635_P_NODE_1618_length_628_cov_20.920553_g1267_i0	PRJNA168635	1618	628	20.920553	131.38107284	Bacteria	2	Bacteria	Bacteria	459	3.14e-124	NTclustered	gi\|1995742126\|gb\|CP070993.1\|	2030810	g1267	i0	80.992	96.8869426751592	605	92	95	20	1	595	405006	405597	MAG: Candidatus Kaiserbacteria bacterium isolate FR12parc1 chromosome, complete genome	blastn	60845	459	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
23316733	23316733	PRJNA168635_P_NODE_33079_length_159_cov_3.018182_g32663_i0	PRJNA168635	33079	159	3.018182	4.79890938	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	226	7.329999999999998e-55	NTclustered	gi\|1950807631\|gb\|CP066682.1\|	2030810	g32663	i0	92.903	0.974842767295597	155	11	97	0	5	159	86	240	MAG: Candidatus Kaiserbacteria bacterium isolate NC_groundwater_79_Ag_B-0.1um_58_26 chromosome	blastn	155	226	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
23316896	23316896	PRJNA168635_P_NODE_999_length_771_cov_7.365651_g739_i0	PRJNA168635	999	771	7.365651	56.78916921	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	381	8.689999999999998e-101	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g739	i0	77.078	19.8884565499351	746	118	91	41	63	766	953672	954406	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	15334	381	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria 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);;