contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA683669" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1174772 | 1174772 | PRJNA683669_P_NODE_1001_length_1245_cov_6.674061_g881_i0 | PRJNA683669 | 1001 | 1245 | 6.674061 | 83.09205945 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2283 | 0 | NTclustered | gi|1394370381|gb|MH362816.1| | 2560580 | g881 | i0 | 99.759 | 83.7927710843373 | 1245 | 3 | 100 | 0 | 1 | 1245 | 1803 | 3047 | Mammalian orthorubulavirus 5 strain CAN, complete genome | blastn | 104322 | 2283 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 1174947 | 1174947 | PRJNA683669_P_NODE_461_length_1654_cov_5.636939_g396_i0 | PRJNA683669 | 461 | 1654 | 5.636939 | 93.23497106 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3038 | 0 | NTclustered | gi|2507986953|gb|OQ348510.1| | 2560580 | g396 | i0 | 99.819 | 76.3022974607013 | 1654 | 3 | 100 | 0 | 1 | 1654 | 69 | 1722 | Mammalian orthorubulavirus 5 isolate HLJ-W, complete genome | blastn | 126204 | 3038 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2450139 | 2450139 | PRJNA683669_P_NODE_1662_length_1002_cov_2.212056_g1502_i0 | PRJNA683669 | 1662 | 1002 | 2.212056 | 22.16480112 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1845 | 0 | NTclustered | gi|2325361299|gb|OL548911.1| | 149595 | g1502 | i0 | 99.9 | 83.998003992016 | 1002 | 1 | 100 | 0 | 1 | 1002 | 680 | 1681 | Canine parainfluenza virus isolate SH2021 hemagglutinin-neuraminidase (HN) gene, complete cds | blastn | 84166 | 1851 | 0.9967585089141 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Canine parainfluenza virus | |||
| 6278863 | 6278863 | PRJNA683669_P_NODE_18045_length_305_cov_0.987069_g17813_i0 | PRJNA683669 | 18045 | 305 | 0.987069 | 3.01056045 | Orthorubulavirus | 2560195 | Viruses | Viruses | 558 | 1.37e-154 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g17813 | i0 | 99.672 | 67.9704918032787 | 305 | 1 | 100 | 0 | 1 | 305 | 3129 | 3433 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 20731 | 558 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 6278878 | 6278878 | PRJNA683669_P_NODE_20365_length_286_cov_1.248826_g20133_i0 | PRJNA683669 | 20365 | 286 | 1.248826 | 3.57164236 | Cripavirus | 144051 | Viruses | Viruses | 424 | 4.86e-114 | NTclustered | gi|2196304203|gb|MZ679075.1| | 1955141 | g20133 | i0 | 93.357 | 7.24825174825175 | 286 | 19 | 100 | 0 | 1 | 286 | 697 | 982 | MAG: Cripavirus sp. isolate 165b-k141_225497 nonstructural polyprotein gene, complete cds; and capsid polyprotein gene, partial cds | blastn | 2073 | 424 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus sp. | ||
| 7043565 | 7043565 | PRJNA683669_P_NODE_14306_length_342_cov_1.784387_g14075_i0 | PRJNA683669 | 14306 | 342 | 1.784387 | 6.10260354 | Hangzhou hydrellia griseola dicistrovirus 1 | 2905414 | Viruses | Viruses | 424 | 5.95e-114 | NTclustered | gi|2170811221|gb|MZ209736.1| | 2905414 | g14075 | i0 | 93.357 | 3.34502923976608 | 286 | 19 | 84 | 0 | 57 | 342 | 7749 | 8034 | MAG: Hangzhou hydrellia griseola dicistrovirus 1 isolate YSP1FY336, complete genome | blastn | 1144 | 424 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Hangzhou hydrellia griseola dicistrovirus 1 | |||
| 8318260 | 8318260 | PRJNA683669_P_NODE_9187_length_422_cov_1.191977_g8956_i0 | PRJNA683669 | 9187 | 422 | 1.191977 | 5.03014294 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 680 | 0 | NTclustered | gi|1836405876|gb|MN905999.1| | 1955144 | g8956 | i0 | 95.735 | 5.39810426540284 | 422 | 18 | 100 | 0 | 1 | 422 | 8143 | 8564 | MAG: Dicistroviridae sp. isolate wag171dic3 genomic sequence, sequence | blastn | 2278 | 680 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 8827865 | 8827865 | PRJNA683669_P_NODE_67_length_2955_cov_3.656142_g54_i0 | PRJNA683669 | 67 | 2955 | 3.656142 | 108.0389961 | Orthorubulavirus | 2560195 | Viruses | Viruses | 5446 | 0 | NTclustered | gi|1394370381|gb|MH362816.1| | 2560580 | g54 | i0 | 99.932 | 83.7749576988156 | 2955 | 2 | 100 | 0 | 1 | 2955 | 6071 | 3117 | Mammalian orthorubulavirus 5 strain CAN, complete genome | blastn | 247555 | 5446 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10868849 | 10868849 | PRJNA683669_P_NODE_10009_length_405_cov_2.283133_g9778_i0 | PRJNA683669 | 10009 | 405 | 2.283133 | 9.24668865 | Chrocomolt virus | 3129476 | Viruses | Viruses | 553 | 8.739999999999998e-153 | NTclustered | gi|2717317674|gb|PP171924.1| | 3129476 | g9778 | i0 | 94.215 | 15.762962962963 | 363 | 20 | 89 | 1 | 16 | 377 | 4400 | 4038 | MAG: Chrocomolt virus isolate CC1B_k141_48525 genomic sequence | blastn | 6384 | 553 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Chrocomolt virus | ||||
| 12654250 | 12654250 | PRJNA683669_P_NODE_15930_length_325_cov_1.099206_g15699_i0 | PRJNA683669 | 15930 | 325 | 1.099206 | 3.5724195 | Cripavirus | 144051 | Viruses | Viruses | 440 | 5.579999999999999e-119 | NTclustered | gi|2196304203|gb|MZ679075.1| | 1955141 | g15699 | i0 | 91.077 | 9.98769230769231 | 325 | 29 | 100 | 0 | 1 | 325 | 1548 | 1872 | MAG: Cripavirus sp. isolate 165b-k141_225497 nonstructural polyprotein gene, complete cds; and capsid polyprotein gene, partial cds | blastn | 3246 | 440 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus sp. | ||
| 13418996 | 13418996 | PRJNA683669_P_NODE_32171_length_243_cov_1.129412_g31939_i0 | PRJNA683669 | 32171 | 243 | 1.129412 | 2.74447116 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 364 | 2.479999999999999e-96 | NTclustered | gi|2756423324|gb|PP745452.1| | 1955144 | g31939 | i0 | 93.802 | 7.96296296296296 | 242 | 15 | 99 | 0 | 2 | 243 | 2953 | 3194 | MAG: Dicistroviridae sp. isolate 129_15506 genomic sequence | blastn | 1935 | 364 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 15203559 | 15203559 | PRJNA683669_P_NODE_25472_length_254_cov_1.276243_g25240_i0 | PRJNA683669 | 25472 | 254 | 1.276243 | 3.24165722 | Viruses | 10239 | Viruses | Viruses | 357 | 4.36e-94 | NTclustered | gi|2756423469|gb|PP745525.1| | 1955144 | g25240 | i0 | 92.095 | 9.91732283464567 | 253 | 20 | 99 | 0 | 2 | 254 | 373 | 625 | MAG: Dicistroviridae sp. isolate 196_164348 genomic sequence | blastn | 2519 | 359 | 0.994428969359331 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 15203585 | 15203585 | PRJNA683669_P_NODE_31352_length_244_cov_1.766082_g31120_i0 | PRJNA683669 | 31352 | 244 | 1.766082 | 4.30924008 | Orthorubulavirus | 2560195 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|1394370381|gb|MH362816.1| | 2560580 | g31120 | i0 | 100 | 66.0040983606557 | 244 | 0 | 100 | 0 | 1 | 244 | 6486 | 6243 | Mammalian orthorubulavirus 5 strain CAN, complete genome | blastn | 16105 | 451 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 17752691 | 17752691 | PRJNA683669_P_NODE_21614_length_279_cov_1.092233_g21382_i0 | PRJNA683669 | 21614 | 279 | 1.092233 | 3.04733007 | Orthorubulavirus | 2560195 | Viruses | Viruses | 510 | 3.5299999999999996e-140 | NTclustered | gi|1394370381|gb|MH362816.1| | 2560580 | g21382 | i0 | 99.642 | 67.741935483871 | 279 | 1 | 100 | 0 | 1 | 279 | 12351 | 12629 | Mammalian orthorubulavirus 5 strain CAN, complete genome | blastn | 18900 | 510 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22852255 | 22852255 | PRJNA683669_P_NODE_14638_length_339_cov_0.868421_g14407_i0 | PRJNA683669 | 14638 | 339 | 0.868421 | 2.94394719 | Viruses | 10239 | Viruses | Viruses | 516 | 9.44e-142 | NTclustered | gi|2170811218|gb|MZ209732.1| | 2905414 | g14407 | i0 | 94.1 | 10.7109144542773 | 339 | 20 | 100 | 0 | 1 | 339 | 4882 | 4544 | MAG: Hangzhou hydrellia griseola dicistrovirus 1 isolate XHQTFY46, complete genome | blastn | 3631 | 521 | 0.990403071017274 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Hangzhou hydrellia griseola dicistrovirus 1 | |||
| 24126906 | 24126906 | PRJNA683669_P_NODE_34239_length_240_cov_2.305389_g34007_i0 | PRJNA683669 | 34239 | 240 | 2.305389 | 5.5329336 | Orthorubulavirus | 2560195 | Viruses | Viruses | 444 | 3.05e-120 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g34007 | i0 | 100 | 69.75 | 240 | 0 | 100 | 0 | 1 | 240 | 1204 | 1443 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 16740 | 444 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 24126928 | 24126928 | PRJNA683669_P_NODE_5979_length_525_cov_2.714602_g5750_i0 | PRJNA683669 | 5979 | 525 | 2.714602 | 14.2516605 | Orthorubulavirus | 2560195 | Viruses | Viruses | 965 | 0 | NTclustered | gi|2050235017|gb|MT890698.1| | 2560580 | g5750 | i0 | 99.81 | 80.9752380952381 | 525 | 1 | 100 | 0 | 1 | 525 | 6509 | 7033 | Mammalian orthorubulavirus 5 strain SH/2015/122/PIV5, complete genome | blastn | 42512 | 965 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 24891061 | 24891061 | PRJNA683669_P_NODE_17500_length_309_cov_2.665254_g17268_i0 | PRJNA683669 | 17500 | 309 | 2.665254 | 8.23563486 | Mitovirus sp. | 2587224 | Viruses | Viruses | 121 | 7.8e-23 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g17268 | i0 | 93.75 | 0.258899676375405 | 80 | 5 | 26 | 0 | 199 | 278 | 112 | 33 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 80 | 121 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. |
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);;