RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA944406" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA944406 · 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
26898861 26898861 PRJNA944406_P_NODE_49401_length_264_cov_1.209424_g48442_i0 PRJNA944406 49401 264 1.209424 3.19287936 White clover mosaic virus 12188 Viruses Viruses 175 1.1399999999999999e-48   NR NP_620715.1 12188 g48442 i0 98.9 0.988636363636364 87 1 98.9 0 262 2 1110 1196 NP_620715.1 RNA replication protein [White clover mosaic virus] diamond 261 175 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus trifolii
27720820 27720820 PRJNA944406_P_NODE_6064_length_521_cov_2.406250_g5111_i0 PRJNA944406 6064 521 2.40625 12.5365625 White clover mosaic virus 12188 Viruses Viruses 336 1.8399999999999998e-104   NR NP_620715.1 12188 g5111 i0 95.4 0.99616122840691 173 8 99.6 0 519 1 723 895 NP_620715.1 RNA replication protein [White clover mosaic virus] diamond 519 336 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus trifolii
29937399 29937399 PRJNA944406_P_NODE_34431_length_278_cov_1.195122_g33472_i0 PRJNA944406 34431 278 1.195122 3.32243916 Deltaflexivirus 2169569 Viruses Viruses 118 1.79e-28   NR QKN22675.1 2743100 g33472 i0 67 3.91726618705036 88 29 95 0 11 274 199 286 QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3] diamond 1089 118 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales     Erysiphe necator associated flexivirus 3
30341802 30341802 PRJNA944406_P_NODE_112032_length_232_cov_2.358491_g111073_i0 PRJNA944406 112032 232 2.358491 5.47169912 Leptosphaeria biglobosa deltaflexivirus 2 2985705 Viruses Viruses 102 4.5e-23   NR UYL94495.1 2985705 g111073 i0 65.3 0.969827586206897 75 26 97 0 231 7 1503 1577 UYL94495.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa deltaflexivirus 2] diamond 225 102 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Deltaflexiviridae   Leptosphaeria biglobosa deltaflexivirus 2
30815181 30815181 PRJNA944406_P_NODE_30694_length_281_cov_1.480769_g29735_i0 PRJNA944406 30694 281 1.480769 4.16096089 Grapevine-associated tymo-like virus 1 2814377 Viruses Viruses 141 1.09e-36   NR QXN75447.1 2814377 g29735 i0 64.1 2.91459074733096 92 33 98.2 0 280 5 559 650 QXN75447.1 MAG: RNA-dependent RNA polymerase [Grapevine-associated tymo-like virus 1] diamond 819 141 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales     Grapevine-associated tymo-like virus 1
31194005 31194005 PRJNA944406_P_NODE_83775_length_247_cov_0.885057_g82816_i0 PRJNA944406 83775 247 0.885057 2.18609079 Leptosphaeria biglobosa deltaflexivirus 2 2985705 Viruses Viruses 154 2.319999999999999e-41   NR UYL94495.1 2985705 g82816 i0 92.6 0.983805668016194 81 6 98.4 0 245 3 1379 1459 UYL94495.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa deltaflexivirus 2] diamond 243 154 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Deltaflexiviridae   Leptosphaeria biglobosa deltaflexivirus 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);;