RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1035005" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 10 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA1035005 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
1443875 1443875 PRJNA1035005_P_NODE_84202_length_242_cov_1.757396_g83796_i0 PRJNA1035005 84202 242 1.757396 4.25289832 Natronomonas moolapensis 416273 Archaea Archaea 195 3.42e-45   NTclustered gi|452081962|emb|HF582854.1| 268739 g83796 i0 81.624 1.89669421487603 234 43 97 0 9 242 470106 469873 Natronomonas moolapensis 8.8.11 complete genome blastn 459 195 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas moolapensis
6111068 6111068 PRJNA1035005_P_NODE_5545_length_451_cov_2.637566_g5145_i0 PRJNA1035005 5545 451 2.637566 11.89542266 Halobacteriales 2235 Archaea Archaea 828 0   NTclustered gi|927785581|gb|KT216165.1| 115547 g5145 i0 99.778 100.937915742794 451 1 100 0 1 451 888 438 Uncultured archaeon clone B203 16S ribosomal RNA gene, partial sequence blastn 45523 833 0.993997599039616 Archaea               uncultured archaeon
9936056 9936056 PRJNA1035005_P_NODE_7068_length_408_cov_3.495522_g6666_i0 PRJNA1035005 7068 408 3.495522 14.26172976 Halalkalicoccus 332246 Archaea Archaea 747 0   NTclustered gi|254971262|ref|NR_028180.1| 175632 g6666 i0 99.754 104.18137254902 407 1 99 0 2 408 1451 1045 Halalkalicoccus tibetensis strain DS12 16S ribosomal RNA, complete sequence blastn 42506 747 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus tibetensis
12486685 12486685 PRJNA1035005_P_NODE_32970_length_278_cov_6.082927_g32564_i0 PRJNA1035005 32970 278 6.082927 16.91053706 Halalkalicoccus 332246 Archaea Archaea 508 1.26e-139   NTclustered gi|507148368|ref|NR_103171.1| 413810 g32564 i0 99.64 154.978417266187 278 1 100 0 1 278 2906 2629 Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence blastn 43084 508 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus jeotgali
14197551 14197551 PRJNA1035005_P_NODE_47732_length_260_cov_1.181818_g47326_i0 PRJNA1035005 47732 260 1.181818 3.0727268 Natrinema caseinilyticum 2961570 Archaea Archaea 289 1.66e-73   NTclustered gi|2270264148|gb|CP100445.1| 2961570 g47326 i0 86.822 15.3461538461538 258 34 99 0 3 260 198465 198208 Natrinema caseinilyticum strain ZJ2 chromosome, complete genome blastn 3990 289 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natrinema Natrinema caseinilyticum
15035429 15035429 PRJNA1035005_P_NODE_16512_length_314_cov_2.062241_g16106_i0 PRJNA1035005 16512 314 2.062241 6.47543674 Halobacteriales 2235 Archaea Archaea 569 6.559999999999998e-158   NTclustered gi|332042379|gb|JF518815.1| 115547 g16106 i0 99.363 102.37898089172 314 2 100 0 1 314 362 49 Uncultured archaeon clone BY1_13c2b_A081 16S ribosomal RNA gene, partial sequence blastn 32147 569 1 Archaea               uncultured archaeon
20134326 20134326 PRJNA1035005_P_NODE_7116_length_407_cov_3.074850_g6714_i0 PRJNA1035005 7116 407 3.07485 12.5146395 Halalkalicoccus 332246 Archaea Archaea 691 0   NTclustered gi|507148368|ref|NR_103171.1| 413810 g6714 i0 97.297 195.277641277641 407 11 100 0 1 407 2624 2218 Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence blastn 79478 691 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus jeotgali
21409920 21409920 PRJNA1035005_P_NODE_557_length_2097_cov_3.277668_g433_i0 PRJNA1035005 557 2097 3.277668 68.73269796 Halalkalicoccus 332246 Archaea Archaea 3474 0   NTclustered gi|507148368|ref|NR_103171.1| 413810 g433 i0 96.567 160.995231282785 2097 72 100 0 1 2097 2124 28 Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence blastn 337607 3474 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus jeotgali
21845824 21845824 PRJNA1035005_P_NODE_47538_length_260_cov_1.443850_g47132_i0 PRJNA1035005 47538 260 1.44385 3.75401 Halanaeroarchaeum sp. HSR-CO 2866382 Archaea Archaea 303 5.92e-78   NTclustered gi|2295222443|gb|CP087724.1| 2866382 g47132 i0 87.938 2.43846153846154 257 31 99 0 1 257 918847 918591 Halanaeroarchaeum sp. HSR-CO chromosome, complete genome blastn 634 303 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halanaeroarchaeum Halanaeroarchaeum sp. HSR-CO
24394770 24394770 PRJNA1035005_P_NODE_19940_length_300_cov_3.176211_g19534_i0 PRJNA1035005 19940 300 3.176211 9.528633 Methanosphaera sp. ISO3-F5 1452353 Archaea Archaea 388 1.87e-103   NTclustered gi|2695672494|gb|CP118753.2| 1452353 g19534 i0 90 1.89 300 30 100 0 1 300 1727654 1727953 Methanosphaera sp. ISO3-F5 chromosome, complete genome blastn 567 388 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp. ISO3-F5

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