RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "blastn", bioproject = "PRJNA414225" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 33 ✖

bioproject 1

  • PRJNA414225 · 33 ✖

analysis 1

  • blastn · 33 ✖

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
418906 418906 PRJNA414225_P_NODE_35621_length_175_cov_1.222222_g35534_i0 PRJNA414225 35621 175 1.222222 2.1388885 Caudoviricetes sp. 2832643 Viruses Viruses 147 6.569999999999999e-31   NTclustered gi|2054472816|tpg|BK031770.1| 2832643 g35534 i0 86.029 1.36 136 19 78 0 40 175 10325 10460 MAG TPA_asm: Caudoviricetes sp. isolate ctpsk1, partial genome blastn 238 147 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
1693791 1693791 PRJNA414225_P_NODE_63162_length_165_cov_0.879310_g63075_i0 PRJNA414225 63162 165 0.87931 1.4508615 Caudoviricetes sp. 2832643 Viruses Viruses 228 2.139999999999999e-55   NTclustered gi|2914852300|gb|OR221708.1| 2832643 g63075 i0 91.515 1 165 14 100 0 1 165 2684 2520 MAG: Caudoviricetes sp. isolate MSP1326 genomic sequence blastn 165 228 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
2969657 2969657 PRJNA414225_P_NODE_50163_length_167_cov_0.864407_g50076_i0 PRJNA414225 50163 167 0.864407 1.44355969 Cutibacterium phage P107A 2686222 Viruses Viruses 289 9.81e-74   NTclustered gi|1789795202|gb|MN813679.1| 2686222 g50076 i0 98.182 26.6287425149701 165 3 99 0 1 165 23398 23562 Cutibacterium phage P107A, complete genome blastn 4447 289 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Cutibacterium phage P107A
4245995 4245995 PRJNA414225_P_NODE_42764_length_170_cov_1.289256_g42677_i0 PRJNA414225 42764 170 1.289256 2.1917352 Caudoviricetes sp. 2832643 Viruses Viruses 241 2.8300000000000007e-59   NTclustered gi|2914938452|gb|OR221697.1| 2832643 g42677 i0 93.252 6.77647058823529 163 11 96 0 1 163 10277 10439 MAG: Caudoviricetes sp. isolate MSP1348 genomic sequence blastn 1152 241 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
4246097 4246097 PRJNA414225_P_NODE_88264_length_162_cov_0.902655_g88177_i0 PRJNA414225 88264 162 0.902655 1.4623011 Streptococcus satellite phage Javan296 2558615 Viruses Viruses 294 2.03e-75   NTclustered gi|1608036727|gb|MK448408.1| 2558615 g88177 i0 99.383 99.8641975308642 162 1 100 0 1 162 47 208 Streptococcus satellite phage Javan296, complete genome blastn 16178 294 1 Viruses               Streptococcus satellite phage Javan296
6796737 6796737 PRJNA414225_P_NODE_68146_length_165_cov_0.879310_g68059_i0 PRJNA414225 68146 165 0.87931 1.4508615 Caudoviricetes sp. 2832643 Viruses Viruses 244 2.12e-60   NTclustered gi|2914806384|gb|OR221540.1| 2832643 g68059 i0 93.373 1.22424242424242 166 10 100 1 1 165 22371 22206 MAG: Caudoviricetes sp. isolate MSP1539 genomic sequence blastn 202 244 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
8072239 8072239 PRJNA414225_P_NODE_52107_length_167_cov_0.864407_g52020_i0 PRJNA414225 52107 167 0.864407 1.44355969 Staphylococcus phage Twillingate 2234037 Viruses Viruses 309 7.53e-80   NTclustered gi|1432225596|gb|MH321491.1| 2234037 g52020 i0 100 15.7964071856287 167 0 100 0 1 167 3073 2907 Staphylococcus phage Twillingate, complete genome blastn 2638 309 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae Sepunavirus Staphylococcus phage Twillingate
9347041 9347041 PRJNA414225_P_NODE_31968_length_177_cov_1.593750_g31881_i0 PRJNA414225 31968 177 1.59375 2.8209375 Caudoviricetes sp. 2832643 Viruses Viruses 305 1.04e-78   NTclustered gi|2054415310|tpg|BK035620.1| 2832643 g31881 i0 97.74 4.15254237288136 177 4 100 0 1 177 32732 32908 MAG TPA_asm: Caudoviricetes sp. isolate ctmQY1, partial genome blastn 735 305 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11286441 11286441 PRJNA414225_P_NODE_48249_length_167_cov_0.864407_g48162_i0 PRJNA414225 48249 167 0.864407 1.44355969 Pahexavirus 1982251 Viruses Viruses 298 1.63e-76   NTclustered gi|849255497|ref|NC_027386.1| 1500825 g48162 i0 98.802 100.317365269461 167 2 100 0 1 167 12081 12247 Propionibacterium phage PHL152M00, complete genome blastn 16753 298 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus PHL152M00
11897771 11897771 PRJNA414225_P_NODE_42250_length_170_cov_1.685950_g42163_i0 PRJNA414225 42250 170 1.68595 2.866115 Siphoviridae sp. ct5tj9 2823564 Viruses Viruses 303 3.55e-78   NTclustered gi|2051115658|tpg|BK014716.1| 2823564 g42163 i0 98.824 1 170 2 100 0 1 170 7498 7329 MAG TPA_asm: Siphoviridae sp. ct5tj9, partial genome blastn 170 303 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ct5tj9
13172726 13172726 PRJNA414225_P_NODE_71151_length_164_cov_0.886957_g71064_i0 PRJNA414225 71151 164 0.886957 1.45460948 Geobacillus phage vB_GthS_PK5.1 2985566 Viruses Viruses 213 5.94e-51   NTclustered gi|2320141253|gb|OP341628.1| 2985566 g71064 i0 90.184 1.99390243902439 163 16 99 0 1 163 6359 6197 Geobacillus phage vB_GthS_PK5.1, complete genome blastn 327 213 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Geobacillus phage vB_GthS_PK5.1
13172771 13172771 PRJNA414225_P_NODE_85331_length_162_cov_0.902655_g85244_i0 PRJNA414225 85331 162 0.902655 1.4623011 Caudoviricetes sp. 2832643 Viruses Viruses 294 2.03e-75   NTclustered gi|2914981140|gb|OR222104.1| 2832643 g85244 i0 99.383 3 162 1 100 0 1 162 323251 323412 MAG: Caudoviricetes sp. isolate MSP0003 genomic sequence blastn 486 294 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15110764 15110764 PRJNA414225_P_NODE_10532_length_208_cov_2.251572_g10445_i0 PRJNA414225 10532 208 2.251572 4.68326976 Viruses 10239 Viruses Viruses 58.4 3.92e-4   NTclustered gi|2232939703|gb|OM868076.1| 2928847 g10445 i0 94.595 0.355769230769231 37 2 18 0 1 37 24776 24812 Synechococcus phage Yong-M3-232, complete genome blastn 74 58.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Synechococcus phage Yong-M3-232
15110872 15110872 PRJNA414225_P_NODE_47272_length_167_cov_1.644068_g47185_i0 PRJNA414225 47272 167 1.644068 2.74559356 Viruses 10239 Viruses Viruses 248 1.66e-61   NTclustered gi|2294106312|gb|OP073255.1| 38018 g47185 i0 93.413 63.497005988024 167 11 100 0 1 167 772 938 MAG: Bacteriophage sp. isolate 0467_37095, partial genome blastn 10604 248 1 Viruses               Bacteriophage sp.
15721579 15721579 PRJNA414225_P_NODE_43033_length_169_cov_2.491667_g42946_i0 PRJNA414225 43033 169 2.491667 4.21091723 Caudoviricetes sp. 2832643 Viruses Viruses 239 1.01e-58   NTclustered gi|2052231209|tpg|BK056717.1| 2832643 g42946 i0 92.262 0.994082840236686 168 13 99 0 1 168 12035 12202 MAG TPA_asm: Caudoviricetes sp. isolate ctN2L1, partial genome blastn 168 239 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15721588 15721588 PRJNA414225_P_NODE_47793_length_167_cov_0.864407_g47706_i0 PRJNA414225 47793 167 0.864407 1.44355969 Caudoviricetes sp. 2832643 Viruses Viruses 303 3.5e-78   NTclustered gi|2053063332|tpg|BK024691.1| 2832643 g47706 i0 99.401 12 167 1 100 0 1 167 59216 59382 MAG TPA_asm: Caudoviricetes sp. isolate ctPDS2, partial genome blastn 2004 303 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16385650 16385650 PRJNA414225_P_NODE_80393_length_163_cov_0.894737_g80306_i0 PRJNA414225 80393 163 0.894737 1.45842131 Dongdastvirus 2842653 Viruses Viruses 141 2.82e-29   NTclustered gi|2046356339|ref|NC_054967.1| 2591039 g80306 i0 83.784 7.11656441717791 148 24 91 0 8 155 30448 30595 Achromobacter phage vB_AxyP_19-32_Axy04, complete genome blastn 1160 141 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Dongdastvirus Dongdastvirus Axy04
16385663 16385663 PRJNA414225_P_NODE_87553_length_162_cov_0.902655_g87466_i0 PRJNA414225 87553 162 0.902655 1.4623011 Viruses 10239 Viruses Viruses 300 4.36e-77   NTclustered gi|1829641624|gb|MT121967.1| 2723241 g87466 i0 100 10.9074074074074 162 0 100 0 1 162 12420 12259 Pseudomonas phage SC_9_H1H8_2017 head-tail joining protein, capsid family protein, portal protein, terminase, endonuclease, primase, and nucleotide kinase genes, complete cds blastn 1767 300 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage SC_9_H1H8_2017
16996322 16996322 PRJNA414225_P_NODE_18754_length_188_cov_1.474820_g18667_i0 PRJNA414225 18754 188 1.47482 2.7726616 Caudoviricetes sp. 2832643 Viruses Viruses 259 8.84e-65   NTclustered gi|2054548793|tpg|BK048005.1| 2832643 g18667 i0 91.489 41.8244680851064 188 16 100 0 1 188 10825 10638 MAG TPA_asm: Caudoviricetes sp. isolate ct5Sd10, partial genome blastn 7863 259 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16996350 16996350 PRJNA414225_P_NODE_35054_length_175_cov_1.619048_g34967_i0 PRJNA414225 35054 175 1.619048 2.833334 Caudoviricetes sp. 2832643 Viruses Viruses 307 2.8500000000000004e-79   NTclustered gi|2054694536|tpg|BK052869.1| 2832643 g34967 i0 98.286 1 175 3 100 0 1 175 15671 15497 MAG TPA_asm: Caudoviricetes sp. isolate ct7qV16, partial genome blastn 175 307 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16996355 16996355 PRJNA414225_P_NODE_35954_length_174_cov_1.640000_g35867_i0 PRJNA414225 35954 174 1.64 2.8536 Sepunavirus SEP1 1980930 Viruses Viruses 320 3.63e-83   NTclustered gi|1631923064|ref|NC_041928.1| 1340769 g35867 i0 100 13.4022988505747 173 0 99 0 2 174 1704 1532 Staphylococcus phage phiIBB-SEP1, complete genome blastn 2332 320 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae Sepunavirus Sepunavirus SEP1
18270620 18270620 PRJNA414225_P_NODE_76895_length_163_cov_1.473684_g76808_i0 PRJNA414225 76895 163 1.473684 2.40210492 Caudoviricetes sp. 2832643 Viruses Viruses 165 1.67e-36   NTclustered gi|2674493876|gb|PP079099.1| 2832643 g76808 i0 85.443 0.969325153374233 158 23 97 0 1 158 3429 3272 MAG: Caudoviricetes sp. isolate NYMAG-44 genomic sequence blastn 158 165 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19544672 19544672 PRJNA414225_P_NODE_10916_length_207_cov_0.974684_g10829_i0 PRJNA414225 10916 207 0.974684 2.01759588 Caudoviricetes sp. 2832643 Viruses Viruses 73.1 1.39e-8   NTclustered gi|2914946540|gb|OR221836.1| 2832643 g10829 i0 93.75 0.714975845410628 48 3 23 0 159 206 37770 37723 MAG: Caudoviricetes sp. isolate MSP1174 genomic sequence blastn 148 73.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19544762 19544762 PRJNA414225_P_NODE_55376_length_166_cov_0.871795_g55289_i0 PRJNA414225 55376 166 0.871795 1.4471797 Caudoviricetes sp. 2832643 Viruses Viruses 296 5.82e-76   NTclustered gi|2052231209|tpg|BK056717.1| 2832643 g55289 i0 98.795 2.80120481927711 166 2 100 0 1 166 14852 14687 MAG TPA_asm: Caudoviricetes sp. isolate ctN2L1, partial genome blastn 465 296 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20209424 20209424 PRJNA414225_P_NODE_81236_length_163_cov_0.894737_g81149_i0 PRJNA414225 81236 163 0.894737 1.45842131 Viruses 10239 Viruses Viruses 263 5.77e-66   NTclustered gi|2052880678|tpg|BK032813.1| 2827834 g81149 i0 95.706 2.92024539877301 163 7 100 0 1 163 32940 32778 MAG TPA_asm: Siphoviridae sp. ctJ0s2, partial genome blastn 476 263 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctJ0s2
20820650 20820650 PRJNA414225_P_NODE_5297_length_240_cov_1.445026_g5210_i0 PRJNA414225 5297 240 1.445026 3.4680624 Caudoviricetes sp. 2832643 Viruses Viruses 366 6.79e-97   NTclustered gi|2914946540|gb|OR221836.1| 2832643 g5210 i0 94.167 3.75 240 14 100 0 1 240 35957 35718 MAG: Caudoviricetes sp. isolate MSP1174 genomic sequence blastn 900 366 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20820721 20820721 PRJNA414225_P_NODE_77877_length_163_cov_0.894737_g77790_i0 PRJNA414225 77877 163 0.894737 1.45842131 Caudoviricetes sp. 2832643 Viruses Viruses 302 1.22e-77   NTclustered gi|2914885054|gb|OR222362.1| 2832643 g77790 i0 100 1 163 0 100 0 1 163 49930 49768 MAG: Caudoviricetes sp. isolate MSP1043 genomic sequence blastn 163 302 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
22095346 22095346 PRJNA414225_P_NODE_43318_length_169_cov_1.700000_g43231_i0 PRJNA414225 43318 169 1.7 2.873 Caudoviricetes sp. 2832643 Viruses Viruses 268 1.29e-67   NTclustered gi|2059789084|tpg|BK039506.1| 2832643 g43231 i0 95.266 1 169 8 100 0 1 169 43714 43882 MAG TPA_asm: Caudoviricetes sp. isolate ctCfj1, partial genome blastn 169 268 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23370967 23370967 PRJNA414225_P_NODE_20599_length_187_cov_1.398551_g20512_i0 PRJNA414225 20599 187 1.398551 2.61529037 Caudoviricetes sp. 2832643 Viruses Viruses 324 3.07e-84   NTclustered gi|2058021528|tpg|BK041953.1| 2832643 g20512 i0 97.861 99.7967914438503 187 4 100 0 1 187 8257 8443 MAG TPA_asm: Caudoviricetes sp. isolate ctMw21, partial genome blastn 18662 324 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24645385 24645385 PRJNA414225_P_NODE_69760_length_164_cov_1.417391_g69673_i0 PRJNA414225 69760 164 1.417391 2.32452124 Caudoviricetes sp. 2832643 Viruses Viruses 248 1.63e-61   NTclustered gi|2057061261|tpg|BK037514.1| 2832643 g69673 i0 94.41 2.98170731707317 161 9 98 0 1 161 34940 35100 MAG TPA_asm: Caudoviricetes sp. isolate ctSWe3, partial genome blastn 489 248 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24645431 24645431 PRJNA414225_P_NODE_90660_length_156_cov_2.850467_g90573_i0 PRJNA414225 90660 156 2.850467 4.44672852 Caudoviricetes sp. 2832643 Viruses Viruses 289 9e-74   NTclustered gi|2915021126|gb|OR222571.1| 2832643 g90573 i0 100 1 156 0 100 0 1 156 24382 24537 MAG: Caudoviricetes sp. isolate MSP0360 genomic sequence blastn 156 289 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24645434 24645434 PRJNA414225_P_NODE_9680_length_212_cov_1.570552_g9593_i0 PRJNA414225 9680 212 1.570552 3.32957024 Phietavirus pv88 320848 Viruses Viruses 392 9.67e-105   NTclustered gi|66396333|ref|NC_007063.1| 2908115 g9593 i0 100 134.849056603774 212 0 100 0 1 212 23054 22843 Staphylococcus phage 88, complete genome blastn 28588 392 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Phietavirus Phietavirus pv88
25309244 25309244 PRJNA414225_P_NODE_28980_length_180_cov_1.251908_g28893_i0 PRJNA414225 28980 180 1.251908 2.2534344 Ourmiavirus 186783 Viruses Viruses 279 6.43e-71   NTclustered gi|2819080653|gb|PQ150633.1| 3371276 g28893 i0 94.944 18.1388888888889 178 9 99 0 1 178 1030 1207 MAG: Hebei ourmiavirus 2 isolate Beijing_119 genomic sequence blastn 3265 279 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Hebei ourmiavirus 2

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