metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB20058" 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
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
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);;