contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA703759" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 684873 | 684873 | PRJNA703759_P_NODE_52641_length_208_cov_5.466667_g52165_i0 | PRJNA703759 | 52641 | 208 | 5.466667 | 11.37066736 | Cripavirus sp. | 1955141 | Viruses | Viruses | 374 | 3.4199999999999996e-99 | NTclustered | gi|2672713333|gb|OR723604.1| | 1955141 | g52165 | i0 | 99.038 | 99.875 | 208 | 2 | 100 | 0 | 1 | 208 | 1778 | 1571 | MAG: Cripavirus sp. isolate MSJDC22/4628 genomic sequence | blastn | 20774 | 374 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus sp. | ||
| 2459953 | 2459953 | PRJNA703759_P_NODE_11422_length_398_cov_3.689231_g10946_i0 | PRJNA703759 | 11422 | 398 | 3.689231 | 14.68313938 | Orthorubulavirus | 2560195 | Viruses | Viruses | 730 | 0 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g10946 | i0 | 99.749 | 97.9773869346734 | 398 | 1 | 100 | 0 | 1 | 398 | 209 | 606 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 38995 | 736 | 0.991847826086957 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 3736581 | 3736581 | PRJNA703759_P_NODE_21943_length_298_cov_6.373333_g21467_i0 | PRJNA703759 | 21943 | 298 | 6.373333 | 18.99253234 | Orthorubulavirus | 2560195 | Viruses | Viruses | 551 | 2.239999999999999e-152 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g21467 | i0 | 100 | 69.4697986577181 | 298 | 0 | 100 | 0 | 1 | 298 | 6513 | 6216 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 20702 | 551 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 5787600 | 5787600 | PRJNA703759_P_NODE_17725_length_325_cov_1.547619_g17249_i0 | PRJNA703759 | 17725 | 325 | 1.547619 | 5.02976175 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 538 | 1.9199999999999998e-148 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g17249 | i0 | 96.584 | 0.990769230769231 | 322 | 11 | 99 | 0 | 2 | 323 | 6985 | 6664 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 322 | 538 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 11388347 | 11388347 | PRJNA703759_P_NODE_1269_length_1706_cov_14.026944_g902_i0 | PRJNA703759 | 1269 | 1706 | 14.026944 | 239.29966464 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3149 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g902 | i0 | 100 | 76.274325908558 | 1705 | 0 | 99 | 0 | 2 | 1706 | 1786 | 82 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 130124 | 3149 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 12664373 | 12664373 | PRJNA703759_P_NODE_3190_length_908_cov_4.374850_g2740_i0 | PRJNA703759 | 3190 | 908 | 4.37485 | 39.723638 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1661 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g2740 | i0 | 99.67 | 82.3799559471366 | 908 | 3 | 100 | 0 | 1 | 908 | 7410 | 8317 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 74801 | 1672 | 0.993421052631579 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15213458 | 15213458 | PRJNA703759_P_NODE_2992_length_949_cov_4.079909_g2544_i0 | PRJNA703759 | 2992 | 949 | 4.079909 | 38.71833641 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1748 | 0 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g2544 | i0 | 99.895 | 98 | 949 | 1 | 100 | 0 | 1 | 949 | 1569 | 621 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 93002 | 1748 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15987541 | 15987541 | PRJNA703759_P_NODE_693_length_2684_cov_3.439295_g425_i0 | PRJNA703759 | 693 | 2684 | 3.439295 | 92.3106778 | Cripavirus mortiferum | 3047369 | Viruses | Viruses | 4453 | 0 | NTclustered | gi|2395734185|gb|ON811696.1| | 209529 | g425 | i0 | 96.61 | 88.5264530551416 | 2684 | 91 | 100 | 0 | 1 | 2684 | 9749 | 7066 | MAG: Aphid lethal paralysis virus isolate TIGMIC_1, complete genome | blastn | 237605 | 4453 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus mortiferum | ||
| 19036852 | 19036852 | PRJNA703759_P_NODE_8615_length_466_cov_3.720102_g8139_i0 | PRJNA703759 | 8615 | 466 | 3.720102 | 17.33567532 | Orthorubulavirus | 2560195 | Viruses | Viruses | 856 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g8139 | i0 | 99.785 | 83.9785407725322 | 466 | 1 | 100 | 0 | 1 | 466 | 6816 | 7281 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 39134 | 861 | 0.994192799070848 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22862277 | 22862277 | PRJNA703759_P_NODE_1898_length_1288_cov_14.798354_g1495_i0 | PRJNA703759 | 1898 | 1288 | 14.798354 | 190.60279952 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2355 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g1495 | i0 | 99.689 | 84.1187888198758 | 1287 | 4 | 99 | 0 | 1 | 1287 | 1806 | 3092 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 108345 | 2366 | 0.995350803043111 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 23637341 | 23637341 | PRJNA703759_P_NODE_339_length_6608_cov_4.835042_g168_i0 | PRJNA703759 | 339 | 6608 | 4.835042 | 319.49957536 | Cripavirus mortiferum | 3047369 | Viruses | Viruses | 10586 | 0 | NTclustered | gi|2395734185|gb|ON811696.1| | 209529 | g168 | i0 | 95.634 | 97.6820520581114 | 6597 | 287 | 99 | 1 | 11 | 6607 | 1 | 6596 | MAG: Aphid lethal paralysis virus isolate TIGMIC_1, complete genome | blastn | 645483 | 10586 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus mortiferum | ||
| 24136614 | 24136614 | PRJNA703759_P_NODE_26099_length_280_cov_4.565217_g25623_i0 | PRJNA703759 | 26099 | 280 | 4.565217 | 12.7826076 | Orthorubulavirus | 2560195 | Viruses | Viruses | 486 | 5.969999999999999e-133 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g25623 | i0 | 99.257 | 91.3285714285714 | 269 | 2 | 96 | 0 | 12 | 280 | 4774 | 4506 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 25572 | 486 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 25411336 | 25411336 | PRJNA703759_P_NODE_1680_length_1395_cov_4.999244_g1286_i0 | PRJNA703759 | 1680 | 1395 | 4.999244 | 69.7394538 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2555 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g1286 | i0 | 99.713 | 69.1519713261649 | 1396 | 3 | 100 | 1 | 1 | 1395 | 3087 | 4482 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 96467 | 2555 | 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);;