metadata: contig_metadata: 10 rows where bioproject = "PRJNA642647" and tax

10 rows where bioproject = "PRJNA642647" and tax_phylum = "Minisyncoccota"

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_class	tax_order	tax_family	tax_genus	tax_species
5721523	5721523	PRJNA642647_P_NODE_3725_length_185_cov_1.581081_g3675_i0	PRJNA642647	3725	185	1.581081	2.92499985	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	106	1.2e-18	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g3675	i0	89.286	37.1567567567568	84	9	45	0	52	135	444748	444665	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	6874	106	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
8811499	8811499	PRJNA642647_P_NODE_6627_length_150_cov_4.000000_g6577_i0	PRJNA642647	6627	150	4	6	Bacteria	2	Bacteria	Bacteria	147	5.45e-31	NTclustered	gi\|2862534883\|gb\|CP174360.1\|	1948790	g6577	i0	84.768	10.36	151	17	98	3	1	147	190677	190529	MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome	blastn	1554	148	0.993243243243243	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Minusculum	Candidatus Minusculum obligatum
14646933	14646933	PRJNA642647_P_NODE_5952_length_156_cov_2.058824_g5902_i0	PRJNA642647	5952	156	2.058824	3.21176544	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	126	7.46e-25	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g5902	i0	90.625	469.807692307692	96	8	61	1	55	149	444527	444622	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	73290	126	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
21020372	21020372	PRJNA642647_P_NODE_2277_length_227_cov_3.021053_g2227_i0	PRJNA642647	2277	227	3.021053	6.85779031	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	252	1.86e-62	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g2227	i0	86.957	46.0352422907489	230	22	99	7	2	227	443792	443567	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	10450	252	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
27366035	27366035	PRJNA642647_P_NODE_5743_length_159_cov_1.639344_g5693_i0	PRJNA642647	5743	159	1.639344	2.60655696	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	55.1	5.18e-7	NR	MFA6257754.1	2053589	g5693	i0	49	0.962264150943396	51	26	96.2	0	155	3	540	590	MFA6257754.1 tail fiber domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	153	55.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
27492122	27492122	PRJNA642647_P_NODE_3603_length_187_cov_2.046667_g3553_i0	PRJNA642647	3603	187	2.046667	3.82726729	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	79.3	1.68e-15	NR	MFA5434243.1	2053589	g3553	i0	74.1	0.866310160427808	54	14	86.6	0	164	3	308	361	MFA5434243.1 P22 phage major capsid protein family protein [Candidatus Paceibacterota bacterium]	diamond	162	79.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29039429	29039429	PRJNA642647_P_NODE_5128_length_166_cov_2.775194_g5078_i0	PRJNA642647	5128	166	2.775194	4.60682204	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	48.1	4.61e-5	NR	MFA6314951.1	2053589	g5078	i0	48.1	0.975903614457831	54	26	97.6	1	162	1	70	121	MFA6314951.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	162	48.1	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29197197	29197197	PRJNA642647_P_NODE_6469_length_151_cov_3.254386_g6419_i0	PRJNA642647	6469	151	3.254386	4.91412286	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	45.8	8.7e-4	NR	MFA5766659.1	2053589	g6419	i0	76.9	0.516556291390728	26	5	49.7	1	148	74	248	273	MFA5766659.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	78	45.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
31420765	31420765	PRJNA642647_P_NODE_5596_length_161_cov_1.209677_g5546_i0	PRJNA642647	5596	161	1.209677	1.94757997	Bacteria	2	Bacteria	Bacteria	54.7	5.77e-7	NR	HNU95593.1	2053589	g5546	i0	54.3	1.71428571428571	46	21	85.7	0	155	18	116	161	HNU95593.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	276	54.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
32641672	32641672	PRJNA642647_P_NODE_3400_length_192_cov_1.258065_g3350_i0	PRJNA642647	3400	192	1.258065	2.4154848	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	77	1.01e-14	NR	MFA6226878.1	2053589	g3350	i0	56.3	1	64	27	100	1	192	1	251	313	MFA6226878.1 aminotransferase class V-fold PLP-dependent enzyme [Candidatus Paceibacterota bacterium]	diamond	192	77	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota 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);;