contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA602115" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 575657 | 575657 | PRJNA602115_P_NODE_3621_length_322_cov_1.375479_g3596_i0 | PRJNA602115 | 3621 | 322 | 1.375479 | 4.42904238 | Microvirus sp. | 2202559 | Viruses | Viruses | 446 | 1.1899999999999999e-120 | NTclustered | gi|2581533517|gb|OR350223.1| | 2202559 | g3596 | i0 | 92.089 | 2.6583850931677 | 316 | 25 | 98 | 0 | 1 | 316 | 3881 | 4196 | MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome | blastn | 856 | 446 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 1851351 | 1851351 | PRJNA602115_P_NODE_10182_length_205_cov_1.020833_g10157_i0 | PRJNA602115 | 10182 | 205 | 1.020833 | 2.09270765 | Microviridae sp. | 2202644 | Viruses | Viruses | 198 | 2.17e-46 | NTclustered | gi|2302019813|gb|MT206358.1| | 2202644 | g10157 | i0 | 84.577 | 1.56585365853659 | 201 | 29 | 98 | 2 | 6 | 205 | 2963 | 2764 | MAG: Microviridae sp. isolate CN7_L17_103, complete genome | blastn | 321 | 198 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 1851408 | 1851408 | PRJNA602115_P_NODE_1382_length_503_cov_2.581448_g1357_i0 | PRJNA602115 | 1382 | 503 | 2.581448 | 12.98468344 | Microvirus sp. | 2202559 | Viruses | Viruses | 730 | 0 | NTclustered | gi|2581533517|gb|OR350223.1| | 2202559 | g1357 | i0 | 92.857 | 1.00198807157058 | 504 | 35 | 100 | 1 | 1 | 503 | 2928 | 3431 | MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome | blastn | 504 | 730 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 4403308 | 4403308 | PRJNA602115_P_NODE_1144_length_549_cov_1.729508_g1119_i0 | PRJNA602115 | 1144 | 549 | 1.729508 | 9.49499892 | Microviridae sp. | 2202644 | Viruses | Viruses | 520 | 1.23e-142 | NTclustered | gi|1986762546|gb|MW347815.1| | 2202644 | g1119 | i0 | 89.512 | 16.591985428051 | 410 | 43 | 75 | 0 | 140 | 549 | 88 | 497 | MAG: Microviridae sp. isolate 5cz-micro-4 major capsid protein gene, partial cds | blastn | 9109 | 520 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 4403466 | 4403466 | PRJNA602115_P_NODE_6764_length_244_cov_1.256831_g6739_i0 | PRJNA602115 | 6764 | 244 | 1.256831 | 3.06666764 | Microviridae sp. | 2202644 | Viruses | Viruses | 80.5 | 1.01e-10 | NTclustered | gi|2636869240|gb|OR408952.1| | 2202644 | g6739 | i0 | 80.583 | 0.422131147540984 | 103 | 20 | 42 | 0 | 142 | 244 | 932 | 830 | MAG: Microviridae sp. isolate xizangnaqu28-14668 genomic sequence | blastn | 103 | 80.5 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 4403499 | 4403499 | PRJNA602115_P_NODE_8104_length_220_cov_1.207547_g8079_i0 | PRJNA602115 | 8104 | 220 | 1.207547 | 2.6566034 | Microvirus sp. | 2202559 | Viruses | Viruses | 274 | 3.82e-69 | NTclustered | gi|2581533517|gb|OR350223.1| | 2202559 | g8079 | i0 | 89.401 | 11.9681818181818 | 217 | 23 | 99 | 0 | 1 | 217 | 1508 | 1292 | MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome | blastn | 2633 | 274 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 4403501 | 4403501 | PRJNA602115_P_NODE_8164_length_219_cov_1.132911_g8139_i0 | PRJNA602115 | 8164 | 219 | 1.132911 | 2.48107509 | Microvirus sp. | 2202559 | Viruses | Viruses | 320 | 4.81e-83 | NTclustered | gi|2581533517|gb|OR350223.1| | 2202559 | g8139 | i0 | 94.258 | 1.46118721461187 | 209 | 12 | 95 | 0 | 11 | 219 | 2420 | 2628 | MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome | blastn | 320 | 320 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 6953966 | 6953966 | PRJNA602115_P_NODE_3106_length_344_cov_0.904594_g3081_i0 | PRJNA602115 | 3106 | 344 | 0.904594 | 3.11180336 | Microviridae sp. | 2202644 | Viruses | Viruses | 279 | 1.37e-70 | NTclustered | gi|1986762564|gb|MW348211.1| | 2202644 | g3081 | i0 | 96.45 | 1.0203488372093 | 169 | 6 | 49 | 0 | 176 | 344 | 1 | 169 | MAG: Microviridae sp. isolate 6nt-micro-4 major capsid protein gene, partial cds | blastn | 351 | 279 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 13329771 | 13329771 | PRJNA602115_P_NODE_591_length_751_cov_1.314493_g568_i0 | PRJNA602115 | 591 | 751 | 1.314493 | 9.87184243 | Microvirus sp. | 2202559 | Viruses | Viruses | 499 | 2.24e-136 | NTclustered | gi|2581533517|gb|OR350223.1| | 2202559 | g568 | i0 | 82.453 | 0.781624500665779 | 587 | 87 | 77 | 15 | 173 | 751 | 1787 | 2365 | MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome | blastn | 587 | 499 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 18427799 | 18427799 | PRJNA602115_P_NODE_795_length_663_cov_1.340532_g770_i0 | PRJNA602115 | 795 | 663 | 1.340532 | 8.88772716 | Microvirus sp. | 2202559 | Viruses | Viruses | 745 | 0 | NTclustered | gi|2581533517|gb|OR350223.1| | 2202559 | g770 | i0 | 92.802 | 17.3212669683258 | 514 | 37 | 78 | 0 | 1 | 514 | 155 | 668 | MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome | blastn | 11484 | 745 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 18427810 | 18427810 | PRJNA602115_P_NODE_8295_length_217_cov_0.897436_g8270_i0 | PRJNA602115 | 8295 | 217 | 0.897436 | 1.94743612 | Microvirus sp. | 2202559 | Viruses | Viruses | 340 | 3.6499999999999996e-89 | NTclustered | gi|2581532085|gb|OR350021.1| | 2202559 | g8270 | i0 | 94.931 | 9.10138248847926 | 217 | 11 | 100 | 0 | 1 | 217 | 3415 | 3631 | MAG: Microvirus sp. isolate LSLA_262 clone LS254, complete genome | blastn | 1975 | 340 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microvirus sp. | |||
| 18427823 | 18427823 | PRJNA602115_P_NODE_8815_length_209_cov_0.864865_g8790_i0 | PRJNA602115 | 8815 | 209 | 0.864865 | 1.80756785 | Microviridae sp. | 2202644 | Viruses | Viruses | 195 | 2.88e-45 | NTclustered | gi|2216796470|gb|MW202471.1| | 2202644 | g8790 | i0 | 85.714 | 0.904306220095694 | 189 | 21 | 89 | 5 | 21 | 206 | 3224 | 3409 | Microviridae sp. isolate ctUFZ915, complete genome | blastn | 189 | 195 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 24801857 | 24801857 | PRJNA602115_P_NODE_1560_length_477_cov_1.269231_g1535_i0 | PRJNA602115 | 1560 | 477 | 1.269231 | 6.05423187 | Microviridae sp. | 2202644 | Viruses | Viruses | 337 | 1.1399999999999999e-87 | NTclustered | gi|2636872893|gb|OR410766.1| | 2202644 | g1535 | i0 | 82.323 | 2.55555555555556 | 396 | 62 | 82 | 7 | 37 | 428 | 1200 | 809 | MAG: Microviridae sp. isolate xizangshannan41-10874 genomic sequence | blastn | 1219 | 337 | 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);;