RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1008624" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 18 ✖

bioproject 1

  • PRJNA1008624 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
12480138 12480138 PRJNA1008624_P_NODE_1370_length_739_cov_3.578261_g1214_i0 PRJNA1008624 1370 739 3.578261 26.44334879 Thermococcus 2263 Archaea Archaea 441 8.4e-140   NR WP_167728776.1 163002 g1214 i0 98.6 4.48579161028417 221 3 89.7 0 77 739 1 221 WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3] diamond 3315 441 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus sp. 9N3
18006477 18006477 PRJNA1008624_P_NODE_8395_length_288_cov_5.464435_g8207_i0 PRJNA1008624 8395 288 5.464435 15.7375728 Thermococcus 2263 Archaea Archaea 188 4.21e-53   NR WP_167728776.1 163002 g8207 i0 100 8.72916666666667 93 0 96.9 0 8 286 224 316 WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3] diamond 2514 188 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus sp. 9N3
27002644 27002644 PRJNA1008624_P_NODE_2382_length_560_cov_3.540117_g2204_i0 PRJNA1008624 2382 560 3.540117 19.8246552 Methanomassiliicoccales archaeon 1906667 Archaea Archaea 61.6 9.3e-9   NR MFA5313869.1 1906667 g2204 i0 55.1 0.2625 49 22 26.3 0 152 6 1 49 MFA5313869.1 hypothetical protein [Methanomassiliicoccales archaeon] diamond 147 61.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon
27128869 27128869 PRJNA1008624_P_NODE_13202_length_231_cov_1.126374_g13014_i0 PRJNA1008624 13202 231 1.126374 2.60192394 Methanosarcina sp. 2213 Archaea Archaea 127 1.45e-32   NR HET8685948.1 2213 g13014 i0 80.5 1 77 15 100 0 231 1 74 150 HET8685948.1 phage terminase large subunit [Methanosarcina sp.] diamond 231 127 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
27382281 27382281 PRJNA1008624_P_NODE_30523_length_166_cov_1.743590_g30335_i0 PRJNA1008624 30523 166 1.74359 2.8943594 Methanobacteriota archaeon 2026739 Archaea Archaea 61.6 2.9e-9   NR NDB64671.1 2026739 g30335 i0 57.4 0.849397590361446 47 20 84.9 0 163 23 1597 1643 NDB64671.1 SDR family NAD(P)-dependent oxidoreductase [Methanobacteriota archaeon] diamond 141 61.6 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
27761371 27761371 PRJNA1008624_P_NODE_16944_length_207_cov_0.898734_g16756_i0 PRJNA1008624 16944 207 0.898734 1.86037938 Promethearchaeia archaeon 3067280 Archaea Archaea 110 2.48e-26   NR MFO7795213.1 3067280 g16756 i0 76.5 0.985507246376812 68 16 98.6 0 4 207 825 892 MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] diamond 204 110 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
27918870 27918870 PRJNA1008624_P_NODE_10865_length_253_cov_1.588235_g10677_i0 PRJNA1008624 10865 253 1.588235 4.01823455 Nitrososphaerales archaeon 2268197 Archaea Archaea 76.3 6.42e-14   NR MFI5406628.1 2268197 g10677 i0 58.7 0.889328063241107 75 31 88.9 0 248 24 491 565 MFI5406628.1 hAT transposon family protein [Nitrososphaerales archaeon] diamond 225 76.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
27918880 27918880 PRJNA1008624_P_NODE_27865_length_169_cov_0.866667_g27677_i0 PRJNA1008624 27865 169 0.866667 1.46466723 Nitrososphaera sp. 1971748 Archaea Archaea 71.2 1.17e-12   NR MCI0563357.1 1971748 g27677 i0 56.6 0.940828402366864 53 23 94.1 0 4 162 349 401 MCI0563357.1 SNF2-related protein [Nitrososphaera sp.] diamond 159 71.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
29024426 29024426 PRJNA1008624_P_NODE_35388_length_163_cov_0.912281_g35200_i0 PRJNA1008624 35388 163 0.912281 1.48701803 Nitrososphaera sp. 1971748 Archaea Archaea 60.8 8.51e-10   NR HEX2556991.1 1971748 g35200 i0 55.8 0.957055214723926 52 23 95.7 0 157 2 95 146 HEX2556991.1 hypothetical protein [Nitrososphaera sp.] diamond 156 60.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
29119022 29119022 PRJNA1008624_P_NODE_27489_length_169_cov_0.866667_g27301_i0 PRJNA1008624 27489 169 0.866667 1.46466723 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 66.2 7.11e-11   NR GIU69793.1 2026803 g27301 i0 76.9 0.692307692307692 39 9 69.2 0 162 46 365 403 GIU69793.1 MAG: hypothetical protein KatS3mg002_1029 [Candidatus Woesearchaeota archaeon] diamond 117 66.2 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
29465680 29465680 PRJNA1008624_P_NODE_29690_length_167_cov_0.881356_g29502_i0 PRJNA1008624 29690 167 0.881356 1.47186452 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 83.6 5.42e-17   NR MAH47872.1 2026773 g29502 i0 68.5 0.970059880239521 54 17 97 0 1 162 522 575 MAH47872.1 hypothetical protein [Candidatus Pacearchaeota archaeon] diamond 162 83.6 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
30065986 30065986 PRJNA1008624_P_NODE_14072_length_224_cov_1.342857_g13884_i0 PRJNA1008624 14072 224 1.342857 3.00799968 Candidatus Pacearchaeota archaeon 2026773 Archaea Archaea 50.8 1.32e-5   NR MCK9569036.1 2026773 g13884 i0 55.6 0.964285714285714 36 16 48.2 0 115 222 97 132 MCK9569036.1 hypothetical protein [Candidatus Pacearchaeota archaeon] diamond 216 50.8 1 Archaea Candidatus Pacearchaeota Nanobdellati           Candidatus Pacearchaeota archaeon
30097581 30097581 PRJNA1008624_P_NODE_15872_length_213_cov_0.932927_g15684_i0 PRJNA1008624 15872 213 0.932927 1.98713451 Methanosarcina sp. 2213 Archaea Archaea 87.4 1.8e-19   NR HET8687536.1 2213 g15684 i0 57.6 0.929577464788732 66 27 93 1 200 3 84 148 HET8687536.1 hypothetical protein [Methanosarcina sp.] diamond 198 87.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
30128978 30128978 PRJNA1008624_P_NODE_20252_length_191_cov_1.274648_g20064_i0 PRJNA1008624 20252 191 1.274648 2.43457768 Thermoplasmata archaeon 1906666 Archaea Archaea 67.8 2.72e-11   NR MCK4717694.1 1906666 g20064 i0 50 0.942408376963351 60 30 94.2 0 187 8 370 429 MCK4717694.1 hypothetical protein [Thermoplasmata archaeon] diamond 180 67.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
31101123 31101123 PRJNA1008624_P_NODE_35095_length_163_cov_0.912281_g34907_i0 PRJNA1008624 35095 163 0.912281 1.48701803 root 1 Root_unresolved Root_unresolved 102 6.139999999999999e-24   NR OPY47876.1 1811726 g34907 i0 82.4 8.42944785276074 51 9 93.9 0 6 158 233 283 OPY47876.1 MAG: hypothetical protein A4E42_00230 [Methanoregulaceae archaeon PtaU1.Bin222] diamond 1374 102 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae   Methanoregulaceae archaeon PtaU1.Bin222
31354276 31354276 PRJNA1008624_P_NODE_26376_length_171_cov_1.131148_g26188_i0 PRJNA1008624 26376 171 1.131148 1.93426308 root 1 Root_unresolved Root_unresolved 55.8 3.27e-7   NR HET8686566.1 2213 g26188 i0 67.6 1.78947368421053 34 11 59.6 0 106 5 1 34 HET8686566.1 hypothetical protein [Methanosarcina sp.] diamond 306 55.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
32311050 32311050 PRJNA1008624_P_NODE_14259_length_223_cov_1.109195_g14071_i0 PRJNA1008624 14259 223 1.109195 2.47350485 Promethearchaeia archaeon 3067280 Archaea Archaea 64.3 6.97e-10   NR MFO7795213.1 3067280 g14071 i0 73.7 0.511210762331839 38 10 51.1 0 125 12 1 38 MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] diamond 114 64.3 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia archaeon
32500803 32500803 PRJNA1008624_P_NODE_22659_length_183_cov_1.119403_g22471_i0 PRJNA1008624 22659 183 1.119403 2.04850749 Promethearchaeia archaeon 3067280 Archaea Archaea 103 8.49e-24   NR MFO7795213.1 3067280 g22471 i0 81.4 0.967213114754098 59 11 96.7 0 178 2 718 776 MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] diamond 177 103 1 Archaea   Promethearchaeati Promethearchaeota Promethearchaeia       Promethearchaeia 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);;