RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA946307", tax_kingdom = "Shotokuvirae" and tax_phylum = "Cressdnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cressdnaviricota · 5 ✖

tax_kingdom 1

  • Shotokuvirae · 5 ✖

bioproject 1

  • PRJNA946307 · 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
6364322 6364322 PRJNA946307_P_NODE_168645_length_157_cov_2.731481_g167771_i0 PRJNA946307 168645 157 2.731481 4.28842517 Viruses 10239 Viruses Viruses 248 1.54e-61   NTclustered gi|1675876934|gb|MK032699.1| 2202565 g167771 i0 97.902 12.7834394904459 143 3 91 0 15 157 1991 2133 MAG: Genomoviridae sp. isolate ctfi75, complete genome blastn 2007 248 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Genomoviridae   Genomoviridae sp.
17837920 17837920 PRJNA946307_P_NODE_34234_length_224_cov_4.468571_g33360_i0 PRJNA946307 34234 224 4.468571 10.00959904 Viruses 10239 Viruses Viruses 200 6.72e-47   NTclustered gi|1675876934|gb|MK032699.1| 2202565 g33360 i0 99.099 2.48214285714286 111 1 88 0 2 112 1889 1779 MAG: Genomoviridae sp. isolate ctfi75, complete genome blastn 556 200 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Genomoviridae   Genomoviridae sp.
18779444 18779444 PRJNA946307_P_NODE_65875_length_199_cov_6.793333_g65001_i0 PRJNA946307 65875 199 6.793333 13.51873267 Genomoviridae sp. 2202565 Viruses Viruses 187 4.54e-43   NTclustered gi|2164969938|gb|MN765193.1| 2202565 g65001 i0 100 7.04020100502513 101 0 51 0 1 101 431 331 MAG: Genomoviridae sp. isolate SAfia-016D, complete genome blastn 1401 187 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Genomoviridae   Genomoviridae sp.
27151359 27151359 PRJNA946307_P_NODE_102962_length_183_cov_1.425373_g102088_i0 PRJNA946307 102962 183 1.425373 2.60843259 Arizlama virus 2859451 Viruses Viruses 65.1 1.22e-10   NR QXP07721.1 2859451 g102088 i0 63.3 1.49180327868852 49 14 73.8 1 151 17 146 194 QXP07721.1 MAG: putative capsid protein [Arizlama virus] diamond 273 65.1 1 Viruses   Shotokuvirae Cressdnaviricota         Arizlama virus
31225955 31225955 PRJNA946307_P_NODE_172535_length_153_cov_4.375000_g171661_i0 PRJNA946307 172535 153 4.375 6.69375 Wigfec virus K19_645 2986016 Viruses Viruses 43.5 0.00535   NR UYD39132.1 2986016 g171661 i0 46.3 1.31372549019608 41 22 80.4 0 128 6 61 101 UYD39132.1 MAG: capsid protein [Wigfec virus K19_645] diamond 201 43.5 1 Viruses   Shotokuvirae Cressdnaviricota         Wigfec virus K19_645

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