contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA980585" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2229802 | 2229802 | PRJNA980585_P_NODE_14682_length_363_cov_1.031034_g14428_i0 | PRJNA980585 | 14682 | 363 | 1.031034 | 3.74265342 | Fusarium asiaticum narnavirus 1 | 2921214 | Viruses | Viruses | 610 | 4.529999999999999e-170 | NTclustered | gi|2208388235|gb|MZ969061.1| | 2921214 | g14428 | i0 | 96.97 | 1 | 363 | 11 | 100 | 0 | 1 | 363 | 1500 | 1862 | Fusarium asiaticum narnavirus 1 strain NJ-37 segment RNA1 RNA-dependent RNA polymerase gene, complete cds | blastn | 363 | 610 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Fusarium asiaticum narnavirus 1 | ||
| 2545039 | 2545039 | PRJNA980585_P_NODE_3702_length_641_cov_2.579225_g3451_i0 | PRJNA980585 | 3702 | 641 | 2.579225 | 16.53283225 | root | 1 | Root_unresolved | Root_unresolved | 1155 | 0 | NTclustered | gi|2067732485|gb|MT994243.1| | 11250 | g3451 | i0 | 99.219 | 102.897035881435 | 640 | 5 | 99 | 0 | 2 | 641 | 2575 | 3214 | Mutant Human orthopneumovirus isolate recombinant hRSV-P-BFP, complete genome | blastn | 65957 | 1162 | 0.993975903614458 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Pneumoviridae | Orthopneumovirus | Orthopneumovirus hominis | ||
| 8922344 | 8922344 | PRJNA980585_P_NODE_54567_length_244_cov_0.900585_g54313_i0 | PRJNA980585 | 54567 | 244 | 0.900585 | 2.1974274 | Orthorubulavirus | 2560195 | Viruses | Viruses | 442 | 1.1199999999999994e-119 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g54313 | i0 | 99.587 | 68.2131147540984 | 242 | 1 | 99 | 0 | 3 | 244 | 1634 | 1393 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 16644 | 442 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10198084 | 10198084 | PRJNA980585_P_NODE_59628_length_241_cov_1.732143_g59374_i0 | PRJNA980585 | 59628 | 241 | 1.732143 | 4.17446463 | Orthorubulavirus | 2560195 | Viruses | Viruses | 446 | 8.519999999999999e-121 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g59374 | i0 | 100 | 83.8423236514523 | 241 | 0 | 100 | 0 | 1 | 241 | 7180 | 7420 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 20206 | 446 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 11158265 | 11158265 | PRJNA980585_P_NODE_37289_length_259_cov_1.655914_g37035_i0 | PRJNA980585 | 37289 | 259 | 1.655914 | 4.28881726 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 446 | 9.26e-121 | NTclustered | gi|2396039663|gb|ON812899.1| | 2808997 | g37035 | i0 | 97.683 | 1.60617760617761 | 259 | 6 | 100 | 0 | 1 | 259 | 121 | 379 | MAG: Botourmiaviridae sp. isolate TIGMIC_11, complete genome | blastn | 416 | 446 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 11158640 | 11158640 | PRJNA980585_P_NODE_6309_length_512_cov_2.170843_g6055_i0 | PRJNA980585 | 6309 | 512 | 2.170843 | 11.11471616 | Fusarium asiaticum narnavirus 1 | 2921214 | Viruses | Viruses | 891 | 0 | NTclustered | gi|2208388237|gb|MZ969062.1| | 2921214 | g6055 | i0 | 98.047 | 1 | 512 | 10 | 100 | 0 | 1 | 512 | 554 | 1065 | Fusarium asiaticum narnavirus 1 strain NJ-37 segment RNA2 hypothetical protein gene, complete cds | blastn | 512 | 891 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Fusarium asiaticum narnavirus 1 | ||
| 14023260 | 14023260 | PRJNA980585_P_NODE_45011_length_249_cov_0.875000_g44757_i0 | PRJNA980585 | 45011 | 249 | 0.875 | 2.17875 | Orthorubulavirus | 2560195 | Viruses | Viruses | 457 | 4.09e-124 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g44757 | i0 | 100 | 97.1325301204819 | 247 | 0 | 99 | 0 | 3 | 249 | 254 | 8 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 24186 | 457 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 14982604 | 14982604 | PRJNA980585_P_NODE_30972_length_277_cov_1.352941_g30718_i0 | PRJNA980585 | 30972 | 277 | 1.352941 | 3.74764657 | Fusarium asiaticum narnavirus 1 | 2921214 | Viruses | Viruses | 440 | 4.6499999999999983e-119 | NTclustered | gi|2208388235|gb|MZ969061.1| | 2921214 | g30718 | i0 | 95.307 | 1 | 277 | 13 | 100 | 0 | 1 | 277 | 1079 | 1355 | Fusarium asiaticum narnavirus 1 strain NJ-37 segment RNA1 RNA-dependent RNA polymerase gene, complete cds | blastn | 277 | 440 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Fusarium asiaticum narnavirus 1 | ||
| 16257813 | 16257813 | PRJNA980585_P_NODE_43993_length_249_cov_1.750000_g43739_i0 | PRJNA980585 | 43993 | 249 | 1.75 | 4.3575 | Fusarium asiaticum narnavirus 1 | 2921214 | Viruses | Viruses | 350 | 7.14e-92 | NTclustered | gi|2208388237|gb|MZ969062.1| | 2921214 | g43739 | i0 | 91.968 | 1 | 249 | 20 | 100 | 0 | 1 | 249 | 1784 | 1536 | Fusarium asiaticum narnavirus 1 strain NJ-37 segment RNA2 hypothetical protein gene, complete cds | blastn | 249 | 350 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Fusarium asiaticum narnavirus 1 | ||
| 17846848 | 17846848 | PRJNA980585_P_NODE_13014_length_380_cov_1.690554_g12760_i0 | PRJNA980585 | 13014 | 380 | 1.690554 | 6.4241052 | Orthorubulavirus | 2560195 | Viruses | Viruses | 691 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g12760 | i0 | 99.474 | 88.2026315789474 | 380 | 2 | 100 | 0 | 1 | 380 | 636 | 257 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 33517 | 691 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 18806385 | 18806385 | PRJNA980585_P_NODE_23575_length_303_cov_1.339130_g23321_i0 | PRJNA980585 | 23575 | 303 | 1.33913 | 4.0575639 | Ripabiq virus | 3130194 | Viruses | Viruses | 230 | 1.2099999999999995e-55 | NTclustered | gi|2717319120|gb|PP172496.1| | 3130194 | g23321 | i0 | 85.217 | 17.7359735973597 | 230 | 27 | 75 | 6 | 1 | 228 | 140 | 364 | MAG: Ripabiq virus isolate DRCP1_k141_78731 genomic sequence | blastn | 5374 | 230 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripabiq virus | |||||
| 18807015 | 18807015 | PRJNA980585_P_NODE_61655_length_234_cov_2.776398_g61401_i0 | PRJNA980585 | 61655 | 234 | 2.776398 | 6.49677132 | Sopawol virus | 3131668 | Viruses | Viruses | 274 | 4.11e-69 | NTclustered | gi|2717323098|gb|PP173969.1| | 3131668 | g61401 | i0 | 89.815 | 34.2905982905983 | 216 | 18 | 91 | 3 | 19 | 232 | 127 | 340 | MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence | blastn | 8024 | 274 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopawol virus | |||||
| 23906913 | 23906913 | PRJNA980585_P_NODE_12039_length_392_cov_2.053292_g11785_i0 | PRJNA980585 | 12039 | 392 | 2.053292 | 8.04890464 | Chrocagosk virus | 3129397 | Viruses | Viruses | 99 | 4.75e-16 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g11785 | i0 | 78.75 | 9.55357142857143 | 160 | 24 | 39 | 8 | 129 | 280 | 519 | 676 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 3745 | 99 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus |
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);;