RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1174770" 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

  • PRJNA1174770 · 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
1590940 1590940 PRJNA1174770_P_NODE_7482_length_173_cov_0.758065_g7393_i0 PRJNA1174770 7482 173 0.758065 1.31145245 Citrus endogenous pararetrovirus 1435008 Viruses Viruses 239 1.04e-58   NTclustered gi|1189354729|gb|KY609920.1| 1435008 g7393 i0 95.364 6.12138728323699 151 6 87 1 2 152 1978 2127 Citrus endogenous pararetrovirus strain SPBR01 polyprotein gene, complete cds blastn 1059 239 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Citrus endogenous pararetrovirus
2867106 2867106 PRJNA1174770_P_NODE_3483_length_249_cov_0.855000_g3394_i0 PRJNA1174770 3483 249 0.855 2.12895 Citrus endogenous pararetrovirus 1435008 Viruses Viruses 113 1.02e-20   NTclustered gi|565672279|gb|KF800044.1| 1435008 g3394 i0 97.015 1.07630522088353 67 2 27 0 137 203 6948 6882 Citrus endogenous pararetrovirus clone CB17-2, complete genome blastn 268 113 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Citrus endogenous pararetrovirus
20717666 20717666 PRJNA1174770_P_NODE_6117_length_189_cov_1.364286_g6028_i0 PRJNA1174770 6117 189 1.364286 2.57850054 Citrus blight-associated pararetrovirus 2689385 Viruses Viruses 252 1.49e-62   NTclustered gi|2288530032|gb|MZ330114.1| 2689385 g6028 i0 91.099 1.01058201058201 191 10 99 7 1 188 7039 6853 Citrus blight-associated pararetrovirus isolate TL 101/CBaPRV, complete genome blastn 191 252 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Citrus blight-associated pararetrovirus
21992907 21992907 PRJNA1174770_P_NODE_7258_length_175_cov_1.603175_g7169_i0 PRJNA1174770 7258 175 1.603175 2.80555625 Citrus blight-associated pararetrovirus 2689385 Viruses Viruses 318 1.32e-82   NTclustered gi|1785997357|gb|MN814438.1| 2689385 g7169 i0 99.429 2.00571428571429 175 1 100 0 1 175 5338 5164 Citrus blight-associated pararetrovirus isolate CBaPRV-LC, complete genome blastn 351 318 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Citrus blight-associated 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);;