RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJEB83711", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 12 ✖

tax_phylum 1

  • Pisuviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJEB83711 · 12 ✖

analysis 1

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
1418208 1418208 PRJEB83711_P_NODE_23902_length_363_cov_4.917241_g23636_i0 PRJEB83711 23902 363 4.917241 17.84958483 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 433 1.05e-116   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g23636 i0 91.456 0.870523415977961 316 25 87 2 49 363 5329 5643 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 316 433 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
1419431 1419431 PRJEB83711_P_NODE_77802_length_242_cov_1.846154_g77536_i0 PRJEB83711 77802 242 1.846154 4.46769268 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 294 3.28e-75   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g77536 i0 94.271 0.793388429752066 192 11 79 0 51 242 639 448 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 192 294 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
1419501 1419501 PRJEB83711_P_NODE_81222_length_231_cov_3.803797_g80956_i0 PRJEB83711 81222 231 3.803797 8.78677107 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 344 3.04e-90   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g80956 i0 93.506 1 231 15 100 0 1 231 6387 6617 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 231 344 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
2693941 2693941 PRJEB83711_P_NODE_35483_length_303_cov_2.291304_g35217_i0 PRJEB83711 35483 303 2.291304 6.94265112 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 339 1.93e-88   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g35217 i0 93.074 0.762376237623762 231 16 76 0 73 303 2548 2318 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 231 339 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
9070914 9070914 PRJEB83711_P_NODE_22988_length_370_cov_4.700337_g22722_i0 PRJEB83711 22988 370 4.700337 17.3912469 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 568 2.819999999999999e-157   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g22722 i0 97.033 0.910810810810811 337 10 91 0 34 370 3703 4039 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 337 568 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
12897527 12897527 PRJEB83711_P_NODE_41431_length_285_cov_2.169811_g41165_i0 PRJEB83711 41431 285 2.169811 6.18396135 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 248 3.13e-61   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g41165 i0 96.053 0.533333333333333 152 6 53 0 2 153 5066 4915 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 152 248 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
15446771 15446771 PRJEB83711_P_NODE_45713_length_276_cov_0.768473_g45447_i0 PRJEB83711 45713 276 0.768473 2.12098548 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 449 7.699999999999998e-122   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g45447 i0 96.014 1 276 11 100 0 1 276 5519 5794 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 276 449 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
15447436 15447436 PRJEB83711_P_NODE_77373_length_243_cov_0.917647_g77107_i0 PRJEB83711 77373 243 0.917647 2.22988221 Poacevirus sacchari 3431714 Viruses Viruses 399 6.789999999999999e-107   NTclustered gi|294795277|ref|NC_014037.1| 53954 g77107 i0 96.296 5 243 9 100 0 1 243 5266 5024 Sugarcane streak mosaic virus, complete genome blastn 1215 399 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Poacevirus Poacevirus sacchari
17994913 17994913 PRJEB83711_P_NODE_11835_length_521_cov_2.024554_g11571_i0 PRJEB83711 11835 521 2.024554 10.54792634 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 368 4.46e-97   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g11571 i0 92.578 0.491362763915547 256 19 49 0 261 516 1703 1448 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 256 368 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
17995043 17995043 PRJEB83711_P_NODE_17275_length_426_cov_1.671388_g17009_i0 PRJEB83711 17275 426 1.671388 7.12011288 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 601 3.2499999999999995e-167   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g17009 i0 95.251 0.889671361502347 379 18 89 0 1 379 4573 4195 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 379 601 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
19269564 19269564 PRJEB83711_P_NODE_45376_length_276_cov_1.901478_g45110_i0 PRJEB83711 45376 276 1.901478 5.24807928 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 370 6.17e-98   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g45110 i0 92.913 0.920289855072464 254 18 92 0 22 275 772 1025 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 254 370 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24369896 24369896 PRJEB83711_P_NODE_46340_length_274_cov_1.791045_g46074_i0 PRJEB83711 46340 274 1.791045 4.9074633 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 409 1.3e-109   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g46074 i0 94.361 0.970802919708029 266 15 97 0 1 266 5986 6251 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 266 409 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);;