metadata: contig_metadata: 9 rows where bioproject = "PRJNA690592", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJNA690592", 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
12151023	12151023	PRJNA690592_S_NODE_47430_length_450_cov_1.021220_g46416_i0	PRJNA690592	47430	450	1.02122	4.59549	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	139	1.15e-39	NR	MDR3570671.1	2053589	g46416	i0	72.9	0.713333333333333	107	25	68.7	2	37	345	1	107	MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	321	139	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
26733949	26733949	PRJNA690592_S_NODE_37801_length_497_cov_1.966981_g36790_i0	PRJNA690592	37801	497	1.966981	9.77589557	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	45.8	0.0269	NR	MDR3549073.1	2053589	g36790	i0	34.3	0.404426559356137	67	36	40.4	1	256	56	174	232	MDR3549073.1 B-box zinc finger protein [Candidatus Paceibacterota bacterium]	diamond	201	45.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
26872680	26872680	PRJNA690592_S_NODE_104601_length_322_cov_1.176707_g103587_i0	PRJNA690592	104601	322	1.176707	3.78899654	Pseudomonadati	3379134	Bacteria	Bacteria	56.6	1.22e-6	NR	MBP7846009.1	2053589	g103587	i0	28.8	5.14285714285714	111	73	97.8	2	321	7	71	181	MBP7846009.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	1656	56.6	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27272232	27272232	PRJNA690592_S_NODE_94163_length_335_cov_2.935115_g93149_i0	PRJNA690592	94163	335	2.935115	9.83263525	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	63.9	4e-9	NR	HTH93425.1	2053589	g93149	i0	37.5	5.14029850746269	80	40	71.6	1	327	88	609	678	HTH93425.1 tail fiber domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	1722	63.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
27998687	27998687	PRJNA690592_S_NODE_6265_length_1099_cov_7.293372_g5691_i0	PRJNA690592	6265	1099	7.293372	80.15415828	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	246	5.569999999999999e-74	NR	MDR3582248.1	2053589	g5691	i0	45.2	0.857142857142857	314	168	84.6	4	1065	136	3	316	MDR3582248.1 clusterin-associated protein 1 [Candidatus Paceibacterota bacterium]	diamond	942	246	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28566747	28566747	PRJNA690592_S_NODE_219447_length_229_cov_2.961538_g218433_i0	PRJNA690592	219447	229	2.961538	6.78192202	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	86.7	5.11e-20	NR	MDR3549538.1	2053589	g218433	i0	63.9	0.799126637554585	61	22	79.9	0	46	228	8	68	MDR3549538.1 small nuclear ribonucleoprotein Sm D2 [Candidatus Paceibacterota bacterium]	diamond	183	86.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
28977396	28977396	PRJNA690592_S_NODE_188788_length_250_cov_1.288136_g187774_i0	PRJNA690592	188788	250	1.288136	3.22034	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	53.9	4.35e-6	NR	MDR3547190.1	2053589	g187774	i0	34.1	0.984	82	54	98.4	0	250	5	102	183	MDR3547190.1 alpha/beta hydrolase [Candidatus Paceibacterota bacterium]	diamond	246	53.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
30650984	30650984	PRJNA690592_S_NODE_60733_length_404_cov_1.540785_g59719_i0	PRJNA690592	60733	404	1.540785	6.2247714	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	68.9	1.44e-10	NR	MDR3582082.1	2053589	g59719	i0	46.5	1.02475247524752	71	34	49.8	1	3	203	299	369	MDR3582082.1 EF-hand domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	414	68.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccota bacterium
32485568	32485568	PRJNA690592_S_NODE_63799_length_395_cov_2.751553_g62785_i0	PRJNA690592	63799	395	2.751553	10.86863435	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	139	4.44e-40	NR	MDR3549538.1	2053589	g62785	i0	61	0.79746835443038	105	41	79.7	0	8	322	1	105	MDR3549538.1 small nuclear ribonucleoprotein Sm D2 [Candidatus Paceibacterota bacterium]	diamond	315	139	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);;