RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA888821" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA888821 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
26612138 26612138 PRJNA888821_P_NODE_46721_length_215_cov_11.802817_g46638_i0 PRJNA888821 46721 215 11.802817 25.37605655 Nitrospira sp. 70125 Bacteria Bacteria 132 3.7e-36   NR MBH0197940.1 70125 g46638 i0 94.4 0.990697674418605 71 4 99.1 0 214 2 55 125 MBH0197940.1 TerC family protein [Nitrospira sp.] diamond 213 132 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
26738525 26738525 PRJNA888821_P_NODE_44461_length_223_cov_8.013333_g44378_i0 PRJNA888821 44461 223 8.013333 17.86973259 Nitrospira cf. moscoviensis SBR1 96242 Bacteria Bacteria 133 2.42e-34   NR WP_087475380.1 96242 g44378 i0 93.2 0.995515695067265 74 5 99.6 0 223 2 46 119 WP_087475380.1 PhoX family protein [Nitrospira cf. moscoviensis SBR1015] diamond 222 133 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015
26778630 26778630 PRJNA888821_P_NODE_11121_length_310_cov_9.852321_g11039_i0 PRJNA888821 11121 310 9.852321 30.5421951 Bacteria 2 Bacteria Bacteria 85.5 7.98e-17   NR HEV8328421.1 2026770 g11039 i0 81.6 0.948387096774194 49 9 47.4 0 148 2 279 327 HEV8328421.1 PAS domain S-box protein [Nitrospiraceae bacterium] diamond 294 85.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
27181717 27181717 PRJNA888821_P_NODE_31962_length_261_cov_14.404255_g31879_i0 PRJNA888821 31962 261 14.404255 37.59510555 Nitrospira sp. 70125 Bacteria Bacteria 108 9.02e-26   NR HEX5543879.1 70125 g31879 i0 62.1 3 87 33 100 0 261 1 179 265 HEX5543879.1 DUF3391 domain-containing protein [Nitrospira sp.] diamond 783 108 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27213336 27213336 PRJNA888821_P_NODE_42802_length_229_cov_4.679487_g42719_i0 PRJNA888821 42802 229 4.679487 10.71602523 Nitrospira sp. 70125 Bacteria Bacteria 140 1.63e-40   NR MBH0190519.1 70125 g42719 i0 98.7 1.96506550218341 75 1 98.3 0 3 227 56 130 MBH0190519.1 hypothetical protein [Nitrospira sp.] diamond 450 140 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27560834 27560834 PRJNA888821_P_NODE_49784_length_206_cov_8.285714_g49701_i0 PRJNA888821 49784 206 8.285714 17.06857084 Nitrospira sp. 70125 Bacteria Bacteria 127 4.52e-34   NR HMS83682.1 70125 g49701 i0 94.1 0.990291262135922 68 4 99 0 3 206 40 107 HMS83682.1 hypothetical protein [Nitrospira sp.] diamond 204 127 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27750701 27750701 PRJNA888821_P_NODE_35864_length_248_cov_9.485714_g35781_i0 PRJNA888821 35864 248 9.485714 23.52457072 Nitrospira sp. 70125 Bacteria Bacteria 146 1.79e-42   NR MBH0198534.1 70125 g35781 i0 98.8 0.991935483870968 82 1 99.2 0 248 3 22 103 MBH0198534.1 hypothetical protein [Nitrospira sp.] diamond 246 146 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27813850 27813850 PRJNA888821_P_NODE_41904_length_232_cov_5.823899_g41821_i0 PRJNA888821 41904 232 5.823899 13.51144568 Nitrospira sp. 70125 Bacteria Bacteria 137 1.03e-35   NR MBH0199865.1 70125 g41821 i0 94.8 0.995689655172414 77 4 99.6 0 1 231 314 390 MBH0199865.1 hypothetical protein [Nitrospira sp.] diamond 231 137 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27916040 27916040 PRJNA888821_P_NODE_50045_length_205_cov_12.098485_g49962_i0 PRJNA888821 50045 205 12.098485 24.80189425 Nitrospira 1234 Bacteria Bacteria 74.3 3.93e-15   NR MBH0208492.1 70125 g49962 i0 94.6 3.24878048780488 37 2 54.1 0 205 95 84 120 MBH0208492.1 hypothetical protein [Nitrospira sp.] diamond 666 74.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28097714 28097714 PRJNA888821_P_NODE_47385_length_213_cov_10.807143_g47302_i0 PRJNA888821 47385 213 10.807143 23.01921459 Nitrospira sp. 70125 Bacteria Bacteria 122 2.32e-31   NR MDN5942380.1 70125 g47302 i0 85.9 1 71 10 100 0 1 213 216 286 MDN5942380.1 DUF2130 domain-containing protein [Nitrospira sp.] diamond 213 122 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28161105 28161105 PRJNA888821_P_NODE_14445_length_310_cov_6.962025_g14363_i0 PRJNA888821 14445 310 6.962025 21.5822775 Nitrospira sp. 70125 Bacteria Bacteria 71.2 1.18e-12   NR HEU4683237.1 70125 g14363 i0 70.8 0.464516129032258 48 14 46.5 0 4 147 71 118 HEU4683237.1 biliverdin-producing heme oxygenase [Nitrospira sp.] diamond 144 71.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28445243 28445243 PRJNA888821_P_NODE_36866_length_246_cov_6.219653_g36783_i0 PRJNA888821 36866 246 6.219653 15.30034638 Nitrospira cf. moscoviensis SBR1 96242 Bacteria Bacteria 145 1.38e-41   NR WP_087474393.1 96242 g36783 i0 93.8 1.98780487804878 81 5 98.8 0 2 244 92 172 WP_087474393.1 ribonuclease HIII [Nitrospira cf. moscoviensis SBR1015] diamond 489 145 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015
28476670 28476670 PRJNA888821_P_NODE_19486_length_310_cov_3.080169_g19404_i0 PRJNA888821 19486 310 3.080169 9.5485239 Nitrospira sp. 70125 Bacteria Bacteria 97.8 3.24e-24   NR MBH0199708.1 70125 g19404 i0 98 0.474193548387097 49 1 47.4 0 162 308 38 86 MBH0199708.1 hypothetical protein [Nitrospira sp.] diamond 147 97.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28697847 28697847 PRJNA888821_P_NODE_11787_length_310_cov_9.130802_g11705_i0 PRJNA888821 11787 310 9.130802 28.3054862 Nitrospira sp. 70125 Bacteria Bacteria 88.2 1.33e-19   NR MDF0644442.1 70125 g11705 i0 83.3 0.464516129032258 48 8 46.5 0 1 144 78 125 MDF0644442.1 hypothetical protein [Nitrospira sp.] diamond 144 88.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28729291 28729291 PRJNA888821_P_NODE_18127_length_310_cov_4.308017_g18045_i0 PRJNA888821 18127 310 4.308017 13.3548527 Nitrospira sp. 70125 Bacteria Bacteria 102 3.0599999999999998e-24   NR BFU94088.1 70125 g18045 i0 85.7 6.16451612903226 49 7 47.4 0 149 3 114 162 BFU94088.1 MAG: Intradiol ring-cleavage dioxygenase [Nitrospira sp.] diamond 1911 102 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29076711 29076711 PRJNA888821_P_NODE_16228_length_310_cov_5.691983_g16146_i0 PRJNA888821 16228 310 5.691983 17.6451473 Nitrospira sp. 70125 Bacteria Bacteria 100 3.23e-22   NR MBX3326463.1 70125 g16146 i0 98 0.474193548387097 49 1 47.4 0 309 163 322 370 MBX3326463.1 transglycosylase SLT domain-containing protein [Nitrospira sp.] diamond 147 100 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29242332 29242332 PRJNA888821_P_NODE_17589_length_310_cov_4.717300_g17507_i0 PRJNA888821 17589 310 4.7173 14.62363 Nitrospira 1234 Bacteria Bacteria 110 5.22e-29   NR THJ24335.1 1985130 g17507 i0 59.2 1.99354838709677 103 33 91 1 301 20 1 103 THJ24335.1 MAG: YtxH domain-containing protein [Nitrospira sp. CG24D] diamond 618 110 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. CG24D
29360791 29360791 PRJNA888821_P_NODE_42589_length_229_cov_16.070513_g42506_i0 PRJNA888821 42589 229 16.070513 36.80147477 Nitrospira sp. 70125 Bacteria Bacteria 137 9.35e-40   NR MDH4329510.1 70125 g42506 i0 80.8 0.956331877729258 73 14 95.6 0 219 1 21 93 MDH4329510.1 hypothetical protein [Nitrospira sp.] diamond 219 137 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29644493 29644493 PRJNA888821_P_NODE_48470_length_210_cov_7.379562_g48387_i0 PRJNA888821 48470 210 7.379562 15.4970802 Nitrospira sp. 70125 Bacteria Bacteria 129 5.49e-33   NR MBX3332160.1 70125 g48387 i0 82.4 2.91428571428571 68 12 97.1 0 5 208 419 486 MBX3332160.1 hypothetical protein [Nitrospira sp.] diamond 612 129 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29802691 29802691 PRJNA888821_P_NODE_21211_length_309_cov_8.211864_g21129_i0 PRJNA888821 21211 309 8.211864 25.37465976 Nitrospira sp. 70125 Bacteria Bacteria 108 2.3700000000000003e-27   NR MDX2252319.1 70125 g21129 i0 88.9 0.524271844660194 54 6 52.4 0 148 309 71 124 MDX2252319.1 sulfotransferase family 2 domain-containing protein [Nitrospira sp.] diamond 162 108 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30316625 30316625 PRJNA888821_P_NODE_18272_length_310_cov_4.181435_g18190_i0 PRJNA888821 18272 310 4.181435 12.9624485 Nitrospira 1234 Bacteria Bacteria 80.5 2.5e-16   NR GKS58011.1 70125 g18190 i0 82.6 0.909677419354839 46 8 44.5 0 139 2 11 56 GKS58011.1 bacterioferritin [Nitrospira sp.] diamond 282 80.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30411233 30411233 PRJNA888821_P_NODE_20913_length_309_cov_9.940678_g20831_i0 PRJNA888821 20913 309 9.940678 30.71669502 Pseudomonadati 3379134 Bacteria Bacteria 89.7 2.55e-18   NR MBS0173727.1 70125 g20831 i0 81.6 13.9029126213592 49 9 47.6 0 149 3 718 766 MBS0173727.1 DNA polymerase III subunit alpha [Nitrospira sp.] diamond 4296 90.1 0.995560488346282 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30718894 30718894 PRJNA888821_P_NODE_50114_length_205_cov_9.386364_g50031_i0 PRJNA888821 50114 205 9.386364 19.2420462 Nitrospira sp. 70125 Bacteria Bacteria 135 5.39e-38   NR MBH0200486.1 70125 g50031 i0 97.1 0.995121951219512 68 2 99.5 0 1 204 106 173 MBH0200486.1 dTMP kinase [Nitrospira sp.] diamond 204 135 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30908691 30908691 PRJNA888821_P_NODE_40374_length_237_cov_10.518293_g40291_i0 PRJNA888821 40374 237 10.518293 24.92835441 Nitrospira sp. 70125 Bacteria Bacteria 95.5 2.1399999999999994e-23   NR MBS0168541.1 70125 g40291 i0 100 0.632911392405063 50 0 63.3 0 2 151 63 112 MBS0168541.1 type II toxin-antitoxin system PemK/MazF family toxin [Nitrospira sp.] diamond 150 95.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31168973 31168973 PRJNA888821_P_NODE_17795_length_310_cov_4.578059_g17713_i0 PRJNA888821 17795 310 4.578059 14.1919829 Nitrospira 1234 Bacteria Bacteria 72.4 7.25e-14   NR MBX3306497.1 70125 g17713 i0 66.7 1.65483870967742 45 15 43.5 0 1 135 70 114 MBX3306497.1 helix-turn-helix domain-containing protein [Nitrospira sp.] diamond 513 72.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31192539 31192539 PRJNA888821_P_NODE_33055_length_257_cov_6.206522_g32972_i0 PRJNA888821 33055 257 6.206522 15.95076154 Nitrospira sp. 70125 Bacteria Bacteria 161 1.04e-44   NR MBL8051779.1 70125 g32972 i0 96.5 1.98443579766537 85 3 99.2 0 257 3 40 124 MBL8051779.1 sulfurtransferase TusA family protein [Nitrospira sp.] diamond 510 161 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31224377 31224377 PRJNA888821_P_NODE_35055_length_250_cov_5.361582_g34972_i0 PRJNA888821 35055 250 5.361582 13.403955 Nitrospira sp. 70125 Bacteria Bacteria 145 2.6e-39   NR MBM4128324.1 70125 g34972 i0 92.8 0.996 83 6 99.6 0 2 250 152 234 MBM4128324.1 anthranilate synthase component I [Nitrospira sp.] diamond 249 145 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31351166 31351166 PRJNA888821_P_NODE_41596_length_233_cov_6.006250_g41513_i0 PRJNA888821 41596 233 6.00625 13.9945625 Nitrospira sp. 70125 Bacteria Bacteria 159 2.3299999999999997e-46   NR MBH0192795.1 70125 g41513 i0 100 0.991416309012876 77 0 99.1 0 3 233 99 175 MBH0192795.1 dihydroorotate oxidase [Nitrospira sp.] diamond 231 159 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31730491 31730491 PRJNA888821_P_NODE_28617_length_276_cov_3.428571_g28535_i0 PRJNA888821 28617 276 3.428571 9.46285596 Nitrospira sp. 70125 Bacteria Bacteria 190 1.9999999999999993e-58   NR MBH0192707.1 70125 g28535 i0 96.7 1 92 3 100 0 1 276 190 281 MBH0192707.1 hypothetical protein [Nitrospira sp.] diamond 276 190 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32402966 32402966 PRJNA888821_P_NODE_10699_length_310_cov_10.286920_g10617_i0 PRJNA888821 10699 310 10.28692 31.889452 Nitrospira 1234 Bacteria Bacteria 108 6.2600000000000005e-27   NR HAN90743.1 70125 g10617 i0 55.3 8.97096774193548 103 41 99.7 1 310 2 5 102 HAN90743.1 hypothetical protein [Nitrospira sp.] diamond 2781 109 0.990825688073395 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32647412 32647412 PRJNA888821_P_NODE_37260_length_245_cov_11.674419_g37177_i0 PRJNA888821 37260 245 11.674419 28.60232655 Nitrospira sp. 70125 Bacteria Bacteria 63.2 2.08e-10   NR HEX6727405.1 70125 g37177 i0 68.3 1.00408163265306 41 13 50.2 0 125 3 79 119 HEX6727405.1 cupredoxin domain-containing protein [Nitrospira sp.] diamond 246 63.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32678965 32678965 PRJNA888821_P_NODE_47680_length_212_cov_11.690647_g47597_i0 PRJNA888821 47680 212 11.690647 24.78417164 Nitrospira sp. 70125 Bacteria Bacteria 50.4 1.7e-6   NR MDH5670145.1 70125 g47597 i0 70 0.424528301886792 30 9 42.5 0 91 2 1 30 MDH5670145.1 hypothetical protein [Nitrospira sp.] diamond 90 50.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.

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