RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA399133" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 11 ✖

bioproject 1

  • PRJNA399133 · 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
413208 413208 PRJNA399133_P_NODE_5681_length_222_cov_1.609626_g5593_i0 PRJNA399133 5681 222 1.609626 3.57336972 uncultured virus 340016 Viruses Viruses 161 3.14e-35   NTclustered gi|350283975|gb|JF964211.1| 340016 g5593 i0 88.321 13.3918918918919 137 12 61 4 79 213 374 240 Uncultured virus clone GOM_phoH_15 phosphate-starvation inducible protein (phoH) gene, partial cds blastn 2973 161 1 Viruses               uncultured virus
1688038 1688038 PRJNA399133_P_NODE_142_length_1307_cov_3.996855_g112_i0 PRJNA399133 142 1307 3.996855 52.23889485 Maltschvirus maltsch 2956182 Viruses Viruses 58.4 0.003   NTclustered gi|1839187624|emb|LR796897.1| 2100421 g112 i0 100 0.0749808722264728 31 0 2 0 1086 1116 6284 6314 uncultured Caudovirales phage genome assembly blastn 98 58.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
4240421 4240421 PRJNA399133_P_NODE_7464_length_192_cov_1.974522_g7376_i0 PRJNA399133 7464 192 1.974522 3.79108224 uncultured virus 340016 Viruses Viruses 165 2.04e-36   NTclustered gi|705244480|gb|KM520172.1| 340016 g7376 i0 85.535 7.375 159 21 82 2 34 191 1218 1061 Uncultured virus clone CBJ_Contig_2 ribonucleotide reductase gene, partial cds blastn 1416 165 1 Viruses               uncultured virus
10617244 10617244 PRJNA399133_P_NODE_8289_length_182_cov_1.755102_g8201_i0 PRJNA399133 8289 182 1.755102 3.19428564 Caudoviricetes sp. 2832643 Viruses Viruses 124 3.2299999999999997e-24   NTclustered gi|2054463720|tpg|BK031592.1| 2832643 g8201 i0 83.088 0.747252747252747 136 23 75 0 5 140 8581 8446 MAG TPA_asm: Caudoviricetes sp. isolate ctgih1, partial genome blastn 136 124 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13167143 13167143 PRJNA399133_P_NODE_9791_length_168_cov_1.879699_g9703_i0 PRJNA399133 9791 168 1.879699 3.15789432 Maltschvirus maltsch 2956182 Viruses Viruses 56.5 0.001   NTclustered gi|1839214128|emb|LR797474.1| 2100421 g9703 i0 96.97 0.196428571428571 33 1 20 0 37 69 197505 197537 uncultured Caudovirales phage genome assembly blastn 33 56.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
13834443 13834443 PRJNA399133_P_NODE_9971_length_167_cov_0.909091_g9883_i0 PRJNA399133 9971 167 0.909091 1.51818197 Viruses 10239 Viruses Viruses 309 7.53e-80   NTclustered gi|2052870917|tpg|BK032626.1| 2827768 g9883 i0 100 61.3053892215569 167 0 100 0 1 167 660 826 MAG TPA_asm: Siphoviridae sp. ct2KB1, partial genome blastn 10238 309 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ct2KB1
16990683 16990683 PRJNA399133_P_NODE_10474_length_163_cov_1.414062_g10386_i0 PRJNA399133 10474 163 1.414062 2.30492106 Caudoviricetes sp. 2832643 Viruses Viruses 211 2.12e-50   NTclustered gi|2216802433|gb|MW202867.1| 2832643 g10386 i0 93.617 0.865030674846626 141 9 87 0 1 141 3814 3954 Myoviridae sp. isolate ct3Oc712, complete genome blastn 141 211 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16990686 16990686 PRJNA399133_P_NODE_10734_length_161_cov_1.587302_g10646_i0 PRJNA399133 10734 161 1.587302 2.55555622 Gammapapillomavirus 1 333926 Viruses Viruses 298 1.56e-76   NTclustered gi|1878296596|gb|MN605989.1| 10617 g10646 i0 100 3.39130434782609 161 0 100 0 1 161 1228 1388 Human papillomavirus 4 isolate P2, complete genome blastn 546 298 1 Viruses   Shotokuvirae Cossaviricota Papovaviricetes Zurhausenvirales Papillomaviridae Gammapapillomavirus Gammapapillomavirus 1
19539127 19539127 PRJNA399133_P_NODE_8056_length_185_cov_1.333333_g7968_i0 PRJNA399133 8056 185 1.333333 2.46666605 Gammapapillomavirus 1 333926 Viruses Viruses 342 8.369999999999999e-90   NTclustered gi|1878296596|gb|MN605989.1| 10617 g7968 i0 100 3.01081081081081 185 0 100 0 1 185 6778 6962 Human papillomavirus 4 isolate P2, complete genome blastn 557 342 1 Viruses   Shotokuvirae Cossaviricota Papovaviricetes Zurhausenvirales Papillomaviridae Gammapapillomavirus Gammapapillomavirus 1
20814792 20814792 PRJNA399133_P_NODE_11477_length_156_cov_1.652893_g11389_i0 PRJNA399133 11477 156 1.652893 2.57851308 Crassvirales sp. 2960088 Viruses Viruses 185 1.2099999999999999e-42   NTclustered gi|2054561072|tpg|BK048250.1| 2960088 g11389 i0 88.312 0.987179487179487 154 18 99 0 3 156 15051 15204 MAG TPA_asm: Crassvirales sp. isolate ct4px4, partial genome blastn 154 185 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Crassvirales     Crassvirales sp.
22089698 22089698 PRJNA399133_P_NODE_2718_length_303_cov_1.723881_g2630_i0 PRJNA399133 2718 303 1.723881 5.22335943 Veracruzvirus phantastic 2956639 Viruses Viruses 62.1 4.69e-5   NTclustered gi|640885266|ref|NC_024148.1| 1486426 g2630 i0 92.857 0.237623762376238 42 3 14 0 109 150 2117 2158 Mycobacterium phage Phantastic, complete genome blastn 72 62.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Veracruzvirus Veracruzvirus phantastic

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