contig_metadata
8 rows where bioproject = "PRJNA421571", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2361552 | 2361552 | PRJNA421571_P_NODE_70142_length_303_cov_1.469565_g67593_i0 | PRJNA421571 | 70142 | 303 | 1.469565 | 4.45278195 | Paramyxoviridae | 11158 | Viruses | Viruses | 555 | 1.7599999999999995e-153 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g67593 | i0 | 99.67 | 68.3795379537954 | 303 | 1 | 100 | 0 | 1 | 303 | 10815 | 10513 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 20719 | 555 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 3636759 | 3636759 | PRJNA421571_P_NODE_4603_length_1677_cov_4.379676_g3871_i0 | PRJNA421571 | 4603 | 1677 | 4.379676 | 73.44716652 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3092 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g3871 | i0 | 99.94 | 97.6869409660107 | 1677 | 1 | 100 | 0 | 1 | 1677 | 4485 | 6161 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 163821 | 3092 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 4913957 | 4913957 | PRJNA421571_P_NODE_504_length_3044_cov_3.789633_g395_i0 | PRJNA421571 | 504 | 3044 | 3.789633 | 115.35642852 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3949 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g395 | i0 | 99.494 | 77.8298291721419 | 2172 | 10 | 100 | 1 | 873 | 3044 | 2206 | 36 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 236914 | 3949 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 6189266 | 6189266 | PRJNA421571_P_NODE_8145_length_1326_cov_6.664006_g6940_i0 | PRJNA421571 | 8145 | 1326 | 6.664006 | 88.36471956 | Paramyxoviridae | 11158 | Viruses | Viruses | 2427 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g6940 | i0 | 99.698 | 69.0399698340875 | 1326 | 4 | 100 | 0 | 1 | 1326 | 3382 | 2057 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 91547 | 2438 | 0.995488105004102 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 6189273 | 6189273 | PRJNA421571_P_NODE_82385_length_271_cov_1.555556_g79836_i0 | PRJNA421571 | 82385 | 271 | 1.555556 | 4.21555676 | Orthorubulavirus | 2560195 | Viruses | Viruses | 501 | 2.05e-137 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g79836 | i0 | 100 | 69.3173431734317 | 271 | 0 | 100 | 0 | 1 | 271 | 11431 | 11161 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 18785 | 501 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 18937346 | 18937346 | PRJNA421571_P_NODE_50695_length_386_cov_0.980831_g48147_i0 | PRJNA421571 | 50695 | 386 | 0.980831 | 3.78600766 | Orthorubulavirus | 2560195 | Viruses | Viruses | 713 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g48147 | i0 | 100 | 63.9145077720207 | 386 | 0 | 100 | 0 | 1 | 386 | 15087 | 14702 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 24671 | 713 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 20212273 | 20212273 | PRJNA421571_P_NODE_66556_length_315_cov_1.590909_g64007_i0 | PRJNA421571 | 66556 | 315 | 1.590909 | 5.01136335 | Paramyxoviridae | 11158 | Viruses | Viruses | 582 | 8.459999999999998e-162 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g64007 | i0 | 100 | 82.5619047619048 | 315 | 0 | 100 | 0 | 1 | 315 | 5548 | 5862 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 26007 | 582 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 26600515 | 26600515 | PRJNA421571_P_NODE_60641_length_337_cov_1.166667_g58092_i0 | PRJNA421571 | 60641 | 337 | 1.166667 | 3.93166779 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 137 | 2.73e-39 | NR | UNI74092.1 | 2900380 | g58092 | i0 | 69.1 | 0.863501483679525 | 97 | 30 | 86.4 | 0 | 335 | 45 | 24 | 120 | UNI74092.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 291 | 137 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis |
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);;