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

5 rows where bioproject = "PRJNA432257", 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
11908397	11908397	PRJNA432257_S_NODE_39650_length_252_cov_2.683721_g39269_i0	PRJNA432257	39650	252	2.683721	6.76297692	Bacteria	2	Bacteria	Bacteria	119	1.16e-30	NR	QFR38631.1	1862133	g39269	i0	82.4	6.51190476190476	68	12	81	0	224	21	212	279	QFR38631.1 50S ribosomal protein L2 [Candidatus Gracilibacteria bacterium 28_42_T64]	diamond	1641	120	0.991666666666667	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Gracilibacteria bacterium 28_42_T64
23381662	23381662	PRJNA432257_S_NODE_29759_length_280_cov_2.991770_g29378_i0	PRJNA432257	29759	280	2.99177	8.376956	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	170	8.28e-47	NR	MCF7843570.1	2044595	g29378	i0	85.1	3.72857142857143	87	13	93.2	0	262	2	406	492	MCF7843570.1 class I tRNA ligase family protein [Candidatus Altimarinota bacterium]	diamond	1044	170	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
26902593	26902593	PRJNA432257_S_NODE_100201_length_176_cov_2.625899_g99820_i0	PRJNA432257	100201	176	2.625899	4.62158224	Bacteria	2	Bacteria	Bacteria	52.8	4.39e-6	NR	MCF7843431.1	2044595	g99820	i0	68.4	1.22727272727273	38	11	64.8	1	140	27	8	44	MCF7843431.1 ribonuclease R [Candidatus Altimarinota bacterium]	diamond	216	53.1	0.994350282485876	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
29475470	29475470	PRJNA432257_S_NODE_88950_length_185_cov_2.054054_g88569_i0	PRJNA432257	88950	185	2.054054	3.7999999	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	104	4.45e-25	NR	MBF0981377.1	2044595	g88569	i0	95.1	0.989189189189189	61	3	98.9	0	185	3	9	69	MBF0981377.1 sortase [Candidatus Altimarinota bacterium]	diamond	183	104	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
30170485	30170485	PRJNA432257_S_NODE_99712_length_176_cov_68.546763_g99331_i0	PRJNA432257	99712	176	68.546763	120.64230288	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	69.3	6.37e-12	NR	MCF7843810.1	2044595	g99331	i0	71.7	1.55113636363636	46	13	78.4	0	140	3	955	1000	MCF7843810.1 DNA polymerase III subunit alpha [Candidatus Altimarinota bacterium]	diamond	273	69.3	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);;