RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1047551" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 6 ✖

bioproject 1

  • PRJNA1047551 · 6 ✖

analysis 1

  • blastn · 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
6552433 6552433 PRJNA1047551_S_NODE_10386_length_165_cov_6.415385_g10259_i0 PRJNA1047551 10386 165 6.415385 10.58538525 Crogonang virus 9 3062921 Viruses Viruses 134 4.7900000000000005e-27   NTclustered gi|2836327217|gb|PQ161481.1| 3062921 g10259 i0 97.436 1.78181818181818 78 2 47 0 18 95 9031 9108 MAG: Crogonang virus 9 isolate CS13 RNA-dependent RNA polymerase and capsid protein genes, complete cds blastn 294 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 9
12928375 12928375 PRJNA1047551_S_NODE_5651_length_207_cov_1.040698_g5524_i0 PRJNA1047551 5651 207 1.040698 2.15424486 Malassezia restricta virus MrV40L 2727863 Viruses Viruses 372 1.2199999999999997e-98   NTclustered gi|1832308141|gb|MN603497.1| 2727863 g5524 i0 99.034 1 207 2 100 0 1 207 2902 2696 Malassezia restricta virus MrV40L, complete genome blastn 207 372 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Malassezia restricta virus MrV40L
15477417 15477417 PRJNA1047551_S_NODE_533_length_585_cov_8.032727_g420_i0 PRJNA1047551 533 585 8.032727 46.99145295 Botourmiaviridae sp. 2808997 Viruses Viruses 464 6.27e-126   NTclustered gi|2320142628|gb|ON585088.1| 2808997 g420 i0 82.545 0.94017094017094 550 75 92 20 37 574 2001 2541 MAG: Botourmiaviridae sp. isolate PMS2_Contig239 RNA-dependent RNA polymerase gene, complete cds blastn 550 464 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.
16751476 16751476 PRJNA1047551_S_NODE_1934_length_322_cov_15.780488_g1807_i0 PRJNA1047551 1934 322 15.780488 50.81317136 Monilinia fructicola mitovirus 10 2964643 Viruses Viruses 337 7.449999999999997e-88   NTclustered gi|2273758207|gb|ON038384.1| 2964643 g1807 i0 90.837 1.26086956521739 251 23 78 0 71 321 14 264 Monilinia fructicola mitovirus 10 RNA-dependent RNA polymerase gene, complete cds blastn 406 337 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Monilinia fructicola mitovirus 10
18026401 18026401 PRJNA1047551_S_NODE_3055_length_265_cov_1.686957_g2928_i0 PRJNA1047551 3055 265 1.686957 4.47043605 Coltivirus dermacentoris 3428066 Viruses Viruses 424 4.46e-114   NTclustered gi|2758887253|gb|PP473574.1| 46839 g2928 i0 95.472 75.1811320754717 265 12 100 0 1 265 4808 4544 MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence blastn 19923 424 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales Spinareoviridae Coltivirus Coltivirus dermacentoris
20575693 20575693 PRJNA1047551_S_NODE_3897_length_239_cov_1.769608_g3770_i0 PRJNA1047551 3897 239 1.769608 4.22936312 Caudoviricetes sp. 2832643 Viruses Viruses 361 3.14e-95   NTclustered gi|2057177473|tpg|BK058946.1| 2832643 g3770 i0 93.827 7.07531380753138 243 10 100 4 1 239 32829 32588 MAG TPA_asm: Caudoviricetes sp. isolate ctbxB6, partial genome blastn 1691 361 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.

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