metadata: contig_metadata: 5 rows where bioproject = "PRJNA438111", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA438111", tax_clade = "Bacteria candidate phyla" 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
9362765	9362765	PRJNA438111_P_NODE_85268_length_154_cov_2.192000_g84643_i0	PRJNA438111	85268	154	2.192	3.37568	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	75.5	6.12e-15	NR	RKW23974.1	2044595	g84643	i0	90.5	0.818181818181818	42	4	81.8	0	153	28	109	150	RKW23974.1 MAG: ATP-binding cassette domain-containing protein [Candidatus Altimarinota bacterium]	diamond	126	75.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
30882107	30882107	PRJNA438111_P_NODE_38534_length_196_cov_4.598802_g37909_i0	PRJNA438111	38534	196	4.598802	9.01365192	Bacteria	2	Bacteria	Bacteria	54.7	1.55e-7	NR	RKW23284.1	2044595	g37909	i0	81.8	1.01020408163265	33	6	50.5	0	195	97	83	115	RKW23284.1 MAG: hypothetical protein D8B45_03705, partial [Candidatus Altimarinota bacterium]	diamond	198	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
31434703	31434703	PRJNA438111_P_NODE_46856_length_185_cov_3.519231_g46231_i0	PRJNA438111	46856	185	3.519231	6.51057735	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	123	4.96e-32	NR	MBF0981025.1	2044595	g46231	i0	98.4	0.989189189189189	61	1	98.9	0	183	1	137	197	MBF0981025.1 peptide chain release factor 1 [Candidatus Altimarinota bacterium]	diamond	183	123	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
31640840	31640840	PRJNA438111_P_NODE_63896_length_168_cov_5.597122_g63271_i0	PRJNA438111	63896	168	5.597122	9.40316496	Bacteria	2	Bacteria	Bacteria	78.6	3.11e-15	NR	RKW25514.1	2044595	g63271	i0	70.4	2.89285714285714	54	16	96.4	0	3	164	527	580	RKW25514.1 MAG: PKD domain-containing protein, partial [Candidatus Altimarinota bacterium]	diamond	486	78.6	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
32762547	32762547	PRJNA438111_P_NODE_38500_length_196_cov_4.748503_g37875_i0	PRJNA438111	38500	196	4.748503	9.30706588	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	94	6.87e-21	NR	RKW23495.1	2044595	g37875	i0	76.8	1.05612244897959	69	4	87.2	1	194	24	155	223	RKW23495.1 MAG: hypothetical protein D8B45_03330, partial [Candidatus Altimarinota bacterium]	diamond	207	94	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);;