contig_metadata
10 rows where bioproject = "PRJNA1086823" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193718 | 193718 | PRJNA1086823_P_NODE_14741_length_249_cov_0.886364_g14624_i0 | PRJNA1086823 | 14741 | 249 | 0.886364 | 2.20704636 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 453 | 5.29e-123 | NTclustered | gi|1028325827|gb|KX060176.1| | 2905673 | g14624 | i0 | 99.597 | 82.6666666666667 | 248 | 1 | 99 | 0 | 2 | 249 | 7047 | 6800 | Parainfluenza virus 5 strain AGS, complete genome | blastn | 20584 | 453 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 4845509 | 4845509 | PRJNA1086823_P_NODE_8444_length_288_cov_1.446512_g8327_i0 | PRJNA1086823 | 8444 | 288 | 1.446512 | 4.16595456 | Orthorubulavirus | 2560195 | Viruses | Viruses | 532 | 7.8e-147 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g8327 | i0 | 100 | 96.3125 | 288 | 0 | 100 | 0 | 1 | 288 | 1078 | 791 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 27738 | 532 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 8670661 | 8670661 | PRJNA1086823_P_NODE_4647_length_366_cov_2.587031_g4530_i0 | PRJNA1086823 | 4647 | 366 | 2.587031 | 9.46853346 | Orthorubulavirus | 2560195 | Viruses | Viruses | 676 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g4530 | i0 | 100 | 81.6939890710382 | 366 | 0 | 100 | 0 | 1 | 366 | 1798 | 2163 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 29900 | 676 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 9945581 | 9945581 | PRJNA1086823_P_NODE_2028_length_527_cov_1.132159_g1912_i0 | PRJNA1086823 | 2028 | 527 | 1.132159 | 5.96647793 | Orthorubulavirus | 2560195 | Viruses | Viruses | 959 | 0 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g1912 | i0 | 99.619 | 97.6242884250474 | 525 | 2 | 99 | 0 | 1 | 525 | 255 | 779 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 51448 | 965 | 0.993782383419689 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 9945584 | 9945584 | PRJNA1086823_P_NODE_2588_length_474_cov_1.486284_g2471_i0 | PRJNA1086823 | 2588 | 474 | 1.486284 | 7.04498616 | Orthorubulavirus | 2560195 | Viruses | Viruses | 870 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g2471 | i0 | 99.789 | 70 | 474 | 1 | 100 | 0 | 1 | 474 | 1564 | 1091 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 33180 | 870 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10397269 | 10397269 | PRJNA1086823_P_NODE_8389_length_289_cov_1.032407_g8272_i0 | PRJNA1086823 | 8389 | 289 | 1.032407 | 2.98365623 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 508 | 1.32e-139 | NTclustered | gi|1028325827|gb|KX060176.1| | 2905673 | g8272 | i0 | 98.616 | 84.8927335640138 | 289 | 1 | 100 | 1 | 1 | 289 | 2269 | 2554 | Parainfluenza virus 5 strain AGS, complete genome | blastn | 24534 | 508 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13770731 | 13770731 | PRJNA1086823_P_NODE_14451_length_249_cov_1.329545_g14334_i0 | PRJNA1086823 | 14451 | 249 | 1.329545 | 3.31056705 | Orthorubulavirus | 2560195 | Viruses | Viruses | 460 | 3.16e-125 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g14334 | i0 | 100 | 67.9919678714859 | 249 | 0 | 100 | 0 | 1 | 249 | 3913 | 4161 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 16930 | 460 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13770751 | 13770751 | PRJNA1086823_P_NODE_2331_length_495_cov_2.431280_g2214_i0 | PRJNA1086823 | 2331 | 495 | 2.43128 | 12.034836 | Orthorubulavirus | 2560195 | Viruses | Viruses | 909 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g2214 | i0 | 99.798 | 67.7373737373737 | 495 | 1 | 100 | 0 | 1 | 495 | 3116 | 3610 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 33530 | 909 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 18869052 | 18869052 | PRJNA1086823_P_NODE_7595_length_299_cov_1.637168_g7478_i0 | PRJNA1086823 | 7595 | 299 | 1.637168 | 4.89513232 | Orthorubulavirus | 2560195 | Viruses | Viruses | 542 | 1.35e-149 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g7478 | i0 | 99.331 | 83 | 299 | 2 | 100 | 0 | 1 | 299 | 7679 | 7381 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 24817 | 547 | 0.990859232175503 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22694289 | 22694289 | PRJNA1086823_P_NODE_1958_length_534_cov_1.644252_g1842_i0 | PRJNA1086823 | 1958 | 534 | 1.644252 | 8.78030568 | Orthorubulavirus | 2560195 | Viruses | Viruses | 981 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g1842 | i0 | 99.813 | 83.4157303370787 | 534 | 1 | 100 | 0 | 1 | 534 | 70 | 603 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 44544 | 981 | 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);;