RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA312899 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
378874 378874 PRJNA312899_P_NODE_100701_length_162_cov_0.884956_g100259_i0 PRJNA312899 100701 162 0.884956 1.43362872 Halococcus dombrowskii 179637 Archaea Archaea 158 2.78e-34   NTclustered gi|2221492933|gb|CP095007.1| 179637 g100259 i0 84.118 39.4876543209877 170 19 100 1 1 162 67812 67981 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 6397 158 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
4207534 4207534 PRJNA312899_P_NODE_88684_length_166_cov_0.871795_g88242_i0 PRJNA312899 88684 166 0.871795 1.4471797 Natrialba magadii 13769 Archaea Archaea 248 1.65e-61   NTclustered gi|289529249|gb|CP001932.1| 547559 g88242 i0 93.902 3.81927710843373 164 10 99 0 2 165 1343489 1343326 Natrialba magadii ATCC 43099, complete sequence blastn 634 248 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natrialba Natrialba magadii
9993282 9993282 PRJNA312899_P_NODE_93348_length_164_cov_1.756522_g92906_i0 PRJNA312899 93348 164 1.756522 2.88069608 Haloarcula 2237 Archaea Archaea 248 1.63e-61   NTclustered gi|1646147608|gb|CP039138.1| 272569 g92906 i0 93.902 6.95121951219512 164 10 100 0 1 164 2292949 2292786 Haloarcula marismortui ATCC 43049 chromosome, complete genome blastn 1140 250 0.992 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Haloarcula Haloarcula marismortui
11857984 11857984 PRJNA312899_P_NODE_30850_length_331_cov_10.932624_g30408_i0 PRJNA312899 30850 331 10.932624 36.18698544 Methanimicrococcus hongohii 3028295 Archaea Archaea 390 5.82e-104   NTclustered gi|2591774574|gb|CP131059.1| 3028295 g30408 i0 87.915 2 331 40 100 0 1 331 1988069 1988399 Methanimicrococcus hongohii strain Hf6 chromosome, complete genome blastn 662 390 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanimicrococcus Methanimicrococcus hongohii
15683122 15683122 PRJNA312899_P_NODE_95993_length_163_cov_1.789474_g95551_i0 PRJNA312899 95993 163 1.789474 2.91684262 Halobacterium sp. DL1 751944 Archaea Archaea 102 1.33e-17   NTclustered gi|573484043|gb|CP007060.1| 751944 g95551 i0 94.03 32.4969325153374 67 4 41 0 95 161 1085589 1085655 Halobacterium sp. DL1, complete genome blastn 5297 102 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium sp. DL1

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