metadata: contig_metadata: 6 rows where bioproject = "PRJNA703759", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax

6 rows where bioproject = "PRJNA703759", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax_superkingdom = "Bacteria"

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_genus	tax_species
12163313	12163313	PRJNA703759_P_NODE_17450_length_327_cov_2.102362_g16974_i0	PRJNA703759	17450	327	2.102362	6.87472374	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	392	1.6e-104	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g16974	i0	88.58	566.737003058104	324	36	99	1	4	327	2628878	2629200	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	185323	392	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
19810976	19810976	PRJNA703759_P_NODE_17276_length_329_cov_1.109375_g16800_i0	PRJNA703759	17276	329	1.109375	3.64984375	Candidatus Nitrohelix vancouverensis	2705534	Bacteria	Bacteria	126	1.7999999999999997e-24	NTclustered	gi\|1938442527\|gb\|CP048620.1\|	2705534	g16800	i0	77.049	78.3130699088146	244	41	74	9	85	327	2189762	2189991	MAG: Candidatus Nitrohelix vancouverensis isolate VA-1 chromosome	blastn	25765	126	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitrohelix	Candidatus Nitrohelix vancouverensis
27335803	27335803	PRJNA703759_P_NODE_49303_length_243_cov_0.917647_g48827_i0	PRJNA703759	49303	243	0.917647	2.22988221	Candidatus Entotheonella sp.	2066855	Bacteria	Bacteria	56.2	6.42e-7	NR	HEY7709496.1	2066855	g48827	i0	39.5	1	81	42	91.4	1	242	21	181	261	HEY7709496.1 chemotaxis protein CheB [Candidatus Entotheonella sp.]	diamond	243	56.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella sp.
28420569	28420569	PRJNA703759_P_NODE_49526_length_243_cov_0.917647_g49050_i0	PRJNA703759	49526	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	110	1.8499999999999999e-28	NR	OGW21230.1	1801688	g49050	i0	60.5	4	81	31	100	1	243	1	17	96	OGW21230.1 MAG: protein tyrosine phosphatase [Nitrospinae bacterium RIFCSPLOWO2_12_FULL_47_7]	diamond	972	111	0.990990990990991	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinae bacterium RIFCSPLOWO2_12_FULL_47_7
30809502	30809502	PRJNA703759_P_NODE_27434_length_275_cov_2.599010_g26958_i0	PRJNA703759	27434	275	2.59901	7.1472775	Nitrospina sp.	2024844	Bacteria	Bacteria	58.2	2.13e-7	NR	MCA9483733.1	2024844	g26958	i0	42	0.883636363636364	81	41	87.3	3	244	5	12	87	MCA9483733.1 alpha-2-macroglobulin family protein [Nitrospina sp.]	diamond	243	58.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospina	Nitrospina sp.
32832395	32832395	PRJNA703759_P_NODE_22240_length_297_cov_1.375000_g21764_i0	PRJNA703759	22240	297	1.375	4.08375	Nitrospina sp.	2024844	Bacteria	Bacteria	106	2.5399999999999998e-24	NR	HIB42721.1	2024844	g21764	i0	50	2.90909090909091	98	49	99	0	294	1	77	174	HIB42721.1 hypothetical protein [Nitrospina sp.]	diamond	864	106	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospina	Nitrospina sp.

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