metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax_clade = "Nitrospinota/Tectimicrobiota group"

6 rows where analysis = "blastn", bioproject = "PRJNA944406" 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_genus	tax_species
7302221	7302221	PRJNA944406_P_NODE_11006_length_376_cov_1.755776_g10047_i0	PRJNA944406	11006	376	1.755776	6.60171776	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	324	6.87e-84	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g10047	i0	82.632	133.425531914894	380	52	100	13	1	376	2629827	2630196	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	50168	324	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
7303096	7303096	PRJNA944406_P_NODE_8986_length_415_cov_2.040936_g8027_i0	PRJNA944406	8986	415	2.040936	8.4698844	Candidatus Nitronauta litoralis	2705533	Bacteria	Bacteria	139	2.98e-28	NTclustered	gi\|1938439011\|gb\|CP048685.1\|	2705533	g8027	i0	76.596	94.7012048192771	282	48	66	17	136	407	3876379	3876652	MAG: Candidatus Nitronauta litoralis isolate EB chromosome, complete genome	blastn	39301	139	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitronauta	Candidatus Nitronauta litoralis
8577136	8577136	PRJNA944406_P_NODE_11387_length_371_cov_0.946309_g10428_i0	PRJNA944406	11387	371	0.946309	3.51080639	Candidatus Nitrohelix vancouverensis	2705534	Bacteria	Bacteria	134	1.22e-26	NTclustered	gi\|1938442527\|gb\|CP048620.1\|	2705534	g10428	i0	77.043	87.4420485175202	257	44	69	9	22	277	2190004	2189762	MAG: Candidatus Nitrohelix vancouverensis isolate VA-1 chromosome	blastn	32441	134	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitrohelix	Candidatus Nitrohelix vancouverensis
8577801	8577801	PRJNA944406_P_NODE_7487_length_459_cov_1.569948_g6531_i0	PRJNA944406	7487	459	1.569948	7.20606132	uncultured marine Nitrospinaceae bacterium	482920	Bacteria	Bacteria	211	6.94e-50	NTclustered	gi\|118340518\|gb\|EF106972.1\|	482920	g6531	i0	76.334	45.6296296296296	431	81	92	16	40	459	39201	38781	Uncultured marine Nitrospinaceae bacterium clone EB080L20_F04, partial sequence	blastn	20944	211	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae		uncultured marine Nitrospinaceae bacterium
23876770	23876770	PRJNA944406_P_NODE_13499_length_346_cov_1.948718_g12540_i0	PRJNA944406	13499	346	1.948718	6.74256428	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	462	1.2799999999999998e-125	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g12540	i0	90.778	454.352601156069	347	30	100	2	1	346	2629136	2628791	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	157206	462	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
23877100	23877100	PRJNA944406_P_NODE_40139_length_272_cov_1.547739_g39180_i0	PRJNA944406	40139	272	1.547739	4.20985008	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	318	2.23e-82	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g39180	i0	88.148	7.31617647058824	270	28	99	3	2	269	2628930	2629197	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	1990	318	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella 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);;