RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "diamond", bioproject = "PRJNA315399" and tax_phylum = "Phixviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Phixviricota · 35 ✖

tax_kingdom 1

bioproject 1

  • PRJNA315399 · 35 ✖

analysis 1

  • diamond · 35 ✖

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
4211905 4211905 PRJNA315399_S_NODE_163564_length_157_cov_5.200000_g163363_i0 PRJNA315399 163564 157 5.2 8.164 Sedum sarmentosum microvirus 2740151 Viruses Viruses 73.9 1.07e-13   NR QKI28950.1 2740151 g163363 i0 69.6 0.878980891719745 46 14 87.9 0 13 150 78 123 QKI28950.1 VP4 [Sedum sarmentosum microvirus] diamond 138 73.9 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Sedum sarmentosum microvirus
26789762 26789762 PRJNA315399_S_NODE_67521_length_198_cov_3.248447_g67320_i0 PRJNA315399 67521 198 3.248447 6.43192506 Microvirus sp. 2202559 Viruses Viruses 44.3 0.00367   NR QJB21202.1 2202559 g67320 i0 56.7 0.909090909090909 30 13 45.5 0 196 107 104 133 QJB21202.1 MAG: hypothetical protein [Microvirus sp.] diamond 180 44.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
26838947 26838947 PRJNA315399_S_NODE_77061_length_191_cov_3.454545_g76860_i0 PRJNA315399 77061 191 3.454545 6.59818095 Viruses 10239 Viruses Viruses 79 2.68e-15   NR QJB21242.1 2202559 g76860 i0 60 2.89005235602094 60 24 94.2 0 10 189 131 190 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 552 79 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
27074440 27074440 PRJNA315399_S_NODE_3362_length_502_cov_5.397849_g3180_i0 PRJNA315399 3362 502 5.397849 27.09720198 Microvirus sp. 2202559 Viruses Viruses 74.3 2.07e-14   NR QJB21244.1 2202559 g3180 i0 71.4 0.585657370517928 49 14 29.3 0 234 380 1 49 QJB21244.1 MAG: hypothetical protein [Microvirus sp.] diamond 294 74.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
27169037 27169037 PRJNA315399_S_NODE_134422_length_165_cov_5.296875_g134221_i0 PRJNA315399 134422 165 5.296875 8.73984375 Microvirus sp. 2202559 Viruses Viruses 48.9 8.76e-5   NR QJB21227.1 2202559 g134221 i0 52.4 0.763636363636364 42 20 76.4 0 150 25 306 347 QJB21227.1 MAG: DNA pilot protein [Microvirus sp.] diamond 126 48.9 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
27281650 27281650 PRJNA315399_S_NODE_74923_length_192_cov_8.645161_g74722_i0 PRJNA315399 74923 192 8.645161 16.59870912 Microvirus 10842 Viruses Viruses 43.5 0.00985   NR XHH71840.1 3343847 g74722 i0 39.5 1.328125 43 26 67.2 0 39 167 9 51 XHH71840.1 DNA pilot protein [bajarodmic virus 1041] diamond 255 43.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae Microvirus bajarodmic virus 1041
27548391 27548391 PRJNA315399_S_NODE_94504_length_181_cov_3.437500_g94303_i0 PRJNA315399 94504 181 3.4375 6.221875 Microvirus D_HF4_162 3071176 Viruses Viruses 47.4 3.82e-4   NR WMC01471.1 3071176 g94303 i0 55.8 0.712707182320442 43 18 69.6 1 22 147 173 215 WMC01471.1 replication initiator protein [Microvirus D_HF4_162] diamond 129 47.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus D_HF4_162
27832530 27832530 PRJNA315399_S_NODE_63284_length_201_cov_6.823171_g63083_i0 PRJNA315399 63284 201 6.823171 13.71457371 Microvirus sp. 2202559 Viruses Viruses 68.9 1.54e-12   NR QJB21229.1 2202559 g63083 i0 52.6 1.70149253731343 57 27 85.1 0 188 18 77 133 QJB21229.1 MAG: hypothetical protein [Microvirus sp.] diamond 342 68.9 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
28022190 28022190 PRJNA315399_S_NODE_37825_length_232_cov_3.610256_g37624_i0 PRJNA315399 37825 232 3.610256 8.37579392 Microvirus sp. 2202559 Viruses Viruses 61.6 1.56e-9   NR QJB21229.1 2202559 g37624 i0 54.9 0.65948275862069 51 23 65.9 0 223 71 83 133 QJB21229.1 MAG: hypothetical protein [Microvirus sp.] diamond 153 61.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
28179576 28179576 PRJNA315399_P_NODE_264706_length_181_cov_2.312500_g264258_i0 PRJNA315399 264706 181 2.3125 4.185625 Microvirus D_HF4_162 3071176 Viruses Viruses 54.3 1.3e-6   NR WMC01471.1 3071176 g264258 i0 41.3 1.32596685082873 80 17 82.9 1 18 167 119 198 WMC01471.1 replication initiator protein [Microvirus D_HF4_162] diamond 240 54.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus D_HF4_162
28842770 28842770 PRJNA315399_S_NODE_155448_length_159_cov_5.590164_g155247_i0 PRJNA315399 155448 159 5.590164 8.88836076 Microvirus sp. 2202559 Viruses Viruses 64.7 2.57e-12   NR QJB21244.1 2202559 g155247 i0 72.7 2.45283018867925 44 12 83 0 143 12 8 51 QJB21244.1 MAG: hypothetical protein [Microvirus sp.] diamond 390 64.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
29064094 29064094 PRJNA315399_S_NODE_42248_length_225_cov_2.781915_g42047_i0 PRJNA315399 42248 225 2.781915 6.25930875 Microvirus sp. 2202559 Viruses Viruses 91.3 1.45e-19   NR QJB21242.1 2202559 g42047 i0 65.6 0.853333333333333 64 22 85.3 0 221 30 242 305 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 192 91.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
29316521 29316521 PRJNA315399_P_NODE_470269_length_154_cov_3.111111_g469821_i0 PRJNA315399 470269 154 3.111111 4.79111094 Microvirus sp. 2202559 Viruses Viruses 53.9 1.09e-6   NR WNK13711.1 2202559 g469821 i0 57.8 0.876623376623377 45 19 87.7 0 148 14 146 190 WNK13711.1 MAG: DNA pilot protein [Microvirus sp.] diamond 135 53.9 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
29411177 29411177 PRJNA315399_S_NODE_29409_length_249_cov_10.580189_g29208_i0 PRJNA315399 29409 249 10.580189 26.34467061 Sedum sarmentosum microvirus 2740151 Viruses Viruses 113 1.24e-27   NR QKI28950.1 2740151 g29208 i0 65.4 0.939759036144578 78 27 94 0 4 237 34 111 QKI28950.1 VP4 [Sedum sarmentosum microvirus] diamond 234 113 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Sedum sarmentosum microvirus
30074281 30074281 PRJNA315399_S_NODE_159232_length_158_cov_5.917355_g159031_i0 PRJNA315399 159232 158 5.917355 9.3494209 Sedum sarmentosum microvirus 2740151 Viruses Viruses 53.1 2.47e-6   NR QKI28952.1 2740151 g159031 i0 52.5 0.759493670886076 40 19 75.9 0 20 139 483 522 QKI28952.1 VP1 [Sedum sarmentosum microvirus] diamond 120 53.1 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Sedum sarmentosum microvirus
30200593 30200593 PRJNA315399_S_NODE_160412_length_158_cov_3.305785_g160211_i0 PRJNA315399 160412 158 3.305785 5.2231403 Microviridae sp. 2202644 Viruses Viruses 46.2 6.58e-4   NR DAT28393.1 2202644 g160211 i0 45.6 1.08227848101266 57 23 96.8 2 2 154 26 80 DAT28393.1 MAG TPA: DNA pilot protein VP2 [Microviridae sp.] diamond 171 46.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
30674685 30674685 PRJNA315399_S_NODE_198373_length_150_cov_2.389381_g198172_i0 PRJNA315399 198373 150 2.389381 3.5840715 Microvirus sp. 2202559 Viruses Viruses 50.4 2.02e-5   NR QJB21242.1 2202559 g198172 i0 62.5 1.6 40 15 80 0 16 135 247 286 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 240 50.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30706264 30706264 PRJNA315399_S_NODE_19034_length_284_cov_6.157895_g18833_i0 PRJNA315399 19034 284 6.157895 17.4884218 Microvirus sp. 2202559 Viruses Viruses 96.7 3.39e-21   NR QJB21242.1 2202559 g18833 i0 56.1 0.866197183098592 82 36 86.6 0 271 26 274 355 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 246 96.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30769602 30769602 PRJNA315399_P_NODE_29814_length_272_cov_2.357447_g29369_i0 PRJNA315399 29814 272 2.357447 6.41225584 Sedum sarmentosum microvirus 2740151 Viruses Viruses 122 7.849999999999999e-31   NR QKI28950.1 2740151 g29369 i0 60.2 0.970588235294118 88 35 97.1 0 1 264 28 115 QKI28950.1 VP4 [Sedum sarmentosum microvirus] diamond 264 122 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Sedum sarmentosum microvirus
30769624 30769624 PRJNA315399_P_NODE_46494_length_242_cov_5.824390_g46046_i0 PRJNA315399 46494 242 5.82439 14.0950238 Microviridae sp. 2202644 Viruses Viruses 76.6 2.95e-14   NR WAE43659.1 2202644 g46046 i0 51.4 0.892561983471074 72 32 89.3 1 222 7 253 321 WAE43659.1 MAG: replication initiator protein [Microviridae sp.] diamond 216 76.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
30801029 30801029 PRJNA315399_S_NODE_109694_length_174_cov_3.708029_g109493_i0 PRJNA315399 109694 174 3.708029 6.45197046 Microvirus sp. 2202559 Viruses Viruses 49.3 3.68e-5   NR QJB21229.1 2202559 g109493 i0 76 0.948275862068966 25 6 43.1 0 141 67 110 134 QJB21229.1 MAG: hypothetical protein [Microvirus sp.] diamond 165 49.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30864218 30864218 PRJNA315399_P_NODE_49794_length_238_cov_3.895522_g49346_i0 PRJNA315399 49794 238 3.895522 9.27134236 Microvirus sp. 2202559 Viruses Viruses 67.4 6.78e-11   NR QJB21242.1 2202559 g49346 i0 62.5 0.705882352941177 56 21 70.6 0 56 223 231 286 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 168 67.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30896069 30896069 PRJNA315399_P_NODE_497714_length_151_cov_5.228070_g497266_i0 PRJNA315399 497714 151 5.22807 7.8943857 Microvirus sp. 2202559 Viruses Viruses 71.2 5.75e-15   NR QJB21191.1 2202559 g497266 i0 79.5 2.60264900662252 44 9 87.4 0 137 6 5 48 QJB21191.1 MAG: hypothetical protein [Microvirus sp.] diamond 393 71.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
31338313 31338313 PRJNA315399_P_NODE_89356_length_206_cov_4.337278_g88908_i0 PRJNA315399 89356 206 4.337278 8.93479268 Microvirus sp. 2202559 Viruses Viruses 68.9 1.24e-11   NR QJB21242.1 2202559 g88908 i0 57.1 1.9368932038835 56 24 81.6 0 206 39 137 192 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 399 68.9 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
31401888 31401888 PRJNA315399_S_NODE_64816_length_200_cov_4.134969_g64615_i0 PRJNA315399 64816 200 4.134969 8.269938 Microvirus sp. 2202559 Viruses Viruses 64.3 4.98e-10   NR QJB21242.1 2202559 g64615 i0 53.2 1.74 62 26 93 1 200 15 137 195 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 348 64.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
31591604 31591604 PRJNA315399_P_NODE_410696_length_160_cov_6.032520_g410248_i0 PRJNA315399 410696 160 6.03252 9.652032 Microvirus sp. 2202559 Viruses Viruses 48.9 4.2e-5   NR QJB21202.1 2202559 g410248 i0 62.5 0.6 32 12 60 0 160 65 102 133 QJB21202.1 MAG: hypothetical protein [Microvirus sp.] diamond 96 48.9 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
31812849 31812849 PRJNA315399_P_NODE_97897_length_202_cov_4.927273_g97449_i0 PRJNA315399 97897 202 4.927273 9.95309146 Microvirus sp. 2202559 Viruses Viruses 77.8 7.9e-15   NR QJB21242.1 2202559 g97449 i0 67.3 0.816831683168317 55 18 81.7 0 15 179 251 305 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 165 77.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
31939274 31939274 PRJNA315399_S_NODE_125597_length_168_cov_4.290076_g125396_i0 PRJNA315399 125597 168 4.290076 7.20732768 Microviridae sp. 2202644 Viruses Viruses 52.4 5.5e-6   NR DAU29216.1 2202644 g125396 i0 40.4 1.01785714285714 57 28 91.1 1 10 162 157 213 DAU29216.1 MAG TPA: Major capsid protein [Microviridae sp.] diamond 171 52.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
32002717 32002717 PRJNA315399_S_NODE_114878_length_172_cov_3.407407_g114677_i0 PRJNA315399 114878 172 3.407407 5.86074004 Microvirus sp. 2202559 Viruses Viruses 68.6 9.43e-14   NR QJB21244.1 2202559 g114677 i0 75.6 2.3546511627907 45 11 78.5 0 136 2 1 45 QJB21244.1 MAG: hypothetical protein [Microvirus sp.] diamond 405 68.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
32224180 32224180 PRJNA315399_P_NODE_138938_length_190_cov_5.627451_g138490_i0 PRJNA315399 138938 190 5.627451 10.6921569 Microvirus sp. 2202559 Viruses Viruses 50.8 2.55e-5   NR QJB21242.1 2202559 g138490 i0 46.7 0.947368421052632 60 32 94.7 0 189 10 210 269 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 180 50.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
32224264 32224264 PRJNA315399_S_NODE_186658_length_152_cov_4.356522_g186457_i0 PRJNA315399 186658 152 4.356522 6.62191344 Microvirus sp. 2202559 Viruses Viruses 55.5 3.44e-7   NR QJB21242.1 2202559 g186457 i0 53.2 0.927631578947368 47 22 92.8 0 141 1 282 328 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 141 55.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
32414108 32414108 PRJNA315399_S_NODE_109599_length_174_cov_3.963504_g109398_i0 PRJNA315399 109599 174 3.963504 6.89649696 Microvirus sp. 2202559 Viruses Viruses 60.8 6.11e-9   NR QJB21239.1 2202559 g109398 i0 46.8 1.62068965517241 47 25 81 0 31 171 61 107 QJB21239.1 MAG: major capsid protein [Microvirus sp.] diamond 282 60.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
32445875 32445875 PRJNA315399_S_NODE_33519_length_240_cov_5.463054_g33318_i0 PRJNA315399 33519 240 5.463054 13.1113296 Microvirus sp. 2202559 Viruses Viruses 91.3 1.84e-19   NR QJB21242.1 2202559 g33318 i0 66.7 0.7875 63 21 78.8 0 19 207 243 305 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 189 91.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
32540841 32540841 PRJNA315399_S_NODE_35479_length_236_cov_5.482412_g35278_i0 PRJNA315399 35479 236 5.482412 12.93849232 Microvirus sp. 2202559 Viruses Viruses 110 1.8e-26   NR QJB21242.1 2202559 g35278 i0 65.7 0.889830508474576 70 24 89 0 27 236 110 179 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 210 110 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
32792349 32792349 PRJNA315399_S_NODE_192520_length_151_cov_3.035088_g192319_i0 PRJNA315399 192520 151 3.035088 4.58298288 Microvirus sp. 2202559 Viruses Viruses 41.6 0.0265   NR QJB21242.1 2202559 g192319 i0 53.3 0.596026490066225 30 14 59.6 0 21 110 318 347 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 90 41.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.

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