RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax_phylum = "Negarnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Negarnaviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJEB11748 · 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
16609 16609 PRJEB11748_P_NODE_237141_length_255_cov_3.561856_g234958_i0 PRJEB11748 237141 255 3.561856 9.0827328 Betapaprhavirus frugiperda 2844304 Viruses Viruses 405 1.54e-108   NTclustered gi|1560769851|gb|MH926029.1| 1481139 g234958 i0 99.115 10.6352941176471 226 1 88 1 9 233 7230 7455 Spodoptera frugiperda rhabdovirus, complete genome blastn 2712 405 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Betapaprhavirus Betapaprhavirus frugiperda
7671668 7671668 PRJEB11748_P_NODE_52047_length_593_cov_38.142857_g49938_i0 PRJEB11748 52047 593 38.142857 226.18714201 Penicillimonavirus etaplasmoparae 2845791 Viruses Viruses 854 0   NTclustered gi|2542075287|gb|OQ550535.1| 2692021 g49938 i0 93.982 0.952782462057336 565 33 95 1 13 577 658 95 Plasmopara viticola lesion associated mononegaambi virus 9 isolate DMG-B_Contig8 hypothetical protein genes, complete cds blastn 565 854 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Mymonaviridae Penicillimonavirus Penicillimonavirus etaplasmoparae
10221398 10221398 PRJEB11748_P_NODE_350569_length_197_cov_10.691176_g348386_i0 PRJEB11748 350569 197 10.691176 21.06161672 Penicillimonavirus etaplasmoparae 2845791 Viruses Viruses 250 5.64e-62   NTclustered gi|2542075287|gb|OQ550535.1| 2692021 g348386 i0 92.982 1.15736040609137 171 12 87 0 2 172 807 637 Plasmopara viticola lesion associated mononegaambi virus 9 isolate DMG-B_Contig8 hypothetical protein genes, complete cds blastn 228 250 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Mymonaviridae Penicillimonavirus Penicillimonavirus etaplasmoparae

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