RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA1151638" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 14 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA1151638 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
2852963 2852963 PRJNA1151638_P_NODE_6403_length_243_cov_2.752941_g6336_i0 PRJNA1151638 6403 243 2.752941 6.68964663 Caudoviricetes sp. 2832643 Viruses Viruses 267 7.19e-67   NTclustered gi|2054683533|tpg|BK052657.1| 2832643 g6336 i0 90.594 3.08230452674897 202 17 83 2 34 234 3207 3407 MAG TPA_asm: Caudoviricetes sp. isolate ctIBL2, partial genome blastn 749 267 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
5405127 5405127 PRJNA1151638_P_NODE_7125_length_227_cov_2.766234_g7058_i0 PRJNA1151638 7125 227 2.766234 6.27935118 Actinobacteria phage HS02 3056388 Viruses Viruses 374 3.8e-99   NTclustered gi|2559889243|gb|OQ890312.1| 3056388 g7058 i0 96.46 0.995594713656388 226 8 99 0 1 226 25196 24971 MAG: Actinobacteria phage HS02, partial genome blastn 226 374 1 Viruses               Actinobacteria phage HS02
6679815 6679815 PRJNA1151638_P_NODE_4266_length_262_cov_1.650794_g4199_i0 PRJNA1151638 4266 262 1.650794 4.32508028 Caudoviricetes sp. 2832643 Viruses Viruses 435 2.0300000000000003e-117   NTclustered gi|2057046998|tpg|BK049396.1| 2832643 g4199 i0 96.565 5.01526717557252 262 9 100 0 1 262 11059 11320 MAG TPA_asm: Caudoviricetes sp. isolate ctSSL1, partial genome blastn 1314 435 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9229897 9229897 PRJNA1151638_P_NODE_2328_length_321_cov_2.475806_g2261_i0 PRJNA1151638 2328 321 2.475806 7.94733726 Caudoviricetes sp. 2832643 Viruses Viruses 488 1.9399999999999996e-133   NTclustered gi|2914750556|gb|OR221279.1| 2832643 g2261 i0 94.081 10.3738317757009 321 19 100 0 1 321 30208 30528 MAG: Caudoviricetes sp. isolate MSP1829 genomic sequence blastn 3330 488 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9229947 9229947 PRJNA1151638_P_NODE_4408_length_259_cov_1.494624_g4341_i0 PRJNA1151638 4408 259 1.494624 3.87107616 Caudoviricetes sp. 2832643 Viruses Viruses 315 2.72e-81   NTclustered gi|2054454799|tpg|BK031399.1| 2832643 g4341 i0 88.603 7.74517374517375 272 14 99 9 2 259 1735 1467 MAG TPA_asm: Caudoviricetes sp. isolate ct2dy1, partial genome blastn 2006 315 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13055586 13055586 PRJNA1151638_P_NODE_3331_length_284_cov_1.478673_g3264_i0 PRJNA1151638 3331 284 1.478673 4.19943132 Caudoviricetes sp. 2832643 Viruses Viruses 255 1.86e-63   NTclustered gi|2053090150|tpg|BK020282.1| 2832643 g3264 i0 96.732 1.54929577464789 153 5 54 0 1 153 41839 41991 MAG TPA_asm: Caudoviricetes sp. isolate ct1BD1, partial genome blastn 440 255 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14330927 14330927 PRJNA1151638_P_NODE_3552_length_278_cov_1.521951_g3485_i0 PRJNA1151638 3552 278 1.521951 4.23102378 Pahexavirus P100D 1982266 Viruses Viruses 481 2.75e-131   NTclustered gi|408905847|ref|NC_018852.1| 1229789 g3485 i0 97.842 99.9748201438849 278 6 100 0 1 278 27696 27973 Propionibacterium phage P100D, complete genome blastn 27793 481 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus P100D
15604762 15604762 PRJNA1151638_P_NODE_3373_length_283_cov_1.485714_g3306_i0 PRJNA1151638 3373 283 1.485714 4.20457062 Caudoviricetes sp. 2832643 Viruses Viruses 320 6.48e-83   NTclustered gi|2053090150|tpg|BK020282.1| 2832643 g3306 i0 87.636 4.80918727915194 275 34 97 0 9 283 17696 17422 MAG TPA_asm: Caudoviricetes sp. isolate ct1BD1, partial genome blastn 1361 320 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20703301 20703301 PRJNA1151638_P_NODE_1117_length_429_cov_7.443820_g1050_i0 PRJNA1151638 1117 429 7.44382 31.9339878 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.041   NTclustered gi|2054791230|tpg|BK049928.1| 2832643 g1050 i0 100 0.0652680652680653 28 0 7 0 375 402 1569 1596 MAG TPA_asm: Caudoviricetes sp. isolate ctwKx1, partial genome blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20703302 20703302 PRJNA1151638_P_NODE_1157_length_421_cov_2.152299_g1090_i0 PRJNA1151638 1157 421 2.152299 9.06117879 Sepunavirus SEP1 1980930 Viruses Viruses 235 3.75e-57   NTclustered gi|1631923064|ref|NC_041928.1| 1340769 g1090 i0 79.819 7.05225653206651 332 59 78 6 94 421 58338 58665 Staphylococcus phage phiIBB-SEP1, complete genome blastn 2969 235 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae Sepunavirus Sepunavirus SEP1
21978857 21978857 PRJNA1151638_P_NODE_6778_length_242_cov_0.923077_g6711_i0 PRJNA1151638 6778 242 0.923077 2.23384634 Corynebacterium phage HS03 3056390 Viruses Viruses 292 1.18e-74   NTclustered gi|2559889330|gb|OQ890313.1| 3056390 g6711 i0 89.03 13.1694214876033 237 25 98 1 5 240 30861 30625 MAG: Corynebacterium phage HS03, partial genome blastn 3187 292 1 Viruses               Corynebacterium phage HS03
23254247 23254247 PRJNA1151638_P_NODE_4779_length_253_cov_0.866667_g4712_i0 PRJNA1151638 4779 253 0.866667 2.19266751 Zhangqianvirus IME1354 3060827 Viruses Viruses 361 3.36e-95   NTclustered gi|2437990282|ref|NC_070727.1| 3070820 g4712 i0 95.556 9.4703557312253 225 10 89 0 29 253 42273 42049 Staphylococcus phage IME1354_01, complete genome blastn 2396 361 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Zhangqianvirus Zhangqianvirus IME1354
23989220 23989220 PRJNA1151638_P_NODE_6419_length_243_cov_1.952941_g6352_i0 PRJNA1151638 6419 243 1.952941 4.74564663 root 1 Root_unresolved Root_unresolved 342 1.16e-89   NTclustered gi|2054683533|tpg|BK052657.1| 2832643 g6352 i0 92.887 9.51028806584362 239 12 98 4 5 243 4341 4574 MAG TPA_asm: Caudoviricetes sp. isolate ctIBL2, partial genome blastn 2311 342 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24527980 24527980 PRJNA1151638_P_NODE_6920_length_236_cov_2.325153_g6853_i0 PRJNA1151638 6920 236 2.325153 5.48736108 Caudoviricetes sp. 2832643 Viruses Viruses 303 5.29e-78   NTclustered gi|2057123275|tpg|BK057999.1| 2832643 g6853 i0 89.831 4.46610169491525 236 24 100 0 1 236 817 1052 MAG TPA_asm: Caudoviricetes sp. isolate ctSjB4, partial genome blastn 1054 303 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.

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