RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1120586" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1120586 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
276426 276426 PRJNA1120586_P_NODE_5301_length_489_cov_2.864286_g5111_i0 PRJNA1120586 5301 489 2.864286 14.00635854 Caudoviricetes sp. 2832643 Viruses Viruses 159 4.69e-47   NR QHJ79797.1 2832643 g5111 i0 69 1.40490797546012 113 35 69.3 0 19 357 1 113 QHJ79797.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 687 159 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
1028417 1028417 PRJNA1120586_P_NODE_33181_length_251_cov_2.373626_g32990_i0 PRJNA1120586 33181 251 2.373626 5.95780126 Shigella virus Moo19 2886042 Viruses Viruses 112 3.2499999999999996e-30   NR YP_010657728.1 2886042 g32990 i0 81 0.693227091633466 58 11 69.3 0 1 174 37 94 YP_010657728.1 gp6 [Shigella virus Moo19] diamond 174 112 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
4102813 4102813 PRJNA1120586_P_NODE_15744_length_324_cov_2.392157_g15553_i0 PRJNA1120586 15744 324 2.392157 7.75058868 Salmonella phage PhiSTP1 2910785 Viruses Viruses 157 1.4599999999999998e-43   NR UNY50475.1 2910785 g15553 i0 76.6 2.97222222222222 107 18 99.1 1 322 2 289 388 UNY50475.1 hypothetical protein [Salmonella phage PhiSTP1] diamond 963 157 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae Cornellvirus Salmonella phage PhiSTP1
26753216 26753216 PRJNA1120586_P_NODE_24901_length_277_cov_2.509615_g24710_i0 PRJNA1120586 24901 277 2.509615 6.95163355 Caudoviricetes sp. 2832643 Viruses Viruses 148 8.23e-44   NR DAH52748.1 2832643 g24710 i0 76.9 0.985559566787004 91 21 98.6 0 277 5 24 114 DAH52748.1 MAG TPA: tail assembly chaperone [Caudoviricetes sp.] diamond 273 148 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26880425 26880425 PRJNA1120586_P_NODE_50241_length_227_cov_2.645570_g50050_i0 PRJNA1120586 50241 227 2.64557 6.0054439 Shigella phage vB_SboS_Gloob 2902746 Viruses Viruses 97.4 1.7e-21   NR UHS65013.1 2902746 g50050 i0 60 0.991189427312775 75 30 99.1 0 227 3 278 352 UHS65013.1 putative tail spike protein [Shigella phage vB_SboS_Gloob] diamond 225 97.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Ackermannviridae Agtrevirus Shigella phage vB_SboS_Gloob
27132902 27132902 PRJNA1120586_P_NODE_33602_length_250_cov_1.834254_g33411_i0 PRJNA1120586 33602 250 1.834254 4.585635 Shigella virus Moo19 2886042 Viruses Viruses 163 2.14e-50   NR YP_010657726.1 2886042 g33411 i0 88 0.996 83 10 99.6 0 250 2 6 88 YP_010657726.1 gp4 [Shigella virus Moo19] diamond 249 163 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
27733807 27733807 PRJNA1120586_P_NODE_11724_length_360_cov_2.865979_g11533_i0 PRJNA1120586 11724 360 2.865979 10.3175244 Caudoviricetes sp. 2832643 Viruses Viruses 72.4 7.38e-14   NR DAU29119.1 2832643 g11533 i0 48.8 0.7 84 32 66.7 4 360 121 15 91 DAU29119.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 252 72.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27733808 27733808 PRJNA1120586_P_NODE_41984_length_233_cov_2.317073_g41793_i0 PRJNA1120586 41984 233 2.317073 5.39878009 Hafnia phage TS33 3110108 Viruses Viruses 128 5.71e-33   NR WQY91229.1 3110108 g41793 i0 79.5 1.00429184549356 78 15 99.1 1 2 232 202 279 WQY91229.1 62kDa structural protein [Hafnia phage TS33] diamond 234 128 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
28112272 28112272 PRJNA1120586_P_NODE_5265_length_490_cov_3.125891_g5075_i0 PRJNA1120586 5265 490 3.125891 15.3168659 Hafnia phage TS33 3110108 Viruses Viruses 306 2.37e-97   NR WQY91228.1 3110108 g5075 i0 88.9 0.991836734693878 162 18 99.2 0 488 3 46 207 WQY91228.1 DNA polymerase I [Hafnia phage TS33] diamond 486 306 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
28270031 28270031 PRJNA1120586_P_NODE_3446_length_580_cov_1.835616_g3259_i0 PRJNA1120586 3446 580 1.835616 10.6465728 Salmonella phage vB_SalM-LPST94 2282399 Viruses Viruses 281 5.2e-87   NR AXF41693.1 2282399 g3259 i0 88.3 0.837931034482759 162 19 83.8 0 3 488 596 757 AXF41693.1 hypothetical protein LPST94_00131 [Salmonella phage vB_SalM-LPST94] diamond 486 281 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Ackermannviridae Kuttervirus Salmonella phage vB_SalM-LPST94
28491343 28491343 PRJNA1120586_P_NODE_51147_length_227_cov_0.911392_g50956_i0 PRJNA1120586 51147 227 0.911392 2.06885984 Pseudomonas phage vB_PseuGesM_254 3092638 Viruses Viruses 64.3 1.33e-11   NR WOZ57422.1 3092638 g50956 i0 73 0.488986784140969 37 10 48.9 0 115 225 1 37 WOZ57422.1 hypothetical protein [Pseudomonas phage vB_PseuGesM_254] diamond 111 64.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Chemalvirus Chemalvirus PseuGes254
29722333 29722333 PRJNA1120586_P_NODE_14970_length_330_cov_1.490421_g14779_i0 PRJNA1120586 14970 330 1.490421 4.9183893 Caudoviricetes sp. 2832643 Viruses Viruses 204 3.97e-65   NR XOR38047.1 2832643 g14779 i0 87.3 1 110 14 100 0 330 1 17 126 XOR38047.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 330 204 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29754067 29754067 PRJNA1120586_P_NODE_1331_length_870_cov_2.161049_g1182_i0 PRJNA1120586 1331 870 2.161049 18.8011263 Serratia phage Eta 1282995 Viruses Viruses 439 3.4399999999999983e-152   NR YP_008130344.1 1282995 g1182 i0 90.2 0.841379310344828 244 24 84.1 0 139 870 1 244 YP_008130344.1 major head protein [Serratia phage Eta] diamond 732 439 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae Seretavirus Seretavirus eta
30512386 30512386 PRJNA1120586_P_NODE_25893_length_274_cov_1.253659_g25702_i0 PRJNA1120586 25893 274 1.253659 3.43502566 Shigella virus Moo19 2886042 Viruses Viruses 159 6.18e-43   NR YP_010657804.1 2886042 g25702 i0 81.3 0.996350364963504 91 17 99.6 0 273 1 191 281 YP_010657804.1 tail spike protein [Shigella virus Moo19] diamond 273 159 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
31207066 31207066 PRJNA1120586_P_NODE_2495_length_665_cov_2.459732_g2312_i0 PRJNA1120586 2495 665 2.459732 16.3572178 Hafnia phage TS33 3110108 Viruses Viruses 380 1.44e-123   NR WQY91225.1 3110108 g2312 i0 89 0.98796992481203 219 24 98.8 0 661 5 316 534 WQY91225.1 hypothetical protein [Hafnia phage TS33] diamond 657 380 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
31618687 31618687 PRJNA1120586_P_NODE_43236_length_232_cov_3.466258_g43045_i0 PRJNA1120586 43236 232 3.466258 8.04171856 Escherichia phage pO91 3072194 Viruses Viruses 144 6.01e-38   NR WMM35656.1 3072194 g43045 i0 85.7 0.995689655172414 77 11 99.6 0 2 232 214 290 WMM35656.1 hypothetical protein [Escherichia phage pO91] diamond 231 144 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autotranscriptaviridae Kayfunavirus Kayfunavirus pO91
31618689 31618689 PRJNA1120586_P_NODE_53676_length_221_cov_3.059211_g53485_i0 PRJNA1120586 53676 221 3.059211 6.76085631 Serratia phage vB_SmaM-Kashira 2943834 Viruses Viruses 54.7 1.1e-7   NR URC22674.1 2943834 g53485 i0 81.5 0.366515837104072 27 5 36.7 0 1 81 56 82 URC22674.1 hypothetical protein KASHIRA_01000 [Serratia phage vB_SmaM-Kashira] diamond 81 54.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Serratia phage vB_SmaM-Kashira
32030048 32030048 PRJNA1120586_P_NODE_38738_length_237_cov_1.714286_g38547_i0 PRJNA1120586 38738 237 1.714286 4.06285782 Serratia phage vB_SmaM-ChuuTotoro 2943832 Viruses Viruses 103 3.61e-26   NR URC22120.1 2943832 g38547 i0 63.6 0.974683544303797 77 28 97.5 0 231 1 4 80 URC22120.1 hypothetical protein CHUUTOTORO_00160 [Serratia phage vB_SmaM-ChuuTotoro] diamond 231 103 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Serratia phage vB_SmaM-ChuuTotoro
32156680 32156680 PRJNA1120586_P_NODE_6698_length_446_cov_2.050398_g6507_i0 PRJNA1120586 6698 446 2.050398 9.14477508 Acinetobacter phage ABPH49 2282400 Viruses Viruses 89.4 1.82e-20   NR AXN57863.1 2282400 g6507 i0 65.6 0.410313901345291 61 21 41 0 263 445 1 61 AXN57863.1 hypothetical protein [Acinetobacter phage ABPH49] diamond 183 89.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage ABPH49
32378089 32378089 PRJNA1120586_P_NODE_11039_length_369_cov_1.516667_g10848_i0 PRJNA1120586 11039 369 1.516667 5.59650123 Escherichia phage V5 399183 Viruses Viruses 90.5 1.4e-20   NR YP_002003552.1 399183 g10848 i0 47.3 1.49593495934959 110 47 87 2 367 47 2 103 YP_002003552.1 hypothetical protein rv5_gp050 [Escherichia phage V5] diamond 552 90.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Vequintavirus Vequintavirus V5
32851160 32851160 PRJNA1120586_P_NODE_23140_length_284_cov_3.041860_g22949_i0 PRJNA1120586 23140 284 3.04186 8.6388824 Caudoviricetes sp. 2832643 Viruses Viruses 84.7 5.39e-18   NR XOR94467.1 2832643 g22949 i0 50 0.71830985915493 68 34 71.8 0 275 72 124 191 XOR94467.1 MAG: HNH endonuclease [Caudoviricetes sp.] diamond 204 84.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32882579 32882579 PRJNA1120586_P_NODE_54460_length_214_cov_4.013793_g54269_i0 PRJNA1120586 54460 214 4.013793 8.58951702 Escherichia phage NTEC3 2885687 Viruses Viruses 120 1.43e-29   NR YP_010749190.1 2885687 g54269 i0 75.7 1.96261682242991 70 17 98.1 0 212 3 41 110 YP_010749190.1 tail spike protein [Escherichia phage NTEC3] diamond 420 120 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae Kagunavirus Escherichia phage NTEC3
32903371 32903371 PRJNA1120586_P_NODE_13240_length_344_cov_2.850909_g13049_i0 PRJNA1120586 13240 344 2.850909 9.80712696 Viruses 10239 Viruses Viruses 115 1.85e-30   NR URC22378.1 2943832 g13049 i0 45.6 1.98837209302326 114 62 99.4 0 342 1 8 121 URC22378.1 hypothetical protein CHUUTOTORO_02930 [Serratia phage vB_SmaM-ChuuTotoro] diamond 684 115 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Serratia phage vB_SmaM-ChuuTotoro

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