RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA691918" and tax_clade = "CRESS viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • CRESS viruses · 3 ✖

bioproject 1

  • PRJNA691918 · 3 ✖

analysis 1

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
3731047 3731047 PRJNA691918_S_NODE_343_length_171_cov_5.778571_g342_i0 PRJNA691918 343 171 5.778571 9.88135641 Viruses 10239 Viruses Viruses 305 9.96e-79   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g342 i0 99.408 2.98245614035088 169 0 98 1 4 171 2385 2217 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 510 305 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS virus
8832180 8832180 PRJNA691918_S_NODE_107_length_222_cov_16011.392670_g106_i0 PRJNA691918 107 222 16011.39267 35545.2917274 Viruses 10239 Viruses Viruses 313 8.18e-81   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g106 i0 99.422 20.481981981982 173 0 78 1 2 174 1850 2021 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 4547 313 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS virus
17757070 17757070 PRJNA691918_S_NODE_234_length_189_cov_19008.487342_g233_i0 PRJNA691918 234 189 19008.487342 35926.04107638 Viruses 10239 Viruses Viruses 267 5.32e-67   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g233 i0 98.667 23.2698412698413 150 2 79 0 38 187 2524 2375 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 4398 267 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS virus

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