metadata: contig_metadata: 8 rows where bioproject = "PRJNA558770" and tax

8 rows where bioproject = "PRJNA558770" and tax_phylum = "Candidatus Nomuraibacteriota"

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
15841725	15841725	PRJNA558770_P_NODE_186793_length_234_cov_4.321608_g184788_i0	PRJNA558770	186793	234	4.321608	10.11256272	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	128	3.38e-25	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g184788	i0	97.333	11.2478632478632	75	2	32	0	160	234	135699	135625	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	2632	128	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
26920710	26920710	PRJNA558770_P_NODE_130842_length_234_cov_8.030151_g128837_i0	PRJNA558770	130842	234	8.030151	18.79055334	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	51.2	3.22e-5	NR	MCX6753931.1	2052152	g128837	i0	91.7	0.615384615384615	24	2	30.8	0	162	233	89	112	MCX6753931.1 rod shape-determining protein RodA [Candidatus Nomurabacteria bacterium]	diamond	144	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
27742619	27742619	PRJNA558770_P_NODE_274944_length_234_cov_1.814070_g272939_i0	PRJNA558770	274944	234	1.81407	4.2449238	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	87	8.95e-19	NR	USN97772.1	2052152	g272939	i0	58.4	0.987179487179487	77	5	98.7	1	233	3	46	95	USN97772.1 MAG: flavodoxin family protein [Candidatus Nomurabacteria bacterium]	diamond	231	87	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28057988	28057988	PRJNA558770_P_NODE_255785_length_234_cov_2.185930_g253780_i0	PRJNA558770	255785	234	2.18593	5.1150762	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	46.6	0.00139	NR	MCX6756738.1	2052152	g253780	i0	72.7	0.576923076923077	22	6	28.2	0	11	76	233	254	MCX6756738.1 type II secretion system F family protein [Candidatus Nomurabacteria bacterium]	diamond	135	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28103498	28103498	PRJNA558770_P_NODE_308665_length_233_cov_12.823232_g306660_i0	PRJNA558770	308665	233	12.823232	29.87813056	Bacteria	2	Bacteria	Bacteria	54.7	1.91e-6	NR	KKP60946.1	1618768	g306660	i0	100	2.57510729613734	25	0	32.2	0	76	2	150	174	KKP60946.1 MAG: polymerase III subunit beta protein [Candidatus Nomurabacteria bacterium GW2011_GWF1_34_20]	diamond	600	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWF1_34_20
29398174	29398174	PRJNA558770_P_NODE_200789_length_234_cov_3.748744_g198784_i0	PRJNA558770	200789	234	3.748744	8.77206096	Bacteria	2	Bacteria	Bacteria	48.9	2.12e-4	NR	OGI67006.1	1801741	g198784	i0	95.8	0.923076923076923	24	1	30.8	0	74	3	167	190	OGI67006.1 MAG: hypothetical protein A2823_02830 [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_41_91]	diamond	216	48.9	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_41_91
31166875	31166875	PRJNA558770_P_NODE_117115_length_234_cov_9.577889_g115110_i0	PRJNA558770	117115	234	9.577889	22.41226026	Bacteria	2	Bacteria	Bacteria	57.8	1.62e-7	NR	KKP91362.1	1618765	g115110	i0	45.1	4.25641025641026	82	37	94.9	1	233	12	382	463	KKP91362.1 MAG: Efflux transporter, RND family, MFP subunit [Candidatus Nomurabacteria bacterium GW2011_GWE2_36_115]	diamond	996	57.8	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWE2_36_115
32323941	32323941	PRJNA558770_P_NODE_329759_length_233_cov_6.308081_g327754_i0	PRJNA558770	329759	233	6.308081	14.69782873	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_	2052152	Bacteria	Bacteria	56.6	3.66e-7	NR	OGI78641.1	1801747	g327754	i0	31	1.62231759656652	126	38	99.1	1	231	1	168	293	OGI78641.1 MAG: transcription antitermination factor NusB [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_02_FULL_33_12]	diamond	378	56.6	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_02_FULL_33_12

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);;