contig_metadata
6 rows where bioproject = "PRJNA641707" and tax_phylum = "Nitrospinota"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6991662 | 6991662 | PRJNA641707_P_NODE_206386_length_196_cov_6.816327_g203723_i0 | PRJNA641707 | 206386 | 196 | 6.816327 | 13.36000092 | Nitrospina watsonii | 1323948 | Bacteria | Bacteria | 172 | 1.25e-38 | NTclustered | gi|2427816174|emb|OX336137.1| | 1323948 | g203723 | i0 | 83.684 | 201.377551020408 | 190 | 23 | 93 | 4 | 6 | 187 | 1935783 | 1935972 | Nitrospina watsonii strain 347 genome assembly, chromosome: NSPWAT | blastn | 39470 | 172 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinia | Nitrospinales | Nitrospinaceae | Nitrospina | Nitrospina watsonii | |
| 15919901 | 15919901 | PRJNA641707_P_NODE_69833_length_251_cov_3.693069_g67170_i0 | PRJNA641707 | 69833 | 251 | 3.693069 | 9.26960319 | Candidatus Nitrohelix vancouverensis | 2705534 | Bacteria | Bacteria | 108 | 4.79e-19 | NTclustered | gi|1938442527|gb|CP048620.1| | 2705534 | g67170 | i0 | 86.139 | 32.2589641434263 | 101 | 13 | 40 | 1 | 1 | 101 | 2187256 | 2187355 | MAG: Candidatus Nitrohelix vancouverensis isolate VA-1 chromosome | blastn | 8097 | 108 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinia | Nitrospinales | Nitrospinaceae | Candidatus Nitrohelix | Candidatus Nitrohelix vancouverensis | |
| 22293868 | 22293868 | PRJNA641707_P_NODE_57258_length_282_cov_8.175966_g54597_i0 | PRJNA641707 | 57258 | 282 | 8.175966 | 23.05622412 | Candidatus Nitronauta litoralis | 2705533 | Bacteria | Bacteria | 93.5 | 1.53e-14 | NTclustered | gi|1938439011|gb|CP048685.1| | 2705533 | g54597 | i0 | 77.206 | 2.98581560283688 | 136 | 26 | 46 | 1 | 34 | 164 | 3877717 | 3877582 | MAG: Candidatus Nitronauta litoralis isolate EB chromosome, complete genome | blastn | 842 | 93.5 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinia | Nitrospinales | Nitrospinaceae | Candidatus Nitronauta | Candidatus Nitronauta litoralis | |
| 29670155 | 29670155 | PRJNA641707_P_NODE_253190_length_181_cov_2.939394_g250527_i0 | PRJNA641707 | 253190 | 181 | 2.939394 | 5.32030314 | Nitrospinae bacterium CG11_big_fil_rev_8_21_14_ | 1974048 | Bacteria | Bacteria | 57 | 4.44e-8 | NR | PIR00428.1 | 1974048 | g250527 | i0 | 50 | 0.895027624309392 | 54 | 27 | 89.5 | 0 | 13 | 174 | 8 | 61 | PIR00428.1 MAG: hypothetical protein COV66_06785 [Nitrospinae bacterium CG11_big_fil_rev_8_21_14_0_20_45_15] | diamond | 162 | 57 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinae bacterium CG11_big_fil_rev_8_21_14_0_20_45_15 | |||||
| 31218246 | 31218246 | PRJNA641707_P_NODE_317895_length_158_cov_13.192661_g315232_i0 | PRJNA641707 | 317895 | 158 | 13.192661 | 20.84440438 | Nitrospinota bacterium | 2026769 | Bacteria | Bacteria | 84.7 | 5.47e-18 | NR | MBI3326113.1 | 2026769 | g315232 | i0 | 78.4 | 0.968354430379747 | 51 | 11 | 96.8 | 0 | 153 | 1 | 30 | 80 | MBI3326113.1 NAD(+) diphosphatase [Nitrospinota bacterium] | diamond | 153 | 84.7 | 1 | Bacteria | Nitrospinota/Tectimicrobiota group | Pseudomonadati | Nitrospinota | Nitrospinota bacterium | |||||
| 31724505 | 31724505 | PRJNA641707_P_NODE_167697_length_201_cov_29.532895_g165034_i0 | PRJNA641707 | 167697 | 201 | 29.532895 | 59.36111895 | Nitrospinota bacterium | 2026769 | Bacteria | Bacteria | 41.2 | 0.0198 | NR | MFC1492043.1 | 2026769 | g165034 | i0 | 42.9 | 0.73134328358209 | 49 | 28 | 73.1 | 0 | 183 | 37 | 38 | 86 | MFC1492043.1 hypothetical protein [Nitrospinota bacterium] | diamond | 147 | 41.2 | 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);;