contig_metadata
7 rows where analysis = "blastn", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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);;