RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1016321" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1016321 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
13756102 13756102 PRJNA1016321_P_NODE_171_length_2662_cov_7.118965_g156_i0 PRJNA1016321 171 2662 7.118965 189.5068483 Apis mellifera associated ourmia-like virus 2 3373667 Viruses Viruses 776 3.45e-269   NR XII93055.1 3373667 g156 i0 59.4 0.793388429752066 704 263 77.3 8 86 2143 43 741 XII93055.1 RNA-dependent RNA polymerase [Apis mellifera associated ourmia-like virus 2] diamond 2112 776 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Apis mellifera associated ourmia-like virus 2
28045566 28045566 PRJNA1016321_P_NODE_24525_length_376_cov_1.016502_g24294_i0 PRJNA1016321 24525 376 1.016502 3.82204752 Suillus luteus botourmiavirus 1 3067802 Viruses Viruses 88.2 2.03e-17   NR WLK77426.1 3067802 g24294 i0 42.7 0.933510638297872 117 61 90.2 3 351 13 469 583 WLK77426.1 RNA-dependent RNA polymerase [Suillus luteus botourmiavirus 1] diamond 351 88.2 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Suillus luteus botourmiavirus 1
28574512 28574512 PRJNA1016321_P_NODE_33907_length_309_cov_1.144068_g33676_i0 PRJNA1016321 33907 309 1.144068 3.53517012 Narnavirus 186767 Viruses Viruses 55.8 1.23e-6   NR WNA22205.1 2719492 g33676 i0 35.6 1.45631067961165 104 61 99 4 3 308 54 153 WNA22205.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 1] diamond 450 55.8 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Downy mildew lesion associated splipalmivirus 1
29119379 29119379 PRJNA1016321_P_NODE_32949_length_314_cov_1.477178_g32718_i0 PRJNA1016321 32949 314 1.477178 4.63833892 Botourmiaviridae sp. 2808997 Viruses Viruses 121 2.32e-29   NR WAK77813.1 2808997 g32718 i0 58.7 0.993630573248408 104 40 99.4 1 2 313 99 199 WAK77813.1 MAG: RNA-dependent RNA polymerase [Botourmiaviridae sp.] diamond 312 121 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.
31362230 31362230 PRJNA1016321_P_NODE_12096_length_572_cov_4.843687_g11873_i0 PRJNA1016321 12096 572 4.843687 27.70588964 Tongren Botou tick virus 1 2972060 Viruses Viruses 310 2.78e-98   NR UYL95439.1 2972060 g11873 i0 79.9 0.965034965034965 184 37 96.5 0 3 554 454 637 UYL95439.1 MAG: RNA-dependent RNA polymerase [Tongren Botou tick virus 1] diamond 552 310 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Tongren Botou tick virus 1
32532830 32532830 PRJNA1016321_P_NODE_32119_length_319_cov_1.252033_g31888_i0 PRJNA1016321 32119 319 1.252033 3.99398527 Suillus luteus botourmiavirus 1 3067802 Viruses Viruses 104 2.1099999999999998e-23   NR WLK77426.1 3067802 g31888 i0 49 1.89028213166144 100 51 94 0 301 2 52 151 WLK77426.1 RNA-dependent RNA polymerase [Suillus luteus botourmiavirus 1] diamond 603 104 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Suillus luteus botourmiavirus 1

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