metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax

13 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Candidatus Parcubacteria"

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
2676845	2676845	PRJEB64798_P_NODE_124143_length_203_cov_2.837662_g122377_i0	PRJEB64798	124143	203	2.837662	5.76045386	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	228	2.739999999999999e-55	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g122377	i0	88.083	201.246305418719	193	21	95	2	8	200	53936	53746	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	40853	228	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
2677694	2677694	PRJEB64798_P_NODE_179743_length_174_cov_6.736000_g177977_i0	PRJEB64798	179743	174	6.736	11.72064	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	278	2.22e-70	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g177977	i0	95.402	4.63793103448276	174	8	100	0	1	174	52960	53133	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	807	278	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
2678986	2678986	PRJEB64798_P_NODE_38323_length_319_cov_5.570370_g36563_i0	PRJEB64798	38323	319	5.57037	17.7694803	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	446	1.17e-120	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g36563	i0	98.047	8.99059561128527	256	5	80	0	1	256	54526	54271	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	2868	446	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
7781905	7781905	PRJEB64798_P_NODE_72967_length_226_cov_3.259887_g71202_i0	PRJEB64798	72967	226	3.259887	7.36734462	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	143	1.16e-29	NTclustered	gi\|2314736631\|dbj\|AP024682.1\|	2762014	g71202	i0	89.474	130.022123893805	114	11	50	1	113	225	11228	11341	MAG: Candidatus Parcubacteria bacterium KatS3mg098 DNA, complete genome	blastn	29385	143	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
9054242	9054242	PRJEB64798_P_NODE_141208_length_193_cov_1.652778_g139442_i0	PRJEB64798	141208	193	1.652778	3.18986154	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	171	4.3999999999999996e-38	NTclustered	gi\|2874254054\|emb\|OY970378.1\|	2762014	g139442	i0	96.154	187.378238341969	104	4	54	0	2	105	448223	448120	MAG: Candidatus Parcubacteria bacterium isolate MFD01275.bin.c.8 genome assembly, chromosome: 1	blastn	36164	171	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
9054549	9054549	PRJEB64798_P_NODE_160988_length_183_cov_2.283582_g159222_i0	PRJEB64798	160988	183	2.283582	4.17895506	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	233	5.19e-57	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g159222	i0	90.449	17.8142076502732	178	15	97	2	1	178	52584	52409	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	3260	233	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
10332515	10332515	PRJEB64798_P_NODE_71529_length_228_cov_10.229050_g69764_i0	PRJEB64798	71529	228	10.22905	23.322234	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	231	2.43e-56	NTclustered	gi\|2874254054\|emb\|OY970378.1\|	2762014	g69764	i0	85.909	296.399122807018	220	27	96	3	5	222	449545	449762	MAG: Candidatus Parcubacteria bacterium isolate MFD01275.bin.c.8 genome assembly, chromosome: 1	blastn	67579	231	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
11606703	11606703	PRJEB64798_P_NODE_224070_length_161_cov_3.008929_g222304_i0	PRJEB64798	224070	161	3.008929	4.84437569	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	207	2.7e-49	NTclustered	gi\|2874254054\|emb\|OY970378.1\|	2762014	g222304	i0	91.026	65.0745341614907	156	10	96	4	2	155	447229	447076	MAG: Candidatus Parcubacteria bacterium isolate MFD01275.bin.c.8 genome assembly, chromosome: 1	blastn	10477	207	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
12880695	12880695	PRJEB64798_P_NODE_148091_length_189_cov_6.221429_g146325_i0	PRJEB64798	148091	189	6.221429	11.75850081	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	183	5.509999999999999e-42	NTclustered	gi\|2314736631\|dbj\|AP024682.1\|	2762014	g146325	i0	88.667	0.793650793650794	150	17	79	0	6	155	8128	7979	MAG: Candidatus Parcubacteria bacterium KatS3mg098 DNA, complete genome	blastn	150	183	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
14156620	14156620	PRJEB64798_P_NODE_224612_length_161_cov_2.125000_g222846_i0	PRJEB64798	224612	161	2.125	3.42125	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	252	1.23e-62	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g222846	i0	96.689	115.670807453416	151	5	94	0	4	154	54793	54643	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	18623	252	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
17979947	17979947	PRJEB64798_P_NODE_239015_length_155_cov_7.547170_g237249_i0	PRJEB64798	239015	155	7.54717	11.6981135	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	171	3.37e-38	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g237249	i0	91.803	114.838709677419	122	10	79	0	23	144	52077	52198	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	17800	171	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
19253314	19253314	PRJEB64798_P_NODE_193456_length_169_cov_2.725000_g191690_i0	PRJEB64798	193456	169	2.725	4.60525	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	169	1.34e-37	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g191690	i0	87.333	119.337278106509	150	15	87	4	20	166	52636	52488	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	20168	169	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
24354147	24354147	PRJEB64798_P_NODE_232280_length_158_cov_2.568807_g230514_i0	PRJEB64798	232280	158	2.568807	4.05871506	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	97.1	5.95e-16	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g230514	i0	80.315	0.80379746835443	127	25	80	0	31	157	52243	52369	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	127	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria 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);;