RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJEB2368" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 23 ✖

tax_clade 1

bioproject 1

  • PRJEB2368 · 23 ✖
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
11500915 11500915 PRJEB2368_P_NODE_11050_length_286_cov_1.381526_g10732_i0 PRJEB2368 11050 286 1.381526 3.95116436 Nitrosopumilus zosterae 718286 Archaea Archaea 80.5 1.21e-10   NTclustered gi|2289589374|dbj|AP026695.1| 718286 g10732 i0 85.526 0.538461538461538 76 11 27 0 211 286 1666346 1666421 Nitrosopumilus zosterae NM25 DNA, complete genome blastn 154 80.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus zosterae
11500947 11500947 PRJEB2368_P_NODE_8130_length_287_cov_1.724000_g7812_i0 PRJEB2368 8130 287 1.724 4.94788 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 113 1.2e-20   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g7812 i0 93.421 0.264808362369338 76 5 26 0 212 287 128857 128932 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 76 113 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
14051062 14051062 PRJEB2368_P_NODE_8912_length_287_cov_1.496000_g8594_i0 PRJEB2368 8912 287 1.496 4.29352 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 130 1.19e-25   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g8594 i0 97.368 3.95470383275261 76 2 26 0 1 76 103528 103453 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 1135 130 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
16599742 16599742 PRJEB2368_P_NODE_8194_length_287_cov_1.704000_g7876_i0 PRJEB2368 8194 287 1.704 4.89048 Candidatus Nitrosopumilus sediminis 1229909 Archaea Archaea 78.7 4.38e-10   NTclustered gi|407047065|gb|CP003843.1| 1229909 g7876 i0 89.231 0.442508710801394 65 3 22 3 5 67 49121 49059 Candidatus Nitrosopumilus sp. AR2, complete genome blastn 127 78.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Candidatus Nitrosopumilus sediminis
22974904 22974904 PRJEB2368_P_NODE_8499_length_287_cov_1.608000_g8181_i0 PRJEB2368 8499 287 1.608 4.61496 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 130 1.19e-25   NTclustered gi|937513727|gb|CP012850.1| 1353260 g8181 i0 97.368 0.264808362369338 76 2 26 0 212 287 872858 872933 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 76 130 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
26653042 26653042 PRJEB2368_P_NODE_10101_length_287_cov_1.304000_g9783_i0 PRJEB2368 10101 287 1.304 3.74248 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 47 0.00115   NR HXV38476.1 2202732 g9783 i0 95.7 0.240418118466899 23 1 24 0 281 213 119 141 HXV38476.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 69 47 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
26805120 26805120 PRJEB2368_P_NODE_10181_length_287_cov_1.288000_g9863_i0 PRJEB2368 10181 287 1.288 3.69656 Nitrosopumilus 338191 Archaea Archaea 43.1 0.0437   NR MDH3618399.1 2024843 g9863 i0 79.2 1.00348432055749 24 5 25.1 0 72 1 294 317 MDH3618399.1 glycosyltransferase family 4 protein [Nitrosopumilus sp.] diamond 288 43.5 0.990804597701149 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
27254294 27254294 PRJEB2368_P_NODE_9863_length_287_cov_1.344000_g9545_i0 PRJEB2368 9863 287 1.344 3.85728 Nitrososphaerota archaeon 2026795 Archaea Archaea 72.4 8.31e-13   NR MDE1814494.1 2026795 g9545 i0 50.5 1.98606271777003 95 37 99.3 1 286 2 78 162 MDE1814494.1 hypothetical protein [Nitrososphaerota archaeon] diamond 570 72.4 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
27949197 27949197 PRJEB2368_P_NODE_10505_length_287_cov_1.184000_g10187_i0 PRJEB2368 10505 287 1.184 3.39808 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 46.6 0.00199   NR MBS3175595.1 2026803 g10187 i0 31.5 1.1602787456446 111 53 92 1 285 22 106 216 MBS3175595.1 glycosyltransferase [Candidatus Woesearchaeota archaeon] diamond 333 46.6 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
28037582 28037582 PRJEB2368_P_NODE_8065_length_287_cov_1.748000_g7747_i0 PRJEB2368 8065 287 1.748 5.01676 Nanobdellati 1783276 Archaea Archaea 43.1 0.0125   NR MEK6947056.1 2026764 g7747 i0 80 0.522648083623693 25 5 26.1 0 2 76 52 76 MEK6947056.1 hypothetical protein [Nanoarchaeota archaeon] diamond 150 43.5 0.990804597701149 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
28201579 28201579 PRJEB2368_P_NODE_8466_length_287_cov_1.616000_g8148_i0 PRJEB2368 8466 287 1.616 4.63792 Candidatus Iainarchaeum archaeon 3101447 Archaea Archaea 43.5 0.0324   NR HRT03637.1 2026736 g8148 i0 76 0.261324041811847 25 6 26.1 0 2 76 183 207 HRT03637.1 AAA family ATPase [Candidatus Iainarchaeum archaeon] diamond 75 43.5 1 Archaea   Nanobdellati Candidatus Iainarchaeota       Candidatus Iainarchaeum Candidatus Iainarchaeum archaeon
28542893 28542893 PRJEB2368_P_NODE_7207_length_287_cov_2.384000_g6889_i0 PRJEB2368 7207 287 2.384 6.84208 Archaea 2157 Archaea Archaea 47 0.00208   NR PIN94733.1 1974437 g6889 i0 30.5 4.93379790940767 95 47 99.3 1 287 3 451 526 PIN94733.1 MAG: DNA polymerase II large subunit, partial [Candidatus Pacearchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_30_48] diamond 1416 47 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_30_48
28675532 28675532 PRJEB2368_P_NODE_8647_length_287_cov_1.556000_g8329_i0 PRJEB2368 8647 287 1.556 4.46572 Nanobdellota archaeon 2026764 Archaea Archaea 45.1 0.00933   NR MDP3027261.1 2026764 g8329 i0 31.2 0.97212543554007 93 17 97.2 1 8 286 321 366 MDP3027261.1 hypothetical protein [Nanoarchaeota archaeon] diamond 279 45.1 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
29142836 29142836 PRJEB2368_P_NODE_10329_length_287_cov_1.248000_g10011_i0 PRJEB2368 10329 287 1.248 3.58176 Archaea 2157 Archaea Archaea 49.3 4.17e-5   NR MAG50737.1 1906665 g10011 i0 91.7 0.742160278745645 24 2 25.1 0 75 4 51 74 MAG50737.1 cysteine methyltransferase [archaeon] diamond 213 49.3 1 Archaea               archaeon
29363708 29363708 PRJEB2368_P_NODE_8529_length_287_cov_1.596000_g8211_i0 PRJEB2368 8529 287 1.596 4.58052 Thermoproteati 1783275 Archaea Archaea 53.1 1.21e-5   NR PIW33344.1 2022694 g8211 i0 96 1.82926829268293 25 1 26.1 0 286 212 253 277 PIW33344.1 MAG: prephenate dehydrogenase/arogenate dehydrogenase family protein [Nitrosopumilales archaeon CG15_BIG_FIL_POST_REV_8_21_14_020_37_12] diamond 525 53.5 0.992523364485981 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon CG15_BIG_FIL_POST_REV_8_21_14_020_37_12
29559345 29559345 PRJEB2368_P_NODE_7710_length_287_cov_1.900000_g7392_i0 PRJEB2368 7710 287 1.9 5.453 archaeon 1906665 Archaea Archaea 48.9 5.88e-5   NR MCR4285090.1 1906665 g7392 i0 83.3 0.51219512195122 24 4 25.1 0 284 213 9 32 MCR4285090.1 50S ribosomal protein L44e [archaeon] diamond 147 48.9 1 Archaea               archaeon
29678987 29678987 PRJEB2368_P_NODE_15590_length_153_cov_1.681034_g15271_i0 PRJEB2368 15590 153 1.681034 2.57198202 root 1 Root_unresolved Root_unresolved 42 0.0033   NR MEA2045212.1 2026739 g15271 i0 50 1.7843137254902 40 17 74.5 2 149 36 22 60 MEA2045212.1 PAN domain-containing protein [Methanobacteriota archaeon] diamond 273 42.4 0.990566037735849 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
30033289 30033289 PRJEB2368_P_NODE_10191_length_287_cov_1.288000_g9873_i0 PRJEB2368 10191 287 1.288 3.69656 Nanobdellota archaeon 2026764 Archaea Archaea 50.8 1.87e-5   NR MBU0907382.1 2026764 g9873 i0 34.7 0.993031358885017 95 28 99.3 1 2 286 32 92 MBU0907382.1 EamA/RhaT family transporter [Nanoarchaeota archaeon] diamond 285 50.8 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
30633300 30633300 PRJEB2368_P_NODE_8453_length_287_cov_1.620000_g8135_i0 PRJEB2368 8453 287 1.62 4.6494 uncultured archaeon 115547 Archaea Archaea 52.8 5.92e-7   NR VVB78960.1 115547 g8135 i0 80 0.522648083623693 25 5 26.1 0 2 76 15 39 VVB78960.1 Uncharacterised protein [uncultured archaeon] diamond 150 52.8 1 Archaea               uncultured archaeon
31233653 31233653 PRJEB2368_P_NODE_9675_length_287_cov_1.376000_g9357_i0 PRJEB2368 9675 287 1.376 3.94912 Nitrososphaerota archaeon 2026795 Archaea Archaea 49.3 1.28e-4   NR TLX80400.1 2026795 g9357 i0 88 0.261324041811847 25 3 26.1 0 286 212 108 132 TLX80400.1 MAG: MarR family transcriptional regulator [Nitrososphaerota archaeon] diamond 75 49.3 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31328704 31328704 PRJEB2368_P_NODE_10536_length_287_cov_1.164000_g10218_i0 PRJEB2368 10536 287 1.164 3.34068 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 49.3 2.94e-5   NR MBS3104967.1 2026803 g10218 i0 88 0.261324041811847 25 3 26.1 0 2 76 20 44 MBS3104967.1 DNA cytosine methyltransferase [Candidatus Woesearchaeota archaeon] diamond 75 49.3 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
31448878 31448878 PRJEB2368_P_NODE_10036_length_287_cov_1.316000_g9718_i0 PRJEB2368 10036 287 1.316 3.77692 root 1 Root_unresolved Root_unresolved 53.5 1.03e-5   NR AQS31771.1 115547 g9718 i0 100 24.5853658536585 24 0 25.1 0 285 214 275 298 AQS31771.1 hypothetical protein [uncultured archaeon] diamond 7056 53.5 1 Archaea               uncultured archaeon
31487096 31487096 PRJEB2368_P_NODE_7756_length_287_cov_1.880000_g7438_i0 PRJEB2368 7756 287 1.88 5.3956 Nanobdellota archaeon 2026764 Archaea Archaea 49.7 7.88e-5   NR MEK6915184.1 2026764 g7438 i0 87.5 0.250871080139373 24 3 25.1 0 285 214 95 118 MEK6915184.1 glycosyltransferase [Nanoarchaeota archaeon] diamond 72 49.7 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota 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);;