RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1148190 · 30 ✖

analysis 1

  • blastn · 30 ✖

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
1571942 1571942 PRJNA1148190_P_NODE_561222_length_255_cov_1.269231_g550049_i0 PRJNA1148190 561222 255 1.269231 3.23653905 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 407 4.29e-109   NTclustered gi|663500052|gb|KF900324.1| 1455887 g550049 i0 95.652 0.992156862745098 253 11 99 0 1 253 30850 30598 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 253 407 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
2309620 2309620 PRJNA1148190_P_NODE_223702_length_359_cov_1.353147_g212532_i0 PRJNA1148190 223702 359 1.353147 4.85779773 Nitrososphaeraceae 1033997 Archaea Archaea 505 2.169999999999999e-138   NTclustered gi|300521484|gb|GU797787.1| 497727 g212532 i0 92.201 140.142061281337 359 25 99 3 3 359 1005 1362 Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence blastn 50311 508 0.99409448818897606 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis
2311783 2311783 PRJNA1148190_P_NODE_95062_length_550_cov_2.025157_g83914_i0 PRJNA1148190 95062 550 2.025157 11.1383635 Archaea 2157 Archaea Archaea 63.9 2.5e-5   NTclustered gi|663515405|gb|KF900753.1| 1456074 g83914 i0 95 0.14 40 2 7 0 487 526 7315 7276 Uncultured marine thaumarchaeote KM3_188_F10 genomic sequence blastn 77 63.9 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote KM3_188_F10
2850547 2850547 PRJNA1148190_P_NODE_742763_length_243_cov_0.905882_g731590_i0 PRJNA1148190 742763 243 0.905882 2.20129326 Nitrosotalea devaniterrae 1078905 Archaea Archaea 52.8 0.022   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g731590 i0 100 0.11522633744856 28 0 12 0 136 163 1803783 1803756 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 28 52.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
2851313 2851313 PRJNA1148190_P_NODE_80363_length_610_cov_1.651769_g69238_i0 PRJNA1148190 80363 610 1.651769 10.0757909 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 761 0   NTclustered gi|663500052|gb|KF900324.1| 1455887 g69238 i0 95.949 0.975409836065574 469 19 98 0 1 469 23946 24414 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 595 761 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
4119432 4119432 PRJNA1148190_P_NODE_220864_length_361_cov_1.291667_g209694_i0 PRJNA1148190 220864 361 1.291667 4.66291787 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 320 8.5e-83   NTclustered gi|663500052|gb|KF900324.1| 1455887 g209694 i0 83.056 0.997229916897507 360 54 99 5 1 359 38559 38912 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 360 320 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
5394948 5394948 PRJNA1148190_P_NODE_179325_length_395_cov_1.102484_g168156_i0 PRJNA1148190 179325 395 1.102484 4.3548118 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 630 3.819999999999999e-176   NTclustered gi|663500052|gb|KF900324.1| 1455887 g168156 i0 95.443 1 395 18 100 0 1 395 38709 38315 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 395 630 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
7413836 7413836 PRJNA1148190_P_NODE_649266_length_248_cov_0.880000_g638093_i0 PRJNA1148190 649266 248 0.88 2.1824 Nitrososphaera 497726 Archaea Archaea 241 4.46e-59   NTclustered gi|647810480|gb|CP007536.1| 926571 g638093 i0 85.106 7.1008064516129 235 35 95 0 9 243 1465704 1465938 Nitrososphaera viennensis EN76, complete genome blastn 1761 241 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera viennensis
9220448 9220448 PRJNA1148190_P_NODE_215908_length_364_cov_2.010309_g204738_i0 PRJNA1148190 215908 364 2.010309 7.31752476 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 351 3.04e-92   NTclustered gi|663500052|gb|KF900324.1| 1455887 g204738 i0 94.69 1.02747252747253 226 12 100 0 1 226 22775 23000 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 374 351 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
10499870 10499870 PRJNA1148190_P_NODE_470689_length_272_cov_1.547739_g459516_i0 PRJNA1148190 470689 272 1.547739 4.20985008 Nitrosopumilus cobalaminigenes 1470066 Archaea Archaea 56.5 0.002   NTclustered gi|1869221159|gb|CP026993.1| 1470066 g459516 i0 97.059 0.125 34 0 13 1 123 156 136415 136383 Nitrosopumilus cobalaminigenes strain HCA1 chromosome, complete genome blastn 34 56.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus cobalaminigenes
11774892 11774892 PRJNA1148190_P_NODE_473910_length_272_cov_1.000000_g462737_i0 PRJNA1148190 473910 272 1 2.72 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 156 1.85e-33   NTclustered gi|663500052|gb|KF900324.1| 1455887 g462737 i0 78.327 0.966911764705882 263 42 93 11 1 254 32149 31893 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 263 156 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
14320792 14320792 PRJNA1148190_P_NODE_187392_length_387_cov_1.471338_g176223_i0 PRJNA1148190 187392 387 1.471338 5.69407806 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 588 2.2799999999999998e-163   NTclustered gi|663500052|gb|KF900324.1| 1455887 g176223 i0 94.057 1 387 23 100 0 1 387 31236 31622 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 387 588 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
14321414 14321414 PRJNA1148190_P_NODE_224912_length_358_cov_1.603509_g213742_i0 PRJNA1148190 224912 358 1.603509 5.74056222 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 520 7.729999999999998e-143   NTclustered gi|663500052|gb|KF900324.1| 1455887 g213742 i0 92.778 1.0055865921787699 360 24 100 1 1 358 29455 29096 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 360 520 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
14328835 14328835 PRJNA1148190_P_NODE_755892_length_242_cov_1.366864_g744719_i0 PRJNA1148190 755892 242 1.366864 3.30781088 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 412 8.68e-111   NTclustered gi|663500052|gb|KF900324.1| 1455887 g744719 i0 97.51 0.995867768595041 241 6 99 0 1 241 41226 41466 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 241 412 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
15600273 15600273 PRJNA1148190_P_NODE_56353_length_776_cov_2.086771_g45428_i0 PRJNA1148190 56353 776 2.086771 16.19334296 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 1179 0   NTclustered gi|663500052|gb|KF900324.1| 1455887 g45428 i0 94.072 1 776 46 100 0 1 776 21502 22277 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 776 1179 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
18145411 18145411 PRJNA1148190_P_NODE_300235_length_320_cov_0.931174_g289062_i0 PRJNA1148190 300235 320 0.931174 2.9797568 Nitrosopumilus oxyclinae 1959104 Archaea Archaea 52.8 0.03   NTclustered gi|1869222960|gb|CP026994.1| 1959104 g289062 i0 100 0.0875 28 0 9 0 13 40 710715 710688 Nitrosopumilus oxyclinae strain HCE1 chromosome, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus oxyclinae
19417923 19417923 PRJNA1148190_P_NODE_183376_length_391_cov_1.267296_g172207_i0 PRJNA1148190 183376 391 1.267296 4.95512736 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 265 4.41e-66   NTclustered gi|663500052|gb|KF900324.1| 1455887 g172207 i0 81.62 0.820971867007673 321 57 82 2 68 387 22355 22674 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 321 265 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
19419015 19419015 PRJNA1148190_P_NODE_249776_length_343_cov_2.162963_g238606_i0 PRJNA1148190 249776 343 2.162963 7.41896309 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 534 2.64e-147   NTclustered gi|663500052|gb|KF900324.1| 1455887 g238606 i0 94.752 1 343 18 100 0 1 343 30000 30342 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 343 534 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
19425322 19425322 PRJNA1148190_P_NODE_702156_length_245_cov_0.895349_g690983_i0 PRJNA1148190 702156 245 0.895349 2.19360505 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 195 3.47e-45   NTclustered gi|937513727|gb|CP012850.1| 1353260 g690983 i0 81.25 1.89795918367347 240 45 98 0 6 245 1946820 1946581 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 465 195 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
20693692 20693692 PRJNA1148190_P_NODE_208057_length_370_cov_1.646465_g196887_i0 PRJNA1148190 208057 370 1.646465 6.0919205 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 547 3.679999999999999e-151   NTclustered gi|663500052|gb|KF900324.1| 1455887 g196887 i0 93.478 0.994594594594595 368 24 99 0 3 370 41905 42272 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 368 547 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
20699981 20699981 PRJNA1148190_P_NODE_650897_length_248_cov_0.880000_g639724_i0 PRJNA1148190 650897 248 0.88 2.1824 Nitrosopumilus sp. 2024843 Archaea Archaea 54.7 0.006   NTclustered gi|2621701204|emb|OY759726.1| 2024843 g639724 i0 100 0.116935483870968 29 0 12 0 54 82 586006 586034 MAG: Nitrosopumilus sp. isolate 673f8e26-873e-4515-b19f-a0e48533455e genome assembly, chromosome: 1 blastn 29 54.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
20700632 20700632 PRJNA1148190_P_NODE_702197_length_245_cov_0.895349_g691024_i0 PRJNA1148190 702197 245 0.895349 2.19360505 Nitrosopumilus piranensis 1582439 Archaea Archaea 204 5.77e-48   NTclustered gi|756791811|gb|CP010868.1| 1582439 g691024 i0 81.781 3.09795918367347 247 41 100 4 1 245 1356420 1356176 Nitrosopumilus piranensis strain D3C chromosome, complete genome blastn 759 204 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus piranensis
21968431 21968431 PRJNA1148190_P_NODE_170618_length_404_cov_1.163142_g159449_i0 PRJNA1148190 170618 404 1.163142 4.69909368 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 331 4.44e-86   NTclustered gi|663500052|gb|KF900324.1| 1455887 g159449 i0 86.622 0.74009900990099 299 40 74 0 106 404 21650 21352 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 299 331 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
21969360 21969360 PRJNA1148190_P_NODE_225778_length_358_cov_0.975439_g214608_i0 PRJNA1148190 225778 358 0.975439 3.49207162 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 584 2.7e-162   NTclustered gi|663500052|gb|KF900324.1| 1455887 g214608 i0 96.089 1 358 14 100 0 1 358 35605 35962 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 358 584 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
21970515 21970515 PRJNA1148190_P_NODE_303678_length_318_cov_1.526531_g292505_i0 PRJNA1148190 303678 318 1.526531 4.85436858 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 505 1.8999999999999995e-138   NTclustered gi|663500052|gb|KF900324.1| 1455887 g292505 i0 95.556 0.990566037735849 315 14 99 0 4 318 36669 36355 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 315 505 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
23242744 23242744 PRJNA1148190_P_NODE_103379_length_524_cov_2.254989_g92222_i0 PRJNA1148190 103379 524 2.254989 11.81614236 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 813 0   NTclustered gi|663500052|gb|KF900324.1| 1455887 g92222 i0 94.656 1.11450381679389 524 28 100 0 1 524 33658 33135 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 584 813 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
23245000 23245000 PRJNA1148190_P_NODE_238779_length_350_cov_0.960289_g227609_i0 PRJNA1148190 238779 350 0.960289 3.3610115 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 163 1.4599999999999998e-35   NTclustered gi|663500052|gb|KF900324.1| 1455887 g227609 i0 87.324 0.405714285714286 142 18 41 0 123 264 24264 24405 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 142 163 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
23247845 23247845 PRJNA1148190_P_NODE_42759_length_961_cov_1.751126_g32226_i0 PRJNA1148190 42759 961 1.751126 16.82832086 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 706 0   NTclustered gi|663500052|gb|KF900324.1| 1455887 g32226 i0 81.151 0.921956295525494 886 162 92 5 3 884 36210 35326 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 886 706 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
23252758 23252758 PRJNA1148190_P_NODE_81839_length_603_cov_1.475472_g70714_i0 PRJNA1148190 81839 603 1.475472 8.89709616 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 942 0   NTclustered gi|663500052|gb|KF900324.1| 1455887 g70714 i0 94.859 1 603 31 100 0 1 603 40500 39898 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 603 942 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06
24519741 24519741 PRJNA1148190_P_NODE_308780_length_316_cov_1.308642_g297607_i0 PRJNA1148190 308780 316 1.308642 4.13530872 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 512 1.13e-140   NTclustered gi|663500052|gb|KF900324.1| 1455887 g297607 i0 95.886 1.08860759493671 316 13 100 0 1 316 27351 27036 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 344 512 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06

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