contig_metadata
10 rows where bioproject = "PRJNA785164" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3317025 | 3317025 | PRJNA785164_P_NODE_20243_length_424_cov_2.518519_g19778_i0 | PRJNA785164 | 20243 | 424 | 2.518519 | 10.67852056 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 92 | 1.77e-18 | NR | WLN26256.1 | 3065075 | g19778 | i0 | 50 | 0.650943396226415 | 92 | 46 | 65.1 | 0 | 303 | 28 | 229 | 320 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 276 | 92 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 8866569 | 8866569 | PRJNA785164_P_NODE_16407_length_488_cov_3.175904_g15942_i0 | PRJNA785164 | 16407 | 488 | 3.175904 | 15.49841152 | root | 1 | Root_unresolved | Root_unresolved | 902 | 0 | NTclustered | gi|2057561291|gb|MZ399798.1| | 11036 | g15942 | i0 | 100 | 99.9918032786885 | 488 | 0 | 100 | 0 | 1 | 488 | 623 | 136 | Venezuelan equine encephalitis virus strain TC-83, complete genome | blastn | 48796 | 902 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 8866676 | 8866676 | PRJNA785164_P_NODE_47607_length_260_cov_3.294118_g47142_i0 | PRJNA785164 | 47607 | 260 | 3.294118 | 8.5647068 | root | 1 | Root_unresolved | Root_unresolved | 481 | 2.55e-131 | NTclustered | gi|992068117|gb|KC344485.2| | 11036 | g47142 | i0 | 100 | 99.9538461538462 | 260 | 0 | 100 | 0 | 1 | 260 | 4474 | 4733 | Venezuelan equine encephalitis virus strain VEEV/Equus ferus caballus/COL/CoAn5384/1967/IAB, complete genome | blastn | 25988 | 481 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 15241957 | 15241957 | PRJNA785164_P_NODE_44652_length_269_cov_2.219388_g44187_i0 | PRJNA785164 | 44652 | 269 | 2.219388 | 5.97015372 | root | 1 | Root_unresolved | Root_unresolved | 492 | 1.23e-134 | NTclustered | gi|992068117|gb|KC344485.2| | 11036 | g44187 | i0 | 99.628 | 99.9925650557621 | 269 | 1 | 100 | 0 | 1 | 269 | 1595 | 1327 | Venezuelan equine encephalitis virus strain VEEV/Equus ferus caballus/COL/CoAn5384/1967/IAB, complete genome | blastn | 26898 | 492 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 19065148 | 19065148 | PRJNA785164_P_NODE_1035_length_2361_cov_8.333916_g952_i0 | PRJNA785164 | 1035 | 2361 | 8.333916 | 196.76375676 | root | 1 | Root_unresolved | Root_unresolved | 4331 | 0 | NTclustered | gi|2057561291|gb|MZ399798.1| | 11036 | g952 | i0 | 100 | 99.4455739093604 | 2345 | 0 | 99 | 0 | 4 | 2348 | 1614 | 3958 | Venezuelan equine encephalitis virus strain TC-83, complete genome | blastn | 234791 | 4337 | 0.998616555222504 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 19065149 | 19065149 | PRJNA785164_P_NODE_10415_length_671_cov_3.772575_g9967_i0 | PRJNA785164 | 10415 | 671 | 3.772575 | 25.31397825 | root | 1 | Root_unresolved | Root_unresolved | 1240 | 0 | NTclustered | gi|692518277|gb|KJ410017.1| | 11036 | g9967 | i0 | 100 | 99.8986587183309 | 671 | 0 | 100 | 0 | 1 | 671 | 545 | 1215 | Venezuelan equine encephalitis virus isolate AB66640(VEEVIAB) nonstructural polyprotein precursor and structural polyprotein genes, complete cds | blastn | 67032 | 1240 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 24165082 | 24165082 | PRJNA785164_P_NODE_2019_length_1823_cov_3.128000_g1872_i0 | PRJNA785164 | 2019 | 1823 | 3.128 | 57.02344 | root | 1 | Root_unresolved | Root_unresolved | 3334 | 0 | NTclustered | gi|992068117|gb|KC344485.2| | 11036 | g1872 | i0 | 100 | 98.8902907295666 | 1805 | 0 | 99 | 0 | 19 | 1823 | 5073 | 6877 | Venezuelan equine encephalitis virus strain VEEV/Equus ferus caballus/COL/CoAn5384/1967/IAB, complete genome | blastn | 180277 | 3334 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 24165094 | 24165094 | PRJNA785164_P_NODE_25079_length_371_cov_1.902685_g24614_i0 | PRJNA785164 | 25079 | 371 | 1.902685 | 7.05896135 | root | 1 | Root_unresolved | Root_unresolved | 680 | 0 | NTclustered | gi|692518277|gb|KJ410017.1| | 11036 | g24614 | i0 | 99.73 | 99.622641509434 | 371 | 1 | 100 | 0 | 1 | 371 | 4043 | 4413 | Venezuelan equine encephalitis virus isolate AB66640(VEEVIAB) nonstructural polyprotein precursor and structural polyprotein genes, complete cds | blastn | 36960 | 680 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 29453307 | 29453307 | PRJNA785164_P_NODE_8090_length_802_cov_3.625514_g7675_i0 | PRJNA785164 | 8090 | 802 | 3.625514 | 29.07662228 | Sea turtle neural virus 1 | 3112944 | Viruses | Viruses | 49.3 | 0.0109 | NR | WET19891.1 | 3112944 | g7675 | i0 | 52.5 | 0.149625935162095 | 40 | 19 | 15 | 0 | 800 | 681 | 458 | 497 | WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] | diamond | 120 | 49.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Sea turtle neural virus 1 | ||
| 30338469 | 30338469 | PRJNA785164_P_NODE_42512_length_276_cov_2.088670_g42047_i0 | PRJNA785164 | 42512 | 276 | 2.08867 | 5.7647292 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 67.4 | 1.2e-10 | NR | WLN26256.1 | 3065075 | g42047 | i0 | 39.8 | 0.956521739130435 | 88 | 53 | 95.7 | 0 | 12 | 275 | 90 | 177 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 264 | 67.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus |
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);;