RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA564013" and tax_kingdom = "Pararnavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Pararnavirae · 4 ✖

bioproject 1

  • PRJNA564013 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3684277 3684277 PRJNA564013_P_NODE_360143_length_191_cov_7.192308_g357291_i0 PRJNA564013 360143 191 7.192308 13.73730828 root 1 Root_unresolved Root_unresolved 84.2 5.83e-12   NTclustered gi|7414449|emb|AJ288590.1| 61673 g357291 i0 94.545 25.2041884816754 55 2 29 1 21 75 1976 1923 Porcine endogenous retrovirus PERV-B4 env gene for envelope protein, genomic RNA blastn 4814 84.2 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus porConc
10750946 10750946 PRJNA564013_P_NODE_109909_length_395_cov_8.877246_g107068_i0 PRJNA564013 109909 395 8.877246 35.0651217 Gammaretrovirus murleu 3428959 Viruses Viruses 392 1.9599999999999994e-104   NTclustered gi|4928667|gb|AF136154.1|AF136154 11786 g107068 i0 97.807 70.2329113924051 228 3 57 1 20 245 228 1 Murine leukemia virus long terminal repeat, partial sequence blastn 27742 392 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
10755170 10755170 PRJNA564013_P_NODE_309809_length_219_cov_4.164557_g306957_i0 PRJNA564013 309809 219 4.164557 9.12037983 Gammaretrovirus murleu 3428959 Viruses Viruses 324 3.72e-84   NTclustered gi|1167936865|gb|KY574518.1| 11786 g306957 i0 100 79.8721461187215 175 0 80 0 24 198 3400 3226 Murine leukemia virus isolate PTV1, complete genome blastn 17492 324 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
18982853 18982853 PRJNA564013_P_NODE_123975_length_378_cov_4.507886_g121129_i0 PRJNA564013 123975 378 4.507886 17.03980908 Viruses 10239 Viruses Viruses 510 4.94e-140   NTclustered gi|1189354729|gb|KY609920.1| 1435008 g121129 i0 91.005 6.95767195767196 378 34 100 0 1 378 1323 1700 Citrus endogenous pararetrovirus strain SPBR01 polyprotein gene, complete cds blastn 2630 510 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Citrus endogenous pararetrovirus

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