RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA1143173" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 25 ✖

bioproject 1

  • PRJNA1143173 · 25 ✖

analysis 1

  • diamond · 25 ✖

tax_clade 0

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
2836948 2836948 PRJNA1143173_P_NODE_24243_length_274_cov_5.671642_g24217_i0 PRJNA1143173 24243 274 5.671642 15.54029908 Thermoproteota archaeon 2056631 Archaea Archaea 114 2.32e-27   NR RDJ35443.1 2056631 g24217 i0 62.9 0.974452554744526 89 32 97.4 1 273 7 122 209 RDJ35443.1 MAG: CTP synthase [Thermoproteota archaeon] diamond 267 114 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
16863280 16863280 PRJNA1143173_P_NODE_24134_length_274_cov_11.323383_g24108_i0 PRJNA1143173 24134 274 11.323383 31.02606942 Thermoproteota archaeon 2056631 Archaea Archaea 154 2.5699999999999998e-42   NR RDJ35311.1 2056631 g24108 i0 74.4 2.94525547445255 90 23 98.5 0 272 3 41 130 RDJ35311.1 MAG: SpoVR family protein [Thermoproteota archaeon] diamond 807 154 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27165077 27165077 PRJNA1143173_P_NODE_23722_length_276_cov_2.571429_g23696_i0 PRJNA1143173 23722 276 2.571429 7.09714404 Thermoproteota archaeon 2056631 Archaea Archaea 82 1.68e-16   NR RDJ35624.1 2056631 g23696 i0 60.7 0.608695652173913 56 22 60.9 0 109 276 1 56 RDJ35624.1 MAG: PD-(D/E)XK nuclease family protein [Thermoproteota archaeon] diamond 168 82 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27185680 27185680 PRJNA1143173_P_NODE_36022_length_240_cov_5.898204_g35996_i0 PRJNA1143173 36022 240 5.898204 14.1556896 root 1 Root_unresolved Root_unresolved 102 1.88e-23   NR RDJ35219.1 2056631 g35996 i0 63.8 10.1625 80 25 98.8 2 2 238 129 205 RDJ35219.1 MAG: L-lysine 6-transaminase [Thermoproteota archaeon] diamond 2439 102 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
27544397 27544397 PRJNA1143173_P_NODE_22864_length_278_cov_6.034146_g22838_i0 PRJNA1143173 22864 278 6.034146 16.77492588 Thermoproteota archaeon 2056631 Archaea Archaea 56.6 2.43e-7   NR RDJ35338.1 2056631 g22838 i0 48.8 0.464028776978417 43 22 46.4 0 149 277 3 45 RDJ35338.1 MAG: hypothetical protein DWQ19_11020 [Thermoproteota archaeon] diamond 129 56.6 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28238792 28238792 PRJNA1143173_P_NODE_9826_length_310_cov_4.561181_g9800_i0 PRJNA1143173 9826 310 4.561181 14.1396611 Thermoproteota archaeon 2056631 Archaea Archaea 55.5 4.26e-7   NR RDJ35488.1 2056631 g9800 i0 54 0.483870967741935 50 23 48.4 0 150 1 41 90 RDJ35488.1 MAG: hypothetical protein DWQ19_11775 [Thermoproteota archaeon] diamond 150 55.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28491667 28491667 PRJNA1143173_P_NODE_33407_length_248_cov_2.874286_g33381_i0 PRJNA1143173 33407 248 2.874286 7.12822928 Thermoproteota archaeon 2056631 Archaea Archaea 71.6 2.87e-13   NR RDJ35620.1 2056631 g33381 i0 43.8 0.967741935483871 80 43 94.4 1 2 235 31 110 RDJ35620.1 MAG: hypothetical protein DWQ19_12445 [Thermoproteota archaeon] diamond 240 71.6 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
28775696 28775696 PRJNA1143173_P_NODE_44827_length_196_cov_5.634146_g44801_i0 PRJNA1143173 44827 196 5.634146 11.04292616 Nitrososphaerales archaeon 2268197 Archaea Archaea 65.5 7.57e-11   NR MEM2760206.1 2268197 g44801 i0 50.7 1.02551020408163 67 31 99.5 1 1 195 101 167 MEM2760206.1 class II aldolase/adducin family protein [Nitrososphaerales archaeon] diamond 201 65.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
29060010 29060010 PRJNA1143173_P_NODE_14008_length_299_cov_4.814159_g13982_i0 PRJNA1143173 14008 299 4.814159 14.39433541 Thermoproteota archaeon 2056631 Archaea Archaea 104 6.0999999999999996e-24   NR RDJ35659.1 2056631 g13982 i0 50.9 1.06354515050167 106 42 98.3 2 297 4 151 254 RDJ35659.1 MAG: hypothetical protein DWQ19_12640 [Thermoproteota archaeon] diamond 318 104 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29154917 29154917 PRJNA1143173_P_NODE_629_length_726_cov_7.744257_g615_i0 PRJNA1143173 629 726 7.744257 56.22330582 Thermoproteota archaeon 2056631 Archaea Archaea 75.5 8.62e-12   NR RDJ35437.1 2056631 g615 i0 47.6 0.338842975206612 82 32 32.2 2 331 564 79 153 RDJ35437.1 MAG: hypothetical protein DWQ19_11520 [Thermoproteota archaeon] diamond 246 75.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29470068 29470068 PRJNA1143173_P_NODE_13990_length_299_cov_4.862832_g13964_i0 PRJNA1143173 13990 299 4.862832 14.53986768 Thermoproteota archaeon 2056631 Archaea Archaea 66.6 2.98e-10   NR RDJ35648.1 2056631 g13964 i0 39.1 0.692307692307692 69 42 69.2 0 208 2 124 192 RDJ35648.1 MAG: hypothetical protein DWQ19_12585 [Thermoproteota archaeon] diamond 207 66.6 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
29691069 29691069 PRJNA1143173_P_NODE_43270_length_207_cov_4.097015_g43244_i0 PRJNA1143173 43270 207 4.097015 8.48082105 Thermoproteota archaeon 2056631 Archaea Archaea 78.2 7.04e-15   NR RDJ35306.1 2056631 g43244 i0 68 0.72463768115942 50 16 72.5 0 7 156 2 51 RDJ35306.1 MAG: PHP domain-containing protein [Thermoproteota archaeon] diamond 150 78.2 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30007403 30007403 PRJNA1143173_P_NODE_25031_length_272_cov_3.819095_g25005_i0 PRJNA1143173 25031 272 3.819095 10.3879384 Thermoproteota archaeon 2056631 Archaea Archaea 92.8 1.11e-19   NR RDJ35652.1 2056631 g25005 i0 51.6 1.02573529411765 93 42 99.3 2 271 2 363 455 RDJ35652.1 MAG: hypothetical protein DWQ19_12605 [Thermoproteota archaeon] diamond 279 92.8 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30038806 30038806 PRJNA1143173_P_NODE_39151_length_229_cov_5.243590_g39125_i0 PRJNA1143173 39151 229 5.24359 12.0078211 Thermoproteota archaeon 2056631 Archaea Archaea 102 4.0799999999999996e-23   NR RDJ35291.1 2056631 g39125 i0 64.5 0.995633187772926 76 26 98.3 1 3 227 243 318 RDJ35291.1 MAG: hypothetical protein DWQ19_10780 [Thermoproteota archaeon] diamond 228 102 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30070311 30070311 PRJNA1143173_P_NODE_14972_length_299_cov_2.119469_g14946_i0 PRJNA1143173 14972 299 2.119469 6.33721231 Thermoproteota archaeon 2056631 Archaea Archaea 53.5 8.52e-7   NR RDJ35275.1 2056631 g14946 i0 39.3 0.842809364548495 84 44 77.3 2 58 288 5 88 RDJ35275.1 MAG: hypothetical protein DWQ19_10700 [Thermoproteota archaeon] diamond 252 53.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30101866 30101866 PRJNA1143173_P_NODE_44592_length_197_cov_14.991935_g44566_i0 PRJNA1143173 44592 197 14.991935 29.53411195 Nitrososphaerales archaeon 2268197 Archaea Archaea 46.6 8.94e-4   NR MFI5405082.1 2268197 g44566 i0 44.4 0.685279187817259 45 25 68.5 0 6 140 756 800 MFI5405082.1 LamG domain-containing protein [Nitrososphaerales archaeon] diamond 135 46.6 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
30375817 30375817 PRJNA1143173_P_NODE_2812_length_472_cov_3.859649_g2786_i0 PRJNA1143173 2812 472 3.859649 18.21754328 root 1 Root_unresolved Root_unresolved 55.5 1.45e-5   NR HEY1249177.1 1971748 g2786 i0 30.4 4.36016949152542 161 107 99.2 2 5 472 223 383 HEY1249177.1 hypothetical protein [Nitrososphaera sp.] diamond 2058 55.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
30449829 30449829 PRJNA1143173_P_NODE_6793_length_324_cov_5.039841_g6767_i0 PRJNA1143173 6793 324 5.039841 16.32908484 Thermoproteota archaeon 2056631 Archaea Archaea 112 9.45e-29   NR RDJ35620.1 2056631 g6767 i0 56.7 0.962962962962963 104 44 95.4 1 312 4 61 164 RDJ35620.1 MAG: hypothetical protein DWQ19_12445 [Thermoproteota archaeon] diamond 312 112 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31271157 31271157 PRJNA1143173_P_NODE_27315_length_265_cov_6.229167_g27289_i0 PRJNA1143173 27315 265 6.229167 16.50729255 Thermoproteota archaeon 2056631 Archaea Archaea 93.6 3.11e-21   NR RDJ35375.1 2056631 g27289 i0 55.7 0.894339622641509 79 32 88.3 2 265 32 43 119 RDJ35375.1 MAG: hypothetical protein DWQ19_11205 [Thermoproteota archaeon] diamond 237 93.6 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31397755 31397755 PRJNA1143173_P_NODE_12716_length_303_cov_9.921739_g12690_i0 PRJNA1143173 12716 303 9.921739 30.06286917 Thermoproteota archaeon 2056631 Archaea Archaea 47 0.00122   NR RDJ35263.1 2056631 g12690 i0 51.1 0.445544554455446 45 20 44.6 1 2 136 133 175 RDJ35263.1 MAG: cytidine deaminase [Thermoproteota archaeon] diamond 135 47 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
31872002 31872002 PRJNA1143173_P_NODE_23957_length_275_cov_3.965347_g23931_i0 PRJNA1143173 23957 275 3.965347 10.90470425 Thermoproteota archaeon 2056631 Archaea Archaea 120 1.83e-29   NR RDJ35440.1 2056631 g23931 i0 65.9 0.992727272727273 91 31 99.3 0 275 3 335 425 RDJ35440.1 MAG: hypothetical protein DWQ19_11535 [Thermoproteota archaeon] diamond 273 120 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32188581 32188581 PRJNA1143173_P_NODE_36858_length_237_cov_7.810976_g36832_i0 PRJNA1143173 36858 237 7.810976 18.51201312 Thermoproteota archaeon 2056631 Archaea Archaea 103 1.7799999999999995e-23   NR RDJ35651.1 2056631 g36832 i0 53.8 0.987341772151899 78 35 98.7 1 3 236 59 135 RDJ35651.1 MAG: hypothetical protein DWQ19_12600 [Thermoproteota archaeon] diamond 234 103 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32346958 32346958 PRJNA1143173_P_NODE_25339_length_271_cov_4.424242_g25313_i0 PRJNA1143173 25339 271 4.424242 11.98969582 Thermoproteota archaeon 2056631 Archaea Archaea 115 4.71e-28   NR RDJ35126.1 2056631 g25313 i0 58.9 0.996309963099631 90 37 99.6 0 270 1 236 325 RDJ35126.1 MAG: glycosyltransferase [Thermoproteota archaeon] diamond 270 115 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32505071 32505071 PRJNA1143173_P_NODE_32299_length_251_cov_4.095506_g32273_i0 PRJNA1143173 32299 251 4.095506 10.27972006 Thermoproteota archaeon 2056631 Archaea Archaea 43.1 0.00592   NR RDJ35272.1 2056631 g32273 i0 36.8 0.812749003984064 68 42 80.1 1 51 251 1 68 RDJ35272.1 MAG: hypothetical protein DWQ19_10685 [Thermoproteota archaeon] diamond 204 43.1 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32536751 32536751 PRJNA1143173_P_NODE_4279_length_408_cov_7.000000_g4253_i0 PRJNA1143173 4279 408 7 28.56 Candidatus Bathyarchaeia archaeon 3045160 Archaea Archaea 72.8 7.32e-12   NR HUU53136.1 3045160 g4253 i0 33.1 1.06617647058824 145 61 80.1 4 27 353 264 408 HUU53136.1 2'-5' RNA ligase family protein [Candidatus Bathyarchaeia archaeon] diamond 435 72.8 1 Archaea   Thermoproteati Candidatus Bathyarchaeota Candidatus Bathyarchaeia       Candidatus Bathyarchaeia 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);;