contig_metadata
4 rows where bioproject = "PRJNA1118794", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1024927 | 1024927 | PRJNA1118794_P_NODE_44041_length_260_cov_1.406417_g43291_i0 | PRJNA1118794 | 44041 | 260 | 1.406417 | 3.6566842 | Orthorubulavirus | 2560195 | Viruses | Viruses | 481 | 2.55e-131 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g43291 | i0 | 100 | 68.2692307692308 | 260 | 0 | 100 | 0 | 1 | 260 | 4160 | 4419 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 17750 | 481 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 1505548 | 1505548 | PRJNA1118794_P_NODE_45782_length_256_cov_1.683060_g45032_i0 | PRJNA1118794 | 45782 | 256 | 1.68306 | 4.3086336 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 472 | 1.51e-128 | NTclustered | gi|2562721692|gb|OQ994985.1| | 2905673 | g45032 | i0 | 100 | 67.984375 | 255 | 0 | 99 | 0 | 2 | 256 | 13822 | 14076 | Parainfluenza virus 5 strain GX2020, complete genome | blastn | 17404 | 472 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15052671 | 15052671 | PRJNA1118794_P_NODE_69852_length_242_cov_1.366864_g69102_i0 | PRJNA1118794 | 69852 | 242 | 1.366864 | 3.30781088 | Orthorubulavirus | 2560195 | Viruses | Viruses | 448 | 2.3799999999999995e-121 | NTclustered | gi|2507986953|gb|OQ348510.1| | 2560580 | g69102 | i0 | 100 | 68.004132231405 | 242 | 0 | 100 | 0 | 1 | 242 | 13035 | 12794 | Mammalian orthorubulavirus 5 isolate HLJ-W, complete genome | blastn | 16457 | 448 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 25251184 | 25251184 | PRJNA1118794_P_NODE_14720_length_379_cov_1.307190_g13970_i0 | PRJNA1118794 | 14720 | 379 | 1.30719 | 4.9542501 | Orthorubulavirus | 2560195 | Viruses | Viruses | 684 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g13970 | i0 | 99.208 | 63.5804749340369 | 379 | 3 | 100 | 0 | 1 | 379 | 15239 | 14861 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 24097 | 684 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis |
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);;