RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA667863" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA667863 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
634013 634013 PRJNA667863_P_NODE_1281_length_458_cov_1.922078_g1247_i0 PRJNA667863 1281 458 1.922078 8.80311724 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 191 9.02e-44   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1247 i0 96.522 0.251091703056769 115 4 25 0 344 458 4704 4590 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 115 191 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
1910108 1910108 PRJNA667863_P_NODE_1162_length_473_cov_6.402500_g1129_i0 PRJNA667863 1162 473 6.4025 30.283825 Picornaviridae sp. 1530251 Viruses Viruses 689 0   NTclustered gi|2245486294|gb|ON162260.1| 1530251 g1129 i0 95.581 2.50105708245243 430 19 91 0 1 430 1449 1878 MAG: Picornaviridae sp. isolate 359R-k141_118116 RNA dependent RNA polymerase gene, partial cds blastn 1183 689 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
1910215 1910215 PRJNA667863_P_NODE_3082_length_347_cov_1.762774_g3048_i0 PRJNA667863 3082 347 1.762774 6.11682578 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 305 2.28e-78   NTclustered gi|2754691651|gb|PP872615.1| 3003959 g3048 i0 82.609 0.994236311239193 345 60 99 0 1 345 7670 7326 MAG: Picornavirales sp. isolate TC-PLV-59 MR233-17E/322 genomic sequence blastn 345 305 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
4991804 4991804 PRJNA667863_P_NODE_15604_length_243_cov_1.470588_g15570_i0 PRJNA667863 15604 243 1.470588 3.57352884 Alphapartitivirus 1511808 Viruses Viruses 449 6.65e-122   NTclustered gi|2129099809|gb|MT675004.1| 2043550 g15570 i0 100 48.7242798353909 243 0 100 0 1 243 1903 1661 Medicago sativa alphapartitivirus 1 isolate MSAPV1/BJFi2 RNA-dependent RNA polymerase gene, complete cds blastn 11840 449 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Medicago sativa alphapartitivirus 1
8287260 8287260 PRJNA667863_P_NODE_2027_length_394_cov_2.834891_g1993_i0 PRJNA667863 2027 394 2.834891 11.16947054 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 259 2.07e-64   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1993 i0 89.372 0.525380710659898 207 20 52 2 188 393 5329 5534 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 207 259 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
8287282 8287282 PRJNA667863_P_NODE_3567_length_333_cov_1.523077_g3533_i0 PRJNA667863 3567 333 1.523077 5.07184641 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 448 3.4299999999999995e-121   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g3533 i0 90.691 1 333 31 100 0 1 333 6893 6561 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 333 448 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
8287287 8287287 PRJNA667863_P_NODE_4027_length_321_cov_4.024194_g3993_i0 PRJNA667863 4027 321 4.024194 12.91766274 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 466 9.08e-127   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g3993 i0 92.835 1 321 23 100 0 1 321 5476 5796 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 321 466 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
10838159 10838159 PRJNA667863_P_NODE_2709_length_361_cov_1.701389_g2675_i0 PRJNA667863 2709 361 1.701389 6.14201429 Lasius neglectus picorna-like virus 11 2933700 Viruses Viruses 366 1.08e-96   NTclustered gi|2306450196|gb|MW314649.1| 2933700 g2675 i0 85 0.997229916897507 360 54 99 0 2 361 5851 6210 Lasius neglectus picorna-like virus 11 from Italy genomic sequence blastn 360 366 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Lasius neglectus picorna-like virus 11
12113364 12113364 PRJNA667863_P_NODE_8130_length_269_cov_3.321429_g8096_i0 PRJNA667863 8130 269 3.321429 8.93464401 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 359 1.3e-94   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g8096 i0 90.741 1.00371747211896 270 23 100 2 1 269 5767 6035 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 270 359 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24860303 24860303 PRJNA667863_P_NODE_9460_length_261_cov_1.281915_g9426_i0 PRJNA667863 9460 261 1.281915 3.34579815 Locarnavirus sp. 2809529 Viruses Viruses 383 7.43e-102   NTclustered gi|2196309129|gb|MZ679338.1| 2809529 g9426 i0 93.103 1 261 18 100 0 1 261 3118 2858 MAG: Locarnavirus sp. isolate 174-k141_240960 hypothetical protein 1 and hypothetical protein 2 genes, complete cds blastn 261 383 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Locarnavirus Locarnavirus sp.

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