RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA788929" 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

  • PRJNA788929 · 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
3320407 3320407 PRJNA788929_P_NODE_163_length_3853_cov_9.919841_g138_i0 PRJNA788929 163 3853 9.919841 382.21147373 Caudoviricetes sp. 2832643 Viruses Viruses 129 1.55e-29   NR XOS49115.1 2832643 g138 i0 33.3 0.191539060472359 246 128 18.9 4 1464 736 1 213 XOS49115.1 MAG: hypothetical protein MSP0388_22 [Caudoviricetes sp.] diamond 738 129 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19896237 19896237 PRJNA788929_P_NODE_33556_length_270_cov_1.385787_g32895_i0 PRJNA788929 33556 270 1.385787 3.7416249 Caudoviricetes sp. 2832643 Viruses Viruses 127 6.52e-33   NR QHJ79428.1 2832643 g32895 i0 73.7 0.844444444444444 76 20 84.4 0 3 230 295 370 QHJ79428.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 228 127 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26705278 26705278 PRJNA788929_P_NODE_21121_length_355_cov_1.092199_g20461_i0 PRJNA788929 21121 355 1.092199 3.87730645 Synechococcus phage Yong-M2-251 2928846 Viruses Viruses 172 1.31e-49   NR UPT53414.1 2928846 g20461 i0 94.8 0.811267605633803 96 5 81.1 0 354 67 322 417 UPT53414.1 integrase [Synechococcus phage Yong-M2-251] diamond 288 172 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Synechococcus phage Yong-M2-251
26768829 26768829 PRJNA788929_P_NODE_41001_length_244_cov_1.801170_g40340_i0 PRJNA788929 41001 244 1.80117 4.3948548 Shigella virus Moo19 2886042 Viruses Viruses 129 9.02e-37   NR YP_010657724.1 2886042 g40340 i0 73.8 1.0327868852459 84 17 97.1 1 237 1 33 116 YP_010657724.1 gp2 [Shigella virus Moo19] diamond 252 129 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
27148087 27148087 PRJNA788929_P_NODE_17982_length_390_cov_2.189274_g17322_i0 PRJNA788929 17982 390 2.189274 8.5381686 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 2.92e-5   NR XOS06192.1 2832643 g17322 i0 34.7 1.55384615384615 98 57 72.3 3 109 390 1 95 XOS06192.1 MAG: hypothetical protein MSP0216_132 [Caudoviricetes sp.] diamond 606 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27179877 27179877 PRJNA788929_P_NODE_21962_length_347_cov_1.686131_g21301_i0 PRJNA788929 21962 347 1.686131 5.85087457 Salmonella phage PRF-SP1 2873462 Viruses Viruses 52.8 1.23e-6   NR UAW07671.1 2873462 g21301 i0 52 0.432276657060519 50 23 43.2 1 117 266 3 51 UAW07671.1 hypothetical protein PKKHGKEC_00004 [Salmonella phage PRF-SP1] diamond 150 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autotranscriptaviridae Kayfunavirus Kayfunavirus PRFSP1
27654130 27654130 PRJNA788929_P_NODE_26604_length_309_cov_1.885593_g25943_i0 PRJNA788929 26604 309 1.885593 5.82648237 Shigella virus Moo19 2886042 Viruses Viruses 105 5.5e-24   NR YP_010657804.1 2886042 g25943 i0 51 1.00970873786408 104 47 97.1 1 6 305 316 419 YP_010657804.1 tail spike protein [Shigella virus Moo19] diamond 312 105 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
28033002 28033002 PRJNA788929_P_NODE_38705_length_249_cov_1.312500_g38044_i0 PRJNA788929 38705 249 1.3125 3.268125 Pectobacterium phage POP72 1965269 Viruses Viruses 62.4 1.07e-10   NR ARB10919.1 1965269 g38044 i0 49.1 0.662650602409639 55 28 66.3 0 26 190 19 73 ARB10919.1 hypothetical protein POP72_003 [Pectobacterium phage POP72] diamond 165 62.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autosignataviridae Axomammavirus Axomammavirus PP1
28190490 28190490 PRJNA788929_P_NODE_15646_length_424_cov_9.407407_g14987_i0 PRJNA788929 15646 424 9.407407 39.88740568 Staphylococcus phage Madawaska 2797424 Viruses Viruses 99 1.3e-21   NR QQO92725.1 2797424 g14987 i0 36.4 0.933962264150943 132 80 91.3 3 387 1 12 142 QQO92725.1 homing endonuclease [Staphylococcus phage Madawaska] diamond 396 99 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage Madawaska
28443520 28443520 PRJNA788929_P_NODE_32946_length_273_cov_1.155000_g32285_i0 PRJNA788929 32946 273 1.155 3.15315 Caudoviricetes sp. 2832643 Viruses Viruses 142 8.919999999999997e-42   NR QHJ80087.1 2832643 g32285 i0 74.4 0.989010989010989 90 23 98.9 0 3 272 18 107 QHJ80087.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 270 142 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28538266 28538266 PRJNA788929_P_NODE_29707_length_290_cov_1.410138_g29046_i0 PRJNA788929 29707 290 1.410138 4.0894002 Stenotrophomonas phage RAS14 2996120 Viruses Viruses 173 1.37e-52   NR WAX21587.1 2996120 g29046 i0 89.6 0.993103448275862 96 10 99.3 0 2 289 47 142 WAX21587.1 hypothetical protein [Stenotrophomonas phage RAS14] diamond 288 173 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Stenotrophomonas phage RAS14
28569539 28569539 PRJNA788929_P_NODE_15007_length_435_cov_3.422652_g14348_i0 PRJNA788929 15007 435 3.422652 14.8885362 Escherichia phage UPEC 3102713 Viruses Viruses 154 2.89e-45   NR QUL77285.1 2811509 g14348 i0 57.3 0.806896551724138 117 49 80.7 1 419 69 7 122 QUL77285.1 hypothetical protein [Escherichia phage UPEC06] diamond 351 154 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Escherichia phage UPEC06
28569541 28569541 PRJNA788929_P_NODE_25167_length_319_cov_10.227642_g24506_i0 PRJNA788929 25167 319 10.227642 32.62617798 Acinetobacter phage nACB2 3015925 Viruses Viruses 135 4.97e-35   NR WAW11706.1 3015925 g24506 i0 65.3 0.893416927899687 95 33 89.3 0 307 23 379 473 WAW11706.1 hypothetical protein nACB2_075 [Acinetobacter phage nACB2] diamond 285 135 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Ackermannviridae   Acinetobacter phage nACB2
30022274 30022274 PRJNA788929_P_NODE_19551_length_370_cov_68.306397_g18891_i0 PRJNA788929 19551 370 68.306397 252.7336689 Caudoviricetes sp. 2832643 Viruses Viruses 41.2 0.0444   NR DAV81047.1 2832643 g18891 i0 50 0.308108108108108 38 19 30.8 0 257 144 9 46 DAV81047.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 114 41.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30527587 30527587 PRJNA788929_P_NODE_16373_length_413_cov_1.514706_g15714_i0 PRJNA788929 16373 413 1.514706 6.25573578 Yersinia phage MHG19 3025402 Viruses Viruses 97.1 1.41e-23   NR WCZ66322.1 3025402 g15714 i0 63.9 0.443099273607748 61 22 44.3 0 184 2 5 65 WCZ66322.1 hypothetical protein [Yersinia phage MHG19] diamond 183 97.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae   Yersinia phage MHG19
31475927 31475927 PRJNA788929_P_NODE_12476_length_490_cov_1.616307_g11819_i0 PRJNA788929 12476 490 1.616307 7.9199043 Salmonella phage SSBI34 2861009 Viruses Viruses 114 1.82e-29   NR QYC52536.1 2861009 g11819 i0 55.9 0.679591836734694 111 47 68 1 373 41 3 111 QYC52536.1 hypothetical protein [Salmonella phage SSBI34] diamond 333 114 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Salmonella phage SSBI34
31548534 31548534 PRJNA788929_P_NODE_21736_length_349_cov_1.115942_g21075_i0 PRJNA788929 21736 349 1.115942 3.89463758 root 1 Root_unresolved Root_unresolved 120 5.1e-29   NR XOR59337.1 2832643 g21075 i0 48.7 2.00286532951289 113 58 97.1 0 346 8 257 369 XOR59337.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 699 120 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31602474 31602474 PRJNA788929_P_NODE_19056_length_377_cov_1.519737_g18396_i0 PRJNA788929 19056 377 1.519737 5.72940849 Escherichia phage vB_EcoP-ZQ2 2810370 Viruses Viruses 170 3.6e-52   NR YP_010659955.1 2810370 g18396 i0 78.6 3.13527851458886 98 21 78 0 13 306 1 98 YP_010659955.1 hypothetical protein PP768_gp18 [Escherichia phage vB_EcoP-ZQ2] diamond 1182 170 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Gamaleyavirus Gamaleyavirus Zq2
32117833 32117833 PRJNA788929_P_NODE_7978_length_658_cov_2.200000_g7334_i0 PRJNA788929 7978 658 2.2 14.476 Viruses 10239 Viruses Viruses 126 7.32e-34   NR QUL77296.1 2811509 g7334 i0 66.3 1.44072948328267 86 29 39.2 0 204 461 1 86 QUL77296.1 hypothetical protein [Escherichia phage UPEC06] diamond 948 126 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Escherichia phage UPEC06
32266893 32266893 PRJNA788929_P_NODE_12518_length_489_cov_1.612981_g11861_i0 PRJNA788929 12518 489 1.612981 7.88747709 Serratia phage Eta 1282995 Viruses Viruses 295 7.29e-98   NR YP_008130344.1 1282995 g11861 i0 93.2 0.993865030674847 162 11 99.4 0 2 487 14 175 YP_008130344.1 major head protein [Serratia phage Eta] diamond 486 295 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae Seretavirus Seretavirus eta
32488326 32488326 PRJNA788929_P_NODE_15899_length_420_cov_15.279539_g15240_i0 PRJNA788929 15899 420 15.279539 64.1740638 Caudoviricetes sp. 2832643 Viruses Viruses 79 5.6e-15   NR XOR12485.1 2832643 g15240 i0 40.8 0.928571428571429 130 71 90.7 3 19 399 4 130 XOR12485.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 390 79 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32677237 32677237 PRJNA788929_P_NODE_37400_length_252_cov_10.994413_g36739_i0 PRJNA788929 37400 252 10.994413 27.70592076 uncultured Caudovirales phage 2100421 Viruses Viruses 107 9.57e-28   NR CAB4132897.1 2100421 g36739 i0 65.8 0.904761904761905 76 25 89.3 1 226 2 33 108 CAB4132897.1 HNHc domain containing protein [uncultured Caudovirales phage] diamond 228 107 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch

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