RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1233465" and tax_phylum = "Negarnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Negarnaviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1233465 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
32949160 32949160 PRJNA1233465a_S_NODE_9442_length_554_cov_10.116832_g8280_i0 PRJNA1233465 9442 554 10.116832 56.04724928 African cichlid piscichuvirus 3065075 Viruses Viruses 105 1.5400000000000001e-22   NR WLN26256.1 3065075 g8280 i0 49.5 0.557761732851986 103 52 55.8 0 554 246 132 234 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 309 105 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus
32967988 32967988 PRJNA1233465e_S_NODE_6874_length_585_cov_2.794776_g5722_i0 PRJNA1233465 6874 585 2.794776 16.3494396 African cichlid piscichuvirus 3065075 Viruses Viruses 129 7.7099999999999995e-31   NR WLN26256.1 3065075 g5722 i0 46.4 0.707692307692308 138 74 70.8 0 562 149 97 234 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 414 129 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus
32968461 32968461 PRJNA1233465f_S_NODE_197050_length_179_cov_1.176923_g194770_i0 PRJNA1233465 197050 179 1.176923 2.10669217 Luffa virus 1 2977973 Viruses Viruses 82.8 1.21e-16   NR DAZ90745.1 2977973 g194770 i0 71.7 0.888268156424581 53 15 88.8 0 176 18 808 860 DAZ90745.1 TPA_asm: polyprotein [Luffa virus 1] diamond 159 82.8 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Varicosavirus Varicosavirus luffae
33052533 33052533 PRJNA1233465d_S_NODE_7109_length_543_cov_1.692308_g6082_i0 PRJNA1233465 7109 543 1.692308 9.18923244 African cichlid piscichuvirus 3065075 Viruses Viruses 129 6.44e-31   NR WLN26256.1 3065075 g6082 i0 46.4 0.76243093922651906 138 74 76.2 0 527 114 97 234 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 414 129 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus
33070589 33070589 PRJNA1233465f_S_NODE_23165_length_438_cov_5.825193_g20918_i0 PRJNA1233465 23165 438 5.825193 25.51434534 African cichlid piscichuvirus 3065075 Viruses Viruses 97.4 2.66e-20   NR WLN26256.1 3065075 g20918 i0 51.1 0.616438356164384 90 44 61.6 0 12 281 145 234 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 270 97.4 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus
33086143 33086143 PRJNA1233465b_S_NODE_4038_length_951_cov_8.151885_g3291_i0 PRJNA1233465 4038 951 8.151885 77.52442635 African cichlid piscichuvirus 3065075 Viruses Viruses 164 2.76e-41   NR WLN26256.1 3065075 g3291 i0 42 0.706624605678233 224 125 69.1 2 948 292 11 234 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 672 164 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus

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