RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJEB14175" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14175 · 18 ✖

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
25510389 25510389 PRJEB14175_P_NODE_57081_length_492_cov_4.320186_g54831_i0 PRJEB14175 57081 492 4.320186 21.25531512 uncultured crenarchaeote 29281 Archaea Archaea 852 0   NTclustered gi|42557759|emb|AJ627422.1| 29281 g54831 i0 99.362 92.760162601626 470 3 96 0 1 470 42969 42500 Uncultured crenarchaeote genomic fragment 54d9 blastn 45638 852 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
25773157 25773157 PRJEB14175_P_NODE_104747_length_347_cov_70.727273_g102481_i0 PRJEB14175 104747 347 70.727273 245.42363731 uncultured crenarchaeote 29281 Archaea Archaea 387 7.93e-103   NTclustered gi|146262968|gb|EF414271.1| 29281 g102481 i0 88.58 133.994236311239 324 30 93 6 1 324 519 203 Uncultured crenarchaeote clone BS80e2H5 putative amoA protein-like (amoA) mRNA, partial sequence blastn 46496 387 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
25775114 25775114 PRJEB14175_P_NODE_143619_length_284_cov_44.807175_g141352_i0 PRJEB14175 143619 284 44.807175 127.252377 uncultured crenarchaeote 29281 Archaea Archaea 298 3.05e-76   NTclustered gi|22797874|emb|AJ496176.1| 29281 g141352 i0 87.405 55.9401408450704 262 30 92 3 25 284 6166 6426 Uncultured crenarchaeote 34 kb genomic fragment blastn 15887 298 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
25782304 25782304 PRJEB14175_P_NODE_54411_length_504_cov_32.214447_g52165_i0 PRJEB14175 54411 504 32.214447 162.36081288 uncultured crenarchaeote 29281 Archaea Archaea 490 8.81e-134   NTclustered gi|42557759|emb|AJ627422.1| 29281 g52165 i0 85.386 79.3333333333333 479 62 95 8 1 477 40844 40372 Uncultured crenarchaeote genomic fragment 54d9 blastn 39984 490 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
25915510 25915510 PRJEB14175_P_NODE_241252_length_205_cov_6.402778_g238984_i0 PRJEB14175 241252 205 6.402778 13.1256949 uncultured crenarchaeote 29281 Archaea Archaea 329 7.39e-86   NTclustered gi|42557759|emb|AJ627422.1| 29281 g238984 i0 98.396 58.2292682926829 187 3 91 0 1 187 40548 40362 Uncultured crenarchaeote genomic fragment 54d9 blastn 11937 329 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
26189951 26189951 PRJEB14175_P_NODE_41638_length_578_cov_4.912959_g39433_i0 PRJEB14175 41638 578 4.912959 28.39690302 uncultured crenarchaeote 29281 Archaea Archaea 931 0   NTclustered gi|42557759|emb|AJ627422.1| 29281 g39433 i0 96.937 33.401384083045 555 17 96 0 24 578 40490 41044 Uncultured crenarchaeote genomic fragment 54d9 blastn 19306 931 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
26324196 26324196 PRJEB14175_P_NODE_258599_length_201_cov_1.214286_g256331_i0 PRJEB14175 258599 201 1.214286 2.44071486 uncultured crenarchaeote 29281 Archaea Archaea 335 1.5499999999999995e-87   NTclustered gi|22797874|emb|AJ496176.1| 29281 g256331 i0 98.421 20.7960199004975 190 3 95 0 1 190 8810 8621 Uncultured crenarchaeote 34 kb genomic fragment blastn 4180 335 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
26562959 26562959 PRJEB14175_P_NODE_43856_length_563_cov_11.561753_g41642_i0 PRJEB14175 43856 563 11.561753 65.09266939 Archaea 2157 Archaea Archaea 915 0   NTclustered gi|42557759|emb|AJ627422.1| 29281 g41642 i0 97.222 78.9378330373002 540 15 96 0 22 561 41488 42027 Uncultured crenarchaeote genomic fragment 54d9 blastn 44442 924 0.99025974025974 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
26563179 26563179 PRJEB14175_P_NODE_54280_length_505_cov_7.042793_g52034_i0 PRJEB14175 54280 505 7.042793 35.56610465 Thermoproteati 1783275 Archaea Archaea 678 0   NTclustered gi|22797874|emb|AJ496176.1| 29281 g52034 i0 91.054 104.556435643564 503 44 99 1 3 505 7391 6890 Uncultured crenarchaeote 34 kb genomic fragment blastn 52801 684 0.991228070175439 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
32908859 32908859 PRJEB14175_P_NODE_178897_length_246_cov_1.340541_g176630_i0 PRJEB14175 178897 246 1.340541 3.29773086 Thermoproteota archaeon 2056631 Archaea Archaea 171 1.1e-49   NR MDP9306352.1 2056631 g176630 i0 98.8 2 82 1 100 0 246 1 246 327 MDP9306352.1 tRNA pseudouridine(13) synthase TruD [Thermoproteota archaeon] diamond 492 171 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32943272 32943272 PRJEB14175_P_NODE_192954_length_234_cov_1.109827_g190687_i0 PRJEB14175 192954 234 1.109827 2.59699518 Thermoproteota archaeon 2056631 Archaea Archaea 156 5.76e-46   NR MDP9306257.1 2056631 g190687 i0 98.7 0.987179487179487 77 1 98.7 0 232 2 39 115 MDP9306257.1 S4 domain-containing protein [Thermoproteota archaeon] diamond 231 156 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32956922 32956922 PRJEB14175_P_NODE_220858_length_213_cov_1.657895_g218590_i0 PRJEB14175 220858 213 1.657895 3.53131635 Thermoproteati 1783275 Archaea Archaea 48.5 2.24e-4   NR MEM0172469.1 2056631 g218590 i0 43.9 2.83098591549296 66 30 93 2 209 12 150 208 MEM0172469.1 GH25 family lysozyme [Thermoproteota archaeon] diamond 603 48.5 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
32995827 32995827 PRJEB14175_P_NODE_96595_length_365_cov_7.476974_g94329_i0 PRJEB14175 96595 365 7.476974 27.2909551 Thermoproteota archaeon 2056631 Archaea Archaea 148 8.119999999999997e-42   NR NLE03613.1 2056631 g94329 i0 68.8 0.895890410958904 109 34 89.6 0 18 344 73 181 NLE03613.1 hypothetical protein [Thermoproteota archaeon] diamond 327 148 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33042330 33042330 PRJEB14175_P_NODE_85444_length_393_cov_2.912651_g83179_i0 PRJEB14175 85444 393 2.912651 11.44671843 Thermoproteati 1783275 Archaea Archaea 158 5.329999999999998e-47   NR MDP9498899.1 2056631 g83179 i0 90.2 1.87786259541985 82 8 62.6 0 141 386 1 82 MDP9498899.1 hypothetical protein [Thermoproteota archaeon] diamond 738 158 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33113262 33113262 PRJEB14175_P_NODE_130191_length_303_cov_21.074380_g127924_i0 PRJEB14175 130191 303 21.07438 63.8553714 Ignisphaera sp. 2268142 Archaea Archaea 64.7 1.37e-9   NR MCI4435416.1 2268142 g127924 i0 63 0.881188118811881 46 16 45.5 1 153 290 393 437 MCI4435416.1 hypothetical protein [Ignisphaera sp.] diamond 267 64.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Desulfurococcales Desulfurococcaceae Ignisphaera Ignisphaera sp.
33131669 33131669 PRJEB14175_P_NODE_268687_length_191_cov_7.269231_g266419_i0 PRJEB14175 268687 191 7.2692310000000004 13.88423121 Thermoproteota archaeon 2056631 Archaea Archaea 102 9.49e-26   NR MEM3368534.1 2056631 g266419 i0 96.4 0.879581151832461 56 2 88 0 2 169 92 147 MEM3368534.1 hypothetical protein [Thermoproteota archaeon] diamond 168 102 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33147188 33147188 PRJEB14175_P_NODE_101568_length_354_cov_5.163823_g99302_i0 PRJEB14175 101568 354 5.163823 18.27993342 Thermoproteota archaeon 2056631 Archaea Archaea 201 9.46e-64   NR MDP9305585.1 2056631 g99302 i0 91.9 0.940677966101695 111 9 94.1 0 22 354 47 157 MDP9305585.1 cob(I)yrinic acid a,c-diamide adenosyltransferase [Thermoproteota archaeon] diamond 333 201 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
33147455 33147455 PRJEB14175_P_NODE_128288_length_306_cov_7.020408_g126021_i0 PRJEB14175 128288 306 7.020408 21.48244848 Thermoproteota archaeon 2056631 Archaea Archaea 154 2.75e-41   NR MDQ3869313.1 2056631 g126021 i0 83.2 1.86274509803922 95 16 93.1 0 21 305 321 415 MDQ3869313.1 SMC family ATPase [Thermoproteota archaeon] diamond 570 154 1 Archaea   Thermoproteati Thermoproteota         Thermoproteota 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);;