metadata: contig_metadata: 9 rows where bioproject = "PRJEB20058", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJEB20058", tax_clade = "Bacteria candidate phyla" 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
25516677	25516677	PRJEB20058_P_NODE_189737_length_265_cov_6.921569_g186913_i0	PRJEB20058	189737	265	6.921569	18.34215785	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	182	2.96e-41	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g186913	i0	80.738	58.0867924528302	244	37	90	10	1	238	385732	385971	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	15393	182	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
25519387	25519387	PRJEB20058_P_NODE_31849_length_743_cov_5.894428_g29341_i0	PRJEB20058	31849	743	5.894428	43.79560004	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	1081	0	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g29341	i0	93.243	303.908479138627	740	40	99	8	1	735	964220	963486	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	225804	1081	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
25650509	25650509	PRJEB20058_P_NODE_141290_length_326_cov_95.667925_g138469_i0	PRJEB20058	141290	326	95.667925	311.8774355	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	422	2.03e-113	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g138469	i0	92.256	89.3527607361963	297	23	91	0	2	298	964578	964874	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	29129	422	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
26329931	26329931	PRJEB20058_P_NODE_119463_length_365_cov_24.243421_g116647_i0	PRJEB20058	119463	365	24.243421	88.48848665	Bacteria	2	Bacteria	Bacteria	88.6	3.09e-19	NR	MDB5255098.1	2052152	g116647	i0	73.2	1.83287671232877	56	15	46	0	196	363	18	73	MDB5255098.1 ribosomal protein large subunit ribosomal protein [Candidatus Nomurabacteria bacterium]	diamond	669	88.6	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
26565607	26565607	PRJEB20058_P_NODE_197096_length_258_cov_6.385787_g194272_i0	PRJEB20058	197096	258	6.385787	16.47533046	Bacteria	2	Bacteria	Bacteria	300	7.6e-77	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g194272	i0	89.54	133.949612403101	239	22	92	3	21	258	964459	964223	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	34559	300	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
32979154	32979154	PRJEB20058_P_NODE_127427_length_350_cov_9.726644_g124608_i0	PRJEB20058	127427	350	9.726644	34.043254	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	94.4	5.990000000000001e-21	NR	MDB5260158.1	2052152	g124608	i0	43.1	0.934285714285714	109	62	93.4	0	327	1	1	109	MDB5260158.1 (p)ppGpp synthetase SpoT/RelA [Candidatus Nomurabacteria bacterium]	diamond	327	94.4	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
32996844	32996844	PRJEB20058_P_NODE_55995_length_561_cov_4.230000_g53246_i0	PRJEB20058	55995	561	4.23	23.7303	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	82.4	7.26e-16	NR	HAQ02987.1	2052152	g53246	i0	33.3	1.64171122994652	153	92	76.5	4	446	18	12	164	HAQ02987.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	921	82.4	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
33098515	33098515	PRJEB20058_P_NODE_156078_length_305_cov_2.622951_g153255_i0	PRJEB20058	156078	305	2.622951	8.00000055	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	115	1.7e-29	NR	USN95627.1	2052152	g153255	i0	68.4	3.04918032786885	76	24	74.8	0	229	2	7	82	USN95627.1 MAG: hypothetical protein H6793_00450 [Candidatus Nomurabacteria bacterium]	diamond	930	115	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
33133076	33133076	PRJEB20058_P_NODE_21431_length_898_cov_14.409797_g19306_i0	PRJEB20058	21431	898	14.409797	129.39997706	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	398	5.06e-134	NR	MCC6199087.1	2052152	g19306	i0	76.7	0.861915367483296	258	58	86.2	1	884	111	219	474	MCC6199087.1 methionine--tRNA ligase [Candidatus Nomurabacteria bacterium]	diamond	774	398	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);;