RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 16 ✖

bioproject 1

  • PRJNA488043 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
27170970 27170970 PRJNA488043_P_NODE_20482_length_167_cov_1.963768_g18240_i0 PRJNA488043 20482 167 1.963768 3.27949256 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 70.5 2.17e-12   NR RLI37484.1 2026714 g18240 i0 66 1.86826347305389 53 18 95.2 0 161 3 170 222 RLI37484.1 MAG: hypothetical protein DRO66_03775 [Candidatus Bathyarchaeota archaeon] diamond 312 70.5 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
27250395 27250395 PRJNA488043_P_NODE_15243_length_224_cov_2.312821_g13001_i0 PRJNA488043 15243 224 2.312821 5.18071904 root 1 Root_unresolved Root_unresolved 71.6 6.62e-14   NR MDX1532587.1 2202732 g13001 i0 51.4 1.94196428571429 72 35 96.4 0 224 9 23 94 MDX1532587.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 435 71.6 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
27629645 27629645 PRJNA488043_P_NODE_15244_length_224_cov_2.282051_g13002_i0 PRJNA488043 15244 224 2.282051 5.11179424 root 1 Root_unresolved Root_unresolved 57 1.96e-7   NR WP_292787978.1 66852 g13002 i0 48 2.14285714285714 50 26 67 0 5 154 88 137 WP_292787978.1 DNA-methyltransferase [Methanobrevibacter sp.] diamond 480 57.4 0.993031358885017 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
27803026 27803026 PRJNA488043_P_NODE_22324_length_152_cov_1.691057_g20082_i0 PRJNA488043 22324 152 1.691057 2.57040664 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 42 0.0203   NR MCK9570055.1 2026773 g20082 i0 48.6 0.690789473684211 35 18 69.1 0 112 8 305 339 MCK9570055.1 hypothetical protein [Candidatus Pacearchaeota archaeon] diamond 105 42 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
28497649 28497649 PRJNA488043_P_NODE_3427_length_783_cov_2.578249_g1558_i1 PRJNA488043 3427 783 2.578249 20.18768967 Nanobdellota archaeon 2026764 Archaea Archaea 80.1 4.22e-14   NR MCA9497338.1 2026764 g1558 i1 45.6 0.344827586206897 90 46 33.7 2 518 781 10 98 MCA9497338.1 HK97 family phage prohead protease [Nanoarchaeota archaeon] diamond 270 80.1 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
29286725 29286725 PRJNA488043_P_NODE_16909_length_203_cov_2.655172_g14667_i0 PRJNA488043 16909 203 2.655172 5.38999916 Methanosarcina sp. 2213 Archaea Archaea 51.6 1.53e-6   NR HET8686851.1 2213 g14667 i0 69 0.428571428571429 29 9 42.9 0 114 200 1 29 HET8686851.1 hypothetical protein [Methanosarcina sp.] diamond 87 51.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
29728627 29728627 PRJNA488043_P_NODE_3450_length_779_cov_2.849333_g1558_i2 PRJNA488043 3450 779 2.849333 22.19630407 Nanobdellota archaeon 2026764 Archaea Archaea 80.1 4.14e-14   NR MCA9497338.1 2026764 g1558 i2 45.6 0.346598202824134 90 46 33.9 2 266 3 10 98 MCA9497338.1 HK97 family phage prohead protease [Nanoarchaeota archaeon] diamond 270 80.1 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
29855262 29855262 PRJNA488043_P_NODE_16011_length_214_cov_1.610811_g13769_i0 PRJNA488043 16011 214 1.610811 3.44713554 Methanosarcina sp. 2213 Archaea Archaea 67.8 1.3e-12   NR HET8689073.1 2213 g13769 i0 47.9 0.995327102803738 71 37 99.5 0 1 213 12 82 HET8689073.1 hypothetical protein [Methanosarcina sp.] diamond 213 67.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
30013266 30013266 PRJNA488043_P_NODE_3011_length_853_cov_2.406553_g1558_i0 PRJNA488043 3011 853 2.406553 20.52789709 Nanobdellota archaeon 2026764 Archaea Archaea 80.1 6.27e-14   NR MCA9497338.1 2026764 g1558 i0 45.6 0.316529894490035 90 46 30.9 2 588 851 10 98 MCA9497338.1 HK97 family phage prohead protease [Nanoarchaeota archaeon] diamond 270 80.1 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
30076222 30076222 PRJNA488043_P_NODE_2112_length_1066_cov_3.185149_g621_i2 PRJNA488043 2112 1066 3.185149 33.95368834 Candidatus Methanomethylicaceae archaeon 2282146 Archaea Archaea 52.4 4.83e-5   NR MEM2002118.1 3058293 g621 i2 42.2 0.180112570356473 64 35 18 2 882 691 1 62 MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] diamond 192 52.4 1 Archaea   Thermoproteati Candidatus Methanomethylicota Candidatus Methanomethylicia Candidatus Methanomethylicales Candidatus Methanomethylicaceae   Candidatus Methanomethylicaceae archaeon
30455860 30455860 PRJNA488043_P_NODE_9393_length_360_cov_2.175227_g7163_i0 PRJNA488043 9393 360 2.175227 7.8308172 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 79 1.64e-16   NR MCK5607752.1 2026773 g7163 i0 51.2 0.716666666666667 86 35 70 2 269 18 1 81 MCK5607752.1 hypothetical protein [Candidatus Pacearchaeota archaeon] diamond 258 79 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
30613335 30613335 PRJNA488043_P_NODE_20613_length_166_cov_1.518248_g18371_i0 PRJNA488043 20613 166 1.518248 2.52029168 Nitrosarchaeum koreense 1088740 Archaea Archaea 52 7.25e-6   NR WP_007550483.1 1088740 g18371 i0 56.4 2.02409638554217 55 20 94 3 8 163 516 569 WP_007550483.1 hypothetical protein [Nitrosarchaeum koreense] diamond 336 52 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum koreense
31024251 31024251 PRJNA488043_P_NODE_2055_length_1087_cov_3.140832_g621_i1 PRJNA488043 2055 1087 3.140832 34.14084384 Candidatus Methanomethylicaceae archaeon 2282146 Archaea Archaea 52.4 4.94e-5   NR MEM2002118.1 3058293 g621 i1 42.2 0.176632934682613 64 35 17.7 2 903 712 1 62 MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] diamond 192 52.4 1 Archaea   Thermoproteati Candidatus Methanomethylicota Candidatus Methanomethylicia Candidatus Methanomethylicales Candidatus Methanomethylicaceae   Candidatus Methanomethylicaceae archaeon
31609454 31609454 PRJNA488043_P_NODE_10676_length_318_cov_2.356401_g8435_i0 PRJNA488043 10676 318 2.356401 7.49335518 root 1 Root_unresolved Root_unresolved 90.9 4.3e-19   NR HET8686349.1 2213 g8435 i0 83.6 2.07547169811321 55 9 51.9 0 1 165 286 340 HET8686349.1 DNA methyltransferase [Methanosarcina sp.] diamond 660 90.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
31719839 31719839 PRJNA488043_P_NODE_2157_length_1053_cov_3.283203_g621_i3 PRJNA488043 2157 1053 3.283203 34.57212759 Candidatus Methanomethylicaceae archaeon 2282146 Archaea Archaea 52.4 4.77e-5   NR MEM2002118.1 3058293 g621 i3 42.2 0.182336182336182 64 35 18.2 2 864 673 1 62 MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] diamond 192 52.4 1 Archaea   Thermoproteati Candidatus Methanomethylicota Candidatus Methanomethylicia Candidatus Methanomethylicales Candidatus Methanomethylicaceae   Candidatus Methanomethylicaceae archaeon
32004599 32004599 PRJNA488043_P_NODE_21678_length_157_cov_1.640625_g19436_i0 PRJNA488043 21678 157 1.640625 2.57578125 Methanosarcina sp. 2213 Archaea Archaea 62 6.73e-11   NR HET8689436.1 2213 g19436 i0 51 0.974522292993631 51 25 97.5 0 5 157 34 84 HET8689436.1 hypothetical protein [Methanosarcina sp.] diamond 153 62 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.

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