contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA473201" and tax_phylum = "Negarnaviricota"
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 |
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);;