RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA605033 · 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
1857669 1857669 PRJNA605033_P_NODE_165622_length_183_cov_1.229730_g164053_i0 PRJNA605033 165622 183 1.22973 2.2504059 Methanobacteriota archaeon 2026739 Archaea Archaea 67.6 5.57e-7   NTclustered gi|2108123351|gb|CP070732.1| 2026739 g164053 i0 100 4.11475409836066 36 0 20 0 6 41 1649628 1649593 MAG: Methanobacteriota archaeon isolate bin41 chromosome blastn 753 67.6 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
3697509 3697509 PRJNA605033_P_NODE_88623_length_222_cov_2.219251_g87054_i0 PRJNA605033 88623 222 2.219251 4.92673722 Halobacteriales 2235 Archaea Archaea 111 3.2e-20   NTclustered gi|299123054|gb|CP002062.1| 795797 g87054 i0 95.652 1.52702702702703 69 3 31 0 1 69 1318414 1318482 Halalkalicoccus jeotgali B3, complete genome blastn 339 111 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus jeotgali
5685980 5685980 PRJNA605033_P_NODE_210365_length_162_cov_1.259843_g208796_i0 PRJNA605033 210365 162 1.259843 2.04094566 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 291 2.62e-74   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g208796 i0 99.375 74.9012345679012 160 1 99 0 1 160 293826 293667 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 12134 291 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
6248501 6248501 PRJNA605033_P_NODE_143525_length_200_cov_2.896970_g141956_i0 PRJNA605033 143525 200 2.89697 5.79394 Thermoproteati 1783275 Archaea Archaea 364 1.96e-96   NTclustered gi|22797874|emb|AJ496176.1| 29281 g141956 i0 99.5 34.305 200 1 100 0 1 200 7350 7151 Uncultured crenarchaeote 34 kb genomic fragment blastn 6861 364 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
10074371 10074371 PRJNA605033_P_NODE_66048_length_222_cov_3.737968_g64479_i0 PRJNA605033 66048 222 3.737968 8.29828896 Halorubrum 56688 Archaea Archaea 52.8 0.02   NTclustered gi|1540603140|gb|CP030064.1| 634157 g64479 i0 100 0.252252252252252 28 0 13 0 160 187 2695383 2695356 Halorubrum sp. PV6 chromosome, complete genome blastn 56 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. PV6
14611210 14611210 PRJNA605033_P_NODE_216112_length_160_cov_1.136000_g214543_i0 PRJNA605033 216112 160 1.136 1.8176 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 228 2.0499999999999995e-55   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g214543 i0 92.073 49.65 164 9 100 2 1 160 1789672 1789509 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 7944 228 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
14611394 14611394 PRJNA605033_P_NODE_234792_length_154_cov_1.000000_g233223_i0 PRJNA605033 234792 154 1 1.54 uncultured archaeon 115547 Archaea Archaea 224 2.5299999999999994e-54   NTclustered gi|388254672|gb|JQ768092.1| 115547 g233223 i0 92.857 52.0779220779221 154 11 100 0 1 154 27982 27829 Uncultured archaeon clone 02j05, complete sequence blastn 8020 224 1 Archaea               uncultured archaeon
20983543 20983543 PRJNA605033_P_NODE_113997_length_222_cov_1.727273_g112428_i0 PRJNA605033 113997 222 1.727273 3.83454606 Halorubrum ezzemoulense 337243 Archaea Archaea 56.5 0.002   NTclustered gi|1565814486|gb|CP034940.1| 337243 g112428 i0 96.97 0.148648648648649 33 1 15 0 188 220 2855919 2855951 Halorubrum ezzemoulense strain Fb21 chromosome, complete genome blastn 33 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum ezzemoulense
22260332 22260332 PRJNA605033_P_NODE_93758_length_222_cov_2.096257_g92189_i0 PRJNA605033 93758 222 2.096257 4.65369054 Haloplanus aerogenes 660522 Archaea Archaea 102 1.93e-17   NTclustered gi|1526250537|gb|CP034145.1| 660522 g92189 i0 91.781 0.657657657657658 73 6 33 0 3 75 1832118 1832046 Haloplanus aerogenes strain JCM 16430 chromosome, complete genome blastn 146 102 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus aerogenes
24809379 24809379 PRJNA605033_P_NODE_72540_length_222_cov_2.914439_g70971_i0 PRJNA605033 72540 222 2.914439 6.47005458 Halalkalicoccus salilacus 3117459 Archaea Archaea 110 1.15e-19   NTclustered gi|2674869203|gb|CP144461.1| 3117459 g70971 i0 93.243 5.26576576576577 74 5 33 0 1 74 620372 620445 Halalkalicoccus salilacus strain FCH27 chromosome, complete genome blastn 1169 110 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus salilacus

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