metadata: contig_metadata: 5 rows where bioproject = "PRJNA690592" and tax

5 rows where bioproject = "PRJNA690592" and tax_phylum = "Candidatus Altimarinota"

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
27113882	27113882	PRJNA690592_S_NODE_186542_length_251_cov_0.865169_g185528_i0	PRJNA690592	186542	251	0.865169	2.17157419	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	43.1	0.00772	NR	HPO05948.1	2044595	g185528	i0	32.9	2.73705179282869	70	47	83.7	0	211	2	14	83	HPO05948.1 thioredoxin [Candidatus Altimarinota bacterium]	diamond	687	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
28440550	28440550	PRJNA690592_S_NODE_108406_length_317_cov_1.512295_g107392_i0	PRJNA690592	108406	317	1.512295	4.79397515	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	141	1.1e-37	NR	MDF2378969.1	2044595	g107392	i0	71.3	0.889589905362776	94	27	89	0	317	36	64	157	MDF2378969.1 adenylosuccinate synthase [Candidatus Altimarinota bacterium]	diamond	282	141	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
30240495	30240495	PRJNA690592_S_NODE_19472_length_676_cov_2.567164_g18522_i0	PRJNA690592	19472	676	2.567164	17.35402864	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	57.8	9.97e-6	NR	MFA6090757.1	2044595	g18522	i0	28.1	0.505917159763314	114	82	50.6	0	214	555	271	384	MFA6090757.1 SulP family inorganic anion transporter [Candidatus Altimarinota bacterium]	diamond	342	57.8	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
30872339	30872339	PRJNA690592_S_NODE_201214_length_246_cov_0.890173_g200200_i0	PRJNA690592	201214	246	0.890173	2.18982558	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	50.4	6.91e-5	NR	MCP4523361.1	2044595	g200200	i0	32.4	0.902439024390244	74	50	90.2	0	15	236	138	211	MCP4523361.1 ion transporter [Candidatus Altimarinota bacterium]	diamond	222	50.4	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
32148732	32148732	PRJNA690592_S_NODE_108478_length_317_cov_1.307377_g107464_i0	PRJNA690592	108478	317	1.307377	4.14438509	Bacteria	2	Bacteria	Bacteria	47.8	0.00154	NR	MDQ7010084.1	2044595	g107464	i0	45.2	2.56466876971609	62	22	58.7	3	6	191	281	330	MDQ7010084.1 spherulation-specific family 4 protein [Candidatus Altimarinota bacterium]	diamond	813	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota 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);;