RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493244 · 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
1730578 1730578 PRJNA493244_P_NODE_1501282_length_242_cov_5.000000_g1478157_i0 PRJNA493244 1501282 242 5 12.1 Erysiphe necator associated ourmia-like virus 87 2741867 Viruses Viruses 394 3.14e-105   NTclustered gi|2798495165|gb|PP945076.1| 2741867 g1478157 i0 98.649 0.91735537190082606 222 3 92 0 21 242 1954 2175 Erysiphe necator associated ourmia-like virus 87 strain China-NX113 RNA-dependent RNA polymerase gene, complete cds blastn 222 394 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 87
3006906 3006906 PRJNA493244_P_NODE_16083_length_2467_cov_7.995844_g14384_i0 PRJNA493244 16083 2467 7.995844 197.25747148 Narnaviridae sp. 2583949 Viruses Viruses 2586 0   NTclustered gi|2245490375|gb|ON164215.1| 2583949 g14384 i0 97.674 0.623023915687069 1505 35 61 0 1 1505 89 1593 MAG: Narnaviridae sp. isolate 176-k141_8579 RNA dependent RNA polymerase gene, partial cds blastn 1537 2586 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Narnaviridae sp.
5561484 5561484 PRJNA493244_P_NODE_993845_length_409_cov_19.195402_g970765_i0 PRJNA493244 993845 409 19.195402 78.50919418 Aspergillus flavus magoulivirus 1 2871716 Viruses Viruses 226 2.19e-54   NTclustered gi|2095891259|gb|MZ600058.1| 2871716 g970765 i0 79.883 0.838630806845966 343 41 80 20 12 337 381 50 MAG: Aspergillus flavus magoulivirus 1 isolate UniPR4 genomic sequence, sequence blastn 343 226 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Magoulivirus Aspergillus flavus magoulivirus 1
8109025 8109025 PRJNA493244_P_NODE_1536527_length_234_cov_3.150289_g1513402_i0 PRJNA493244 1536527 234 3.150289 7.37167626 Chrocagost virus 3129398 Viruses Viruses 281 2.46e-71   NTclustered gi|2717317482|gb|PP171846.1| 3129398 g1513402 i0 92.424 312.551282051282 198 14 84 1 5 201 5664 5861 MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence blastn 73137 281 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes       Chrocagost virus
9383175 9383175 PRJNA493244_P_NODE_1276128_length_304_cov_1.983539_g1253004_i0 PRJNA493244 1276128 304 1.983539 6.02995856 Hebei scleroulivirus 3371279 Viruses Viruses 372 1.91e-98   NTclustered gi|2819062619|gb|PQ150490.1| 3371279 g1253004 i0 93.6 1.00657894736842 250 15 82 1 24 272 2113 2362 MAG: Hebei scleroulivirus isolate Beijing_119 genomic sequence blastn 306 372 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Scleroulivirus Hebei scleroulivirus

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