RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA493632" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493632 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
1101755 1101755 PRJNA493632_P_NODE_299861_length_295_cov_9.180180_g296423_i0 PRJNA493632 299861 295 9.18018 27.081531 root 1 Root_unresolved Root_unresolved 470 6.379999999999998e-128   NTclustered gi|338970373|gb|HQ316973.2| 29281 g296423 i0 96.233 98.9796610169492 292 2 96 1 7 289 718 427 Uncultured crenarchaeote clone REF_D_4 16S ribosomal RNA gene, partial sequence blastn 29199 470 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
1740762 1740762 PRJNA493632_P_NODE_547342_length_248_cov_1.971429_g543903_i0 PRJNA493632 547342 248 1.971429 4.88914392 Sulfolobus acidocaldarius 2285 Archaea Archaea 54.7 0.006   NTclustered gi|969872653|gb|CP013694.1| 2285 g543903 i0 94.118 0.25 34 2 14 0 166 199 959058 959025 Sulfolobus acidocaldarius strain GG12-C01-09 chromosome blastn 62 54.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
4929813 4929813 PRJNA493632_P_NODE_284484_length_302_cov_3.170306_g281048_i0 PRJNA493632 284484 302 3.170306 9.57432412 root 1 Root_unresolved Root_unresolved 78.7 4.64e-10   NTclustered gi|969872653|gb|CP013694.1| 2285 g281048 i0 97.727 39.1258278145695 44 1 15 0 257 300 1789827 1789784 Sulfolobus acidocaldarius strain GG12-C01-09 chromosome blastn 11816 78.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
6841879 6841879 PRJNA493632_P_NODE_460166_length_260_cov_1.267380_g456727_i0 PRJNA493632 460166 260 1.26738 3.295188 Sulfolobus acidocaldarius 2285 Archaea Archaea 52.8 0.024   NTclustered gi|969872653|gb|CP013694.1| 2285 g456727 i0 100 0.107692307692308 28 0 11 0 65 92 279905 279878 Sulfolobus acidocaldarius strain GG12-C01-09 chromosome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
10029790 10029790 PRJNA493632_P_NODE_262288_length_310_cov_3.388186_g258852_i0 PRJNA493632 262288 310 3.388186 10.5033766 root 1 Root_unresolved Root_unresolved 52.8 0.029   NTclustered gi|969872653|gb|CP013694.1| 2285 g258852 i0 100 0.180645161290323 28 0 9 0 188 215 74657 74630 Sulfolobus acidocaldarius strain GG12-C01-09 chromosome blastn 56 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
10664445 10664445 PRJNA493632_P_NODE_264389_length_310_cov_2.924051_g260953_i0 PRJNA493632 264389 310 2.924051 9.0645581 Sulfolobus acidocaldarius 2285 Archaea Archaea 87.9 7.94e-13   NTclustered gi|969872653|gb|CP013694.1| 2285 g260953 i0 97.959 38.7387096774194 49 1 16 0 20 68 1789836 1789788 Sulfolobus acidocaldarius strain GG12-C01-09 chromosome blastn 12009 87.9 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
11937086 11937086 PRJNA493632_P_NODE_134110_length_403_cov_14.548485_g130693_i0 PRJNA493632 134110 403 14.548485 58.63039455 Pyrobaculum islandicum 2277 Archaea Archaea 58.4 8.31e-4   NTclustered gi|294441|gb|L07511.1|PYBRGDY 2277 g130693 i0 100 1.98014888337469 31 0 8 0 192 222 227 197 Pyrobaculum islandicum 16S ribosomal RNA gene blastn 798 58.4 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum islandicum
14494434 14494434 PRJNA493632_P_NODE_54472_length_584_cov_1.663405_g51213_i0 PRJNA493632 54472 584 1.663405 9.7142852 Sulfolobus acidocaldarius 2285 Archaea Archaea 87.9 1.58e-12   NTclustered gi|969872653|gb|CP013694.1| 2285 g51213 i0 97.959 41.0736301369863 49 1 18 0 327 375 1789836 1789788 Sulfolobus acidocaldarius strain GG12-C01-09 chromosome blastn 23987 87.9 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
15131178 15131178 PRJNA493632_P_NODE_520092_length_250_cov_1.451977_g516653_i0 PRJNA493632 520092 250 1.451977 3.6299425 root 1 Root_unresolved Root_unresolved 52.8 0.023   NTclustered gi|969872653|gb|CP013694.1| 2285 g516653 i0 96.667 0.456 30 1 12 0 1 30 1789813 1789784 Sulfolobus acidocaldarius strain GG12-C01-09 chromosome blastn 114 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
16404361 16404361 PRJNA493632_P_NODE_302573_length_294_cov_7.063348_g299135_i0 PRJNA493632 302573 294 7.063348 20.76624312 root 1 Root_unresolved Root_unresolved 442 1.3899999999999998e-119   NTclustered gi|584613379|emb|HG931415.1| 29281 g299135 i0 94.521 99.3061224489796 292 7 96 1 7 289 122 413 Uncultured crenarchaeote partial 16S rRNA gene, clone 1G3_S32 blastn 29196 442 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
17042908 17042908 PRJNA493632_P_NODE_534454_length_249_cov_1.545455_g531015_i0 PRJNA493632 534454 249 1.545455 3.84818295 Sulfolobus acidocaldarius 2285 Archaea Archaea 52.8 0.023   NTclustered gi|969874815|gb|CP013695.1| 2285 g531015 i0 100 0.112449799196787 28 0 11 0 197 224 44 17 Sulfolobus acidocaldarius strain NG05B_CO5_07 chromosome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
17679219 17679219 PRJNA493632_P_NODE_259174_length_310_cov_5.717300_g255738_i0 PRJNA493632 259174 310 5.7173 17.72363 root 1 Root_unresolved Root_unresolved 278 4.39e-70   NTclustered gi|196122286|gb|EU888340.1| 29281 g255738 i0 100 97.9741935483871 150 0 97 0 1 150 986 837 Uncultured crenarchaeote clone B6 16S ribosomal RNA gene, partial sequence blastn 30372 278 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
20229923 20229923 PRJNA493632_P_NODE_576076_length_246_cov_2.300578_g572635_i0 PRJNA493632 576076 246 2.300578 5.65942188 root 1 Root_unresolved Root_unresolved 80.5 1.02e-10   NTclustered gi|969872653|gb|CP013694.1| 2285 g572635 i0 97.778 48.4308943089431 45 1 18 0 35 79 1789785 1789829 Sulfolobus acidocaldarius strain GG12-C01-09 chromosome blastn 11914 80.5 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
20865819 20865819 PRJNA493632_P_NODE_449857_length_262_cov_1.306878_g446418_i0 PRJNA493632 449857 262 1.306878 3.42402036 Sulfolobus acidocaldarius 2285 Archaea Archaea 84.2 8.48e-12   NTclustered gi|969872653|gb|CP013694.1| 2285 g446418 i0 97.872 45.5687022900763 47 1 18 0 127 173 1789832 1789786 Sulfolobus acidocaldarius strain GG12-C01-09 chromosome blastn 11939 84.2 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
24690148 24690148 PRJNA493632_P_NODE_457420_length_260_cov_2.433155_g453981_i0 PRJNA493632 457420 260 2.433155 6.326203 Sulfolobus acidocaldarius 2285 Archaea Archaea 84.2 8.4e-12   NTclustered gi|969872653|gb|CP013694.1| 2285 g453981 i0 96.078 45.3384615384615 51 1 20 1 94 144 1789832 1789783 Sulfolobus acidocaldarius strain GG12-C01-09 chromosome blastn 11788 84.2 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius

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