RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax_phylum = "Preplasmiviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Preplasmiviricota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJEB11748 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
16596725 16596725 PRJEB11748_P_NODE_68034_length_512_cov_11.937916_g65889_i0 PRJEB11748 68034 512 11.937916 61.12212992 Thermus phage phiKo 2301535 Viruses Viruses 127 7.4e-35   NR AYJ74693.1 2301535 g65889 i0 84.7 0.421875 72 11 42.2 0 495 280 1 72 AYJ74693.1 hypothetical protein phiKo_18 [Thermus phage phiKo] diamond 216 127 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
27285755 27285755 PRJEB11748_P_NODE_332343_length_205_cov_5.916667_g330160_i0 PRJEB11748 332343 205 5.916667 12.12916735 Thermus phage phiKo 2301535 Viruses Viruses 48.5 6.8e-5   NR AYJ74679.1 2301535 g330160 i0 53.7 0.6 41 19 60 0 12 134 27 67 AYJ74679.1 hypothetical protein phiKo_04 [Thermus phage phiKo] diamond 123 48.5 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
28201350 28201350 PRJEB11748_P_NODE_353606_length_196_cov_2.607407_g351423_i0 PRJEB11748 353606 196 2.607407 5.11051772 Thermus phage phiKo 2301535 Viruses Viruses 50.8 8.17e-6   NR AYJ74679.1 2301535 g351423 i0 46 0.76530612244898 50 27 76.5 0 183 34 13 62 AYJ74679.1 hypothetical protein phiKo_04 [Thermus phage phiKo] diamond 150 50.8 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
28706817 28706817 PRJEB11748_P_NODE_33067_length_766_cov_45.060993_g31178_i0 PRJEB11748 33067 766 45.060993 345.16720638 Thermus phage phiKo 2301535 Viruses Viruses 67 2.73e-10   NR AYJ74683.1 2301535 g31178 i0 46.9 0.37597911227154 96 46 36.4 3 192 470 8 101 AYJ74683.1 hypothetical protein phiKo_08 [Thermus phage phiKo] diamond 288 67 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
29180356 29180356 PRJEB11748_P_NODE_11489_length_1407_cov_40.242199_g10399_i0 PRJEB11748 11489 1407 40.242199 566.20773993 Thermus phage phiKo 2301535 Viruses Viruses 77.8 4.87e-13   NR AYJ74679.1 2301535 g10399 i0 45 0.213219616204691 100 51 20.7 4 2 292 44 142 AYJ74679.1 hypothetical protein phiKo_04 [Thermus phage phiKo] diamond 300 77.8 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
29180541 29180541 PRJEB11748_P_NODE_342869_length_201_cov_4.942857_g340686_i0 PRJEB11748 342869 201 4.942857 9.93514257 Lake Baikal virophage 4 3086127 Viruses Viruses 59.3 2e-8   NR WPF46508.1 3086127 g340686 i0 59.3 3.13432835820896 54 22 80.6 0 174 13 6 59 WPF46508.1 MAG: hypothetical protein [Lake Baikal virophage 4] diamond 630 59.3 1 Viruses   Bamfordvirae Preplasmiviricota Virophaviricetes Priklausovirales Lavidaviridae   Lake Baikal virophage 4
29338219 29338219 PRJEB11748_P_NODE_26889_length_865_cov_91.267588_g25152_i0 PRJEB11748 26889 865 91.267588 789.4646362 Thermus phage phiKo 2301535 Viruses Viruses 199 1.6400000000000002e-58   NR AYJ74696.1 2301535 g25152 i0 44.8 0.936416184971098 270 131 92.3 7 67 864 10 265 AYJ74696.1 hypothetical protein phiKo_21 [Thermus phage phiKo] diamond 810 199 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
29653594 29653594 PRJEB11748_P_NODE_37390_length_716_cov_11.755725_g35413_i0 PRJEB11748 37390 716 11.755725 84.170991 Thermus phage phiKo 2301535 Viruses Viruses 94.4 1.57e-20   NR AYJ74698.1 2301535 g35413 i0 41.7 0.553072625698324 132 62 52 6 142 513 3 127 AYJ74698.1 hypothetical protein phiKo_23 [Thermus phage phiKo] diamond 396 94.4 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
30001480 30001480 PRJEB11748_P_NODE_320251_length_210_cov_3.812081_g318068_i0 PRJEB11748 320251 210 3.812081 8.0053701 Thermus phage phiKo 2301535 Viruses Viruses 70.5 5.41e-13   NR AYJ74680.1 2301535 g318068 i0 52.5 0.842857142857143 59 27 84.3 1 9 185 65 122 AYJ74680.1 hypothetical protein phiKo_05 [Thermus phage phiKo] diamond 177 70.5 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
30190717 30190717 PRJEB11748_P_NODE_203952_length_280_cov_6.703196_g201769_i0 PRJEB11748 203952 280 6.703196 18.7689488 Thermus phage phiKo 2301535 Viruses Viruses 41.2 0.0292   NR AYJ74697.1 2301535 g201769 i0 40.7 0.578571428571429 54 30 55.7 1 120 275 19 72 AYJ74697.1 hypothetical protein phiKo_22 [Thermus phage phiKo] diamond 162 41.2 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
30317869 30317869 PRJEB11748_P_NODE_43912_length_652_cov_62.287648_g41842_i0 PRJEB11748 43912 652 62.287648 406.11546496 Thermus phage phiKo 2301535 Viruses Viruses 215 4.14e-67   NR AYJ74689.1 2301535 g41842 i0 66 0.717791411042945 156 50 70.9 2 161 622 46 200 AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo] diamond 468 215 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
30412270 30412270 PRJEB11748_P_NODE_16753_length_1139_cov_42.545455_g15394_i0 PRJEB11748 16753 1139 42.545455 484.59273245 Thermus phage phiKo 2301535 Viruses Viruses 205 2.8599999999999997e-61   NR AYJ74680.1 2301535 g15394 i0 57.1 0.466198419666374 177 70 46.1 3 415 939 6 178 AYJ74680.1 hypothetical protein phiKo_05 [Thermus phage phiKo] diamond 531 205 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
30664865 30664865 PRJEB11748_P_NODE_385913_length_175_cov_5.675439_g383730_i0 PRJEB11748 385913 175 5.675439 9.93201825 Thermus phage phiKo 2301535 Viruses Viruses 44.7 2.43e-4   NR AYJ74684.1 2301535 g383730 i0 57.9 0.651428571428571 38 16 65.1 0 156 43 13 50 AYJ74684.1 hypothetical protein phiKo_09 [Thermus phage phiKo] diamond 114 44.7 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
30791263 30791263 PRJEB11748_P_NODE_68474_length_510_cov_79.559020_g66329_i0 PRJEB11748 68474 510 79.55902 405.751002 Thermus phage phiKo 2301535 Viruses Viruses 61.2 2.84e-8   NR AYJ74682.1 2301535 g66329 i0 56.9 0.341176470588235 58 21 31.8 2 178 339 102 159 AYJ74682.1 peptidase [Thermus phage phiKo] diamond 174 61.2 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
31170109 31170109 PRJEB11748_P_NODE_306875_length_216_cov_3.574194_g304692_i0 PRJEB11748 306875 216 3.574194 7.72025904 Thermus phage phiKo 2301535 Viruses Viruses 55.1 1.05e-6   NR AYJ74696.1 2301535 g304692 i0 41.2 1.88888888888889 68 39 94.4 1 6 209 147 213 AYJ74696.1 hypothetical protein phiKo_21 [Thermus phage phiKo] diamond 408 55.1 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
31676210 31676210 PRJEB11748_P_NODE_237357_length_255_cov_2.561856_g235174_i0 PRJEB11748 237357 255 2.561856 6.5327328 Thermus phage phiKo 2301535 Viruses Viruses 92 6.290000000000001e-21   NR AYJ74689.1 2301535 g235174 i0 63.8 0.811764705882353 69 23 78.8 1 247 47 124 192 AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo] diamond 207 92 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
32277558 32277558 PRJEB11748_P_NODE_118039_length_382_cov_5.006231_g115864_i0 PRJEB11748 118039 382 5.006231 19.12380242 Thermus phage phiKo 2301535 Viruses Viruses 56.6 3.92e-7   NR AYJ74679.1 2301535 g115864 i0 40.7 0.636125654450262 81 38 58.9 2 364 140 14 90 AYJ74679.1 hypothetical protein phiKo_04 [Thermus phage phiKo] diamond 243 56.6 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
32277682 32277682 PRJEB11748_P_NODE_29099_length_825_cov_56.654450_g25152_i1 PRJEB11748 29099 825 56.65445 467.3992125 Thermus phage phiKo 2301535 Viruses Viruses 172 6.07e-48   NR AYJ74696.1 2301535 g25152 i1 49.7 0.709090909090909 195 93 70.9 2 586 2 76 265 AYJ74696.1 hypothetical protein phiKo_21 [Thermus phage phiKo] diamond 585 172 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
32309449 32309449 PRJEB11748_P_NODE_291799_length_223_cov_8.629630_g289616_i0 PRJEB11748 291799 223 8.62963 19.2440749 Thermus phage phiKo 2301535 Viruses Viruses 56.2 9.25e-8   NR AYJ74679.1 2301535 g289616 i0 50.9 0.739910313901345 55 26 72.6 1 57 218 1 55 AYJ74679.1 hypothetical protein phiKo_04 [Thermus phage phiKo] diamond 165 56.2 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
32593884 32593884 PRJEB11748_P_NODE_29480_length_819_cov_23.581794_g27671_i0 PRJEB11748 29480 819 23.581794 193.13489286 Thermus phage phiKo 2301535 Viruses Viruses 127 1.7e-33   NR AYJ74693.1 2301535 g27671 i0 84.7 0.263736263736264 72 11 26.4 0 802 587 1 72 AYJ74693.1 hypothetical protein phiKo_18 [Thermus phage phiKo] diamond 216 127 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
32845470 32845470 PRJEB11748_P_NODE_106180_length_404_cov_100.766764_g66329_i1 PRJEB11748 106180 404 100.766764 407.09772656 Thermus phage phiKo 2301535 Viruses Viruses 59.3 6.03e-8   NR AYJ74682.1 2301535 g66329 i1 55.2 0.430693069306931 58 22 40.1 2 227 66 102 159 AYJ74682.1 peptidase [Thermus phage phiKo] diamond 174 59.3 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo

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);;