RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA680334" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA680334 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
10853907 10853907 PRJNA680334_S_NODE_4589_length_396_cov_17.801653_g4106_i0 PRJNA680334 4589 396 17.801653 70.49454588 Potexvirus trifolii 3433859 Viruses Viruses 643 4.919999999999999e-180   NTclustered gi|2792601926|gb|PQ162444.1| 12188 g4106 i0 95.96 31.4974747474747 396 16 100 0 1 396 5448 5843 White clover mosaic virus isolate DSMZ PV-1407, complete genome blastn 12473 643 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus trifolii
13404545 13404545 PRJNA680334_S_NODE_8751_length_326_cov_16.058020_g8265_i0 PRJNA680334 8751 326 16.05802 52.3491452 Potexvirus trifolii 3433859 Viruses Viruses 448 3.3499999999999996e-121   NTclustered gi|61323|emb|X16636.1| 12188 g8265 i0 91.875 25.319018404908 320 26 98 0 7 326 5527 5846 White clover mosaic virus total genomic mRNA blastn 8254 448 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus trifolii
14678355 14678355 PRJNA680334_S_NODE_1712_length_542_cov_9.377210_g1257_i0 PRJNA680334 1712 542 9.37721 50.8244782 Tobamovirus plantagonis 3432885 Viruses Viruses 850 0   NTclustered gi|1820428442|gb|MT129775.1| 51680 g1257 i0 95.009 36.7859778597786 541 27 99 0 1 541 5495 4955 Ribgrass mosaic virus strain GudgCC_DN40115-8, complete genome blastn 19938 850 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus plantagonis
24876007 24876007 PRJNA680334_S_NODE_4900_length_388_cov_6.878873_g4416_i0 PRJNA680334 4900 388 6.878873 26.69002724 Bromovirus BMV 3427622 Viruses Viruses 712 0   NTclustered gi|2214792991|gb|MW581063.1| 12302 g4416 i0 99.742 36.788659793814404 388 1 100 0 1 388 815 1202 Brome mosaic virus isolate BMV-R movement protein and coat protein genes, complete cds blastn 14274 712 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Bromovirus Bromovirus BMV

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