RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA827593" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA827593 · 25 ✖

analysis 1

  • diamond · 25 ✖

tax_clade 0

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
5924031 5924031 PRJNA827593_P_NODE_16805_length_525_cov_1.938053_g16508_i0 PRJNA827593 16805 525 1.938053 10.17477825 Candidatus Nitrosotalea sp. FS 2341021 Archaea Archaea 159 7.78e-46   NR WP_166286845.1 2341021 g16508 i0 90.4 0.537142857142857 94 8 53.1 1 245 523 1 94 WP_166286845.1 FMN-dependent NADH-azoreductase [Candidatus Nitrosotalea sp. FS] diamond 282 159 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea sp. FS
17399092 17399092 PRJNA827593_P_NODE_14394_length_572_cov_1.659319_g14099_i0 PRJNA827593 14394 572 1.659319 9.49130468 Nitrosotalea sp. 2833567 Archaea Archaea 332 4.949999999999998e-106   NR HEU5221721.1 2833567 g14099 i0 95.8 0.870629370629371 166 7 87.1 0 75 572 1 166 HEU5221721.1 hypothetical protein [Nitrosotalea sp.] diamond 498 332 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea sp.
18672561 18672561 PRJNA827593_P_NODE_4055_length_1142_cov_2.554724_g3838_i0 PRJNA827593 4055 1142 2.554724 29.17494808 Candidatus Nitrosotalea sp. FS 2341021 Archaea Archaea 297 2.51e-97   NR WP_166285870.1 2341021 g3838 i0 88.6 0.459719789842382 175 19 45.7 1 201 722 1 175 WP_166285870.1 hypothetical protein [Candidatus Nitrosotalea sp. FS] diamond 525 297 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea sp. FS
23773429 23773429 PRJNA827593_P_NODE_26899_length_402_cov_2.458967_g26600_i0 PRJNA827593 26899 402 2.458967 9.88504734 Candidatus Nitrosotalea sp. FS 2341021 Archaea Archaea 139 3.94e-39   NR WP_166286325.1 2341021 g26600 i0 89.7 0.582089552238806 78 8 58.2 0 169 402 1 78 WP_166286325.1 hypothetical protein [Candidatus Nitrosotalea sp. FS] diamond 234 139 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea sp. FS
26642880 26642880 PRJNA827593_P_NODE_60981_length_251_cov_1.646067_g60682_i0 PRJNA827593 60981 251 1.646067 4.13162817 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 148 2.41e-42   NR HKQ22230.1 2169593 g60682 i0 93.5 2.7609561752988 77 5 92 0 19 249 138 214 HKQ22230.1 ribonucleotide reductase N-terminal alpha domain-containing protein [Nitrososphaeraceae archaeon] diamond 693 148 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
26769660 26769660 PRJNA827593_P_NODE_28521_length_389_cov_1.610759_g28222_i0 PRJNA827593 28521 389 1.610759 6.26585251 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 124 1.12e-33   NR HWY36127.1 2202732 g28222 i0 67 0.77120822622108 100 32 77.1 1 387 88 46 144 HWY36127.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 300 124 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
27117525 27117525 PRJNA827593_P_NODE_45602_length_298_cov_2.053333_g45303_i0 PRJNA827593 45602 298 2.053333 6.11893234 Nitrososphaera sp. 1971748 Archaea Archaea 133 6.51e-34   NR NOJ27505.1 1971748 g45303 i0 76.9 1.83221476510067 91 21 91.6 0 24 296 64 154 NOJ27505.1 hypothetical protein [Nitrososphaera sp.] diamond 546 133 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
27212340 27212340 PRJNA827593_P_NODE_23142_length_438_cov_2.594521_g22843_i0 PRJNA827593 23142 438 2.594521 11.36400198 Candidatus Nitrosotalea sp. FS 2341021 Archaea Archaea 122 4.07e-33   NR WP_166285229.1 2341021 g22843 i0 86.9 0.575342465753425 84 11 57.5 0 81 332 2 85 WP_166285229.1 tetratricopeptide repeat protein [Candidatus Nitrosotalea sp. FS] diamond 252 122 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea sp. FS
27433990 27433990 PRJNA827593_P_NODE_40743_length_318_cov_1.257143_g40444_i0 PRJNA827593 40743 318 1.257143 3.99771474 uncultured marine thaumarchaeote AD1 1167203 Archaea Archaea 63.2 8.29e-10   NR AIE91003.1 1455887 g40444 i0 52.6 1.4811320754717 57 24 50.9 1 172 11 40 96 AIE91003.1 hypothetical protein [uncultured marine thaumarchaeote AD1000_100_C06] diamond 471 63.2 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
27821434 27821434 PRJNA827593_P_NODE_8304_length_774_cov_2.689016_g8021_i0 PRJNA827593 8304 774 2.689016 20.81298384 root 1 Root_unresolved Root_unresolved 101 9.86e-22   NR HET8793581.1 2169593 g8021 i0 72.3 0.906976744186046 65 18 25.2 0 714 520 175 239 HET8793581.1 glycosyltransferase [Nitrososphaeraceae archaeon] diamond 702 101 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28444244 28444244 PRJNA827593_P_NODE_16406_length_532_cov_2.259259_g16109_i0 PRJNA827593 16406 532 2.259259 12.01925788 Nitrososphaera sp. 1971748 Archaea Archaea 161 2.3599999999999996e-47   NR NOJ27511.1 1971748 g16109 i0 75.2 0.569548872180451 101 25 57 0 305 3 1 101 NOJ27511.1 heavy metal-responsive transcriptional regulator [Nitrososphaera sp.] diamond 303 161 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
28759789 28759789 PRJNA827593_P_NODE_28727_length_387_cov_3.579618_g28428_i0 PRJNA827593 28727 387 3.579618 13.85312166 Candidatus Nitrosotalea sp. FS 2341021 Archaea Archaea 246 7.23e-81   NR NHH98214.1 2341021 g28428 i0 98.4 0.992248062015504 128 2 99.2 0 385 2 49 176 NHH98214.1 hypothetical protein [Candidatus Nitrosotalea sp. FS] diamond 384 246 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea sp. FS
28791296 28791296 PRJNA827593_P_NODE_40167_length_320_cov_1.834008_g39868_i0 PRJNA827593 40167 320 1.834008 5.8688256 Candidatus Nitrosotalea sp. FS 2341021 Archaea Archaea 211 4.17e-66   NR NHH97542.1 2341021 g39868 i0 100 1.9875 106 0 99.4 0 320 3 22 127 NHH97542.1 hypothetical protein [Candidatus Nitrosotalea sp. FS] diamond 636 211 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea sp. FS
28799819 28799819 PRJNA827593_P_NODE_66287_length_243_cov_1.788235_g65988_i0 PRJNA827593 66287 243 1.788235 4.34541105 Nitrososphaeria 1643678 Archaea Archaea 74.7 3.07e-14   NR WP_157927012.1 1903276 g65988 i0 89.7 2.88888888888889 39 4 48.1 0 119 3 1 39 WP_157927012.1 pyridoxamine 5'-phosphate oxidase family protein [Candidatus Nitrosotalea okcheonensis] diamond 702 75.1 0.994673768308922 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea okcheonensis
28886004 28886004 PRJNA827593_P_NODE_1568_length_1894_cov_4.643053_g1416_i0 PRJNA827593 1568 1894 4.643053 87.93942382 Nitrosopumilus sp. 2024843 Archaea Archaea 151 6.93e-38   NR MEK0336630.1 2024843 g1416 i0 57.3 0.196409714889124 124 52 19.5 1 1115 1483 111 234 MEK0336630.1 hypothetical protein [Nitrosopumilus sp.] diamond 372 151 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
29012787 29012787 PRJNA827593_P_NODE_4648_length_1056_cov_1.970498_g4417_i0 PRJNA827593 4648 1056 1.970498 20.80845888 Nitrososphaera sp. 1971748 Archaea Archaea 91.3 1.33e-16   NR HZT35237.1 1971748 g4417 i0 29 0.803977272727273 283 168 75.9 7 1038 238 72 337 HZT35237.1 hypothetical protein [Nitrososphaera sp.] diamond 849 91.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
29107291 29107291 PRJNA827593_P_NODE_57248_length_261_cov_1.898936_g56949_i0 PRJNA827593 57248 261 1.898936 4.95622296 Nitrosotalea sinensis 1499975 Archaea Archaea 109 2.88e-28   NR WP_101010492.1 1499975 g56949 i0 93.3 0.689655172413793 60 4 69 0 260 81 103 162 WP_101010492.1 hypothetical protein [Nitrosotalea sinensis] diamond 180 109 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea sinensis
29517512 29517512 PRJNA827593_P_NODE_32330_length_362_cov_2.010381_g32031_i0 PRJNA827593 32330 362 2.010381 7.27757922 Nitrososphaerota archaeon 2026795 Archaea Archaea 104 3.88e-23   NR MEM3062467.1 2026795 g32031 i0 51.4 3.06629834254144 105 45 87 3 45 359 343 441 MEM3062467.1 helicase-related protein [Nitrososphaerota archaeon] diamond 1110 104 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
30252901 30252901 PRJNA827593_P_NODE_31552_length_367_cov_2.085034_g31253_i0 PRJNA827593 31552 367 2.085034 7.65207478 root 1 Root_unresolved Root_unresolved 93.6 1.58e-21   NR MEM3062449.1 2026795 g31253 i0 50 1.29972752043597 90 40 73.6 2 96 365 1 85 MEM3062449.1 hypothetical protein [Nitrososphaerota archaeon] diamond 477 93.6 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31159932 31159932 PRJNA827593_P_NODE_14095_length_579_cov_1.361660_g13800_i0 PRJNA827593 14095 579 1.36166 7.8840114 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 132 2.84e-36   NR HKQ22235.1 2169593 g13800 i0 67.7 0.512953367875648 99 29 49.7 2 234 521 1 99 HKQ22235.1 zinc ribbon domain-containing protein [Nitrososphaeraceae archaeon] diamond 297 132 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31350233 31350233 PRJNA827593_P_NODE_69236_length_231_cov_3.310127_g68937_i0 PRJNA827593 69236 231 3.310127 7.64639337 Nitrosotalea sp. 2833567 Archaea Archaea 148 2.3999999999999998e-39   NR HEU5221721.1 2833567 g68937 i0 96.1 0.987012987012987 76 3 98.7 0 2 229 181 256 HEU5221721.1 hypothetical protein [Nitrosotalea sp.] diamond 228 148 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea sp.
31508386 31508386 PRJNA827593_P_NODE_36496_length_338_cov_1.705660_g36197_i0 PRJNA827593 36496 338 1.70566 5.7651308 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 164 1.51e-46   NR HKQ20687.1 2169593 g36197 i0 66.1 0.994082840236686 112 38 99.4 0 3 338 214 325 HKQ20687.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 336 164 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32014311 32014311 PRJNA827593_P_NODE_16718_length_527_cov_1.356828_g16421_i0 PRJNA827593 16718 527 1.356828 7.15048356 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 112 3.19e-28   NR HKQ20689.1 2169593 g16421 i0 40.9 0.77988614800759 137 80 78 1 98 508 1 136 HKQ20689.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 411 112 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32236198 32236198 PRJNA827593_P_NODE_36518_length_338_cov_1.494340_g36219_i0 PRJNA827593 36518 338 1.49434 5.0508692 Nitrosotalea sp. 2833567 Archaea Archaea 221 6.9e-69   NR HEU5220461.1 2833567 g36219 i0 98.2 0.994082840236686 112 2 99.4 0 337 2 174 285 HEU5220461.1 tRNA-guanine transglycosylase [Nitrosotalea sp.] diamond 336 221 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea sp.
32489197 32489197 PRJNA827593_P_NODE_4359_length_1094_cov_6.574927_g4135_i0 PRJNA827593 4359 1094 6.574927 71.92970138 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 228 1.6e-69   NR HET8793581.1 2169593 g4135 i0 73.6 0.405850091407678 148 39 40.6 0 453 10 1 148 HET8793581.1 glycosyltransferase [Nitrososphaeraceae archaeon] diamond 444 228 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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