contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA896758" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 872844 | 872844 | PRJNA896758_P_NODE_1_length_8278_cov_71.580378_g0_i0 | PRJNA896758 | 1 | 8278 | 71.580378 | 5925.42369084 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 13651 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g0 | i0 | 96.438 | 3.02464363372795 | 8281 | 287 | 100 | 6 | 1 | 8278 | 8295 | 20 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 25038 | 13651 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 872860 | 872860 | PRJNA896758_P_NODE_22201_length_249_cov_1.369318_g21811_i0 | PRJNA896758 | 22201 | 249 | 1.369318 | 3.40960182 | Carlavirus vignae | 3427805 | Viruses | Viruses | 372 | 1.52e-98 | NTclustered | gi|2505219822|gb|OP611426.1| | 67761 | g21811 | i0 | 93.574 | 87.8875502008032 | 249 | 16 | 100 | 0 | 1 | 249 | 8182 | 7934 | Cowpea mild mottle virus isolate Buritama_BR, complete genome | blastn | 21884 | 372 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 2148231 | 2148231 | PRJNA896758_P_NODE_2_length_8278_cov_70.724071_g0_i1 | PRJNA896758 | 2 | 8278 | 70.724071 | 5854.53859738 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 13640 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g0 | i1 | 96.413 | 3.02464363372795 | 8281 | 289 | 100 | 6 | 1 | 8278 | 8295 | 20 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 25038 | 13640 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 3423672 | 3423672 | PRJNA896758_P_NODE_3_length_8278_cov_70.262645_g0_i2 | PRJNA896758 | 3 | 8278 | 70.262645 | 5816.3417531 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 13590 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g0 | i2 | 96.305 | 3.02464363372795 | 8281 | 298 | 100 | 6 | 1 | 8278 | 8295 | 20 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 25038 | 13590 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 4701359 | 4701359 | PRJNA896758_P_NODE_16824_length_282_cov_0.842105_g16434_i0 | PRJNA896758 | 16824 | 282 | 0.842105 | 2.3747361 | Carlavirus vignae | 3427805 | Viruses | Viruses | 494 | 3.6e-135 | NTclustered | gi|2017771285|gb|MW657188.1| | 67761 | g16434 | i0 | 98.233 | 100.354609929078 | 283 | 4 | 100 | 1 | 1 | 282 | 381 | 99 | Cowpea mild mottle virus clone BP1:1 triple gene block 1 (ORF2) gene, complete cds | blastn | 28300 | 494 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 4701382 | 4701382 | PRJNA896758_P_NODE_19324_length_265_cov_0.802083_g18934_i0 | PRJNA896758 | 19324 | 265 | 0.802083 | 2.12551995 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 407 | 4.49e-109 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g18934 | i0 | 94.34 | 3 | 265 | 15 | 100 | 0 | 1 | 265 | 1340 | 1604 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 795 | 407 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 5976189 | 5976189 | PRJNA896758_P_NODE_305_length_1866_cov_18.607362_g0_i4 | PRJNA896758 | 305 | 1866 | 18.607362 | 347.21337492 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 3118 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g0 | i4 | 96.838 | 2.96730975348339 | 1866 | 58 | 100 | 1 | 1 | 1866 | 1884 | 20 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 5537 | 3118 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 5976241 | 5976241 | PRJNA896758_P_NODE_9585_length_368_cov_2.915254_g9195_i0 | PRJNA896758 | 9585 | 368 | 2.915254 | 10.72813472 | Carlavirus vignae | 3427805 | Viruses | Viruses | 438 | 2.3e-118 | NTclustered | gi|2505219822|gb|OP611426.1| | 67761 | g9195 | i0 | 88.108 | 3.01086956521739 | 370 | 42 | 100 | 1 | 1 | 368 | 6528 | 6897 | Cowpea mild mottle virus isolate Buritama_BR, complete genome | blastn | 1108 | 438 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 8525628 | 8525628 | PRJNA896758_P_NODE_21687_length_250_cov_0.870056_g21297_i0 | PRJNA896758 | 21687 | 250 | 0.870056 | 2.17514 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 457 | 4.1099999999999985e-124 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g21297 | i0 | 99.6 | 1 | 250 | 1 | 100 | 0 | 1 | 250 | 1433 | 1682 | Malassezia restricta virus MrV40L, complete genome | blastn | 250 | 457 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 8525654 | 8525654 | PRJNA896758_P_NODE_247_length_2016_cov_19.200206_g0_i3 | PRJNA896758 | 247 | 2016 | 19.200206 | 387.07615296 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 3044 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g0 | i3 | 93.908 | 3.00496031746032 | 2019 | 120 | 100 | 1 | 1 | 2016 | 3281 | 1263 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 6058 | 3044 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 11076371 | 11076371 | PRJNA896758_P_NODE_22509_length_249_cov_0.875000_g22119_i0 | PRJNA896758 | 22509 | 249 | 0.875 | 2.17875 | Carlavirus vignae | 3427805 | Viruses | Viruses | 455 | 1.47e-123 | NTclustered | gi|2505219822|gb|OP611426.1| | 67761 | g22119 | i0 | 99.598 | 100 | 249 | 1 | 100 | 0 | 1 | 249 | 6114 | 6362 | Cowpea mild mottle virus isolate Buritama_BR, complete genome | blastn | 24900 | 455 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 12351807 | 12351807 | PRJNA896758_P_NODE_23290_length_247_cov_1.321839_g22900_i0 | PRJNA896758 | 23290 | 247 | 1.321839 | 3.26494233 | Carlavirus vignae | 3427805 | Viruses | Viruses | 446 | 8.759999999999998e-121 | NTclustered | gi|2017770961|gb|MW657026.1| | 67761 | g22900 | i0 | 99.19 | 99.9878542510122 | 247 | 2 | 100 | 0 | 1 | 247 | 5242 | 5488 | Cowpea mild mottle virus clone P3a:9 viral replicase (ORF1) gene, complete cds | blastn | 24697 | 446 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 12351809 | 12351809 | PRJNA896758_P_NODE_23390_length_247_cov_0.885057_g23000_i0 | PRJNA896758 | 23390 | 247 | 0.885057 | 2.18609079 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 385 | 1.94e-102 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g23000 | i0 | 94.737 | 2.98785425101215 | 247 | 13 | 100 | 0 | 1 | 247 | 2936 | 2690 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 738 | 385 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 12351812 | 12351812 | PRJNA896758_P_NODE_23590_length_247_cov_0.885057_g23200_i0 | PRJNA896758 | 23590 | 247 | 0.885057 | 2.18609079 | Carlavirus vignae | 3427805 | Viruses | Viruses | 446 | 8.759999999999998e-121 | NTclustered | gi|2909031160|gb|PQ825743.1| | 67761 | g23200 | i0 | 99.19 | 25.3805668016194 | 247 | 2 | 100 | 0 | 1 | 247 | 252 | 6 | Cowpea mild mottle virus isolate CPMMV-Soy coat protein gene, partial cds | blastn | 6269 | 446 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 12351849 | 12351849 | PRJNA896758_P_NODE_470_length_1604_cov_2.387329_g310_i0 | PRJNA896758 | 470 | 1604 | 2.387329 | 38.29275716 | Carlavirus vignae | 3427805 | Viruses | Viruses | 2839 | 0 | NTclustered | gi|2505219801|gb|OP611423.1| | 67761 | g310 | i0 | 98.628 | 79.5317955112219 | 1604 | 21 | 99 | 1 | 2 | 1604 | 8191 | 6588 | Cowpea mild mottle virus isolate LEM1_BR, complete genome | blastn | 127569 | 2839 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 14900771 | 14900771 | PRJNA896758_P_NODE_21572_length_250_cov_1.757062_g21182_i0 | PRJNA896758 | 21572 | 250 | 1.757062 | 4.392655 | Zhejiang betaflexivirus 2 | 2824414 | Viruses | Viruses | 431 | 2.489999999999999e-116 | NTclustered | gi|2075444446|gb|MW897315.1| | 2824414 | g21182 | i0 | 97.984 | 93.388 | 248 | 5 | 99 | 0 | 1 | 248 | 7790 | 8037 | MAG: Zhejiang betaflexivirus 2 isolate 15-k141_99752, complete genome | blastn | 23347 | 431 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Zhejiang betaflexivirus 2 | |||
| 20370277 | 20370277 | PRJNA896758_P_NODE_21916_length_250_cov_0.870056_g21526_i0 | PRJNA896758 | 21916 | 250 | 0.870056 | 2.17514 | Carlavirus | 12163 | Viruses | Viruses | 440 | 4.1399999999999976e-119 | NTclustered | gi|2907520831|gb|PQ834430.1| | 67761 | g21526 | i0 | 98.406 | 100.24 | 251 | 3 | 100 | 1 | 1 | 250 | 353 | 603 | Cowpea mild mottle virus isolate CPMMV-Soy-Seed coat protein gene, complete cds | blastn | 25060 | 440 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 22549705 | 22549705 | PRJNA896758_P_NODE_25398_length_243_cov_0.905882_g25008_i0 | PRJNA896758 | 25398 | 243 | 0.905882 | 2.20129326 | Zhejiang betaflexivirus 2 | 2824414 | Viruses | Viruses | 449 | 6.65e-122 | NTclustered | gi|2075444446|gb|MW897315.1| | 2824414 | g25008 | i0 | 100 | 26.4115226337449 | 243 | 0 | 100 | 0 | 1 | 243 | 7552 | 7794 | MAG: Zhejiang betaflexivirus 2 isolate 15-k141_99752, complete genome | blastn | 6418 | 449 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Zhejiang betaflexivirus 2 | |||
| 25098766 | 25098766 | PRJNA896758_P_NODE_10020_length_361_cov_1.222222_g9630_i0 | PRJNA896758 | 10020 | 361 | 1.222222 | 4.41222142 | Carlavirus vignae | 3427805 | Viruses | Viruses | 638 | 2.0699999999999996e-178 | NTclustered | gi|555431087|gb|KF554101.1| | 67761 | g9630 | i0 | 98.615 | 87.8504155124654 | 361 | 4 | 100 | 1 | 1 | 361 | 2504 | 2145 | Cowpea mild mottle virus isolate CPMMV:BR:GO:10:4 triple gene block 1, triple gene block 2, triple gene block 3, coat protein, and putative nucleic acid binding protein genes, complete cds | blastn | 31714 | 638 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae | ||
| 25098847 | 25098847 | PRJNA896758_P_NODE_20100_length_259_cov_1.241935_g19710_i0 | PRJNA896758 | 20100 | 259 | 1.241935 | 3.21661165 | Carlavirus vignae | 3427805 | Viruses | Viruses | 457 | 4.279999999999999e-124 | NTclustered | gi|2505219829|gb|OP611427.1| | 67761 | g19710 | i0 | 98.456 | 74.5057915057915 | 259 | 4 | 100 | 0 | 1 | 259 | 6715 | 6973 | Cowpea mild mottle virus isolate Rubiacea_BR, complete genome | blastn | 19297 | 457 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus vignae |
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);;