metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA630162" 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
3153760	3153760	PRJNA630162_P_NODE_99983_length_185_cov_4.029412_g98460_i0	PRJNA630162	99983	185	4.029412	7.4544122	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	178	2.5e-40	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g98460	i0	87.582	14.172972972973	153	19	83	0	5	157	54091	54243	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	2622	178	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
6979956	6979956	PRJNA630162_P_NODE_115786_length_176_cov_3.551181_g114263_i0	PRJNA630162	115786	176	3.551181	6.25007856	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	278	2.25e-70	NTclustered	gi\|2874254054\|emb\|OY970378.1\|	2762014	g114263	i0	95.906	170.278409090909	171	7	97	0	5	175	448611	448781	MAG: Candidatus Parcubacteria bacterium isolate MFD01275.bin.c.8 genome assembly, chromosome: 1	blastn	29969	278	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
9530229	9530229	PRJNA630162_P_NODE_145648_length_165_cov_2.620690_g144125_i0	PRJNA630162	145648	165	2.62069	4.3241385	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	274	2.7e-69	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g144125	i0	97.5	4.61212121212121	160	4	97	0	1	160	54498	54339	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	761	274	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
14630435	14630435	PRJNA630162_P_NODE_121532_length_173_cov_3.540323_g120009_i0	PRJNA630162	121532	173	3.540323	6.12475879	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	261	2.22e-65	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g120009	i0	94.186	5.89595375722543	172	9	99	1	2	173	54312	54482	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	1020	261	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
14631748	14631748	PRJNA630162_P_NODE_91112_length_191_cov_1.542254_g89589_i0	PRJNA630162	91112	191	1.542254	2.94570514	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	108	3.46e-19	NTclustered	gi\|2314736631\|dbj\|AP024682.1\|	2762014	g89589	i0	94.286	0.366492146596859	70	4	37	0	1	70	9450	9519	MAG: Candidatus Parcubacteria bacterium KatS3mg098 DNA, complete genome	blastn	70	108	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
15904425	15904425	PRJNA630162_P_NODE_120793_length_174_cov_1.456000_g119270_i0	PRJNA630162	120793	174	1.456	2.53344	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	206	1.0599999999999999e-48	NTclustered	gi\|2874254054\|emb\|OY970378.1\|	2762014	g119270	i0	89.634	15.8965517241379	164	13	93	3	2	163	447027	446866	MAG: Candidatus Parcubacteria bacterium isolate MFD01275.bin.c.8 genome assembly, chromosome: 1	blastn	2766	206	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
16454186	16454186	PRJNA630162_P_NODE_38033_length_289_cov_2.691667_g36510_i0	PRJNA630162	38033	289	2.691667	7.77891763	Bacteria	2	Bacteria	Bacteria	139	1.9999999999999997e-28	NTclustered	gi\|2874254054\|emb\|OY970378.1\|	2762014	g36510	i0	86.26	19.2629757785467	131	15	45	3	1	130	448214	448086	MAG: Candidatus Parcubacteria bacterium isolate MFD01275.bin.c.8 genome assembly, chromosome: 1	blastn	5567	139	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
19727909	19727909	PRJNA630162_P_NODE_100256_length_185_cov_2.625000_g98733_i0	PRJNA630162	100256	185	2.625	4.85625	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	141	3.28e-29	NTclustered	gi\|2650368334\|dbj\|AP029158.1\|	2762014	g98733	i0	83.333	525.918918918919	156	22	83	4	22	175	53445	53292	MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome	blastn	97295	141	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
23555215	23555215	PRJNA630162_P_NODE_75139_length_207_cov_3.297468_g73616_i0	PRJNA630162	75139	207	3.297468	6.82575876	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	220	4.69e-53	NTclustered	gi\|2314736631\|dbj\|AP024682.1\|	2762014	g73616	i0	88.172	9.98550724637681	186	21	89	1	16	200	10574	10389	MAG: Candidatus Parcubacteria bacterium KatS3mg098 DNA, complete genome	blastn	2067	220	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);;