RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1111077" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 5 ✖

bioproject 1

  • PRJNA1111077 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
5317226 5317226 PRJNA1111077_P_NODE_11085_length_355_cov_3.588652_g10864_i0 PRJNA1111077 11085 355 3.588652 12.7397146 Ripathuj virus 3131458 Viruses Viruses 414 3.72e-111   NTclustered gi|2717322573|gb|PP173760.1| 3131458 g10864 i0 88.473 147.250704225352 347 34 97 6 12 355 48 391 MAG: Ripathuj virus isolate RCCP2_k141_221326 genomic sequence blastn 52274 414 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Ripathuj virus
6593088 6593088 PRJNA1111077_P_NODE_3706_length_581_cov_8.125984_g3485_i0 PRJNA1111077 3706 581 8.125984 47.21196704 Malassezia restricta virus MrV40S 2727864 Viruses Viruses 728 0   NTclustered gi|1832308146|gb|MN603498.1| 2727864 g3485 i0 89.402 1.00688468158348 585 52 100 10 1 581 9 587 Malassezia restricta virus MrV40S, complete genome blastn 585 728 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Malassezia restricta virus MrV40S
15048708 15048708 PRJNA1111077_P_NODE_14912_length_310_cov_4.341772_g14691_i0 PRJNA1111077 14912 310 4.341772 13.4594932 root 1 Root_unresolved Root_unresolved 228 4.4799999999999984e-55   NTclustered gi|2717322326|gb|PP173666.1| 3131364 g14691 i0 85.366 257.332258064516 205 27 65 3 108 310 789 586 MAG: Ripastyr virus isolate MP3_k141_6580 genomic sequence blastn 79773 228 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Ripastyr virus
18066850 18066850 PRJNA1111077_P_NODE_9875_length_375_cov_1.433775_g9654_i0 PRJNA1111077 9875 375 1.433775 5.37665625 Ripothoz virus 3131336 Viruses Viruses 324 6.85e-84   NTclustered gi|2717322249|gb|PP173638.1| 3131336 g9654 i0 84.57 44.6826666666667 337 41 89 9 44 375 5301 5631 MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence blastn 16756 324 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales     Ripothoz virus
19340770 19340770 PRJNA1111077_P_NODE_3256_length_612_cov_11.730983_g3039_i0 PRJNA1111077 3256 612 11.730983 71.79361596 Malassezia restricta virus MrV40S 2727864 Viruses Viruses 771 0   NTclustered gi|1832308146|gb|MN603498.1| 2727864 g3039 i0 94.106 0.831699346405229 509 26 83 3 1 505 595 1103 Malassezia restricta virus MrV40S, complete genome blastn 509 771 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Malassezia restricta virus MrV40S

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