RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA1174770" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 16 ✖

bioproject 1

  • PRJNA1174770 · 16 ✖

analysis 1

  • blastn · 16 ✖

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
316305 316305 PRJNA1174770_P_NODE_10261_length_165_cov_0.887931_g10172_i0 PRJNA1174770 10261 165 0.887931 1.46508615 Caudoviricetes sp. 2832643 Viruses Viruses 272 9.73e-69   NTclustered gi|2914962682|gb|OR221991.1| 2832643 g10172 i0 96.914 1.96363636363636 162 5 98 0 4 165 53697 53536 MAG: Caudoviricetes sp. isolate MSP0133 genomic sequence blastn 324 272 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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
1590976 1590976 PRJNA1174770_P_NODE_9682_length_166_cov_0.880342_g9593_i0 PRJNA1174770 9682 166 0.880342 1.46136772 Caudoviricetes sp. 2832643 Viruses Viruses 302 1.2500000000000001e-77   NTclustered gi|2914986982|gb|OR222125.1| 2832643 g9593 i0 99.398 3.75301204819277 166 1 100 0 1 166 22646 22811 MAG: Caudoviricetes sp. isolate MSP0855 genomic sequence blastn 623 302 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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
5419358 5419358 PRJNA1174770_P_NODE_6505_length_184_cov_1.237037_g6416_i0 PRJNA1174770 6505 184 1.237037 2.27614808 Caudoviricetes sp. 2832643 Viruses Viruses 65.8 2.02e-6   NTclustered gi|2059917061|tpg|BK041566.1| 2832643 g6416 i0 93.182 0.239130434782609 44 3 24 0 57 100 3333 3376 MAG TPA_asm: Caudoviricetes sp. isolate ctKPv40, partial genome blastn 44 65.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6694255 6694255 PRJNA1174770_P_NODE_9546_length_166_cov_0.888889_g9457_i0 PRJNA1174770 9546 166 0.888889 1.47555574 Caudoviricetes sp. 2832643 Viruses Viruses 291 2.7099999999999998e-74   NTclustered gi|2915045223|gb|OR222781.1| 2832643 g9457 i0 98.193 1 166 3 100 0 1 166 18910 19075 MAG: Caudoviricetes sp. isolate MSP0579 genomic sequence blastn 166 291 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7969520 7969520 PRJNA1174770_P_NODE_10667_length_164_cov_0.904348_g10578_i0 PRJNA1174770 10667 164 0.904348 1.48313072 Caudoviricetes sp. 2832643 Viruses Viruses 303 3.42e-78   NTclustered gi|2056734783|tpg|BK044972.1| 2832643 g10578 i0 100 25.890243902439 164 0 100 0 1 164 2038 1875 MAG TPA_asm: Caudoviricetes sp. isolate ctaxg3, partial genome blastn 4246 303 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14345238 14345238 PRJNA1174770_P_NODE_10652_length_164_cov_0.904348_g10563_i0 PRJNA1174770 10652 164 0.904348 1.48313072 Tobamovirus tropici 3432893 Viruses Viruses 303 3.42e-78   NTclustered gi|1893169051|gb|MT130385.1| 327387 g10563 i0 100 12.0060975609756 164 0 100 0 1 164 3669 3832 Tropical soda apple mosaic virus isolate I4-11-TSAMV 183 kDa replicase, movement protein, and coat protein genes, complete cds blastn 1969 303 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tropici
15619055 15619055 PRJNA1174770_P_NODE_7153_length_176_cov_1.622047_g7064_i0 PRJNA1174770 7153 176 1.622047 2.85480272 Caudoviricetes sp. 2832643 Viruses Viruses 224 2.9699999999999996e-54   NTclustered gi|2914824635|gb|OR222226.1| 2832643 g7064 i0 92.357 1.78977272727273 157 12 89 0 19 175 16933 17089 MAG: Caudoviricetes sp. isolate MSP0745 genomic sequence blastn 315 224 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16893397 16893397 PRJNA1174770_P_NODE_9554_length_166_cov_0.888889_g9465_i0 PRJNA1174770 9554 166 0.888889 1.47555574 Lactococcus phage D6890 2979363 Viruses Viruses 307 2.69e-79   NTclustered gi|2306485016|gb|OP323077.1| 2979363 g9465 i0 100 60.2590361445783 166 0 100 0 1 166 25893 25728 Lactococcus phage D6890, complete genome blastn 10003 307 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Lactococcus phage D6890
18167897 18167897 PRJNA1174770_P_NODE_4255_length_223_cov_2.333333_g4166_i0 PRJNA1174770 4255 223 2.333333 5.20333259 Maltschvirus maltsch 2956182 Viruses Viruses 65.8 2.54e-6   NTclustered gi|1862931302|emb|LR798196.1| 2100421 g4166 i0 93.182 0.197309417040359 44 3 20 0 65 108 7986 7943 uncultured Caudovirales phage genome assembly blastn 44 65.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
20717623 20717623 PRJNA1174770_P_NODE_11157_length_163_cov_1.368421_g11068_i0 PRJNA1174770 11157 163 1.368421 2.23052623 Caudoviricetes sp. 2832643 Viruses Viruses 237 3.49e-58   NTclustered gi|2914852300|gb|OR221708.1| 2832643 g11068 i0 93.252 1 163 8 100 3 1 163 881 722 MAG: Caudoviricetes sp. isolate MSP1326 genomic sequence blastn 163 237 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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
20717686 20717686 PRJNA1174770_P_NODE_8957_length_167_cov_0.881356_g8868_i0 PRJNA1174770 8957 167 0.881356 1.47186452 Caudoviricetes sp. 2832643 Viruses Viruses 276 7.64e-70   NTclustered gi|2057046044|tpg|BK049375.1| 2832643 g8868 i0 96.407 1 167 6 100 0 1 167 44113 43947 MAG TPA_asm: Caudoviricetes sp. isolate ctqLd1, partial genome blastn 167 276 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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
21992910 21992910 PRJNA1174770_P_NODE_7478_length_173_cov_0.838710_g7389_i0 PRJNA1174770 7478 173 0.83871 1.4509683 Varroa picorna-like virus 2873563 Viruses Viruses 259 7.98e-65   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g7389 i0 93.642 1.98843930635838 173 11 100 0 1 173 7501 7673 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 344 259 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus

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