RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJEB11523" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 19 ✖

bioproject 1

  • PRJEB11523 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
26747446 26747446 PRJEB11523_P_NODE_3421_length_266_cov_2.244240_g3343_i0 PRJEB11523 3421 266 2.24424 5.9696784 Methanobacteriota archaeon 2026739 Archaea Archaea 90.5 1.58e-20   NR RZD43308.1 2026739 g3343 i0 51.4 2.83082706766917 74 35 82.3 1 254 36 57 130 RZD43308.1 MAG: hypothetical protein CXT73_00935 [Methanobacteriota archaeon] diamond 753 90.5 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
26811258 26811258 PRJEB11523_P_NODE_681_length_735_cov_3.696793_g618_i0 PRJEB11523 681 735 3.696793 27.17142855 Methanosarcina sp. 2213 Archaea Archaea 139 3.76e-37   NR HET8685212.1 2213 g618 i0 45.9 0.604081632653061 148 77 59.6 2 470 33 13 159 HET8685212.1 NUDIX domain-containing protein [Methanosarcina sp.] diamond 444 139 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
26969367 26969367 PRJEB11523_P_NODE_6322_length_183_cov_16.231343_g6244_i0 PRJEB11523 6322 183 16.231343 29.70335769 Nitrososphaerota archaeon 2026795 Archaea Archaea 74.7 7.96e-14   NR MCH7560681.1 2026795 g6244 i0 62.3 0.868852459016393 53 20 86.9 0 25 183 329 381 MCH7560681.1 ParB N-terminal domain-containing protein [Nitrososphaerota archaeon] diamond 159 74.7 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
27247891 27247891 PRJEB11523_P_NODE_943_length_613_cov_21.790780_g870_i0 PRJEB11523 943 613 21.79078 133.5774814 root 1 Root_unresolved Root_unresolved 117 1.8700000000000003e-27   NR MBP04528.1 2026739 g870 i0 32.9 2.09951060358891 228 108 97.9 7 609 10 15 225 MBP04528.1 hypothetical protein [Methanobacteriota archaeon] diamond 1287 118 0.991525423728814 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
27696495 27696495 PRJEB11523_P_NODE_864_length_648_cov_18.831386_g792_i0 PRJEB11523 864 648 18.831386 122.02738128 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 51.6 0.00108   NR MBI2102121.1 2026803 g792 i0 31.8 0.787037037037037 170 73 62 5 241 642 511 673 MBI2102121.1 hypothetical protein [Candidatus Woesearchaeota archaeon] diamond 510 51.6 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
28327522 28327522 PRJEB11523_P_NODE_1446_length_476_cov_2.833724_g1368_i0 PRJEB11523 1446 476 2.833724 13.48852624 Candidatus Nanoarchaeia archaeon 2910166 Archaea Archaea 49.7 0.00136   NR HLC62344.1 2910166 g1368 i0 24.7 1.07142857142857 170 91 95.2 5 457 5 29 180 HLC62344.1 hypothetical protein [Candidatus Nanoarchaeia archaeon] diamond 510 49.7 1 Archaea   Nanobdellati Nanobdellota Candidatus Nanoarchaeia       Candidatus Nanoarchaeia archaeon
28832779 28832779 PRJEB11523_P_NODE_1428_length_481_cov_1.479167_g1350_i0 PRJEB11523 1428 481 1.479167 7.11479327 Candidatus Iainarchaeum archaeon 3101447 Archaea Archaea 256 2.16e-82   NR MDP2666190.1 2026736 g1350 i0 80.3 0.916839916839917 147 29 91.7 0 39 479 184 330 MDP2666190.1 deoxyhypusine synthase family protein [Candidatus Iainarchaeum archaeon] diamond 441 256 1 Archaea   Nanobdellati Candidatus Iainarchaeota       Candidatus Iainarchaeum Candidatus Iainarchaeum archaeon
29274713 29274713 PRJEB11523_P_NODE_5269_length_203_cov_10.922078_g5191_i0 PRJEB11523 5269 203 10.922078 22.17181834 Nanobdellota archaeon 2026764 Archaea Archaea 87.8 1.91e-19   NR MDP3698550.1 2026764 g5191 i0 80.6 0.916256157635468 62 12 91.6 0 4 189 153 214 MDP3698550.1 hypothetical protein [Nanoarchaeota archaeon] diamond 186 87.8 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
29300357 29300357 PRJEB11523_P_NODE_4649_length_218_cov_5.230769_g4571_i0 PRJEB11523 4649 218 5.230769 11.40307642 Archaea 2157 Archaea Archaea 99 4.14e-23   NR MFH1425725.1 1906665 g4571 i0 70.3 4.51376146788991 64 19 88.1 0 214 23 37 100 MFH1425725.1 type II secretion system F family protein [archaeon] diamond 984 100 0.99 Archaea               archaeon
29495864 29495864 PRJEB11523_P_NODE_5790_length_192_cov_13.678322_g5712_i0 PRJEB11523 5790 192 13.678322 26.26237824 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 69.3 1.04e-12   NR MBS3143572.1 2026803 g5712 i0 68 0.78125 50 14 78.1 1 18 167 1 48 MBS3143572.1 hypothetical protein [Candidatus Woesearchaeota archaeon] diamond 150 69.3 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
29716641 29716641 PRJEB11523_P_NODE_4650_length_218_cov_5.106509_g4572_i0 PRJEB11523 4650 218 5.106509 11.13218962 Candidatus Methanogaster sp. 3386292 Archaea Archaea 49.7 6.95e-5   NR PXF61762.1 3386292 g4572 i0 39.4 0.908256880733945 66 40 90.8 0 1 198 71 136 PXF61762.1 MAG: hypothetical protein C4B59_02605 [Candidatus Methanogaster sp.] diamond 198 49.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Candidatus Methanogasteraceae Candidatus Methanogaster Candidatus Methanogaster sp.
29805437 29805437 PRJEB11523_P_NODE_891_length_638_cov_3.972835_g819_i0 PRJEB11523 891 638 3.972835 25.3466873 Archaea 2157 Archaea Archaea 236 9.32e-68   NR MEK6858731.1 2026764 g819 i0 55 3.89811912225705 211 90 97.3 3 631 11 21 230 MEK6858731.1 hypothetical protein [Nanoarchaeota archaeon] diamond 2487 237 0.9957805907173 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
29906543 29906543 PRJEB11523_P_NODE_5991_length_189_cov_1.457143_g5913_i0 PRJEB11523 5991 189 1.457143 2.75400027 Nitrososphaera sp. AFS 2301191 Archaea Archaea 66.2 5.73e-11   NR WP_201449407.1 2301191 g5913 i0 57.4 0.857142857142857 54 22 84.1 1 31 189 34 87 WP_201449407.1 hypothetical protein [Nitrososphaera sp. AFS] diamond 162 66.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp. AFS
29932063 29932063 PRJEB11523_P_NODE_1851_length_404_cov_13.188732_g1773_i0 PRJEB11523 1851 404 13.188732 53.28247728 root 1 Root_unresolved Root_unresolved 84.7 2.33e-17   NR MDD3986020.1 2164 g1773 i0 52.9 1.72277227722772 70 30 49.8 1 201 1 93 162 MDD3986020.1 hypothetical protein [Methanobacterium sp.] diamond 696 84.7 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp.
30222250 30222250 PRJEB11523_P_NODE_5392_length_200_cov_13.019868_g5314_i0 PRJEB11523 5392 200 13.019868 26.039736 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 85.9 5.99e-20   NR HSE99786.1 2169593 g5314 i0 66.7 0.855 57 19 85.5 0 176 6 25 81 HSE99786.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 171 85.9 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30569620 30569620 PRJEB11523_P_NODE_2173_length_365_cov_2.762658_g2095_i0 PRJEB11523 2173 365 2.762658 10.0837017 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 139 3.21e-38   NR MBR9706162.1 2026773 g2095 i0 75.3 0.665753424657534 81 20 66.6 0 19 261 114 194 MBR9706162.1 hypothetical protein [Candidatus Pacearchaeota archaeon] diamond 243 139 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
31739304 31739304 PRJEB11523_P_NODE_3157_length_281_cov_6.827586_g3079_i0 PRJEB11523 3157 281 6.827586 19.18551666 archaeon 1906665 Archaea Archaea 85.5 2.34e-18   NR NCP98419.1 1906665 g3079 i0 74.6 0.629893238434164 59 13 60.9 1 21 191 131 189 NCP98419.1 hypothetical protein [archaeon] diamond 177 85.5 1 Archaea               archaeon
31897643 31897643 PRJEB11523_P_NODE_8517_length_162_cov_0.902655_g8439_i0 PRJEB11523 8517 162 0.902655 1.4623011 Candidatus Poseidoniales archaeon 2163009 Archaea Archaea 104 8.989999999999999e-28   NR MEK9694590.1 2163009 g8439 i0 92.5 0.981481481481482 53 4 98.1 0 3 161 27 79 MEK9694590.1 hypothetical protein [Candidatus Poseidoniales archaeon] diamond 159 104 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
32144696 32144696 PRJEB11523_P_NODE_2118_length_371_cov_4.677019_g2040_i0 PRJEB11523 2118 371 4.677019 17.35174049 root 1 Root_unresolved Root_unresolved 103 3.37e-26   NR MAH50628.1 2026773 g2040 i0 51.6 1.43126684636119 91 38 73.6 1 18 290 10 94 MAH50628.1 hypothetical protein [Candidatus Pacearchaeota archaeon] diamond 531 103 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota 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);;