RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA594101" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 5 ✖

bioproject 1

  • PRJNA594101 · 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
8220114 8220114 PRJNA594101_S_NODE_12467_length_467_cov_1.758883_g12165_i0 PRJNA594101 12467 467 1.758883 8.21398361 Halorarius litoreus 2962676 Archaea Archaea 52.8 0.045   NTclustered gi|2274417429|gb|CP101454.1| 2962676 g12165 i0 100 0.0599571734475375 28 0 6 0 7 34 2612466 2612493 Halorarius litoreus strain BND22 chromosome, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halorarius Halorarius litoreus
9495626 9495626 PRJNA594101_S_NODE_53328_length_246_cov_0.890173_g53026_i0 PRJNA594101 53328 246 0.890173 2.18982558 Haloferacaceae archaeon 50 3384156 Archaea Archaea 52.8 0.022   NTclustered gi|2869714876|gb|CP175567.1| 3384156 g53026 i0 96.774 0.126016260162602 31 1 13 0 132 162 69124 69154 Haloferacaceae archaeon 50 chromosome, complete genome blastn 31 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae   Haloferacaceae archaeon 50
10771454 10771454 PRJNA594101_S_NODE_4669_length_748_cov_6.591111_g4258_i1 PRJNA594101 4669 748 6.591111 49.30151028 Methanolobus sp. WCC4 3125784 Archaea Archaea 60.2 4.48e-4   NTclustered gi|2713784040|gb|CP150629.1| 3125784 g4258 i1 97.143 0.0467914438502674 35 1 5 0 7 41 239171 239137 Methanolobus sp. WCC4 chromosome, complete genome blastn 35 60.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanolobus Methanolobus sp. WCC4
12046279 12046279 PRJNA594101_S_NODE_4530_length_758_cov_5.854015_g4258_i0 PRJNA594101 4530 758 5.854015 44.3734337 Methanolobus sp. WCC4 3125784 Archaea Archaea 60.2 4.54e-4   NTclustered gi|2713784040|gb|CP150629.1| 3125784 g4258 i0 97.143 0.0461741424802111 35 1 5 0 718 752 239137 239171 Methanolobus sp. WCC4 chromosome, complete genome blastn 35 60.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanolobus Methanolobus sp. WCC4
13321015 13321015 PRJNA594101_S_NODE_29151_length_316_cov_1.588477_g28849_i0 PRJNA594101 29151 316 1.588477 5.01958732 Haloferacaceae archaeon 50 3384156 Archaea Archaea 86.1 2.92e-12   NTclustered gi|2869714876|gb|CP175567.1| 3384156 g28849 i0 93.103 3.21518987341772 58 4 18 0 71 128 1968987 1969044 Haloferacaceae archaeon 50 chromosome, complete genome blastn 1016 86.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae   Haloferacaceae archaeon 50

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