RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA429937 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
7465424 7465424 PRJNA429937_P_NODE_152946_length_171_cov_2.084507_g130319_i0 PRJNA429937 152946 171 2.084507 3.56450697 root 1 Root_unresolved Root_unresolved 252 1.32e-62   NTclustered gi|2575892337|gb|OR233204.1| 112229 g130319 i0 92.778 21.280701754386 180 3 100 7 1 171 6389 6211 Pepino mosaic virus isolate DSMZ PV-0975, complete genome blastn 3639 252 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
19553382 19553382 PRJNA429937_P_NODE_8336_length_1235_cov_3.791045_g4913_i0 PRJNA429937 8336 1235 3.791045 46.81940575 Bromovirus BMV 3427622 Viruses Viruses 2049 0   NTclustered gi|2329659867|gb|OK558647.1| 12302 g4913 i0 98.038 38.4453441295547 1172 16 98 2 7 1171 2339 1168 Brome mosaic virus isolate Portage- MB strain hypothetical protein gene, complete cds blastn 47480 2049 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Bromovirus Bromovirus BMV
22103849 22103849 PRJNA429937_P_NODE_72058_length_395_cov_2.207650_g50274_i0 PRJNA429937 72058 395 2.20765 8.7202175 Potexvirus trifolii 3433859 Viruses Viruses 298 4.4e-76   NTclustered gi|1078555000|dbj|LC190455.1| 12188 g50274 i0 93.909 11.2759493670886 197 12 87 0 47 243 274 470 White clover mosaic virus CP gene for coat protein, complete cds, isolate: Namwon blastn 4454 298 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus trifolii

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