contig_metadata
23 rows where bioproject = "PRJEB64798" and tax_phylum = "Phixviricota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3954499 | 3954499 | PRJEB64798_P_NODE_238664_length_155_cov_11.377358_g236898_i0 | PRJEB64798 | 238664 | 155 | 11.377358 | 17.6349049 | Microviridae sp. | 2202644 | Viruses | Viruses | 207 | 2.57e-49 | NTclustered | gi|1444874594|gb|MH572428.1| | 2202644 | g236898 | i0 | 96.063 | 2.45806451612903 | 127 | 5 | 82 | 0 | 5 | 131 | 127 | 1 | Microviridae sp. isolate SD_MC_67, complete genome | blastn | 381 | 207 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 7780621 | 7780621 | PRJEB64798_P_NODE_222627_length_161_cov_8.946429_g220861_i0 | PRJEB64798 | 222627 | 161 | 8.946429 | 14.40375069 | Microviridae sp. | 2202644 | Viruses | Viruses | 100 | 4.71e-17 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g220861 | i0 | 95.385 | 2.91925465838509 | 65 | 0 | 39 | 2 | 72 | 133 | 2877 | 2813 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 470 | 100 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 11606043 | 11606043 | PRJEB64798_P_NODE_180710_length_174_cov_2.736000_g178944_i0 | PRJEB64798 | 180710 | 174 | 2.736 | 4.76064 | Arizlama microvirus | 2859450 | Viruses | Viruses | 213 | 6.35e-51 | NTclustered | gi|2067847856|gb|MW697594.1| | 2859450 | g178944 | i0 | 89.349 | 3.90804597701149 | 169 | 18 | 97 | 0 | 1 | 169 | 2409 | 2577 | MAG: Arizlama microvirus isolate AZLM_26073, complete genome | blastn | 680 | 213 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Arizlama microvirus | |||
| 14155625 | 14155625 | PRJEB64798_P_NODE_157252_length_185_cov_1.227941_g155486_i0 | PRJEB64798 | 157252 | 185 | 1.227941 | 2.27169085 | Capybara microvirus Cap3_SP_645 | 2585486 | Viruses | Viruses | 235 | 1.46e-57 | NTclustered | gi|1655475599|gb|MK496823.1| | 2585486 | g155486 | i0 | 90.11 | 0.983783783783784 | 182 | 16 | 97 | 1 | 1 | 180 | 3964 | 4145 | Capybara microvirus Cap3_SP_645, complete genome | blastn | 182 | 235 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Capybara microvirus Cap3_SP_645 | |||
| 15430284 | 15430284 | PRJEB64798_P_NODE_203193_length_166_cov_8.623932_g201427_i0 | PRJEB64798 | 203193 | 166 | 8.623932 | 14.31572712 | Microviridae sp. | 2202644 | Viruses | Viruses | 226 | 7.739999999999998e-55 | NTclustered | gi|1444874594|gb|MH572428.1| | 2202644 | g201427 | i0 | 91.925 | 1.93975903614458 | 161 | 13 | 97 | 0 | 6 | 166 | 3909 | 3749 | Microviridae sp. isolate SD_MC_67, complete genome | blastn | 322 | 226 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 16703415 | 16703415 | PRJEB64798_P_NODE_126474_length_200_cov_6.298013_g124708_i0 | PRJEB64798 | 126474 | 200 | 6.298013 | 12.596026 | Microviridae sp. | 2202644 | Viruses | Viruses | 86.1 | 1.71e-12 | NTclustered | gi|2057031176|tpg|BK049077.1| | 2202644 | g124708 | i0 | 85.366 | 1.4 | 82 | 12 | 41 | 0 | 1 | 82 | 1810 | 1891 | MAG TPA_asm: Microviridae sp. isolate ctomy2, partial genome | blastn | 280 | 86.1 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 17979232 | 17979232 | PRJEB64798_P_NODE_188855_length_171_cov_1.385246_g187089_i0 | PRJEB64798 | 188855 | 171 | 1.385246 | 2.36877066 | Microviridae sp. | 2202644 | Viruses | Viruses | 76.8 | 8.5e-10 | NTclustered | gi|2216802331|gb|MW202853.1| | 2202644 | g187089 | i0 | 90 | 10.812865497076 | 60 | 4 | 35 | 2 | 112 | 171 | 1075 | 1018 | Microviridae sp. isolate ctxHn541, complete genome | blastn | 1849 | 76.8 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 23079211 | 23079211 | PRJEB64798_P_NODE_158839_length_184_cov_2.370370_g157073_i0 | PRJEB64798 | 158839 | 184 | 2.37037 | 4.3614808 | Microviridae sp. | 2202644 | Viruses | Viruses | 243 | 8.67e-60 | NTclustered | gi|2302019702|gb|MT206132.1| | 2202644 | g157073 | i0 | 93.293 | 3.08695652173913 | 164 | 11 | 89 | 0 | 5 | 168 | 2818 | 2655 | MAG: Microviridae sp. isolate CN7_L17_105, complete genome | blastn | 568 | 243 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 23079573 | 23079573 | PRJEB64798_P_NODE_182219_length_173_cov_6.250000_g180453_i0 | PRJEB64798 | 182219 | 173 | 6.25 | 10.8125 | Microviridae sp. | 2202644 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|2302011513|gb|MT202826.1| | 2202644 | g180453 | i0 | 100 | 0.161849710982659 | 28 | 0 | 16 | 0 | 146 | 173 | 3433 | 3460 | MAG: Microviridae sp. isolate CN7_L15_494, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 27159959 | 27159959 | PRJEB64798_P_NODE_246122_length_153_cov_3.750000_g244356_i0 | PRJEB64798 | 246122 | 153 | 3.75 | 5.7375 | Microviridae sp. | 2202644 | Viruses | Viruses | 69.3 | 3.18e-12 | NR | AXH76119.1 | 2202644 | g244356 | i0 | 75 | 0.941176470588235 | 48 | 12 | 94.1 | 0 | 146 | 3 | 35 | 82 | AXH76119.1 MAG: DNA pilot protein [Microviridae sp.] | diamond | 144 | 69.3 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 28100609 | 28100609 | PRJEB64798_P_NODE_199045_length_167_cov_18.915254_g197279_i0 | PRJEB64798 | 199045 | 167 | 18.915254 | 31.58847418 | root | 1 | Root_unresolved | Root_unresolved | 47.8 | 2.27e-4 | NR | QJB19711.1 | 2202559 | g197279 | i0 | 55 | 1.34730538922156 | 40 | 18 | 71.9 | 0 | 2 | 121 | 118 | 157 | QJB19711.1 MAG: major capsid protein [Microvirus sp.] | diamond | 225 | 48.1 | 0.993762993762994 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 28265323 | 28265323 | PRJEB64798_P_NODE_179426_length_174_cov_11.512000_g177660_i0 | PRJEB64798 | 179426 | 174 | 11.512 | 20.03088 | Apis mellifera associated microvirus 49 | 2494779 | Viruses | Viruses | 51.6 | 1.02e-5 | NR | AZL82869.1 | 2494779 | g177660 | i0 | 65.5 | 0.982758620689655 | 29 | 10 | 50 | 0 | 57 | 143 | 1 | 29 | AZL82869.1 replication initiator protein [Apis mellifera associated microvirus 49] | diamond | 171 | 51.6 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Apis mellifera associated microvirus 49 | |||
| 28991971 | 28991971 | PRJEB64798_P_NODE_131728_length_197_cov_10.695946_g129962_i0 | PRJEB64798 | 131728 | 197 | 10.695946 | 21.07101362 | Microviridae sp. | 2202644 | Viruses | Viruses | 51.6 | 1.18e-5 | NR | AXH76516.1 | 2202644 | g129962 | i0 | 67.6 | 0.517766497461929 | 34 | 11 | 51.8 | 0 | 102 | 1 | 198 | 231 | AXH76516.1 MAG: DNA pilot protein [Microviridae sp.] | diamond | 102 | 51.6 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 29749230 | 29749230 | PRJEB64798_P_NODE_231711_length_158_cov_3.532110_g229945_i0 | PRJEB64798 | 231711 | 158 | 3.53211 | 5.5807338 | Arizlama microvirus | 2859450 | Viruses | Viruses | 93.2 | 1.61e-22 | NR | QXP08621.1 | 2859450 | g229945 | i0 | 86 | 2.86708860759494 | 50 | 7 | 94.9 | 0 | 6 | 155 | 41 | 90 | QXP08621.1 MAG: internal scaffolding protein [Arizlama microvirus] | diamond | 453 | 93.2 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Arizlama microvirus | |||
| 30318601 | 30318601 | PRJEB64798_P_NODE_117712_length_207_cov_12.715190_g115946_i0 | PRJEB64798 | 117712 | 207 | 12.71519 | 26.3204433 | Microviridae sp. | 2202644 | Viruses | Viruses | 84.7 | 3.49e-17 | NR | WXW90121.1 | 2202644 | g115946 | i0 | 71.7 | 1.56521739130435 | 53 | 15 | 76.8 | 0 | 160 | 2 | 442 | 494 | WXW90121.1 MAG: capsid protein [Microviridae sp.] | diamond | 324 | 84.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 30413143 | 30413143 | PRJEB64798_P_NODE_142513_length_192_cov_3.748252_g140747_i0 | PRJEB64798 | 142513 | 192 | 3.748252 | 7.19664384 | Microviridae sp. | 2202644 | Viruses | Viruses | 100 | 7.839999999999999e-23 | NR | AXH76777.1 | 2202644 | g140747 | i0 | 84.5 | 0.90625 | 58 | 8 | 90.6 | 1 | 177 | 4 | 363 | 419 | AXH76777.1 MAG: major capsid protein [Microviridae sp.] | diamond | 174 | 100 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 31202425 | 31202425 | PRJEB64798_P_NODE_64515_length_242_cov_3.295337_g62750_i0 | PRJEB64798 | 64515 | 242 | 3.295337 | 7.97471554 | Microvirus sp. | 2202559 | Viruses | Viruses | 136 | 3.8399999999999995e-37 | NR | QJB19245.1 | 2202559 | g62750 | i0 | 81 | 0.979338842975207 | 79 | 15 | 97.9 | 0 | 1 | 237 | 62 | 140 | QJB19245.1 MAG: replication initiator protein [Microvirus sp.] | diamond | 237 | 136 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 31360990 | 31360990 | PRJEB64798_P_NODE_119856_length_206_cov_8.394904_g118090_i0 | PRJEB64798 | 119856 | 206 | 8.394904 | 17.29350224 | Microviridae sp. | 2202644 | Viruses | Viruses | 48.5 | 1.98e-4 | NR | XOE95391.1 | 2202644 | g118090 | i0 | 65.8 | 0.553398058252427 | 38 | 13 | 55.3 | 0 | 2 | 115 | 67 | 104 | XOE95391.1 MAG: replication initiation protein [Microviridae sp.] | diamond | 114 | 48.5 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 31677112 | 31677112 | PRJEB64798_P_NODE_160077_length_183_cov_5.716418_g158311_i0 | PRJEB64798 | 160077 | 183 | 5.716418 | 10.46104494 | Ariapismic virus 59 | 3376564 | Viruses | Viruses | 52.8 | 2.43e-6 | NR | XJW04579.1 | 3376564 | g158311 | i0 | 56 | 1.70491803278689 | 50 | 22 | 82 | 0 | 178 | 29 | 71 | 120 | XJW04579.1 MAG: DNA pilot protein [Ariapismic virus 59] | diamond | 312 | 52.8 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Ariapismic virus 59 | |||
| 31803640 | 31803640 | PRJEB64798_P_NODE_231477_length_158_cov_4.091743_g229711_i0 | PRJEB64798 | 231477 | 158 | 4.091743 | 6.46495394 | Microviridae sp. | 2202644 | Viruses | Viruses | 52 | 6.21e-6 | NR | AXH78097.1 | 2202644 | g229711 | i0 | 57.8 | 0.854430379746835 | 45 | 19 | 85.4 | 0 | 154 | 20 | 282 | 326 | AXH78097.1 MAG: replication initiator protein [Microviridae sp.] | diamond | 135 | 52 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 32183541 | 32183541 | PRJEB64798_P_NODE_211258_length_164_cov_5.252174_g209492_i0 | PRJEB64798 | 211258 | 164 | 5.252174 | 8.61356536 | Microvirus sp. | 2202559 | Viruses | Viruses | 69.7 | 2.73e-12 | NR | QJB19664.1 | 2202559 | g209492 | i0 | 63.3 | 1.77439024390244 | 49 | 18 | 89.6 | 0 | 3 | 149 | 159 | 207 | QJB19664.1 MAG: replication initiator protein [Microvirus sp.] | diamond | 291 | 69.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 32246948 | 32246948 | PRJEB64798_P_NODE_108598_length_210_cov_9.844720_g106832_i0 | PRJEB64798 | 108598 | 210 | 9.84472 | 20.673912 | Microviridae sp. | 2202644 | Viruses | Viruses | 42.4 | 0.0315 | NR | DAZ92349.1 | 2202644 | g106832 | i0 | 67.7 | 0.442857142857143 | 31 | 10 | 44.3 | 0 | 6 | 98 | 190 | 220 | DAZ92349.1 TPA_asm: replication initiator protein [Microviridae sp.] | diamond | 93 | 42.4 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 32373584 | 32373584 | PRJEB64798_P_NODE_94779_length_212_cov_4.404908_g93013_i0 | PRJEB64798 | 94779 | 212 | 4.404908 | 9.33840496 | Microviridae sp. | 2202644 | Viruses | Viruses | 114 | 7.960000000000001e-29 | NR | XOF05520.1 | 2202644 | g93013 | i0 | 71.3 | 2.26415094339623 | 80 | 13 | 99.1 | 1 | 210 | 1 | 154 | 233 | XOF05520.1 MAG: replication initiation protein [Microviridae sp.] | diamond | 480 | 114 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. |
Advanced export
JSON shape: default, array, newline-delimited
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);;