RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA1098727" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1098727 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
26647251 26647251 PRJNA1098727_P_NODE_4621_length_302_cov_1.588933_g4380_i0 PRJNA1098727 4621 302 1.588933 4.79857766 Kyanoviridae 2946160 Viruses Viruses 160 1.13e-47   NR YP_004322269.1 444860 g4380 i0 76.8 3.93377483443709 99 23 98.3 0 300 4 53 151 YP_004322269.1 tail tube [Synechococcus phage S-SM2] diamond 1188 161 0.993788819875776 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae Nilusvirus Nilusvirus ssm2
26750739 26750739 PRJNA1098727_P_NODE_9961_length_192_cov_1.447552_g9720_i0 PRJNA1098727 9961 192 1.447552 2.77929984 Cyanophage S-RIM4 2530169 Viruses Viruses 45.4 1.63e-4   NR QBQ74963.1 2530169 g9720 i0 60 0.625 40 13 57.8 1 131 21 1 40 QBQ74963.1 hypothetical protein RW110999_085 [Cyanophage S-RIM4] diamond 120 45.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae Shandvirus Cyanophage S-RIM4
27288881 27288881 PRJNA1098727_P_NODE_8283_length_214_cov_1.078788_g8042_i0 PRJNA1098727 8283 214 1.078788 2.30860632 uncultured Mediterranean phage uvMED 1407671 Viruses Viruses 60.5 3.9e-9   NR BAR35611.1 1407671 g8042 i0 80.6 0.869158878504673 31 6 43.5 0 2 94 152 182 BAR35611.1 hypothetical protein [uncultured Mediterranean phage uvMED] diamond 186 60.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       uncultured Mediterranean phage uvMED
27415564 27415564 PRJNA1098727_P_NODE_583_length_921_cov_2.019495_g431_i0 PRJNA1098727 583 921 2.019495 18.59954895 Caudoviricetes sp. 2832643 Viruses Viruses 250 2.74e-80   NR XOS40784.1 2832643 g431 i0 78.1 0.47557003257329 146 32 47.6 0 739 302 1 146 XOS40784.1 MAG: hypothetical protein MSP1018_34 [Caudoviricetes sp.] diamond 438 250 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27510140 27510140 PRJNA1098727_P_NODE_12263_length_172_cov_1.260163_g12022_i0 PRJNA1098727 12263 172 1.260163 2.16748036 Synechococcus phage S-SM2 444860 Viruses Viruses 49.7 5.18e-5   NR YP_004322187.1 444860 g12022 i0 51.6 1.08139534883721 62 24 97.7 3 169 2 140 201 YP_004322187.1 hypothetical protein SSM2_031 [Synechococcus phage S-SM2] diamond 186 49.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae Nilusvirus Nilusvirus ssm2
27636457 27636457 PRJNA1098727_P_NODE_6304_length_250_cov_1.422886_g6063_i0 PRJNA1098727 6304 250 1.422886 3.557215 Caudoviricetes sp. 2832643 Viruses Viruses 58.9 8.28e-8   NR XOS40776.1 2832643 g6063 i0 44.4 0.972 81 41 97.2 2 247 5 334 410 XOS40776.1 MAG: tail protein [Caudoviricetes sp.] diamond 243 58.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28101131 28101131 PRJNA1098727_P_NODE_12365_length_171_cov_1.688525_g12124_i0 PRJNA1098727 12365 171 1.688525 2.88737775 root 1 Root_unresolved Root_unresolved 76.6 1.63e-14   NR YP_004322253.1 444860 g12124 i0 55.4 1.96491228070175 56 25 98.2 0 168 1 2750 2805 YP_004322253.1 baseplate wedge subunit [Synechococcus phage S-SM2] diamond 336 76.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae Nilusvirus Nilusvirus ssm2
28520482 28520482 PRJNA1098727_P_NODE_5707_length_265_cov_1.430556_g5466_i0 PRJNA1098727 5707 265 1.430556 3.7909734 Synechococcus phage Bellamy 2023996 Viruses Viruses 129 1.77e-32   NR YP_009791270.1 2023996 g5466 i0 71.3 1.96981132075472 87 25 98.5 0 263 3 2336 2422 YP_009791270.1 structural protein [Synechococcus phage Bellamy] diamond 522 129 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae Bellamyvirus Bellamyvirus bellamy
28615195 28615195 PRJNA1098727_P_NODE_7947_length_219_cov_1.217647_g7706_i0 PRJNA1098727 7947 219 1.217647 2.66664693 Cyanophage S-TIM54 1137744 Viruses Viruses 84 8.23e-17   NR UYE97294.1 1137744 g7706 i0 58.8 0.931506849315068 68 27 91.8 1 13 213 40 107 UYE97294.1 TerL [Cyanophage S-TIM54] diamond 204 84 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Aurunvirus Cyanophage S-TIM54
29783298 29783298 PRJNA1098727_P_NODE_12071_length_173_cov_2.088710_g11830_i0 PRJNA1098727 12071 173 2.08871 3.6134683 Synechococcus phage S-CBM2 351708 Viruses Viruses 43.5 7.79e-4   NR AFK66355.1 351708 g11830 i0 56.7 0.520231213872832 30 11 52 1 10 99 26 53 AFK66355.1 hypothetical protein SWPG_00106 [Synechococcus phage S-CBM2] diamond 90 43.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae   Synechococcus phage S-CBM2
29932786 29932786 PRJNA1098727_P_NODE_14851_length_164_cov_0.904348_g14610_i0 PRJNA1098727 14851 164 0.904348 1.48313072 Viruses 10239 Viruses Viruses 41.2 0.00763   NR XOF02459.1 2832643 g14610 i0 44 1.71951219512195 50 26 91.5 1 162 13 9 56 XOF02459.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 282 41.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30004556 30004556 PRJNA1098727_P_NODE_9271_length_200_cov_1.317881_g9030_i0 PRJNA1098727 9271 200 1.317881 2.635762 uncultured Mediterranean phage uvMED 1407671 Viruses Viruses 47.4 5.44e-5   NR BAR35617.1 1407671 g9030 i0 33.3 0.9 60 40 90 0 192 13 20 79 BAR35617.1 hypothetical protein [uncultured Mediterranean phage uvMED] diamond 180 47.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       uncultured Mediterranean phage uvMED
30099086 30099086 PRJNA1098727_P_NODE_15672_length_162_cov_0.920354_g15431_i0 PRJNA1098727 15672 162 0.920354 1.49097348 uncultured Caudovirales phage 2100421 Viruses Viruses 43.1 0.00935   NR CAB4125381.1 2100421 g15431 i0 42.9 0.907407407407407 49 27 90.7 1 162 16 296 343 CAB4125381.1 hypothetical protein UFOVP54_125 [uncultured Caudovirales phage] diamond 147 43.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30320953 30320953 PRJNA1098727_P_NODE_9792_length_194_cov_1.420690_g9551_i0 PRJNA1098727 9792 194 1.42069 2.7561386 Synechococcus phage S-SKS1 754042 Viruses Viruses 76.3 2.53e-15   NR YP_007674455.1 754042 g9551 i0 62.5 0.989690721649485 64 24 99 0 3 194 18 81 YP_007674455.1 hypothetical protein SWZG_00090 [Synechococcus phage S-SKS1] diamond 192 76.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Llyrvirus Llyrvirus SSKS1
30699447 30699447 PRJNA1098727_P_NODE_8434_length_212_cov_1.263804_g8193_i0 PRJNA1098727 8434 212 1.263804 2.67926448 uncultured Caudovirales phage 2100421 Viruses Viruses 84.3 2.71e-19   NR CAB4161716.1 2100421 g8193 i0 67.3 0.778301886792453 55 18 77.8 0 167 3 1 55 CAB4161716.1 hypothetical protein UFOVP788_19 [uncultured Caudovirales phage] diamond 165 84.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30731116 30731116 PRJNA1098727_P_NODE_3634_length_349_cov_1.023333_g3393_i0 PRJNA1098727 3634 349 1.023333 3.57143217 Prochlorococcus phage P-TIM68 1542477 Viruses Viruses 55.8 3.3e-6   NR YP_009213671.1 1542477 g3393 i0 46.3 1.31518624641834 82 38 70.5 2 249 4 813 888 YP_009213671.1 hypothetical protein AVU42_gp159 [Prochlorococcus phage P-TIM68] diamond 459 55.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae Haifavirus Haifavirus tim68
31489990 31489990 PRJNA1098727_P_NODE_12896_length_169_cov_0.866667_g12655_i0 PRJNA1098727 12896 169 0.866667 1.46466723 Synechococcus phage S-SCSM1 2588487 Viruses Viruses 105 1.0999999999999998e-24   NR YP_010669918.1 2588487 g12655 i0 89.1 0.976331360946746 55 6 97.6 0 166 2 124 178 YP_010669918.1 tail fiber protein [Synechococcus phage S-SCSM1] diamond 165 105 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae Zhoulongquanvirus Zhoulongquanvirus esscess
31576055 31576055 PRJNA1098727_P_NODE_11036_length_182_cov_1.548872_g10795_i0 PRJNA1098727 11036 182 1.548872 2.81894704 root 1 Root_unresolved Root_unresolved 75.9 3.38e-14   NR YP_009325156.1 1815521 g10795 i0 71.7 1.97802197802198 60 17 98.9 0 181 2 159 218 YP_009325156.1 hypothetical protein BOW92_gp077 [Synechococcus phage S-WAM1] diamond 360 76.3 0.99475753604194 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae Sokavirus Sokavirus swam1
31647702 31647702 PRJNA1098727_P_NODE_14957_length_164_cov_0.904348_g14716_i0 PRJNA1098727 14957 164 0.904348 1.48313072 uncultured Caudovirales phage 2100421 Viruses Viruses 41.2 0.0457   NR CAB4140739.1 2100421 g14716 i0 51.4 0.640243902439024 35 17 64 0 110 6 108 142 CAB4140739.1 hypothetical protein UFOVP395_74 [uncultured Caudovirales phage] diamond 105 41.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
31806041 31806041 PRJNA1098727_P_NODE_5417_length_274_cov_1.342222_g5176_i0 PRJNA1098727 5417 274 1.342222 3.67768828 Caudoviricetes sp. 2832643 Viruses Viruses 110 2.5100000000000004e-27   NR DAI75558.1 2832643 g5176 i0 62.2 0.897810218978102 82 30 88.7 1 4 246 73 154 DAI75558.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 246 110 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32050458 32050458 PRJNA1098727_P_NODE_6258_length_251_cov_1.024752_g6017_i0 PRJNA1098727 6258 251 1.024752 2.57212752 Bellamyvirus 2733096 Viruses Viruses 86.3 1.96e-17   NR BAR39891.1 1407671 g6017 i0 60.3 2.37848605577689 68 27 81.3 0 249 46 14 81 BAR39891.1 hypothetical protein [uncultured Mediterranean phage uvMED] diamond 597 86.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       uncultured Mediterranean phage uvMED
32817291 32817291 PRJNA1098727_P_NODE_2640_length_419_cov_2.689189_g2400_i0 PRJNA1098727 2640 419 2.689189 11.26770191 Caudoviricetes sp. 2832643 Viruses Viruses 80.5 2.11e-16   NR XOS40779.1 2832643 g2400 i0 56.9 0.41527446300716 58 23 41.5 1 243 416 1 56 XOS40779.1 MAG: hypothetical protein MSP1018_29 [Caudoviricetes sp.] diamond 174 80.5 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);;