RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA716463" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 15 ✖

bioproject 1

  • PRJNA716463 · 15 ✖

analysis 1

  • diamond · 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
17286710 17286710 PRJNA716463_P_NODE_88074_length_262_cov_1.629630_g87657_i0 PRJNA716463 88074 262 1.62963 4.2696306 archaeon 1906665 Archaea Archaea 150 5.76e-43   NR MDP2434791.1 1906665 g87657 i0 83.9 7.95801526717557 87 14 99.6 0 261 1 151 237 MDP2434791.1 NSA2 family ribosome biogenesis protein [archaeon] diamond 2085 150 1 Archaea               archaeon
21110993 21110993 PRJNA716463_P_NODE_71177_length_275_cov_2.693069_g70760_i0 PRJNA716463 71177 275 2.693069 7.40593975 Nitrososphaeria archaeon 2268198 Archaea Archaea 178 3.419999999999999e-54   NR NDB47524.1 2268198 g70760 i0 94.5 0.992727272727273 91 5 99.3 0 273 1 71 161 NDB47524.1 ABC transporter ATP-binding protein [Nitrososphaeria archaeon] diamond 273 178 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria       Nitrososphaeria archaeon
27241597 27241597 PRJNA716463_P_NODE_94263_length_256_cov_3.469945_g93846_i0 PRJNA716463 94263 256 3.469945 8.8830592 archaeon 1906665 Archaea Archaea 70.1 9.27e-12   NR MCQ2817599.1 1906665 g93846 i0 44 0.984375 84 45 96.1 2 7 252 256 339 MCQ2817599.1 hypothetical protein [archaeon] diamond 252 70.1 1 Archaea               archaeon
27715821 27715821 PRJNA716463_P_NODE_75004_length_272_cov_3.231156_g74587_i0 PRJNA716463 75004 272 3.231156 8.78874432 Methanothrix sp. 90426 Archaea Archaea 55.5 1.73e-6   NR TFH48370.1 90426 g74587 i0 43.1 0.716911764705882 65 35 71.7 1 260 66 88 150 TFH48370.1 MAG: hypothetical protein E4G89_06400 [Methanothrix sp.] diamond 195 55.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
27810313 27810313 PRJNA716463_P_NODE_105104_length_247_cov_1.758621_g104687_i0 PRJNA716463 105104 247 1.758621 4.34379387 Thermofilaceae archaeon 2268203 Archaea Archaea 184 9.02e-58   NR MEM2592530.1 2268203 g104687 i0 98.8 0.995951417004049 82 1 99.6 0 246 1 39 120 MEM2592530.1 DUF2750 domain-containing protein [Thermofilaceae archaeon] diamond 246 184 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermofilales Thermofilaceae   Thermofilaceae archaeon
28504751 28504751 PRJNA716463_P_NODE_41247_length_298_cov_2.631111_g40830_i0 PRJNA716463 41247 298 2.631111 7.84071078 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 76.3 1.1e-13   NR HKG87688.1 2169593 g40830 i0 68 2.50671140939597 50 16 50.3 0 293 144 357 406 HKG87688.1 PQQ-dependent sugar dehydrogenase [Nitrososphaeraceae archaeon] diamond 747 76.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28788774 28788774 PRJNA716463_P_NODE_85107_length_264_cov_3.099476_g84690_i0 PRJNA716463 85107 264 3.099476 8.1826166400000009 Nitrosopumilales archaeon 2026768 Archaea Archaea 169 5.58e-49   NR RPJ31745.1 2026768 g84690 i0 100 0.988636363636364 87 0 98.9 0 263 3 216 302 RPJ31745.1 MAG: adenosylhomocysteinase [Nitrosopumilales archaeon] diamond 261 169 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
29778118 29778118 PRJNA716463_P_NODE_42091_length_297_cov_3.191964_g41674_i0 PRJNA716463 42091 297 3.191964 9.48013308 root 1 Root_unresolved Root_unresolved 59.3 9.35e-8   NR WP_303346976.1 66852 g41674 i0 67.5 2.19191919191919 40 13 40.4 0 145 26 2 41 WP_303346976.1 DNA cytosine methyltransferase [Methanobrevibacter sp.] diamond 651 59.7 0.993299832495812 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
29862457 29862457 PRJNA716463_P_NODE_59031_length_284_cov_2.559242_g58614_i0 PRJNA716463 59031 284 2.559242 7.26824728 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 52 2.25e-6   NR GIU69039.1 2026803 g58614 i0 57.6 0.887323943661972 33 14 34.9 0 105 7 29 61 GIU69039.1 MAG: hypothetical protein KatS3mg002_0275 [Candidatus Woesearchaeota archaeon] diamond 252 52 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
29925786 29925786 PRJNA716463_P_NODE_21231_length_310_cov_3.485232_g20814_i0 PRJNA716463 21231 310 3.485232 10.8042192 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 48.9 4.77e-4   NR MBI3334363.1 2026773 g20814 i0 46.9 0.948387096774194 49 26 47.4 0 308 162 124 172 MBI3334363.1 hypothetical protein [Candidatus Pacearchaeota archaeon] diamond 294 48.9 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
30020595 30020595 PRJNA716463_P_NODE_54491_length_287_cov_3.341121_g54074_i0 PRJNA716463 54491 287 3.341121 9.58901727 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 66.2 3.12e-10   NR MFH1064255.1 2026803 g54074 i0 35.6 0.940766550522648 90 54 93 2 272 6 186 272 MFH1064255.1 hypothetical protein [Candidatus Woesearchaeota archaeon] diamond 270 66.2 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
30841989 30841989 PRJNA716463_P_NODE_49314_length_291_cov_2.064220_g48897_i0 PRJNA716463 49314 291 2.06422 6.0068802 archaeon 1906665 Archaea Archaea 97.8 3.0300000000000003e-21   NR MCQ2815804.1 1906665 g48897 i0 52.3 0.88659793814433 86 36 83.5 2 288 46 126 211 MCQ2815804.1 50S ribosome-binding GTPase [archaeon] diamond 258 97.8 1 Archaea               archaeon
30936824 30936824 PRJNA716463_P_NODE_46454_length_293_cov_3.118182_g46037_i0 PRJNA716463 46454 293 3.118182 9.13627326 archaeon 1906665 Archaea Archaea 72 2.98e-12   NR RYG98570.1 1906665 g46037 i0 60.4 0.491467576791809 48 19 49.1 0 5 148 330 377 RYG98570.1 MAG: hypothetical protein EON65_51280 [archaeon] diamond 144 72 1 Archaea               archaeon
31379333 31379333 PRJNA716463_P_NODE_97656_length_253_cov_2.844444_g97239_i0 PRJNA716463 97656 253 2.844444 7.19644332 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 165 2.05e-45   NR HEY9491973.1 2169593 g97239 i0 97.6 2.98814229249012 84 2 99.6 0 1 252 19 102 HEY9491973.1 GMC family oxidoreductase [Nitrososphaeraceae archaeon] diamond 756 165 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32518381 32518381 PRJNA716463_P_NODE_45339_length_294_cov_3.248869_g44922_i0 PRJNA716463 45339 294 3.248869 9.55167486 archaeon 1906665 Archaea Archaea 145 1.42e-39   NR RYH05051.1 1906665 g44922 i0 69.9 1.91836734693878 93 28 94.9 0 5 283 160 252 RYH05051.1 MAG: DUF3508 domain-containing protein, partial [archaeon] diamond 564 145 1 Archaea               archaeon

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