contig_metadata
24 rows where bioproject = "PRJNA642647" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1894220 | 1894220 | PRJNA642647_P_NODE_542_length_481_cov_4.254505_g493_i0 | PRJNA642647 | 542 | 481 | 4.254505 | 20.46416905 | Microviridae sp. | 2202644 | Viruses | Viruses | 259 | 2.5700000000000003e-64 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g493 | i0 | 85.547 | 0.532224532224532 | 256 | 28 | 52 | 9 | 219 | 470 | 826 | 1076 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 256 | 259 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 3168803 | 3168803 | PRJNA642647_P_NODE_223_length_737_cov_3.568571_g187_i0 | PRJNA642647 | 223 | 737 | 3.568571 | 26.30036827 | Microviridae sp. | 2202644 | Viruses | Viruses | 470 | 1.72e-127 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g187 | i0 | 84.342 | 2.08005427408412 | 479 | 75 | 65 | 0 | 17 | 495 | 1316 | 838 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 1533 | 470 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 4445662 | 4445662 | PRJNA642647_P_NODE_2144_length_235_cov_3.691919_g2094_i0 | PRJNA642647 | 2144 | 235 | 3.691919 | 8.67600965 | Microviridae sp. | 2202644 | Viruses | Viruses | 322 | 1.45e-83 | NTclustered | gi|2428721376|tpg|BK061429.1| | 2202644 | g2094 | i0 | 93.897 | 3.52765957446808 | 213 | 13 | 91 | 0 | 20 | 232 | 2499 | 2287 | TPA_asm: Microviridae sp. isolate reeWastUs1, complete genome | blastn | 829 | 322 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 4445691 | 4445691 | PRJNA642647_P_NODE_4884_length_166_cov_3.527132_g4834_i0 | PRJNA642647 | 4884 | 166 | 3.527132 | 5.85503912 | Viruses | 10239 | Viruses | Viruses | 77.8 | 5.76e-15 | NR | XOF05518.1 | 2202644 | g4834 | i0 | 82.4 | 3.6144578313253 | 51 | 9 | 92.2 | 0 | 154 | 2 | 248 | 298 | XOF05518.1 MAG: major head protein [Microviridae sp.] | diamond | 600 | 78.2 | 0.994884910485933 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 5721502 | 5721502 | PRJNA642647_P_NODE_1785_length_259_cov_4.671171_g1735_i0 | PRJNA642647 | 1785 | 259 | 4.671171 | 12.09833289 | Microvirus sp. | 2202559 | Viruses | Viruses | 177 | 5.56e-51 | NR | QJB19464.1 | 2202559 | g1735 | i0 | 91.8 | 1.96911196911197 | 85 | 7 | 98.5 | 0 | 257 | 3 | 47 | 131 | QJB19464.1 MAG: major capsid protein [Microvirus sp.] | diamond | 510 | 177 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 5721546 | 5721546 | PRJNA642647_P_NODE_6165_length_154_cov_1.273504_g6115_i0 | PRJNA642647 | 6165 | 154 | 1.273504 | 1.96119616 | Microviridae sp. | 2202644 | Viruses | Viruses | 147 | 5.639999999999999e-31 | NTclustered | gi|2428721376|tpg|BK061429.1| | 2202644 | g6115 | i0 | 95.604 | 0.590909090909091 | 91 | 4 | 59 | 0 | 4 | 94 | 1918 | 2008 | TPA_asm: Microviridae sp. isolate reeWastUs1, complete genome | blastn | 91 | 147 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 6996531 | 6996531 | PRJNA642647_P_NODE_1966_length_247_cov_2.547619_g1916_i0 | PRJNA642647 | 1966 | 247 | 2.547619 | 6.29261893 | Microviridae sp. | 2202644 | Viruses | Viruses | 200 | 7.529999999999999e-47 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g1916 | i0 | 83.568 | 0.862348178137652 | 213 | 35 | 86 | 0 | 12 | 224 | 4230 | 4018 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 213 | 200 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 9546549 | 9546549 | PRJNA642647_P_NODE_1268_length_311_cov_3.021898_g1218_i0 | PRJNA642647 | 1268 | 311 | 3.021898 | 9.39810278 | Microviridae sp. | 2202644 | Viruses | Viruses | 311 | 4.34e-80 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g1218 | i0 | 85.113 | 2.85852090032154 | 309 | 40 | 98 | 6 | 4 | 309 | 441 | 136 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 889 | 311 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 10822250 | 10822250 | PRJNA642647_P_NODE_889_length_375_cov_3.869822_g839_i0 | PRJNA642647 | 889 | 375 | 3.869822 | 14.5118325 | Microviridae sp. | 2202644 | Viruses | Viruses | 105 | 4.46e-25 | NR | AXH76778.1 | 2202644 | g839 | i0 | 76.5 | 1.016 | 68 | 16 | 54.4 | 0 | 207 | 4 | 1 | 68 | AXH76778.1 MAG: DNA pilot protein [Microviridae sp.] | diamond | 381 | 105 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 13372012 | 13372012 | PRJNA642647_P_NODE_2991_length_202_cov_2.933333_g2941_i0 | PRJNA642647 | 2991 | 202 | 2.933333 | 5.92533266 | Microviridae sp. | 2202644 | Viruses | Viruses | 135 | 4.26e-37 | NR | AXH76776.1 | 2202644 | g2941 | i0 | 89.4 | 0.98019801980198 | 66 | 7 | 98 | 0 | 200 | 3 | 88 | 153 | AXH76776.1 MAG: replication initiator protein [Microviridae sp.] | diamond | 198 | 135 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 17195957 | 17195957 | PRJNA642647_P_NODE_6294_length_152_cov_3.269565_g6244_i0 | PRJNA642647 | 6294 | 152 | 3.269565 | 4.9697388 | Arizlama microvirus | 2859450 | Viruses | Viruses | 104 | 3.38e-18 | NTclustered | gi|2067847829|gb|MW697590.1| | 2859450 | g6244 | i0 | 95.385 | 0.842105263157895 | 65 | 3 | 43 | 0 | 13 | 77 | 398 | 334 | MAG: Arizlama microvirus isolate AZLM_406, complete genome | blastn | 128 | 104 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Arizlama microvirus | |||
| 18470224 | 18470224 | PRJNA642647_P_NODE_215_length_760_cov_8.058091_g181_i0 | PRJNA642647 | 215 | 760 | 8.058091 | 61.2414916 | Microviridae sp. | 2202644 | Viruses | Viruses | 551 | 6.169999999999998e-152 | NTclustered | gi|1603903290|gb|MH617454.2| | 2202644 | g181 | i0 | 85.499 | 2.86578947368421 | 531 | 73 | 70 | 4 | 229 | 757 | 664 | 136 | MAG: Microviridae sp. isolate ctig683, complete genome | blastn | 2178 | 551 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 23570725 | 23570725 | PRJNA642647_P_NODE_4679_length_168_cov_6.022901_g4629_i0 | PRJNA642647 | 4679 | 168 | 6.022901 | 10.11847368 | Microvirus sp. | 2202559 | Viruses | Viruses | 176 | 8.03e-40 | NTclustered | gi|1832330608|gb|MT310076.1| | 2202559 | g4629 | i0 | 85.629 | 3.60714285714286 | 167 | 24 | 99 | 0 | 2 | 168 | 1374 | 1208 | MAG: Microvirus sp. isolate 6537_26, complete genome | blastn | 606 | 176 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 27808012 | 27808012 | PRJNA642647_P_NODE_4924_length_166_cov_3.279070_g4874_i0 | PRJNA642647 | 4924 | 166 | 3.27907 | 5.4432562 | Microvirus sp. | 2202559 | Viruses | Viruses | 73.6 | 1.71e-13 | NR | QJB18954.1 | 2202559 | g4874 | i0 | 55.6 | 1.30120481927711 | 72 | 14 | 97.6 | 1 | 164 | 3 | 268 | 339 | QJB18954.1 MAG: major capsid protein [Microvirus sp.] | diamond | 216 | 73.6 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 27851510 | 27851510 | PRJNA642647_P_NODE_884_length_376_cov_12.035398_g834_i0 | PRJNA642647 | 884 | 376 | 12.035398 | 45.25309648 | Viruses | 10239 | Viruses | Viruses | 124 | 2.06e-30 | NR | QJB19464.1 | 2202559 | g834 | i0 | 84.1 | 1.10106382978723 | 69 | 11 | 55.1 | 0 | 375 | 169 | 467 | 535 | QJB19464.1 MAG: major capsid protein [Microvirus sp.] | diamond | 414 | 124 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 28849549 | 28849549 | PRJNA642647_P_NODE_3988_length_180_cov_2.580420_g3938_i0 | PRJNA642647 | 3988 | 180 | 2.58042 | 4.644756 | Microviridae sp. | 2202644 | Viruses | Viruses | 62 | 1.71e-10 | NR | DAZ92351.1 | 2202644 | g3938 | i0 | 69.8 | 0.883333333333333 | 53 | 16 | 88.3 | 0 | 176 | 18 | 3 | 55 | DAZ92351.1 TPA_asm: hypothetical protein [Microviridae sp.] | diamond | 159 | 62 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 28912622 | 28912622 | PRJNA642647_P_NODE_3768_length_184_cov_2.190476_g3718_i0 | PRJNA642647 | 3768 | 184 | 2.190476 | 4.03047584 | Microvirus sp. | 2202559 | Viruses | Viruses | 75.1 | 6.64e-14 | NR | QJB21554.1 | 2202559 | g3718 | i0 | 74.5 | 0.766304347826087 | 47 | 12 | 76.6 | 0 | 142 | 2 | 1 | 47 | QJB21554.1 MAG: major capsid protein [Microvirus sp.] | diamond | 141 | 75.1 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 29039427 | 29039427 | PRJNA642647_P_NODE_2468_length_220_cov_1.240437_g2418_i0 | PRJNA642647 | 2468 | 220 | 1.240437 | 2.7289614 | Microviridae sp. | 2202644 | Viruses | Viruses | 115 | 2.06e-29 | NR | XOF05523.1 | 2202644 | g2418 | i0 | 81.9 | 0.981818181818182 | 72 | 13 | 98.2 | 0 | 219 | 4 | 10 | 81 | XOF05523.1 MAG: minor tail protein, partial [Microviridae sp.] | diamond | 216 | 115 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 29607120 | 29607120 | PRJNA642647_P_NODE_1650_length_270_cov_2.339056_g1600_i0 | PRJNA642647 | 1650 | 270 | 2.339056 | 6.3154512 | Microviridae sp. | 2202644 | Viruses | Viruses | 112 | 8.39e-27 | NR | DAZ92347.1 | 2202644 | g1600 | i0 | 75.3 | 0.811111111111111 | 73 | 6 | 67.8 | 1 | 86 | 268 | 1 | 73 | DAZ92347.1 TPA_asm: major capsid protein [Microviridae sp.] | diamond | 219 | 112 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 29891883 | 29891883 | PRJNA642647_P_NODE_5891_length_157_cov_1.650000_g5841_i0 | PRJNA642647 | 5891 | 157 | 1.65 | 2.5905 | Microviridae sp. | 2202644 | Viruses | Viruses | 49.7 | 4.14e-5 | NR | QRQ90102.1 | 2202644 | g5841 | i0 | 52.2 | 0.878980891719745 | 46 | 22 | 87.9 | 0 | 154 | 17 | 208 | 253 | QRQ90102.1 MAG: major capsid protein [Microviridae sp.] | diamond | 138 | 49.7 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 30124934 | 30124934 | PRJNA642647_P_NODE_2892_length_205_cov_3.315476_g2842_i0 | PRJNA642647 | 2892 | 205 | 3.315476 | 6.7967258 | Viruses | 10239 | Viruses | Viruses | 122 | 1.08e-30 | NR | QJB19548.1 | 2202559 | g2842 | i0 | 88.1 | 1.9609756097561 | 67 | 8 | 98 | 0 | 201 | 1 | 100 | 166 | QJB19548.1 MAG: major capsid protein [Microvirus sp.] | diamond | 402 | 122 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 30871132 | 30871132 | PRJNA642647_P_NODE_3634_length_186_cov_3.583893_g3584_i0 | PRJNA642647 | 3634 | 186 | 3.583893 | 6.66604098 | Microviridae sp. | 2202644 | Viruses | Viruses | 62 | 2.11e-9 | NR | XOF05520.1 | 2202644 | g3584 | i0 | 90.6 | 1.03225806451613 | 32 | 3 | 51.6 | 0 | 184 | 89 | 153 | 184 | XOF05520.1 MAG: replication initiation protein [Microviridae sp.] | diamond | 192 | 62 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 32072806 | 32072806 | PRJNA642647_P_NODE_3058_length_200_cov_4.889571_g3008_i0 | PRJNA642647 | 3058 | 200 | 4.889571 | 9.779142 | Microvirus sp. | 2202559 | Viruses | Viruses | 55.1 | 9.32e-7 | NR | QJB19381.1 | 2202559 | g3008 | i0 | 83.3 | 0.45 | 30 | 5 | 45 | 0 | 3 | 92 | 203 | 232 | QJB19381.1 MAG: major capsid protein [Microvirus sp.] | diamond | 90 | 55.1 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 32262902 | 32262902 | PRJNA642647_P_NODE_3478_length_190_cov_1.013072_g3428_i0 | PRJNA642647 | 3478 | 190 | 1.013072 | 1.9248368 | Arizlama microvirus | 2859450 | Viruses | Viruses | 127 | 2.18e-32 | NR | QXP08673.1 | 2859450 | g3428 | i0 | 90.3 | 0.978947368421053 | 62 | 6 | 97.9 | 0 | 4 | 189 | 413 | 474 | QXP08673.1 MAG: major capsid protein [Arizlama microvirus] | diamond | 186 | 127 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Arizlama microvirus |
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);;