RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax_phylum = "Cressdnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cressdnaviricota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA799842 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
4624424 4624424 PRJNA799842_P_NODE_93144_length_301_cov_0.929825_g91571_i0 PRJNA799842 93144 301 0.929825 2.79877325 Begomovirus ipomoeae 3426807 Viruses Viruses 518 2.3e-142   NTclustered gi|1732260810|gb|MH602265.1| 100755 g91571 i0 97.674 99.9800664451827 301 7 100 0 1 301 2134 1834 Sweet potato leaf curl virus isolate XU11_3, complete genome blastn 30094 518 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Geminiviridae Begomovirus Begomovirus ipomoeae
4624499 4624499 PRJNA799842_P_NODE_96984_length_295_cov_1.292793_g95411_i0 PRJNA799842 96984 295 1.292793 3.81373935 Begomovirus ipomoeae 3426807 Viruses Viruses 484 2.2799999999999996e-132   NTclustered gi|534293318|gb|KF040464.1| 100755 g95411 i0 96.271 98.206779661017 295 11 100 0 1 295 1151 857 Sweet potato leaf curl virus isolate China:Sichuan15(2):2012, complete genome blastn 28971 484 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Geminiviridae Begomovirus Begomovirus ipomoeae
10997087 10997087 PRJNA799842_P_NODE_123729_length_263_cov_1.215789_g122156_i0 PRJNA799842 123729 263 1.215789 3.19752507 Mastrevirus ipomoeae 3430714 Viruses Viruses 165 2.96e-36   NTclustered gi|1197509325|ref|NC_034630.1| 603333 g122156 i0 92.241 1.0532319391635 116 9 44 0 148 263 1358 1243 Sweetpotato symptomless mastrevirus 1 isolate Z01057b, complete genome blastn 277 165 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Geminiviridae Mastrevirus Mastrevirus ipomoeae
10999233 10999233 PRJNA799842_P_NODE_62129_length_361_cov_1.406250_g60556_i0 PRJNA799842 62129 361 1.40625 5.0765625 Begomovirus ipomoeachinaense 3426806 Viruses Viruses 667 0   NTclustered gi|340537772|gb|JF736657.1| 1198219 g60556 i0 100 79.4903047091413 361 0 100 0 1 361 1316 1676 Sweet potato leaf curl China virus isolate SPLCCNV-ZJ, complete genome blastn 28696 667 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Geminiviridae Begomovirus Begomovirus ipomoeachinaense
12698974 12698974 PRJNA799842_P_NODE_53250_length_389_cov_1.316456_g51677_i0 PRJNA799842 53250 389 1.316456 5.12101384 Begomovirus 10814 Viruses Viruses 719 0   NTclustered gi|1018645821|gb|KT992062.1| 100755 g51677 i0 100 99.4627249357327 389 0 100 0 1 389 2465 2077 Sweet potato leaf curl virus isolate 169-SPLCV-II, complete genome blastn 38691 719 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Geminiviridae Begomovirus Begomovirus ipomoeae
12699041 12699041 PRJNA799842_P_NODE_59630_length_368_cov_1.969492_g58057_i0 PRJNA799842 59630 368 1.969492 7.24773056 Begomovirus 10814 Viruses Viruses 486 8.089999999999998e-133   NTclustered gi|2173422625|gb|MW021472.1| 100755 g58057 i0 100 92.3369565217391 263 0 100 0 1 263 233 495 Sweet potato leaf curl virus isolate Hunan:6-1 segment DNA-A, complete sequence blastn 33980 486 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Geminiviridae Begomovirus Begomovirus ipomoeae
13973580 13973580 PRJNA799842_P_NODE_75891_length_330_cov_1.007782_g74318_i0 PRJNA799842 75891 330 1.007782 3.3256806 Begomovirus 10814 Viruses Viruses 604 1.8999999999999996e-168   NTclustered gi|2500367740|ref|NC_075421.1| 100755 g74318 i0 99.697 99.8272727272727 330 1 100 0 1 330 848 519 Sweet potato leaf curl virus isolate SPLCV-SD, complete genome blastn 32943 604 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Geminiviridae Begomovirus Begomovirus ipomoeae
16521488 16521488 PRJNA799842_P_NODE_12053_length_903_cov_1.406024_g10806_i0 PRJNA799842 12053 903 1.406024 12.69639672 Begomovirus 10814 Viruses Viruses 1238 0   NTclustered gi|592747424|gb|KJ013574.1| 1605995 g10806 i0 98.711 68.0487264673311 698 7 95 2 206 903 983 288 Sweet potato leaf curl Henan4 virus isolate China:Hunan2:2012, partial genome blastn 61448 1243 0.99597747385358 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Geminiviridae Begomovirus Begomovirus ipomoeahenanense
17374330 17374330 PRJNA799842_P_NODE_9074_length_1039_cov_1.861284_g8007_i0 PRJNA799842 9074 1039 1.861284 19.33874076 Malazfec virus 23 3112689 Viruses Viruses 665 0   NTclustered gi|2671839772|gb|OR915633.1| 3112689 g8007 i0 83.176 9.55149181905679 743 110 71 14 221 954 773 37 MAG: Malazfec virus 23 isolate K14_1509, complete genome blastn 9924 665 1 Viruses   Shotokuvirae Cressdnaviricota         Malazfec virus 23
19919560 19919560 PRJNA799842_P_NODE_103436_length_287_cov_0.967290_g101863_i0 PRJNA799842 103436 287 0.96729 2.7761223 Begomovirus ipomoeae 3426807 Viruses Viruses 503 6.1e-138   NTclustered gi|1732260810|gb|MH602265.1| 100755 g101863 i0 98.258 99.9547038327526 287 5 100 0 1 287 1679 1393 Sweet potato leaf curl virus isolate XU11_3, complete genome blastn 28687 503 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Geminiviridae Begomovirus Begomovirus ipomoeae
25445197 25445197 PRJNA799842_P_NODE_100140_length_291_cov_0.788991_g98567_i0 PRJNA799842 100140 291 0.788991 2.29596381 Begomovirus 10814 Viruses Viruses 420 6.42e-113   NTclustered gi|592747419|gb|KJ013573.1| 1605995 g98567 i0 99.565 83.0687285223368 230 1 100 0 62 291 295 66 Sweet potato leaf curl Henan4 virus isolate China:Jiangsu3-2-2:2010, partial genome blastn 24173 420 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Geminiviridae Begomovirus Begomovirus ipomoeahenanense

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