contig_metadata
17 rows where bioproject = "PRJNA1046144" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4837299 | 4837299 | PRJNA1046144_P_NODE_4_length_6415_cov_243.468327_g3_i0 | PRJNA1046144 | 4 | 6415 | 243.468327 | 15618.49317705 | root | 1 | Root_unresolved | Root_unresolved | 11566 | 0 | NTclustered | gi|388240129|emb|HE818411.1| | 12242 | g3 | i0 | 99.559 | 99.8254091971941 | 6347 | 28 | 100 | 0 | 69 | 6415 | 6386 | 40 | Tobacco mosaic virus isolate Changle-9, complete genome | blastn | 640380 | 11566 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 6550734 | 6550734 | PRJNA1046144_P_NODE_59686_length_233_cov_0.878049_g59391_i0 | PRJNA1046144 | 59686 | 233 | 0.878049 | 2.04585417 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 425 | 1.07e-114 | NTclustered | gi|2161743781|gb|OL761638.1| | 2697049 | g59391 | i0 | 99.571 | 100 | 233 | 1 | 100 | 0 | 1 | 233 | 28707 | 28939 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/AZ-CDC-ASC210483568/2021, complete genome | blastn | 23300 | 425 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 15475349 | 15475349 | PRJNA1046144_P_NODE_52193_length_243_cov_1.367816_g51898_i0 | PRJNA1046144 | 52193 | 243 | 1.367816 | 3.32379288 | Chronazanb virus | 3129852 | Viruses | Viruses | 141 | 4.54e-29 | NTclustered | gi|2717318485|gb|PP172249.1| | 3129852 | g51898 | i0 | 95.455 | 6.57201646090535 | 88 | 4 | 36 | 0 | 147 | 234 | 4398 | 4485 | MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence | blastn | 1597 | 141 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazanb virus | |||||
| 18024007 | 18024007 | PRJNA1046144_P_NODE_355_length_2008_cov_3.012378_g328_i0 | PRJNA1046144 | 355 | 2008 | 3.012378 | 60.48855024 | Iflavirus sp. | 1916690 | Viruses | Viruses | 1147 | 0 | NTclustered | gi|2895513769|tpg|BK068505.1| | 1916690 | g328 | i0 | 79.462 | 23.7001992031872 | 1636 | 322 | 81 | 12 | 319 | 1947 | 10102 | 11730 | TPA_asm: Iflavirus sp. isolate WUR34 polyprotein gene, complete cds | blastn | 47590 | 1147 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 22686215 | 22686215 | PRJNA1046144_P_NODE_60218_length_232_cov_0.883436_g59923_i0 | PRJNA1046144 | 60218 | 232 | 0.883436 | 2.04957152 | Paramyxoviridae | 11158 | Viruses | Viruses | 429 | 8.2e-116 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g59923 | i0 | 100 | 68.8189655172414 | 232 | 0 | 100 | 0 | 1 | 232 | 2855 | 3086 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 15966 | 429 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 27856451 | 27856451 | PRJNA1046144_P_NODE_16325_length_399_cov_5.639394_g16030_i0 | PRJNA1046144 | 16325 | 399 | 5.639394 | 22.50118206 | Sinu virus | 1927799 | Viruses | Viruses | 184 | 6.13e-53 | NR | YP_010840496.1 | 1927799 | g16030 | i0 | 60.8 | 0.977443609022556 | 130 | 51 | 97.7 | 0 | 3 | 392 | 360 | 489 | YP_010840496.1 glycoprotein [Sinu virus] | diamond | 390 | 184 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Thogotovirus | Thogotovirus sinuense | ||
| 28172220 | 28172220 | PRJNA1046144_P_NODE_65126_length_229_cov_0.900000_g64831_i0 | PRJNA1046144 | 65126 | 229 | 0.9 | 2.061 | Sinu virus | 1927799 | Viruses | Viruses | 114 | 1.4700000000000002e-27 | NR | YP_010840497.1 | 1927799 | g64831 | i0 | 72.4 | 0.995633187772926 | 76 | 21 | 99.6 | 0 | 228 | 1 | 263 | 338 | YP_010840497.1 PB2 polymerase subunit [Sinu virus] | diamond | 228 | 114 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Thogotovirus | Thogotovirus sinuense | ||
| 28835332 | 28835332 | PRJNA1046144_P_NODE_54268_length_238_cov_1.704142_g53973_i0 | PRJNA1046144 | 54268 | 238 | 1.704142 | 4.05585796 | Reoviridae sp. | 2585267 | Viruses | Viruses | 118 | 1.02e-28 | NR | WWV87256.1 | 2585267 | g53973 | i0 | 68.4 | 0.995798319327731 | 79 | 25 | 99.6 | 0 | 238 | 2 | 810 | 888 | WWV87256.1 MAG: RNA-dependent RNA polymerase [Reoviridae sp.] | diamond | 237 | 118 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Reoviridae sp. | ||||
| 29119739 | 29119739 | PRJNA1046144_P_NODE_70489_length_223_cov_2.266234_g70194_i0 | PRJNA1046144 | 70489 | 223 | 2.266234 | 5.05370182 | Reoviridae sp. | 2585267 | Viruses | Viruses | 91.3 | 2.4e-19 | NR | WWV87256.1 | 2585267 | g70194 | i0 | 59.5 | 1.97757847533632 | 74 | 30 | 99.6 | 0 | 1 | 222 | 638 | 711 | WWV87256.1 MAG: RNA-dependent RNA polymerase [Reoviridae sp.] | diamond | 441 | 91.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Reoviridae sp. | ||||
| 29214471 | 29214471 | PRJNA1046144_P_NODE_289_length_2131_cov_3.489816_g266_i0 | PRJNA1046144 | 289 | 2131 | 3.489816 | 74.36797896 | Guiyang narnavirus 1 | 2905332 | Viruses | Viruses | 479 | 4.16e-156 | NR | UHR49782.1 | 2905332 | g266 | i0 | 39.9 | 1.0361332707649 | 736 | 378 | 98.7 | 16 | 2106 | 4 | 3 | 709 | UHR49782.1 MAG: RNA-dependent RNA polymerase, partial [Guiyang narnavirus 1] | diamond | 2208 | 479 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Guiyang narnavirus 1 | ||
| 29498341 | 29498341 | PRJNA1046144_P_NODE_39630_length_272_cov_2.128079_g39335_i0 | PRJNA1046144 | 39630 | 272 | 2.128079 | 5.78837488 | Sinu virus | 1927799 | Viruses | Viruses | 155 | 3.0299999999999996e-42 | NR | YP_010840494.1 | 1927799 | g39335 | i0 | 75.6 | 0.992647058823529 | 90 | 22 | 99.3 | 0 | 271 | 2 | 543 | 632 | YP_010840494.1 PA polymerase subunit [Sinu virus] | diamond | 270 | 155 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Thogotovirus | Thogotovirus sinuense | ||
| 29561376 | 29561376 | PRJNA1046144_P_NODE_2710_length_929_cov_10.017442_g2501_i0 | PRJNA1046144 | 2710 | 929 | 10.017442 | 93.06203618 | Sinu virus | 1927799 | Viruses | Viruses | 297 | 5.59e-97 | NR | YP_010840498.1 | 1927799 | g2501 | i0 | 53.9 | 0.8751345532831 | 271 | 123 | 86.9 | 1 | 901 | 95 | 1 | 271 | YP_010840498.1 ML [Sinu virus] | diamond | 813 | 297 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Thogotovirus | Thogotovirus sinuense | ||
| 29782533 | 29782533 | PRJNA1046144_P_NODE_22951_length_343_cov_1.576642_g22656_i0 | PRJNA1046144 | 22951 | 343 | 1.576642 | 5.40788206 | Sinu virus | 1927799 | Viruses | Viruses | 175 | 8.86e-49 | NR | YP_010840499.1 | 1927799 | g22656 | i0 | 76.1 | 0.988338192419825 | 113 | 27 | 98.8 | 0 | 3 | 341 | 125 | 237 | YP_010840499.1 PB1 protein [Sinu virus] | diamond | 339 | 175 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Thogotovirus | Thogotovirus sinuense | ||
| 31520733 | 31520733 | PRJNA1046144_P_NODE_55616_length_235_cov_2.572289_g55321_i0 | PRJNA1046144 | 55616 | 235 | 2.572289 | 6.04487915 | Sinu virus | 1927799 | Viruses | Viruses | 58.9 | 6.66e-8 | NR | YP_010840494.1 | 1927799 | g55321 | i0 | 47.1 | 0.868085106382979 | 68 | 34 | 85.5 | 2 | 34 | 234 | 109 | 175 | YP_010840494.1 PA polymerase subunit [Sinu virus] | diamond | 204 | 58.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Thogotovirus | Thogotovirus sinuense | ||
| 31520735 | 31520735 | PRJNA1046144_P_NODE_57096_length_234_cov_2.048485_g56801_i0 | PRJNA1046144 | 57096 | 234 | 2.048485 | 4.7934549 | Reoviridae sp. | 2585267 | Viruses | Viruses | 103 | 9.379999999999999e-24 | NR | WWV87256.1 | 2585267 | g56801 | i0 | 64.9 | 0.987179487179487 | 77 | 27 | 98.7 | 0 | 232 | 2 | 734 | 810 | WWV87256.1 MAG: RNA-dependent RNA polymerase [Reoviridae sp.] | diamond | 231 | 103 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Reoviridae sp. | ||||
| 31836675 | 31836675 | PRJNA1046144_P_NODE_44777_length_259_cov_3.989474_g44482_i0 | PRJNA1046144 | 44777 | 259 | 3.989474 | 10.33273766 | Sinu virus | 1927799 | Viruses | Viruses | 74.3 | 3.38e-13 | NR | YP_010840496.1 | 1927799 | g44482 | i0 | 50 | 0.833976833976834 | 72 | 32 | 81.1 | 2 | 211 | 2 | 7 | 76 | YP_010840496.1 glycoprotein [Sinu virus] | diamond | 216 | 74.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Thogotovirus | Thogotovirus sinuense | ||
| 31836686 | 31836686 | PRJNA1046144_P_NODE_7777_length_565_cov_2.322581_g7485_i0 | PRJNA1046144 | 7777 | 565 | 2.322581 | 13.12258265 | Sinu virus | 1927799 | Viruses | Viruses | 150 | 1.9e-39 | NR | YP_010840496.1 | 1927799 | g7485 | i0 | 41.1 | 2.03362831858407 | 185 | 105 | 96.6 | 2 | 20 | 565 | 203 | 386 | YP_010840496.1 glycoprotein [Sinu virus] | diamond | 1149 | 150 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Thogotovirus | Thogotovirus sinuense |
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);;