RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA638724" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA638724 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
5713213 5713213 PRJNA638724_P_NODE_3065_length_350_cov_3.043321_g2979_i0 PRJNA638724 3065 350 3.043321 10.6516235 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 298 3.85e-76   NTclustered gi|2701272534|gb|OR640980.1| 3003959 g2979 i0 82.883 0.951428571428571 333 55 95 2 1 332 2981 2650 Picornavirales sp. isolate Tuebingen RdRp (ORF1) and capsid protein (ORF2) genes, complete cds blastn 333 298 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
5713217 5713217 PRJNA638724_P_NODE_5325_length_277_cov_1.955882_g5239_i0 PRJNA638724 5325 277 1.955882 5.41779314 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 255 1.81e-63   NTclustered gi|2701272534|gb|OR640980.1| 3003959 g5239 i0 83.895 0.963898916967509 267 43 96 0 1 267 2116 1850 Picornavirales sp. isolate Tuebingen RdRp (ORF1) and capsid protein (ORF2) genes, complete cds blastn 267 255 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
8262829 8262829 PRJNA638724_P_NODE_3627_length_326_cov_2.399209_g3541_i0 PRJNA638724 3627 326 2.399209 7.82142134 brine shrimp partiti-like virus 4 2900391 Viruses Viruses 580 3.1599999999999993e-161   NTclustered gi|2209094893|gb|OL472518.1| 2900391 g3541 i0 99.685 12.659509202454 317 1 97 0 1 317 485 169 MAG: Brine shrimp partiti-like virus 4 isolate GSL/14 RNA-dependent RNA polymerase gene, complete cds blastn 4127 580 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   brine shrimp partiti-like virus 4
12088992 12088992 PRJNA638724_P_NODE_6090_length_260_cov_1.957219_g6004_i0 PRJNA638724 6090 260 1.957219 5.0887694 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 311 3.54e-80   NTclustered gi|2701272534|gb|OR640980.1| 3003959 g6004 i0 89.157 0.957692307692308 249 27 96 0 11 259 1142 1390 Picornavirales sp. isolate Tuebingen RdRp (ORF1) and capsid protein (ORF2) genes, complete cds blastn 249 311 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
19736323 19736323 PRJNA638724_P_NODE_5996_length_262_cov_1.227513_g5910_i0 PRJNA638724 5996 262 1.227513 3.21608406 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 226 1.3299999999999994e-54   NTclustered gi|2701272534|gb|OR640980.1| 3003959 g5910 i0 83.004 0.965648854961832 253 39 96 3 2 253 5041 4792 Picornavirales sp. isolate Tuebingen RdRp (ORF1) and capsid protein (ORF2) genes, complete cds blastn 253 226 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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