contig_metadata
8 rows where bioproject = "PRJNA473201", tax_phylum = "Negarnaviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1094401 | 1094401 | PRJNA473201_P_NODE_1_length_15233_cov_14.106596_g0_i0 | PRJNA473201 | 1 | 15233 | 14.106596 | 2148.85776868 | Orthorubulavirus | 2560195 | Viruses | Viruses | 28009 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g0 | i0 | 99.856 | 70.283660473971 | 15233 | 22 | 100 | 0 | 1 | 15233 | 15239 | 7 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 1070631 | 28075 | 0.997649154051647 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 6821235 | 6821235 | PRJNA473201_P_NODE_27866_length_373_cov_1.820000_g27124_i0 | PRJNA473201 | 27866 | 373 | 1.82 | 6.7886 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 76.8 | 2.11e-9 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g27124 | i0 | 97.778 | 0.967828418230563 | 45 | 0 | 12 | 1 | 1 | 44 | 24 | 68 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 361 | 76.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 17021516 | 17021516 | PRJNA473201_P_NODE_60094_length_266_cov_1.196891_g59352_i0 | PRJNA473201 | 60094 | 266 | 1.196891 | 3.18373006 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 95.3 | 3.99e-15 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g59352 | i0 | 95 | 1.62781954887218 | 60 | 3 | 23 | 0 | 1 | 60 | 23 | 82 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 433 | 95.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 17021886 | 17021886 | PRJNA473201_P_NODE_77394_length_245_cov_0.895349_g76652_i0 | PRJNA473201 | 77394 | 245 | 0.895349 | 2.19360505 | Betacytorhabdovirus hordei | 3427192 | Viruses | Viruses | 440 | 4.0399999999999986e-119 | NTclustered | gi|761662709|gb|KM213865.1| | 1985699 | g76652 | i0 | 99.18 | 2.98775510204082 | 244 | 2 | 99 | 0 | 1 | 244 | 7522 | 7279 | Barley yellow striate mosaic virus strain Hebei, complete genome | blastn | 732 | 440 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Betacytorhabdovirus | Betacytorhabdovirus hordei | ||
| 23396174 | 23396174 | PRJNA473201_P_NODE_49979_length_292_cov_1.251142_g49237_i0 | PRJNA473201 | 49979 | 292 | 1.251142 | 3.65333464 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 106 | 2.05e-18 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g49237 | i0 | 95.522 | 0.845890410958904 | 67 | 2 | 23 | 1 | 227 | 292 | 70 | 4 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 247 | 106 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 23396385 | 23396385 | PRJNA473201_P_NODE_61199_length_263_cov_1.215789_g60457_i0 | PRJNA473201 | 61199 | 263 | 1.215789 | 3.19752507 | Betacytorhabdovirus hordei | 3427192 | Viruses | Viruses | 486 | 5.5499999999999986e-133 | NTclustered | gi|761662709|gb|KM213865.1| | 1985699 | g60457 | i0 | 100 | 3 | 263 | 0 | 100 | 0 | 1 | 263 | 2789 | 2527 | Barley yellow striate mosaic virus strain Hebei, complete genome | blastn | 789 | 486 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Betacytorhabdovirus | Betacytorhabdovirus hordei | ||
| 29507634 | 29507634 | PRJNA473201_P_NODE_76610_length_245_cov_34.837209_g75868_i0 | PRJNA473201 | 76610 | 245 | 34.837209 | 85.35116205 | Wheat rosette stunt virus | 75890 | Viruses | Viruses | 59.3 | 5.28e-8 | NR | AAF28467.1 | 75890 | g75868 | i0 | 71.9 | 0.391836734693878 | 32 | 9 | 39.2 | 0 | 157 | 62 | 370 | 401 | AAF28467.1 nucleocapsid protein, partial [Wheat rosette stunt virus] | diamond | 96 | 59.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Wheat rosette stunt virus | |||
| 30992517 | 30992517 | PRJNA473201_P_NODE_48634_length_295_cov_1.378378_g47892_i0 | PRJNA473201 | 48634 | 295 | 1.378378 | 4.0662151 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 94.4 | 5.4e-20 | NR | WLN26256.1 | 3065075 | g47892 | i0 | 45.8 | 0.976271186440678 | 96 | 52 | 97.6 | 0 | 7 | 294 | 129 | 224 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 288 | 94.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);;