contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA728642" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1194961 | 1194961 | PRJNA728642_P_NODE_1_length_7420_cov_5.861440_g0_i0 | PRJNA728642 | 1 | 7420 | 5.86144 | 434.918848 | Orthoavulavirus | 2560194 | Viruses | Viruses | 13692 | 0 | NTclustered | gi|1852396255|gb|MN862503.1| | 159079 | g0 | i0 | 99.973 | 99.9537735849057 | 7420 | 2 | 100 | 0 | 1 | 7420 | 1723 | 9142 | Pigeon paramyxovirus 1 strain Pigeon/Shandong/LCE4/2016, complete genome | blastn | 741657 | 13692 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense | ||
| 3264207 | 3264207 | PRJNA728642_P_NODE_23_length_4315_cov_6.275578_g11_i0 | PRJNA728642 | 23 | 4315 | 6.275578 | 270.7911907 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2361 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g11 | i0 | 91.623 | 0.681344148319815 | 1707 | 139 | 68 | 4 | 1 | 1705 | 7033 | 5329 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 2940 | 2361 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 6299140 | 6299140 | PRJNA728642_P_NODE_5_length_6065_cov_6.578939_g4_i0 | PRJNA728642 | 5 | 6065 | 6.578939 | 399.01265035 | Orthoavulavirus | 2560194 | Viruses | Viruses | 11201 | 0 | NTclustered | gi|1852396262|gb|MN862504.1| | 159079 | g4 | i0 | 100 | 99.8966199505359 | 6065 | 0 | 100 | 0 | 1 | 6065 | 15177 | 9113 | Pigeon paramyxovirus 1 strain Pigeon/Shandong/LC/2017, complete genome | blastn | 605873 | 11201 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense | ||
| 7572745 | 7572745 | PRJNA728642_P_NODE_13986_length_269_cov_1.331633_g13715_i0 | PRJNA728642 | 13986 | 269 | 1.331633 | 3.58209277 | Avastrovirus | 249589 | Viruses | Viruses | 492 | 1.23e-134 | NTclustered | gi|2315884983|gb|OL982613.1| | 1349999 | g13715 | i0 | 99.628 | 100 | 269 | 1 | 100 | 0 | 1 | 269 | 5389 | 5121 | Goose astrovirus isolate XSSH, complete genome | blastn | 26900 | 492 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Avastrovirus | Goose astrovirus | ||
| 7572915 | 7572915 | PRJNA728642_P_NODE_386_length_1647_cov_6.378018_g246_i0 | PRJNA728642 | 386 | 1647 | 6.378018 | 105.04595646 | Orthoavulavirus | 2560194 | Viruses | Viruses | 3042 | 0 | NTclustered | gi|1852396255|gb|MN862503.1| | 159079 | g246 | i0 | 100 | 98.8348512446873 | 1647 | 0 | 100 | 0 | 1 | 1647 | 25 | 1671 | Pigeon paramyxovirus 1 strain Pigeon/Shandong/LCE4/2016, complete genome | blastn | 162781 | 3042 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense | ||
| 8847929 | 8847929 | PRJNA728642_P_NODE_13727_length_272_cov_1.010050_g13456_i0 | PRJNA728642 | 13727 | 272 | 1.01005 | 2.7473359999999998 | Orthoavulavirus | 2560194 | Viruses | Viruses | 501 | 2.06e-137 | NTclustered | gi|1852396276|gb|MN862506.1| | 159079 | g13456 | i0 | 100 | 99.9889705882353 | 271 | 0 | 99 | 0 | 1 | 271 | 11232 | 11502 | Pigeon paramyxovirus 1 strain Pigeon/Shandong/190610-2/2019, complete genome | blastn | 27197 | 503 | 0.996023856858847 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense | ||
| 10916913 | 10916913 | PRJNA728642_P_NODE_18649_length_243_cov_1.211765_g18378_i0 | PRJNA728642 | 18649 | 243 | 1.211765 | 2.94458895 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 444 | 3.09e-120 | NTclustered | gi|1798036485|gb|MN948960.1| | RQ01 | g18378 | i0 | 99.588 | 100 | 243 | 1 | 100 | 0 | 1 | 243 | 2209 | 1967 | Influenza A virus (A/Pennsylvania/1026/2019(H3N2)) segment 3 polymerase PA (PA) and PA-X protein (PA-X) genes, complete cds | blastn | 24300 | 444 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Zebrafish influenza B-like virus | ||
| 11398639 | 11398639 | PRJNA728642_P_NODE_18809_length_243_cov_0.905882_g18538_i0 | PRJNA728642 | 18809 | 243 | 0.905882 | 2.20129326 | Avastrovirus | 249589 | Viruses | Viruses | 449 | 6.65e-122 | NTclustered | gi|2315883747|gb|OL963558.1| | 1349999 | g18538 | i0 | 100 | 100 | 243 | 0 | 100 | 0 | 1 | 243 | 2747 | 2989 | Goose astrovirus isolate JSW10, complete genome | blastn | 24300 | 449 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Avastrovirus | Goose astrovirus | ||
| 11398711 | 11398711 | PRJNA728642_P_NODE_3989_length_519_cov_1.011211_g3718_i0 | PRJNA728642 | 3989 | 519 | 1.011211 | 5.24818509 | Avastrovirus | 249589 | Viruses | Viruses | 959 | 0 | NTclustered | gi|2098512343|gb|MZ367612.1| | 1349999 | g3718 | i0 | 100 | 99.9980732177264 | 519 | 0 | 100 | 0 | 1 | 519 | 3507 | 2989 | Goose astrovirus isolate HNNY0620, complete genome | blastn | 51899 | 959 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Avastrovirus | Goose astrovirus | ||
| 12192100 | 12192100 | PRJNA728642_P_NODE_13230_length_277_cov_0.975490_g12959_i0 | PRJNA728642 | 13230 | 277 | 0.97549 | 2.7021073 | Orthoavulavirus javaense | 3051375 | Viruses | Viruses | 507 | 4.53e-139 | NTclustered | gi|2161956354|gb|MW271787.1| | 2560319 | g12959 | i0 | 99.639 | 100 | 277 | 1 | 100 | 0 | 1 | 277 | 7405 | 7681 | Avian paramyxovirus 1 isolate JS/09/16/Pi nucleoprotein (NP), phosphorprotein (P), matrix protein (M), fusion protein (F), hemagglutinin-neuraminidase (HN), and large polymerase protein (L) genes, complete cds | blastn | 27700 | 507 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense | ||
| 12192299 | 12192299 | PRJNA728642_P_NODE_5630_length_433_cov_2.005556_g5359_i0 | PRJNA728642 | 5630 | 433 | 2.005556 | 8.68405748 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 287 | 1.05e-72 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g5359 | i0 | 92.893 | 0.454965357967667 | 197 | 14 | 45 | 0 | 237 | 433 | 1708 | 1512 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 197 | 287 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 21115295 | 21115295 | PRJNA728642_P_NODE_11657_length_296_cov_1.210762_g11386_i0 | PRJNA728642 | 11657 | 296 | 1.210762 | 3.58385552 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 278 | 4.1700000000000005e-70 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g11386 | i0 | 96.97 | 0.557432432432432 | 165 | 5 | 56 | 0 | 4 | 168 | 2264 | 2100 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 165 | 278 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 23665737 | 23665737 | PRJNA728642_P_NODE_10839_length_308_cov_1.131915_g10568_i0 | PRJNA728642 | 10839 | 308 | 1.131915 | 3.4862982 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 494 | 3.97e-135 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g10568 | i0 | 95.752 | 0.993506493506494 | 306 | 13 | 99 | 0 | 3 | 308 | 330 | 635 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 306 | 494 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 |
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);;