contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA980839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2545452 | 2545452 | PRJNA980839_P_NODE_125902_length_315_cov_3.123967_g122118_i0 | PRJNA980839 | 125902 | 315 | 3.123967 | 9.84049605 | root | 1 | Root_unresolved | Root_unresolved | 582 | 8.459999999999998e-162 | NTclustered | gi|992068117|gb|KC344485.2| | 11036 | g122118 | i0 | 100 | 99.9047619047619 | 315 | 0 | 100 | 0 | 1 | 315 | 321 | 7 | Venezuelan equine encephalitis virus strain VEEV/Equus ferus caballus/COL/CoAn5384/1967/IAB, complete genome | blastn | 31470 | 582 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 2546390 | 2546390 | PRJNA980839_P_NODE_97842_length_367_cov_2.125850_g94058_i0 | PRJNA980839 | 97842 | 367 | 2.12585 | 7.8018695 | Respirovirus | 186938 | Viruses | Viruses | 673 | 0 | NTclustered | gi|60898|emb|X03614.1| | 12730 | g94058 | i0 | 99.728 | 36.7656675749319 | 367 | 1 | 100 | 0 | 1 | 367 | 401 | 35 | Sendai virus (strain Z) genome RNA 5'end | blastn | 13493 | 673 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 5098716 | 5098716 | PRJNA980839_P_NODE_34364_length_837_cov_3.019634_g30931_i0 | PRJNA980839 | 34364 | 837 | 3.019634 | 25.27433658 | Respirovirus | 186938 | Viruses | Viruses | 1546 | 0 | NTclustered | gi|60898|emb|X03614.1| | 12730 | g30931 | i0 | 100 | 47.3775388291517 | 837 | 0 | 100 | 0 | 1 | 837 | 4473 | 3637 | Sendai virus (strain Z) genome RNA 5'end | blastn | 39655 | 1546 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 5098846 | 5098846 | PRJNA980839_P_NODE_61424_length_513_cov_2.554545_g57647_i0 | PRJNA980839 | 61424 | 513 | 2.554545 | 13.10481585 | Respirovirus | 186938 | Viruses | Viruses | 878 | 0 | NTclustered | gi|60898|emb|X03614.1| | 12730 | g57647 | i0 | 99.381 | 43.4736842105263 | 485 | 2 | 100 | 1 | 1 | 485 | 1883 | 2366 | Sendai virus (strain Z) genome RNA 5'end | blastn | 22302 | 878 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 6374657 | 6374657 | PRJNA980839_P_NODE_69325_length_468_cov_3.298734_g65543_i0 | PRJNA980839 | 69325 | 468 | 3.298734 | 15.43807512 | Respirovirus | 186938 | Viruses | Viruses | 857 | 0 | NTclustered | gi|60898|emb|X03614.1| | 12730 | g65543 | i0 | 99.786 | 43.8888888888889 | 467 | 1 | 99 | 0 | 2 | 468 | 1445 | 1911 | Sendai virus (strain Z) genome RNA 5'end | blastn | 20540 | 857 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 8923263 | 8923263 | PRJNA980839_P_NODE_247347_length_211_cov_4.471014_g243563_i0 | PRJNA980839 | 247347 | 211 | 4.471014 | 9.43383954 | root | 1 | Root_unresolved | Root_unresolved | 390 | 3.459999999999999e-104 | NTclustered | gi|60898|emb|X03614.1| | 12730 | g243563 | i0 | 100 | 41.2559241706161 | 211 | 0 | 100 | 0 | 1 | 211 | 4871 | 4661 | Sendai virus (strain Z) genome RNA 5'end | blastn | 8705 | 390 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 9885016 | 9885016 | PRJNA980839_P_NODE_126568_length_314_cov_4.000000_g122784_i0 | PRJNA980839 | 126568 | 314 | 4 | 12.56 | Alphavirus venezuelan | 3426322 | Viruses | Viruses | 231 | 3.52e-56 | NTclustered | gi|4262311|gb|AF075255.1|AF075255 | 11036 | g122784 | i0 | 81.25 | 0.917197452229299 | 288 | 52 | 91 | 2 | 26 | 312 | 2079 | 1793 | Venezuelan equine encephalitis virus strain 71D-1252, complete genome | blastn | 288 | 231 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 11161311 | 11161311 | PRJNA980839_P_NODE_172809_length_268_cov_1.579487_g169025_i0 | PRJNA980839 | 172809 | 268 | 1.579487 | 4.23302516 | Ripachij virus | 3130407 | Viruses | Viruses | 359 | 1.29e-94 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g169025 | i0 | 90.977 | 162.869402985075 | 266 | 24 | 99 | 0 | 1 | 266 | 707 | 442 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 43649 | 359 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 12438752 | 12438752 | PRJNA980839_P_NODE_4370_length_3040_cov_3.045838_g3655_i0 | PRJNA980839 | 4370 | 3040 | 3.045838 | 92.5934752 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1011 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g3655 | i0 | 96.266 | 0.547039473684211 | 616 | 23 | 54 | 0 | 1 | 616 | 24 | 639 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 1663 | 1011 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 12439566 | 12439566 | PRJNA980839_P_NODE_85590_length_401_cov_4.975610_g81806_i0 | PRJNA980839 | 85590 | 401 | 4.97561 | 19.9521961 | Alphavirus venezuelan | 3426322 | Viruses | Viruses | 324 | 7.38e-84 | NTclustered | gi|2624253565|gb|OR644784.1| | 11036 | g81806 | i0 | 81.25 | 1.99501246882793 | 400 | 75 | 99 | 0 | 2 | 401 | 2661 | 3060 | Venezuelan equine encephalitis virus strain 258263 F1/Panama/2015, partial genome | blastn | 800 | 324 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 12749371 | 12749371 | PRJNA980839_P_NODE_19170_length_1350_cov_2.438528_g16725_i0 | PRJNA980839 | 19170 | 1350 | 2.438528 | 32.920128 | Respirovirus | 186938 | Viruses | Viruses | 2466 | 0 | NTclustered | gi|60898|emb|X03614.1| | 12730 | g16725 | i0 | 99.703 | 43.4925925925926 | 1347 | 4 | 99 | 0 | 1 | 1347 | 4898 | 6244 | Sendai virus (strain Z) genome RNA 5'end | blastn | 58715 | 2483 | 0.993153443415223 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 17537265 | 17537265 | PRJNA980839_P_NODE_2494_length_3760_cov_6.553295_g2047_i0 | PRJNA980839 | 2494 | 3760 | 6.553295 | 246.403892 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2327 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g2047 | i0 | 91.983 | 0.769148936170213 | 1659 | 129 | 77 | 4 | 2104 | 3760 | 5329 | 6985 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 2892 | 2327 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 17848012 | 17848012 | PRJNA980839_P_NODE_33094_length_864_cov_3.512010_g29715_i0 | PRJNA980839 | 33094 | 864 | 3.51201 | 30.3437664 | Respirovirus | 186938 | Viruses | Viruses | 1596 | 0 | NTclustered | gi|60898|emb|X03614.1| | 12730 | g29715 | i0 | 100 | 45.6284722222222 | 864 | 0 | 100 | 0 | 1 | 864 | 469 | 1332 | Sendai virus (strain Z) genome RNA 5'end | blastn | 39423 | 1596 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 18811827 | 18811827 | PRJNA980839_P_NODE_63255_length_501_cov_4.766355_g59477_i0 | PRJNA980839 | 63255 | 501 | 4.766355 | 23.87943855 | Alphavirus venezuelan | 3426322 | Viruses | Viruses | 438 | 3.219999999999999e-118 | NTclustered | gi|2624253631|gb|OR644812.1| | 11036 | g59477 | i0 | 82.47 | 99.8003992015968 | 502 | 86 | 100 | 2 | 1 | 501 | 375 | 875 | Venezuelan equine encephalitis virus strain 248025/Panama/2010, partial genome | blastn | 50000 | 438 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 21672741 | 21672741 | PRJNA980839_P_NODE_246237_length_226_cov_3.385621_g242453_i0 | PRJNA980839 | 246237 | 226 | 3.385621 | 7.65150346 | root | 1 | Root_unresolved | Root_unresolved | 392 | 1.04e-104 | NTclustered | gi|334975|gb|M14887.1|PAFVL | 12730 | g242453 | i0 | 99.087 | 30.0398230088496 | 219 | 0 | 96 | 2 | 1 | 218 | 4137 | 3920 | Sendai virus (5' end of the viral genome) L gene, complete cds | blastn | 6789 | 392 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 22948234 | 22948234 | PRJNA980839_P_NODE_62398_length_507_cov_1.730415_g58620_i0 | PRJNA980839 | 62398 | 507 | 1.730415 | 8.77320405 | Respirovirus | 186938 | Viruses | Viruses | 915 | 0 | NTclustered | gi|60898|emb|X03614.1| | 12730 | g58620 | i0 | 99.211 | 39.9250493096647 | 507 | 4 | 100 | 0 | 1 | 507 | 3049 | 3555 | Sendai virus (strain Z) genome RNA 5'end | blastn | 20242 | 915 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis |
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);;