contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA561138" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4958771 | 4958771 | PRJNA561138_P_NODE_484_length_1747_cov_18.070490_g6_i1 | PRJNA561138 | 484 | 1747 | 18.07049 | 315.6914603 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3077 | 0 | NTclustered | gi|335114|gb|M81442.1|SV5NUCCAP | 2560580 | g6 | i1 | 98.454 | 75.6754436176302 | 1747 | 27 | 100 | 0 | 1 | 1747 | 1 | 1747 | Simian virus 5 (W3A) NP RNA, complete cds | blastn | 132205 | 3079 | 0.999350438454043 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 7508625 | 7508625 | PRJNA561138_P_NODE_346_length_2008_cov_2.446512_g238_i0 | PRJNA561138 | 346 | 2008 | 2.446512 | 49.12596096 | Paramyxoviridae | 11158 | Viruses | Viruses | 3679 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g238 | i0 | 99.751 | 69.7963147410359 | 2007 | 5 | 99 | 0 | 1 | 2007 | 10174 | 8168 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 140151 | 3707 | 0.992446722417049 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 8198086 | 8198086 | PRJNA561138_P_NODE_3167_length_695_cov_1.485531_g2981_i0 | PRJNA561138 | 3167 | 695 | 1.485531 | 10.32444045 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 1245 | 0 | NTclustered | gi|1841764908|gb|MT124463.1| | 2905673 | g2981 | i0 | 98.993 | 64.7064748201439 | 695 | 7 | 100 | 0 | 1 | 695 | 14541 | 15235 | Parainfluenza virus 5 isolate China/HB01/2019, complete genome | blastn | 44971 | 1245 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10749372 | 10749372 | PRJNA561138_P_NODE_21809_length_274_cov_1.696517_g21614_i0 | PRJNA561138 | 21809 | 274 | 1.696517 | 4.64845658 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 468 | 2.11e-127 | NTclustered | gi|1028325827|gb|KX060176.1| | 2905673 | g21614 | i0 | 99.609 | 77.4270072992701 | 256 | 1 | 93 | 0 | 1 | 256 | 8009 | 8264 | Parainfluenza virus 5 strain AGS, complete genome | blastn | 21215 | 468 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 12609604 | 12609604 | PRJNA561138_P_NODE_23890_length_255_cov_2.115385_g23695_i0 | PRJNA561138 | 23890 | 255 | 2.115385 | 5.39423175 | Orthorubulavirus | 2560195 | Viruses | Viruses | 472 | 1.5e-128 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g23695 | i0 | 100 | 68.756862745098 | 255 | 0 | 100 | 0 | 1 | 255 | 14181 | 13927 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 17533 | 472 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13884489 | 13884489 | PRJNA561138_P_NODE_23931_length_255_cov_1.417582_g23736_i0 | PRJNA561138 | 23931 | 255 | 1.417582 | 3.6148341 | Orthorubulavirus | 2560195 | Viruses | Viruses | 449 | 7.03e-122 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g23736 | i0 | 98.81 | 68.7058823529412 | 252 | 3 | 99 | 0 | 1 | 252 | 14265 | 14516 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 17520 | 449 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13884529 | 13884529 | PRJNA561138_P_NODE_7371_length_458_cov_1.200000_g7177_i0 | PRJNA561138 | 7371 | 458 | 1.2 | 5.496 | Orthorubulavirus | 2560195 | Viruses | Viruses | 846 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g7177 | i0 | 100 | 68.8013100436681 | 458 | 0 | 100 | 0 | 1 | 458 | 12155 | 11698 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 31511 | 846 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16433356 | 16433356 | PRJNA561138_P_NODE_3753_length_636_cov_0.939609_g3564_i0 | PRJNA561138 | 3753 | 636 | 0.939609 | 5.97591324 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1142 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g3564 | i0 | 99.057 | 67.9921383647799 | 636 | 6 | 100 | 0 | 1 | 636 | 13235 | 13870 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 43243 | 1147 | 0.995640802092415 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21532618 | 21532618 | PRJNA561138_P_NODE_14017_length_349_cov_1.949275_g13822_i0 | PRJNA561138 | 14017 | 349 | 1.949275 | 6.80296975 | Paramyxoviridae | 11158 | Viruses | Viruses | 638 | 1.99e-178 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g13822 | i0 | 99.713 | 67.8051575931232 | 348 | 1 | 99 | 0 | 1 | 348 | 12172 | 11825 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 23664 | 638 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 21532624 | 21532624 | PRJNA561138_P_NODE_15037_length_338_cov_1.184906_g14842_i0 | PRJNA561138 | 15037 | 338 | 1.184906 | 4.00498228 | Orthorubulavirus | 2560195 | Viruses | Viruses | 617 | 2.51e-172 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g14842 | i0 | 99.703 | 67.7751479289941 | 337 | 1 | 99 | 0 | 2 | 338 | 11670 | 11334 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 22908 | 617 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21532685 | 21532685 | PRJNA561138_P_NODE_5797_length_515_cov_1.402715_g5603_i0 | PRJNA561138 | 5797 | 515 | 1.402715 | 7.22398225 | Paramyxoviridae | 11158 | Viruses | Viruses | 952 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g5603 | i0 | 100 | 70.8349514563107 | 515 | 0 | 100 | 0 | 1 | 515 | 7566 | 8080 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 36480 | 952 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 24771462 | 24771462 | PRJNA561138_P_NODE_80_length_8611_cov_16.783673_g6_i0 | PRJNA561138 | 80 | 8611 | 16.783673 | 1445.24208203 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 15407 | 0 | NTclustered | gi|2671791284|gb|PP189887.1| | 2905673 | g6 | i0 | 99.025 | 72.5236325630008 | 8611 | 52 | 100 | 7 | 1 | 8611 | 1 | 8579 | Parainfluenza virus 5 isolate PPIV-5/LZ-1/Gansu/2021, complete genome | blastn | 624501 | 15407 | 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);;