metadata: contig_metadata: 5 rows where bioproject = "PRJEB10140" and tax_clade = "Nitrospinota/Tectimicrobiota group"

5 rows where bioproject = "PRJEB10140" and tax_clade = "Nitrospinota/Tectimicrobiota group"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
28074848	28074848	PRJEB10140_P_NODE_232885_length_175_cov_1.603175_g215576_i0	PRJEB10140	232885	175	1.603175	2.80555625	Nitrospinaceae bacterium	2358456	Bacteria	Bacteria	63.9	5e-10	NR	MEO2043079.1	2358456	g215576	i0	56	0.857142857142857	50	22	85.7	0	168	19	385	434	MEO2043079.1 reverse transcriptase domain-containing protein [Nitrospinaceae bacterium]	diamond	150	63.9	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospinaceae bacterium
28927523	28927523	PRJEB10140_P_NODE_98968_length_370_cov_1.641745_g81671_i0	PRJEB10140	98968	370	1.641745	6.0744565	Nitrospinales bacterium	2833568	Bacteria	Bacteria	44.7	0.0312	NR	MCH2389971.1	2833568	g81671	i0	30.7	1.02972972972973	127	73	96.5	5	13	369	411	530	MCH2389971.1 reverse transcriptase family protein [Nitrospinales bacterium]	diamond	381	44.7	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales		Nitrospinales bacterium
30001243	30001243	PRJEB10140_P_NODE_42371_length_848_cov_1.790989_g27747_i0	PRJEB10140	42371	848	1.790989	15.18758672	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	127	1.97e-30	NR	MDQ3828979.1	2528274	g27747	i0	29.4	0.997641509433962	282	165	96.9	9	6	827	32	287	MDQ3828979.1 FAD-binding oxidoreductase [Candidatus Tectimicrobiota bacterium]	diamond	846	127	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota				Candidatus Tectimicrobiota bacterium
31106666	31106666	PRJEB10140_P_NODE_144755_length_255_cov_1.830097_g127447_i0	PRJEB10140	144755	255	1.830097	4.66674735	Nitrospinaceae bacterium	2358456	Bacteria	Bacteria	54.3	3.51e-6	NR	MEO2043079.1	2358456	g127447	i0	38.7	0.729411764705882	62	38	72.9	0	244	59	413	474	MEO2043079.1 reverse transcriptase domain-containing protein [Nitrospinaceae bacterium]	diamond	186	54.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospinaceae bacterium
31138183	31138183	PRJEB10140_P_NODE_263695_length_166_cov_0.888889_g246386_i0	PRJEB10140	263695	166	0.888889	1.47555574	Nitrospinota bacterium	2026769	Bacteria	Bacteria	72	5.99e-13	NR	MDH5679917.1	2026769	g246386	i0	61.1	0.975903614457831	54	21	97.6	0	3	164	235	288	MDH5679917.1 DUF294 nucleotidyltransferase-like domain-containing protein [Nitrospinota bacterium]	diamond	162	72	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota				Nitrospinota 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);;