RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA293022" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA293022 · 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
373412 373412 PRJNA293022_P_NODE_72861_length_166_cov_0.888889_g72124_i0 PRJNA293022 72861 166 0.888889 1.47555574 Caudoviricetes sp. 2832643 Viruses Viruses 303 3.48e-78   NTclustered gi|2914852811|gb|OR221766.1| 2832643 g72124 i0 100 1.22289156626506 164 0 99 0 1 164 11259 11422 MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence blastn 203 303 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
4200590 4200590 PRJNA293022_P_NODE_73624_length_165_cov_1.086207_g72887_i0 PRJNA293022 73624 165 1.086207 1.79224155 Tidunavirus pTD1 2560834 Viruses Viruses 187 3.6199999999999985e-43   NTclustered gi|1631921414|ref|NC_041916.1| 1938577 g72887 i0 88.462 2.87272727272727 156 16 94 2 2 156 69530 69684 Vibrio phage pTD1 DNA, complete genome blastn 474 187 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Tidunavirus Tidunavirus pTD1
6162449 6162449 PRJNA293022_P_NODE_18065_length_336_cov_1.679443_g17328_i0 PRJNA293022 18065 336 1.679443 5.64292848 Tidunavirus 2560238 Viruses Viruses 385 2.75e-102   NTclustered gi|1631948363|ref|NC_042136.1| 1262540 g17328 i0 87.463 8.62202380952381 335 40 99 2 1 334 165862 165529 Vibrio phage VP4B, partial genome blastn 2897 385 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Tidunavirus Tidunavirus VP4B
6750915 6750915 PRJNA293022_P_NODE_31926_length_248_cov_1.040201_g31189_i0 PRJNA293022 31926 248 1.040201 2.57969848 Siphoviridae sp. ctHip2 2827830 Viruses Viruses 390 4.1799999999999996e-104   NTclustered gi|2052861377|tpg|BK032497.1| 2827830 g31189 i0 95.142 3.79435483870968 247 12 99 0 2 248 311904 312150 MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome blastn 941 390 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctHip2
6751120 6751120 PRJNA293022_P_NODE_74306_length_165_cov_0.896552_g73569_i0 PRJNA293022 74306 165 0.896552 1.4793108 Caudoviricetes sp. 2832643 Viruses Viruses 250 4.5599999999999996e-62   NTclustered gi|2057086288|tpg|BK038025.1| 2832643 g73569 i0 94.444 10.7272727272727 162 9 98 0 2 163 42703 42542 MAG TPA_asm: Caudoviricetes sp. isolate ctQrY3, partial genome blastn 1770 250 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10577436 10577436 PRJNA293022_P_NODE_79189_length_162_cov_0.920354_g78452_i0 PRJNA293022 79189 162 0.920354 1.49097348 Cronobacter phage CR5 1195085 Viruses Viruses 102 1.32e-17   NTclustered gi|398256204|gb|JX094500.1| 1195085 g78452 i0 82.609 1.41975308641975 115 20 71 0 46 160 67963 67849 Cronobacter phage CR5, complete genome blastn 230 102 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Derbicusvirus Cronobacter phage CR5
11852099 11852099 PRJNA293022_P_NODE_74570_length_164_cov_25.113043_g73833_i0 PRJNA293022 74570 164 25.113043 41.18539052 Pseudomonas phage sp. 30-3 2972143 Viruses Viruses 106 1.04e-18   NTclustered gi|2296132097|dbj|LC727698.1| 2972143 g73833 i0 95.455 32.3963414634146 66 3 40 0 63 128 239382 239317 Pseudomonas phage sp. 30-3 phi30-3 DNA, complete genome blastn 5313 106 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Arenbergviridae Wroclawvirus Pseudomonas phage sp. 30-3
15676074 15676074 PRJNA293022_P_NODE_48633_length_200_cov_1.364238_g47896_i0 PRJNA293022 48633 200 1.364238 2.728476 Caudoviricetes sp. 2832643 Viruses Viruses 54.7 0.005   NTclustered gi|2059671301|tpg|BK029109.1| 2832643 g47896 i0 100 0.29 29 0 15 0 171 199 37165 37137 MAG TPA_asm: Caudoviricetes sp. isolate cta8D2, partial genome blastn 58 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15676167 15676167 PRJNA293022_P_NODE_70333_length_167_cov_1.288136_g69596_i0 PRJNA293022 70333 167 1.288136 2.15118712 Caudoviricetes sp. 2832643 Viruses Viruses 278 2.12e-70   NTclustered gi|2915011501|gb|OR222465.1| 2832643 g69596 i0 96.97 16.6407185628743 165 5 99 0 3 167 34828 34664 MAG: Caudoviricetes sp. isolate MSP0923 genomic sequence blastn 2779 278 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16950667 16950667 PRJNA293022_P_NODE_39874_length_221_cov_1.569767_g39137_i0 PRJNA293022 39874 221 1.569767 3.46918507 Caudoviricetes sp. 2832643 Viruses Viruses 54.7 0.005   NTclustered gi|2057140260|tpg|BK058296.1| 2832643 g39137 i0 100 0.131221719457014 29 0 13 0 165 193 6143 6115 MAG TPA_asm: Caudoviricetes sp. isolate ctGYu3, partial genome blastn 29 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16950850 16950850 PRJNA293022_P_NODE_77714_length_163_cov_0.912281_g76977_i0 PRJNA293022 77714 163 0.912281 1.48701803 Siphoviridae sp. ctHip2 2827830 Viruses Viruses 189 9.92e-44   NTclustered gi|2052861377|tpg|BK032497.1| 2827830 g76977 i0 89.333 2.77300613496933 150 16 92 0 1 150 114575 114426 MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome blastn 452 189 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctHip2
18225129 18225129 PRJNA293022_P_NODE_72715_length_166_cov_0.888889_g71978_i0 PRJNA293022 72715 166 0.888889 1.47555574 Caudoviricetes sp. 2832643 Viruses Viruses 259 7.63e-65   NTclustered gi|2059921881|tpg|BK041626.1| 2832643 g71978 i0 95.122 2.96385542168675 164 8 99 0 1 164 31407 31570 MAG TPA_asm: Caudoviricetes sp. isolate ctaeZ3, partial genome blastn 492 259 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
22049666 22049666 PRJNA293022_P_NODE_29218_length_260_cov_2.232227_g28481_i0 PRJNA293022 29218 260 2.232227 5.8037902 Caudoviricetes sp. 2832643 Viruses Viruses 361 3.469999999999999e-95   NTclustered gi|2052998103|tpg|BK030969.1| 2832643 g28481 i0 92.157 470.961538461538 255 20 98 0 6 260 295 41 MAG TPA_asm: Caudoviricetes sp. isolate ctdoP9, partial genome blastn 122450 361 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24599500 24599500 PRJNA293022_P_NODE_67920_length_169_cov_0.866667_g67183_i0 PRJNA293022 67920 169 0.866667 1.46466723 Caudoviricetes sp. 2832643 Viruses Viruses 305 9.81e-79   NTclustered gi|2914826188|gb|OR222292.1| 2832643 g67183 i0 99.405 27.8461538461538 168 1 99 0 1 168 25260 25427 MAG: Caudoviricetes sp. isolate MSP0674 genomic sequence blastn 4706 305 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);;