RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA450343" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA450343 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
439048 439048 PRJNA450343_P_NODE_10001_length_172_cov_1.243902_g9933_i0 PRJNA450343 10001 172 1.243902 2.13951144 Zebrafish picornavirus 1 2304617 Viruses Viruses 263 6.12e-66   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g9933 i0 94.186 3 172 10 100 0 1 172 6071 6242 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 516 263 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
2367949 2367949 PRJNA450343_P_NODE_662_length_703_cov_1.767584_g608_i0 PRJNA450343 662 703 1.767584 12.42611552 Viruses 10239 Viruses Viruses 597 7.189999999999998e-166   NTclustered gi|2754692213|gb|PP872821.1| 1955153 g608 i0 82.184 1.9800853485064 696 122 99 2 4 698 5592 6286 MAG: Picornavirales sp. isolate TC-PLV-265 MR233-17E/1391 genomic sequence blastn 1392 597 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
5542830 5542830 PRJNA450343_P_NODE_1745_length_418_cov_1.913279_g1677_i0 PRJNA450343 1745 418 1.913279 7.99750622 Marnaviridae sp. 2715102 Viruses Viruses 359 2.12e-94   NTclustered gi|2196309055|gb|MZ679255.1| 2715102 g1677 i0 82.254 0.997607655502392 417 72 99 2 2 417 4930 5345 MAG: Marnaviridae sp. isolate 35-k141_83231 hypothetical protein 1 and hypothetical protein 2 genes, complete cds blastn 417 359 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
5542848 5542848 PRJNA450343_P_NODE_3925_length_268_cov_1.630137_g3857_i0 PRJNA450343 3925 268 1.630137 4.36876716 Zebrafish picornavirus 1 2304617 Viruses Viruses 440 4.479999999999998e-119   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g3857 i0 96.269 3 268 10 100 0 1 268 7598 7331 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 804 440 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14467671 14467671 PRJNA450343_P_NODE_12_length_2980_cov_5.338792_g11_i0 PRJNA450343 12 2980 5.338792 159.0960016 Marnaviridae sp. 2715102 Viruses Viruses 2492 0   NTclustered gi|2196309055|gb|MZ679255.1| 2715102 g11 i0 81.888 1.99697986577181 2976 519 99 18 12 2977 6292 9257 MAG: Marnaviridae sp. isolate 35-k141_83231 hypothetical protein 1 and hypothetical protein 2 genes, complete cds blastn 5951 2492 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
19564829 19564829 PRJNA450343_P_NODE_12916_length_163_cov_0.894737_g12848_i0 PRJNA450343 12916 163 0.894737 1.45842131 Chrocurosk virus 3129322 Viruses Viruses 169 1.29e-37   NTclustered gi|2717317280|gb|PP171770.1| 3129322 g12848 i0 85.714 21.0613496932515 161 22 98 1 4 163 1662 1822 MAG: Chrocurosk virus isolate CC1A_k141_129357 genomic sequence blastn 3433 169 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Chrocurosk virus
23391249 23391249 PRJNA450343_P_NODE_11599_length_165_cov_1.767241_g11531_i0 PRJNA450343 11599 165 1.767241 2.91594765 Ripagrog virus 3130723 Viruses Viruses 235 1.28e-57   NTclustered gi|2717320584|gb|PP173025.1| 3130723 g11531 i0 94.156 233.193939393939 154 9 93 0 12 165 1716 1869 MAG: Ripagrog virus isolate KCAP2_k141_407948 genomic sequence blastn 38477 235 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Ripagrog virus

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