metadata: contig_metadata: 6 rows where bioproject = "PRJNA890871", tax_clade = "Bacteria candidate phyla" and tax

6 rows where bioproject = "PRJNA890871", tax_clade = "Bacteria candidate phyla" 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_species
7242951	7242951	PRJNA890871_P_NODE_56406_length_258_cov_1.664865_g56271_i0	PRJNA890871	56406	258	1.664865	4.2953517	Bacteria	2	Bacteria	Bacteria	99	6.909999999999999e-23	NR	MBP9701525.1	2053589	g56271	i0	58.7	6.94186046511628	75	30	87.2	1	31	255	169	242	MBP9701525.1 thymidylate synthase [Candidatus Paceibacterota bacterium]	diamond	1791	99	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28887057	28887057	PRJNA890871_P_NODE_27568_length_321_cov_1.721774_g27433_i0	PRJNA890871	27568	321	1.721774	5.52689454	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	135	1.9799999999999997e-37	NR	HEY4528674.1	2053589	g27433	i0	67.9	5.96261682242991	106	34	99.1	0	4	321	50	155	HEY4528674.1 amidase family protein [Candidatus Paceibacterota bacterium]	diamond	1914	135	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
29203081	29203081	PRJNA890871_P_NODE_18689_length_375_cov_2.006623_g18554_i0	PRJNA890871	18689	375	2.006623	7.52483625	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	59.7	1.66e-7	NR	HTR18688.1	2053589	g18554	i0	36.8	1	125	76	99.2	2	375	4	60	182	HTR18688.1 peptidoglycan-binding protein [Candidatus Paceibacterota bacterium]	diamond	375	59.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31161005	31161005	PRJNA890871_P_NODE_2175_length_1143_cov_5.110280_g2059_i0	PRJNA890871	2175	1143	5.11028	58.4105004	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	85.5	8.27e-17	NR	HUS49709.1	2053589	g2059	i0	51.4	0.194225721784777	74	36	19.4	0	68	289	1	74	HUS49709.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	222	85.5	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31667323	31667323	PRJNA890871_P_NODE_4017_length_754_cov_5.286344_g3886_i0	PRJNA890871	4017	754	5.286344	39.85903376	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	115	1.6600000000000002e-26	NR	MEO5646344.1	2053589	g3886	i0	45	0.592838196286472	149	80	58.5	2	309	749	128	276	MEO5646344.1 dihydroneopterin aldolase [Candidatus Paceibacterota bacterium]	diamond	447	115	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
31730571	31730571	PRJNA890871_P_NODE_58217_length_256_cov_1.464481_g58082_i0	PRJNA890871	58217	256	1.464481	3.74907136	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	109	2.53e-27	NR	MDP7368217.1	2053589	g58082	i0	61.7	1.8984375	81	30	94.9	1	246	4	119	198	MDP7368217.1 PhoH family protein [Candidatus Paceibacterota bacterium]	diamond	486	109	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);;