metadata: contig_metadata: 11 rows where bioproject = "PRJEB11748" and tax

11 rows where bioproject = "PRJEB11748" 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
8636651	8636651	PRJEB11748_P_NODE_210427_length_275_cov_2.831776_g208244_i0	PRJEB11748	210427	275	2.831776	7.787384	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	135	9.329999999999999e-35	NR	MDB5259930.1	2052152	g208244	i0	81.3	0.872727272727273	80	15	87.3	0	250	11	338	417	MDB5259930.1 ATP-dependent helicase PcrA [Candidatus Nomurabacteria bacterium]	diamond	240	135	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
8942169	8942169	PRJEB11748_P_NODE_166168_length_316_cov_5.858824_g163985_i0	PRJEB11748	166168	316	5.858824	18.51388384	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	298	3.44e-76	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g163985	i0	86.063	63.2658227848101	287	29	89	7	28	307	965517	965235	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	19992	298	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
8945340	8945340	PRJEB11748_P_NODE_337528_length_203_cov_5.690141_g335345_i0	PRJEB11748	337528	203	5.690141	11.55098623	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	132	2.21e-26	NTclustered	gi\|2258866441\|gb\|CP060228.1\|	2052152	g335345	i0	82.099	86.7487684729064	162	21	78	6	1	159	249922	250078	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome	blastn	17610	132	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
10219681	10219681	PRJEB11748_P_NODE_250309_length_246_cov_16.870270_g248126_i0	PRJEB11748	250309	246	16.87027	41.5008642	Candidatus Nomurabacteria bacterium CG1_	2052152	Bacteria	Bacteria	67.4	5.61e-11	NR	OIO32942.1	1805282	g248126	i0	90.6	3.51219512195122	32	3	39	0	221	126	284	315	OIO32942.1 MAG: hypothetical protein AUJ44_01400 [Candidatus Nomurabacteria bacterium CG1_02_47_685]	diamond	864	67.4	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium CG1_02_47_685
15317713	15317713	PRJEB11748_P_NODE_177953_length_304_cov_2.168724_g175770_i0	PRJEB11748	177953	304	2.168724	6.59292096	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	475	1.4199999999999997e-129	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g175770	i0	96.516	102.207236842105	287	10	94	0	18	304	961662	961948	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	31071	475	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
24243305	24243305	PRJEB11748_P_NODE_284540_length_227_cov_3.228916_g282357_i0	PRJEB11748	284540	227	3.228916	7.32963932	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	296	8.46e-76	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g282357	i0	92.718	43.3215859030837	206	13	90	2	1	204	964643	964848	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	9834	296	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28264553	28264553	PRJEB11748_P_NODE_369886_length_187_cov_14.150794_g367703_i0	PRJEB11748	369886	187	14.150794	26.46198478	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_	2052152	Bacteria	Bacteria	65.5	9.53e-11	NR	OGI60278.1	1801731	g367703	i0	76.7	0.689839572192513	43	10	69	0	153	25	1	43	OGI60278.1 MAG: hypothetical protein A2641_00590 [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_37_25]	diamond	129	65.5	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_37_25
30374677	30374677	PRJEB11748_P_NODE_385332_length_175_cov_10.631579_g383149_i0	PRJEB11748	385332	175	10.631579	18.60526325	Bacteria	2	Bacteria	Bacteria	63.9	4.55e-10	NR	OGI59663.1	1801730	g383149	i0	53.6	3.34285714285714	56	22	94.3	2	165	1	120	172	OGI59663.1 MAG: hypothetical protein A2727_02170 [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_37_110]	diamond	585	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_37_110
31296717	31296717	PRJEB11748_P_NODE_217915_length_269_cov_2.802885_g215732_i0	PRJEB11748	217915	269	2.802885	7.53976065	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	66.6	1.97e-10	NR	USN95213.1	2052152	g215732	i0	71.7	1.92936802973978	46	13	51.3	0	121	258	12	57	USN95213.1 MAG: hypothetical protein H6793_02660 [Candidatus Nomurabacteria bacterium]	diamond	519	66.6	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
31455099	31455099	PRJEB11748_P_NODE_383916_length_176_cov_11.634783_g381733_i0	PRJEB11748	383916	176	11.634783	20.47721808	Candidatus Nomurabacteria bacterium GW2	2052152	Bacteria	Bacteria	68.2	1.04e-12	NR	KKQ35353.1	1618742	g381733	i0	62.7	2.55681818181818	51	19	86.9	0	23	175	40	90	KKQ35353.1 MAG: hypothetical protein US50_C0017G0014 [Candidatus Nomurabacteria bacterium GW2011_GWB1_37_5]	diamond	450	68.2	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWB1_37_5
31954743	31954743	PRJEB11748_P_NODE_336237_length_204_cov_1.629371_g334054_i0	PRJEB11748	336237	204	1.629371	3.32391684	Bacteria	2	Bacteria	Bacteria	42	0.0416	NR	MEI6352438.1	2052152	g334054	i0	45.5	1.61764705882353	55	26	75	1	166	14	134	188	MEI6352438.1 type IV secretion system DNA-binding domain-containing protein [Candidatus Nomurabacteria bacterium]	diamond	330	42	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria 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);;