RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA940501" and tax_kingdom = "Pararnavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Pararnavirae · 5 ✖

bioproject 1

  • PRJNA940501 · 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
8572756 8572756 PRJNA940501_S_NODE_255487_length_177_cov_2.044776_g254669_i0 PRJNA940501 255487 177 2.044776 3.61925352 Gammaretrovirus murleu 3428959 Viruses Viruses 327 2.2199999999999996e-85   NTclustered gi|1167936849|gb|KY574517.1| 11786 g254669 i0 100 62.4011299435028 177 0 100 0 1 177 7633 7457 Murine leukemia virus isolate MCF247, complete genome blastn 11045 327 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
14948269 14948269 PRJNA940501_S_NODE_300892_length_167_cov_1.491935_g300074_i0 PRJNA940501 300892 167 1.491935 2.49153145 Bovine endogenous retrovirus beta 1 1105057 Viruses Viruses 265 1.65e-66   NTclustered gi|354681771|emb|HE608663.1| 1105057 g300074 i0 95.21 3 167 8 100 0 1 167 517 351 Bovine endogenous retrovirus beta 1 proviral partial pro gene for protease and partial pol gene for reverse transcriptase blastn 501 265 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Betaretrovirus Bovine endogenous retrovirus beta 1
17834964 17834964 PRJNA940501_S_NODE_182894_length_199_cov_0.903846_g182076_i0 PRJNA940501 182894 199 0.903846 1.79865354 root 1 Root_unresolved Root_unresolved 335 1.5299999999999996e-87   NTclustered gi|332097|gb|K00556.1|MMTENV 11757 g182076 i0 96.985 68.2964824120603 199 6 100 0 1 199 2350 2152 mouse mammary tumor virus env mrna blastn 13591 335 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Betaretrovirus Betaretrovirus murmamtum
23870977 23870977 PRJNA940501_S_NODE_168439_length_204_cov_1.248447_g167621_i0 PRJNA940501 168439 204 1.248447 2.54683188 Betaretrovirus murmamtum 3427295 Viruses Viruses 372 1.2e-98   NTclustered gi|3273865|gb|AF071010.1|AF071010 11757 g167621 i0 99.51 5.67156862745098 204 1 100 0 1 204 3960 3757 Mouse mammary tumor virus putative integrase, env polyprotein, and superantigen mRNA, complete cds blastn 1157 372 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Betaretrovirus Betaretrovirus murmamtum
25484265 25484265 PRJNA940501_S_NODE_22500_length_351_cov_3.993506_g21682_i0 PRJNA940501 22500 351 3.993506 14.01720606 Betaretrovirus 140052 Viruses Viruses 604 2.0299999999999991e-168   NTclustered gi|332127|gb|M15122.1|MMTPROCG 11757 g21682 i0 97.721 55.042735042735 351 8 100 0 1 351 1721 1371 Mouse mammary tumor virus complete proviral genome and mouse DNA blastn 19320 610 0.99016393442623 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Betaretrovirus Betaretrovirus murmamtum

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