RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA734348" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 15 ✖

bioproject 1

  • PRJNA734348 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
718399 718399 PRJNA734348_P_NODE_50661_length_289_cov_1.865741_g49964_i0 PRJNA734348 50661 289 1.865741 5.39199149 Halococcus dombrowskii 179637 Archaea Archaea 451 2.26e-122   NTclustered gi|2221492933|gb|CP095007.1| 179637 g49964 i0 94.81 162.124567474048 289 15 100 0 1 289 130071 129783 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 46854 451 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
1197124 1197124 PRJNA734348_P_NODE_31541_length_346_cov_2.868132_g30845_i0 PRJNA734348 31541 346 2.868132 9.92373672 Halococcus 2249 Archaea Archaea 632 9.199999999999996e-177   NTclustered gi|1476493975|gb|MH910955.1| 29286 g30845 i0 99.71 98.5693641618497 345 1 99 0 1 345 38 382 Halococcus sp. strain IIIV-5B 16S ribosomal RNA gene, partial sequence blastn 34105 638 0.990595611285266 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus sp.
1993403 1993403 PRJNA734348_P_NODE_135562_length_239_cov_2.493976_g134864_i0 PRJNA734348 135562 239 2.493976 5.96060264 Salinarchaeum sp. Harcht-Bsk1 1333523 Archaea Archaea 137 5.77e-28   NTclustered gi|507914357|gb|CP005962.1| 1333523 g134864 i0 79.602 7.33891213389121 201 33 82 7 15 211 266907 266711 Salinarchaeum sp. Harcht-Bsk1, complete genome blastn 1754 137 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronoarchaeaceae Salinarchaeum Salinarchaeum sp. Harcht-Bsk1
5025033 5025033 PRJNA734348_P_NODE_100784_length_249_cov_0.875000_g100086_i0 PRJNA734348 100784 249 0.875 2.17875 Methanothrix 2222 Archaea Archaea 460 3.16e-125   NTclustered gi|507148322|ref|NR_103125.1| 2223 g100086 i0 100 61.4538152610442 249 0 100 0 1 249 2452 2204 Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence blastn 15302 460 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii
7096160 7096160 PRJNA734348_P_NODE_143306_length_227_cov_3.948052_g142608_i0 PRJNA734348 143306 227 3.948052 8.96207804 Methanothermococcus okinawensis 155863 Archaea Archaea 52.8 0.02   NTclustered gi|334855522|gb|CP002792.1| 647113 g142608 i0 100 0.123348017621145 28 0 12 0 161 188 1488480 1488453 Methanothermococcus okinawensis IH1, complete genome blastn 28 52.8 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanococcaceae Methanothermococcus Methanothermococcus okinawensis
7097137 7097137 PRJNA734348_P_NODE_52946_length_287_cov_1.266355_g52249_i0 PRJNA734348 52946 287 1.266355 3.63443885 Methanothrix soehngenii 2223 Archaea Archaea 525 1.2999999999999995e-144   NTclustered gi|328927127|gb|CP002565.1| 990316 g52249 i0 99.652 122.222996515679 287 1 100 0 1 287 295789 296075 Methanosaeta concilii GP-6, complete genome blastn 35078 525 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii
9646161 9646161 PRJNA734348_P_NODE_18648_length_473_cov_1.742500_g17958_i0 PRJNA734348 18648 473 1.7425 8.242025 Halomicrococcus gelatinilyticus 1702103 Archaea Archaea 52.8 0.046   NTclustered gi|2270268908|gb|CP100465.1| 1702103 g17958 i0 100 0.0591966173361522 28 0 6 0 348 375 1726337 1726364 Halomicrococcus gelatinilyticus strain GSLN9 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Halomicrococcus Halomicrococcus gelatinilyticus
9646821 9646821 PRJNA734348_P_NODE_48868_length_291_cov_2.440367_g48171_i0 PRJNA734348 48868 291 2.440367 7.10146797 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 340 5.139999999999999e-89   NTclustered gi|985614202|gb|CP010834.1| 1609968 g48171 i0 88.014 1.00343642611684 292 29 99 5 4 291 1932371 1932082 Methanobrevibacter sp. YE315, complete genome blastn 292 340 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315
11400576 11400576 PRJNA734348_P_NODE_122909_length_243_cov_1.658824_g122211_i0 PRJNA734348 122909 243 1.658824 4.03094232 Halobacteriales 2235 Archaea Archaea 449 6.65e-122   NTclustered gi|407907317|gb|JX481744.1| 2250 g122211 i0 100 100.008230452675 243 0 100 0 1 243 1135 893 Halococcus morrhuae strain 123 16S ribosomal RNA gene, partial sequence blastn 24302 449 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus morrhuae
11400956 11400956 PRJNA734348_P_NODE_43609_length_305_cov_1.560345_g42912_i0 PRJNA734348 43609 305 1.560345 4.75905225 Halobacteriales 2235 Archaea Archaea 520 6.479999999999999e-143   NTclustered gi|2457522955|gb|OQ621510.1| 2243 g42912 i0 97.377 99.9344262295082 305 8 100 0 1 305 507 811 Halobacterium sp. strain J-93 16S ribosomal RNA gene, partial sequence blastn 30480 525 0.990476190476191 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium sp.
12676812 12676812 PRJNA734348_P_NODE_3330_length_1505_cov_5.321229_g3009_i0 PRJNA734348 3330 1505 5.321229 80.08449645 Halococcus 2249 Archaea Archaea 2193 0   NTclustered gi|2221492933|gb|CP095007.1| 179637 g3009 i0 92.961 151.397342192691 1520 84 99 11 1 1500 128201 129717 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 227853 2193 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
14746109 14746109 PRJNA734348_P_NODE_124712_length_243_cov_0.905882_g124014_i0 PRJNA734348 124712 243 0.905882 2.20129326 Halococcus qingdaonensis 224402 Archaea Archaea 322 1.51e-83   NTclustered gi|2281256326|gb|CP101943.1| 224402 g124014 i0 90.535 61.9876543209877 243 23 100 0 1 243 10413 10655 Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome blastn 15063 322 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus qingdaonensis
18570760 18570760 PRJNA734348_P_NODE_81855_length_259_cov_1.586022_g81157_i0 PRJNA734348 81855 259 1.586022 4.10779698 Natronomonas salina 1710540 Archaea Archaea 403 5.65e-108   NTclustered gi|1865519430|gb|CP058335.1| 1710540 g81157 i0 95.276 5.61389961389961 254 12 98 0 3 256 1358990 1359243 Natronomonas salina strain YPL13 chromosome, complete genome blastn 1454 403 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas salina
21121616 21121616 PRJNA734348_P_NODE_8637_length_828_cov_3.667550_g3009_i2 PRJNA734348 8637 828 3.66755 30.367314 Halococcus dombrowskii 179637 Archaea Archaea 1323 0   NTclustered gi|2221492933|gb|CP095007.1| 179637 g3009 i2 96.178 161.462560386473 811 27 98 2 16 823 128908 129717 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 133691 1323 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
23671148 23671148 PRJNA734348_P_NODE_3559_length_1451_cov_5.145864_g3009_i1 PRJNA734348 3559 1451 5.145864 74.66648664 Halococcus dombrowskii 179637 Archaea Archaea 2143 0   NTclustered gi|2221492933|gb|CP095007.1| 179637 g3009 i1 93.398 158.026878015162 1454 84 99 9 1 1446 128268 129717 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 229297 2143 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii

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