contig_metadata
16 rows where bioproject = "PRJNA951810" and tax_phylum = "Nitrososphaerota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26683824 | 26683824 | PRJNA951810_P_NODE_111841_length_285_cov_6.490566_g111497_i0 | PRJNA951810 | 111841 | 285 | 6.490566 | 18.4981131 | root | 1 | Root_unresolved | Root_unresolved | 101 | 4.91e-25 | NR | HZT35106.1 | 1971748 | g111497 | i0 | 65.8 | 4.62105263157895 | 73 | 25 | 76.8 | 0 | 6 | 224 | 64 | 136 | HZT35106.1 redoxin domain-containing protein [Nitrososphaera sp.] | diamond | 1317 | 102 | 0.990196078431373 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 27183531 | 27183531 | PRJNA951810_P_NODE_143462_length_263_cov_2.889474_g143117_i0 | PRJNA951810 | 143462 | 263 | 2.889474 | 7.59931662 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 177 | 1.7899999999999995e-54 | NR | HYY70900.1 | 2169593 | g143117 | i0 | 100 | 2.97718631178707 | 87 | 0 | 99.2 | 0 | 261 | 1 | 48 | 134 | HYY70900.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 783 | 177 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 27632513 | 27632513 | PRJNA951810_P_NODE_84284_length_299_cov_2.207965_g83940_i0 | PRJNA951810 | 84284 | 299 | 2.207965 | 6.60181535 | root | 1 | Root_unresolved | Root_unresolved | 101 | 1.67e-24 | NR | MCI0565475.1 | 1971748 | g83940 | i0 | 67.7 | 1.50501672240803 | 65 | 21 | 65.2 | 0 | 255 | 61 | 1 | 65 | MCI0565475.1 transposase [Nitrososphaera sp.] | diamond | 450 | 102 | 0.990196078431373 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 27721242 | 27721242 | PRJNA951810_P_NODE_79524_length_299_cov_4.331858_g79180_i0 | PRJNA951810 | 79524 | 299 | 4.331858 | 12.95225542 | Candidatus Caldarchaeum sp. | 2972665 | Archaea | Archaea | 67.4 | 1.57e-10 | NR | MEM4408068.1 | 2972665 | g79180 | i0 | 65.5 | 0.551839464882943 | 55 | 19 | 55.2 | 0 | 298 | 134 | 338 | 392 | MEM4408068.1 flagellar filament capping protein FliD [Candidatus Caldarchaeum sp.] | diamond | 165 | 67.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeaceae | Candidatus Caldarchaeum | Candidatus Caldarchaeum sp. | |||
| 28288784 | 28288784 | PRJNA951810_P_NODE_116526_length_282_cov_4.961722_g116182_i0 | PRJNA951810 | 116526 | 282 | 4.961722 | 13.99205604 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 58.2 | 2.05e-8 | NR | MEM0288102.1 | 2026795 | g116182 | i0 | 61 | 1.34042553191489 | 41 | 16 | 43.6 | 0 | 123 | 1 | 3 | 43 | MEM0288102.1 DUF1874 domain-containing protein [Nitrososphaerota archaeon] | diamond | 378 | 58.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 28668047 | 28668047 | PRJNA951810_P_NODE_167447_length_244_cov_4.526316_g167102_i0 | PRJNA951810 | 167447 | 244 | 4.526316 | 11.04421104 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 52 | 4.16e-6 | NR | MDF2421386.1 | 2024843 | g167102 | i0 | 45 | 0.737704918032787 | 60 | 32 | 73.8 | 1 | 240 | 61 | 67 | 125 | MDF2421386.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 180 | 52 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 28857124 | 28857124 | PRJNA951810_P_NODE_11408_length_561_cov_3.522541_g11092_i0 | PRJNA951810 | 11408 | 561 | 3.522541 | 19.76145501 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 84.7 | 3.05e-17 | NR | MDE1767364.1 | 2026795 | g11092 | i0 | 54.4 | 0.422459893048128 | 79 | 35 | 41.7 | 1 | 8 | 241 | 24 | 102 | MDE1767364.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 237 | 84.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29242788 | 29242788 | PRJNA951810_P_NODE_69209_length_308_cov_5.442553_g68865_i0 | PRJNA951810 | 69209 | 308 | 5.442553 | 16.76306324 | root | 1 | Root_unresolved | Root_unresolved | 92.4 | 2.83e-19 | NR | HYY40257.1 | 1971748 | g68865 | i0 | 77.6 | 2.38636363636364 | 49 | 11 | 47.7 | 0 | 161 | 307 | 61 | 109 | HYY40257.1 nitrite/sulfite reductase [Nitrososphaera sp.] | diamond | 735 | 93.2 | 0.991416309012876 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 29394165 | 29394165 | PRJNA951810_P_NODE_1609_length_1360_cov_7.190365_g1480_i0 | PRJNA951810 | 1609 | 1360 | 7.190365 | 97.788964000000007 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 134 | 1.18e-33 | NR | MDF2422457.1 | 2024843 | g1480 | i0 | 45 | 0.633088235294118 | 140 | 73 | 30.9 | 2 | 859 | 440 | 1 | 136 | MDF2422457.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 861 | 134 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 29709382 | 29709382 | PRJNA951810_P_NODE_119050_length_280_cov_9.623188_g118705_i0 | PRJNA951810 | 119050 | 280 | 9.623188 | 26.9449264 | Candidatus Nitrosotenuis sp. | 2507556 | Archaea | Archaea | 114 | 2.1200000000000003e-27 | NR | HXE72085.1 | 2507556 | g118705 | i0 | 58.5 | 1.00714285714286 | 94 | 37 | 99.6 | 2 | 280 | 2 | 329 | 421 | HXE72085.1 TIM44-like domain-containing protein [Candidatus Nitrosotenuis sp.] | diamond | 282 | 114 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis sp. | |||||
| 30032305 | 30032305 | PRJNA951810_P_NODE_72071_length_300_cov_4.273128_g71727_i0 | PRJNA951810 | 72071 | 300 | 4.273128 | 12.819384 | root | 1 | Root_unresolved | Root_unresolved | 76.3 | 6.67e-15 | NR | HXF90395.1 | 2507556 | g71727 | i0 | 68.1 | 2.32 | 47 | 15 | 47 | 0 | 1 | 141 | 61 | 107 | HXF90395.1 ribonuclease HI [Candidatus Nitrosotenuis sp.] | diamond | 696 | 76.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis sp. | |||||
| 30342253 | 30342253 | PRJNA951810_P_NODE_5952_length_761_cov_9.146802_g5697_i0 | PRJNA951810 | 5952 | 761 | 9.146802 | 69.60716322 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 66.6 | 1.66e-10 | NR | HIC83772.1 | 2268197 | g5697 | i0 | 81.6 | 0.504599211563732 | 38 | 7 | 15 | 0 | 117 | 4 | 1 | 38 | HIC83772.1 hypothetical protein [Nitrososphaerales archaeon] | diamond | 384 | 66.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 30594385 | 30594385 | PRJNA951810_P_NODE_93993_length_296_cov_3.130045_g93649_i0 | PRJNA951810 | 93993 | 296 | 3.130045 | 9.2649332 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 72.8 | 1.69e-12 | NR | MEO9320431.1 | 1971748 | g93649 | i0 | 71.4 | 0.496621621621622 | 49 | 14 | 49.7 | 0 | 149 | 3 | 305 | 353 | MEO9320431.1 MBL fold metallo-hydrolase [Nitrososphaera sp.] | diamond | 147 | 72.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 31352899 | 31352899 | PRJNA951810_P_NODE_144896_length_262_cov_2.380952_g144551_i0 | PRJNA951810 | 144896 | 262 | 2.380952 | 6.23809424 | Candidatus Nitrosotenuis sp. | 2507556 | Archaea | Archaea | 72.4 | 1.69e-12 | NR | HXF90752.1 | 2507556 | g144551 | i0 | 36 | 1.84351145038168 | 86 | 53 | 96.2 | 1 | 259 | 8 | 264 | 349 | HXF90752.1 glycosyltransferase family 2 protein [Candidatus Nitrosotenuis sp.] | diamond | 483 | 72.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis sp. | |||||
| 31922128 | 31922128 | PRJNA951810_P_NODE_113797_length_284_cov_3.791469_g113453_i0 | PRJNA951810 | 113797 | 284 | 3.791469 | 10.76777196 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 50.1 | 1.53e-4 | NR | MFI5423023.1 | 2268197 | g113453 | i0 | 32.1 | 0.823943661971831 | 78 | 49 | 82.4 | 1 | 284 | 51 | 279 | 352 | MFI5423023.1 hypothetical protein [Nitrososphaerales archaeon] | diamond | 234 | 50.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 32181924 | 32181924 | PRJNA951810_P_NODE_176878_length_235_cov_6.271605_g176533_i0 | PRJNA951810 | 176878 | 235 | 6.271605 | 14.73827175 | root | 1 | Root_unresolved | Root_unresolved | 105 | 1.92e-26 | NR | MDA4133256.1 | 2026795 | g176533 | i0 | 70 | 2.04255319148936 | 80 | 22 | 99.6 | 1 | 2 | 235 | 51 | 130 | MDA4133256.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 480 | 106 | 0.990566037735849 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon |
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);;