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

5 rows where analysis = "diamond", bioproject = "PRJNA550047" and tax_phylum = "Candidatus Sumerlaeota"

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_class	tax_order	tax_family	tax_species
26744199	26744199	PRJNA550047_P_NODE_217361_length_301_cov_14.478070_g215392_i0	PRJNA550047	217361	301	14.47807	43.5789907	Bacteria	2	Bacteria	Bacteria	89.4	1.19e-18	NR	PKO16431.1	2013722	g215392	i0	42	3.88704318936877	138	40	97.7	4	5	298	162	299	PKO16431.1 MAG: MFS transporter [candidate division BRC1 bacterium HGW-BRC1-1]	diamond	1170	89.4	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota				candidate division BRC1 bacterium HGW-BRC1-1
27331075	27331075	PRJNA550047_P_NODE_358123_length_281_cov_26.096154_g356152_i0	PRJNA550047	358123	281	26.096154	73.33019274	Candidatus Sumerlaeota bacterium	2107588	Bacteria	Bacteria	158	2.05e-45	NR	MCX7049459.1	2107588	g356152	i0	72	1.98576512455516	93	26	99.3	0	280	2	148	240	MCX7049459.1 DUF1961 family protein [Candidatus Sumerlaeota bacterium]	diamond	558	158	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota				Candidatus Sumerlaeota bacterium
29398027	29398027	PRJNA550047_P_NODE_420429_length_257_cov_8.451087_g418457_i0	PRJNA550047	420429	257	8.451087	21.71929359	Bacteria	2	Bacteria	Bacteria	77	1e-14	NR	OPZ09016.1	1852824	g418457	i0	50	1.52918287937743	80	39	92.2	1	256	20	96	175	OPZ09016.1 MAG: hypothetical protein BWZ08_00729 [candidate division BRC1 bacterium ADurb.BinA292]	diamond	393	77	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota				candidate division BRC1 bacterium ADurb.BinA292
30140963	30140963	PRJNA550047_P_NODE_589992_length_201_cov_6.671875_g588019_i0	PRJNA550047	589992	201	6.671875	13.41046875	Candidatus Sumerlaeaceae bacterium	2315423	Bacteria	Bacteria	108	6.77e-26	NR	MBX7245724.1	2315423	g588019	i0	83.3	0.985074626865672	66	11	98.5	0	200	3	277	342	MBX7245724.1 transcription termination factor NusA [Candidatus Sumerlaeaceae bacterium]	diamond	198	108	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaeaceae bacterium
30836239	30836239	PRJNA550047_P_NODE_106714_length_345_cov_7.838235_g104754_i0	PRJNA550047	106714	345	7.838235	27.04191075	candidate division BRC1 bacterium SM23_51	1703761	Bacteria	Bacteria	62	1.77e-8	NR	KPL06090.1	1703761	g104754	i0	63.3	0.426086956521739	49	18	42.6	0	198	344	101	149	KPL06090.1 MAG: hypothetical protein AMJ85_10740 [candidate division BRC1 bacterium SM23_51]	diamond	147	62	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota				candidate division BRC1 bacterium SM23_51

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