RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA438687" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA438687 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
1091246 1091246 PRJNA438687_S_NODE_7441_length_159_cov_1.282258_g7351_i0 PRJNA438687 7441 159 1.282258 2.03879022 Pahexavirus 1982251 Viruses Viruses 283 4.29e-72   NTclustered gi|844398545|ref|NC_027294.1| 1500822 g7351 i0 98.742 99.685534591195 159 2 100 0 1 159 855 1013 Propionibacterium phage PHL150M00, complete genome blastn 15850 283 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus PHL308M00
1710187 1710187 PRJNA438687_S_NODE_4462_length_210_cov_6.902857_g4372_i0 PRJNA438687 4462 210 6.902857 14.4959997 Caudoviricetes sp. 2832643 Viruses Viruses 307 3.5600000000000005e-79   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g4372 i0 94.924 340.852380952381 197 9 93 1 1 196 18223 18419 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 71579 307 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
1710193 1710193 PRJNA438687_S_NODE_4782_length_203_cov_2.261905_g4692_i0 PRJNA438687 4782 203 2.261905 4.59166715 Pahexavirus PHL025M00 1982274 Viruses Viruses 337 4.3599999999999994e-88   NTclustered gi|849253308|ref|NC_027357.1| 1500799 g4692 i0 96.552 99.192118226601 203 7 100 0 1 203 10895 11097 Propionibacterium phage PHL025M00, complete genome blastn 20136 337 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus PHL025M00
8088477 8088477 PRJNA438687_S_NODE_2347_length_289_cov_1.889764_g2257_i0 PRJNA438687 2347 289 1.889764 5.46141796 Pahexavirus PHL112N00 1982285 Viruses Viruses 375 1.4e-99   NTclustered gi|543171262|ref|NC_022334.1| 1235654 g2257 i0 90.034 57.8754325259516 291 27 100 2 1 289 27215 26925 Propionibacterium phage PHL112N00, complete genome blastn 16726 375 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus PHL112N00
8088554 8088554 PRJNA438687_S_NODE_5647_length_186_cov_1.536424_g5557_i0 PRJNA438687 5647 186 1.536424 2.85774864 Klebsiella phage vB_KppS-Pokey 2762811 Viruses Viruses 339 1.0899999999999998e-88   NTclustered gi|1973740280|emb|LR881077.1| 2762811 g5557 i0 99.462 4.67204301075269 186 1 100 0 1 186 797 982 Klebsiella phage vB_KppS-Pokey genome assembly, chromosome: 1 blastn 869 339 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Klebsiella phage vB_KppS-Pokey
8088590 8088590 PRJNA438687_S_NODE_7767_length_155_cov_2.041667_g7677_i0 PRJNA438687 7767 155 2.041667 3.16458385 Moovirus moo 3060392 Viruses Viruses 237 3.2800000000000004e-58   NTclustered gi|2438080420|ref|NC_070850.1| 2886042 g7677 i0 94.194 1 155 9 100 0 1 155 53708 53862 Shigella virus Moo19, complete genome blastn 155 237 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
9363377 9363377 PRJNA438687_S_NODE_6468_length_172_cov_1.635036_g6378_i0 PRJNA438687 6468 172 1.635036 2.81226192 Klebsiella phage vB_Kpn_K9PH25C2 3071639 Viruses Viruses 246 6.17e-61   NTclustered gi|2635612894|emb|OY979394.1| 3071639 g6378 i0 92.899 2.88953488372093 169 12 98 0 4 172 29285 29117 Klebsiella phage vB_Kpn_K9PH25C2 genome assembly, chromosome: K9PH25C2_assembly blastn 497 246 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Klebsiella phage vB_Kpn_K9PH25C2
12569983 12569983 PRJNA438687_S_NODE_1890_length_312_cov_2.660650_g1800_i0 PRJNA438687 1890 312 2.66065 8.301228 Pahexavirus 1982251 Viruses Viruses 534 2.3799999999999995e-147   NTclustered gi|849122411|ref|NC_027400.1| 1500802 g1800 i0 97.742 99.0224358974359 310 7 99 0 1 310 25048 24739 Propionibacterium phage PHL055N00, complete genome blastn 30895 534 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus PHL117M00
13188992 13188992 PRJNA438687_S_NODE_4111_length_219_cov_1.804348_g4021_i0 PRJNA438687 4111 219 1.804348 3.95152212 Pahexavirus mrAK 1982258 Viruses Viruses 311 2.9000000000000004e-80   NTclustered gi|906475691|ref|NC_027620.1| 1655016 g4021 i0 92.308 96.1232876712329 221 13 100 4 1 219 27637 27419 Propionibacterium phage MrAK, complete genome blastn 21051 311 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus mrAK
13189027 13189027 PRJNA438687_S_NODE_5531_length_188_cov_1.039216_g5441_i0 PRJNA438687 5531 188 1.039216 1.95372608 Pahexavirus P100D 1982266 Viruses Viruses 326 8.6e-85   NTclustered gi|408905847|ref|NC_018852.1| 1229789 g5441 i0 97.872 99.3670212765958 188 4 100 0 1 188 19083 19270 Propionibacterium phage P100D, complete genome blastn 18681 326 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus P100D
15738033 15738033 PRJNA438687_S_NODE_7113_length_163_cov_2.304688_g7023_i0 PRJNA438687 7113 163 2.304688 3.75664144 Caudoviricetes sp. 2832643 Viruses Viruses 279 5.73e-71   NTclustered gi|2054743127|tpg|BK043269.1| 2832643 g7023 i0 97.546 95.8343558282209 163 4 100 0 1 163 18068 17906 MAG TPA_asm: Caudoviricetes sp. isolate ctnkm1, partial genome blastn 15621 279 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
21493004 21493004 PRJNA438687_S_NODE_2297_length_291_cov_3.160156_g2207_i0 PRJNA438687 2297 291 3.160156 9.19605396 Pahexavirus 1982251 Viruses Viruses 455 1.7600000000000003e-123   NTclustered gi|330858398|ref|NC_015454.1| 504501 g2207 i0 94.845 97.6048109965636 291 15 100 0 1 291 19406 19116 Propionibacterium phage PAD20 endogenous virus, complete genome blastn 28403 455 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus PAD20

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