contig_metadata
15 rows where bioproject = "PRJNA1156092" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2312587 | 2312587 | PRJNA1156092_P_NODE_5762_length_436_cov_1.903581_g5632_i0 | PRJNA1156092 | 5762 | 436 | 1.903581 | 8.29961316 | Paramyxoviridae | 11158 | Viruses | Viruses | 800 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g5632 | i0 | 99.771 | 68.9839449541284 | 436 | 1 | 100 | 0 | 1 | 436 | 2509 | 2074 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 30077 | 806 | 0.992555831265509 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 4865384 | 4865384 | PRJNA1156092_P_NODE_724_length_1041_cov_1.577479_g642_i0 | PRJNA1156092 | 724 | 1041 | 1.577479 | 16.42155639 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1901 | 0 | NTclustered | gi|146351838|gb|EF543648.1| | 149595 | g642 | i0 | 99.616 | 75.073967339097 | 1041 | 4 | 100 | 0 | 1 | 1041 | 1460 | 420 | Canine parainfluenza virus strain FA nucleocapsid (N) gene, complete cds | blastn | 78152 | 1917 | 0.991653625456442 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Canine parainfluenza virus | |||
| 6680503 | 6680503 | PRJNA1156092_P_NODE_13606_length_312_cov_1.271967_g13476_i0 | PRJNA1156092 | 13606 | 312 | 1.271967 | 3.96853704 | Periplaneta americana dicistro-like virus | 3032225 | Viruses | Viruses | 412 | 1.1599999999999999e-110 | NTclustered | gi|2754804027|tpg|BK063169.1| | 3032225 | g13476 | i0 | 90.764 | 1.00641025641026 | 314 | 22 | 100 | 6 | 1 | 312 | 4593 | 4285 | TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds | blastn | 314 | 412 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Periplaneta americana dicistro-like virus | |||
| 8690327 | 8690327 | PRJNA1156092_P_NODE_3647_length_529_cov_1.065789_g3518_i0 | PRJNA1156092 | 3647 | 529 | 1.065789 | 5.63802381 | Orthorubulavirus | 2560195 | Viruses | Viruses | 966 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g3518 | i0 | 99.622 | 85.3478260869565 | 529 | 2 | 100 | 0 | 1 | 529 | 2197 | 2725 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 45149 | 966 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 14331706 | 14331706 | PRJNA1156092_P_NODE_16732_length_286_cov_1.441315_g16602_i0 | PRJNA1156092 | 16732 | 286 | 1.441315 | 4.1221609 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 529 | 1e-145 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g16602 | i0 | 100 | 83.9965034965035 | 286 | 0 | 100 | 0 | 1 | 286 | 7485 | 7200 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 24023 | 529 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16339625 | 16339625 | PRJNA1156092_P_NODE_14493_length_304_cov_1.333333_g14363_i0 | PRJNA1156092 | 14493 | 304 | 1.333333 | 4.05333232 | Paramyxoviridae | 11158 | Viruses | Viruses | 556 | 4.919999999999999e-154 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g14363 | i0 | 99.671 | 96.9605263157895 | 304 | 1 | 100 | 0 | 1 | 304 | 4834 | 4531 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 29476 | 556 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 16339742 | 16339742 | PRJNA1156092_P_NODE_27893_length_245_cov_1.313953_g27763_i0 | PRJNA1156092 | 27893 | 245 | 1.313953 | 3.21918485 | Orthorubulavirus | 2560195 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g27763 | i0 | 100 | 76.4367346938776 | 245 | 0 | 100 | 0 | 1 | 245 | 42 | 286 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 18727 | 453 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 17614978 | 17614978 | PRJNA1156092_P_NODE_25754_length_247_cov_1.770115_g25624_i0 | PRJNA1156092 | 25754 | 247 | 1.770115 | 4.37218405 | Orthorubulavirus | 2560195 | Viruses | Viruses | 446 | 8.759999999999998e-121 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g25624 | i0 | 99.59 | 53.336032388664 | 244 | 1 | 99 | 0 | 4 | 247 | 6462 | 6219 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 13174 | 446 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 20163672 | 20163672 | PRJNA1156092_P_NODE_6096_length_427_cov_1.220339_g5966_i0 | PRJNA1156092 | 6096 | 427 | 1.220339 | 5.21084753 | Paramyxoviridae | 11158 | Viruses | Viruses | 767 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g5966 | i0 | 99.063 | 81.0140515222482 | 427 | 4 | 100 | 0 | 1 | 427 | 1161 | 735 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 34593 | 767 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 20704151 | 20704151 | PRJNA1156092_P_NODE_21697_length_251_cov_4.084270_g21567_i0 | PRJNA1156092 | 21697 | 251 | 4.08427 | 10.2515177 | Mitovirus sp. | 2587224 | Viruses | Viruses | 174 | 4.65e-39 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g21567 | i0 | 94.643 | 3.7410358565737 | 112 | 6 | 45 | 0 | 5 | 116 | 1 | 112 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 939 | 174 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 21439168 | 21439168 | PRJNA1156092_P_NODE_32057_length_241_cov_0.916667_g31927_i0 | PRJNA1156092 | 32057 | 241 | 0.916667 | 2.20916747 | Viruses | 10239 | Viruses | Viruses | 115 | 2.73e-21 | NTclustered | gi|2461860523|dbj|LC726803.1| | 1046403 | g31927 | i0 | 98.485 | 26.1203319502075 | 66 | 0 | 27 | 1 | 177 | 241 | 1143 | 1078 | Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein | blastn | 6295 | 115 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Polerovirus | Polerovirus TUYV | ||
| 22714137 | 22714137 | PRJNA1156092_P_NODE_2178_length_663_cov_1.452542_g2053_i0 | PRJNA1156092 | 2178 | 663 | 1.452542 | 9.63035346 | Paramyxoviridae | 11158 | Viruses | Viruses | 1214 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g2053 | i0 | 99.698 | 69.078431372549 | 663 | 2 | 100 | 0 | 1 | 663 | 3384 | 2722 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 45799 | 1225 | 0.991020408163265 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 23255273 | 23255273 | PRJNA1156092_P_NODE_7499_length_393_cov_1.893750_g7369_i0 | PRJNA1156092 | 7499 | 393 | 1.89375 | 7.4424375 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 108 | 7.91e-19 | NTclustered | gi|2165834316|emb|OV196022.1| | 2697049 | g7369 | i0 | 93.243 | 19.9618320610687 | 74 | 4 | 19 | 1 | 1 | 74 | 592 | 520 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 7845 | 108 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 23989349 | 23989349 | PRJNA1156092_P_NODE_13559_length_312_cov_2.255230_g13429_i0 | PRJNA1156092 | 13559 | 312 | 2.25523 | 7.0363176 | Paramyxoviridae | 11158 | Viruses | Viruses | 575 | 1.3999999999999999e-159 | NTclustered | gi|145617272|gb|EF546392.1| | 149595 | g13429 | i0 | 100 | 97.6410256410256 | 311 | 0 | 99 | 0 | 1 | 311 | 1138 | 828 | Canine parainfluenza virus strain FC fusion protein (F) gene, complete cds | blastn | 30464 | 575 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Canine parainfluenza virus | |||
| 28828045 | 28828045 | PRJNA1156092_P_NODE_18908_length_271_cov_1.166667_g18778_i0 | PRJNA1156092 | 18908 | 271 | 1.166667 | 3.16166757 | Chuvivirus | 2842604 | Viruses | Viruses | 138 | 1.55e-36 | NR | WET19887.1 | 2842604 | g18778 | i0 | 69.7 | 1.97047970479705 | 89 | 27 | 98.5 | 0 | 268 | 2 | 292 | 380 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 534 | 138 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus |
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);;