RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA789095" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 9 ✖

bioproject 1

  • PRJNA789095 · 9 ✖

analysis 1

  • blastn · 9 ✖

tax_clade 0

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
10973862 10973862 PRJNA789095_P_NODE_13389_length_783_cov_2.221127_g12154_i0 PRJNA789095 13389 783 2.221127 17.39142441 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 375 4.1e-99   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g12154 i0 95.339 0.301404853128991 236 11 30 0 547 782 3703 3938 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 236 375 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
10973887 10973887 PRJNA789095_P_NODE_14709_length_718_cov_1.883721_g13431_i0 PRJNA789095 14709 718 1.883721 13.52511678 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 379 2.9e-100   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g13431 i0 91.071 0.586350974930362 280 25 58 0 159 438 4915 5194 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 421 379 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
13523692 13523692 PRJNA789095_P_NODE_17251_length_622_cov_1.735883_g15942_i0 PRJNA789095 17251 622 1.735883 10.79719226 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 641 2.8799999999999992e-179   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g15942 i0 94.076 0.678456591639871 422 25 68 0 1 422 2122 2543 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 422 641 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
14799037 14799037 PRJNA789095_P_NODE_34112_length_353_cov_1.375000_g32778_i0 PRJNA789095 34112 353 1.375 4.85375 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 383 1.0399999999999998e-101   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g32778 i0 92.509 0.756373937677054 267 20 76 0 11 277 1708 1442 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 267 383 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
16073875 16073875 PRJNA789095_P_NODE_64373_length_254_cov_1.243094_g63039_i0 PRJNA789095 64373 254 1.243094 3.15745876 brine shrimp yue-like virus 3 2900455 Viruses Viruses 464 2.4999999999999994e-126   NTclustered gi|2209094280|gb|OL472816.1| 2900455 g63039 i0 99.606 4 254 1 100 0 1 254 728 981 MAG: Brine shrimp yue-like virus 3 isolate 02/QH/92-02 segment 1 RNA-dependent RNA polymerase gene, complete cds blastn 1016 464 1 Viruses   Orthornavirae Negarnaviricota Yunchangviricetes Goujianvirales Yueviridae   brine shrimp yue-like virus 3
18622051 18622051 PRJNA789095_P_NODE_39055_length_321_cov_1.870968_g37721_i0 PRJNA789095 39055 321 1.870968 6.00580728 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 318 2.69e-82   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g37721 i0 90.456 0.750778816199377 241 23 75 0 1 241 4435 4195 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 241 318 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
19896688 19896688 PRJNA789095_P_NODE_13156_length_796_cov_3.825726_g11930_i0 PRJNA789095 13156 796 3.825726 30.45277896 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1107 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g11930 i0 91.698 0.998743718592965 795 66 99 0 2 796 6912 6118 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 795 1107 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
19896769 19896769 PRJNA789095_P_NODE_16496_length_646_cov_2.369983_g15190_i0 PRJNA789095 16496 646 2.369983 15.31009018 brine shrimp chuvirus 1 2900479 Viruses Viruses 97.1 2.93e-15   NTclustered gi|2177952885|gb|OL452274.1| 2900479 g15190 i0 91.429 0.541795665634675 70 6 11 0 577 646 7030 7099 MAG: Brine shrimp chuvirus 1 isolate YC/91, complete genome blastn 350 97.1 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae   brine shrimp chuvirus 1
19896915 19896915 PRJNA789095_P_NODE_22216_length_496_cov_2.706856_g20887_i0 PRJNA789095 22216 496 2.706856 13.42600576 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 706 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g20887 i0 92.51 0.995967741935484 494 35 99 2 4 496 5996 5504 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 494 706 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;