RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA1196384" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1196384 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
322690 322690 PRJNA1196384_S_NODE_3961_length_199_cov_1.672840_g3897_i0 PRJNA1196384 3961 199 1.67284 3.3289516 Caudoviricetes sp. 2832643 Viruses Viruses 83.2 1.22e-18   NR XOR28986.1 2832643 g3897 i0 74.1 2.62311557788945 58 15 87.4 0 26 199 1 58 XOR28986.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 522 83.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
322739 322739 PRJNA1196384_S_NODE_6301_length_166_cov_1.767442_g6237_i0 PRJNA1196384 6301 166 1.767442 2.93395372 Caudoviricetes sp. 2832643 Viruses Viruses 86.7 2.74e-20   NR XOS01667.1 2832643 g6237 i0 72.2 0.975903614457831 54 15 97.6 0 5 166 20 73 XOS01667.1 MAG: hypothetical protein MSP1221_31 [Caudoviricetes sp.] diamond 162 86.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
1597268 1597268 PRJNA1196384_S_NODE_22_length_3077_cov_6.219737_g1_i10 PRJNA1196384 22 3077 6.219737 191.38130749 Mycobacterium phage Turj99 1701849 Viruses Viruses 438 3.35e-139   NR YP_009211765.1 1701849 g1 i10 47.2 0.504062398440039 517 249 49.2 12 2042 528 9 513 YP_009211765.1 intein-containing topoisomerase primase [Mycobacterium phage Turj99] diamond 1551 438 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Fromanvirus Mycobacterium phage Turj99
11801176 11801176 PRJNA1196384_S_NODE_10_length_5949_cov_7.362483_g1_i4 PRJNA1196384 10 5949 7.362483 437.99411367 Mycobacterium phage Turj99 1701849 Viruses Viruses 437 9.579999999999999e-133   NR YP_009211765.1 1701849 g1 i4 47.2 0.260716086737267 517 249 25.5 12 1600 86 9 513 YP_009211765.1 intein-containing topoisomerase primase [Mycobacterium phage Turj99] diamond 1551 437 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Fromanvirus Mycobacterium phage Turj99
14351648 14351648 PRJNA1196384_S_NODE_12_length_4908_cov_7.031000_g1_i5 PRJNA1196384 12 4908 7.031 345.08148 Mycobacterium phage Turj99 1701849 Viruses Viruses 438 1.7999999999999992e-134   NR YP_009211765.1 1701849 g1 i5 47.2 0.31601466992665 517 249 30.9 12 2867 4381 9 513 YP_009211765.1 intein-containing topoisomerase primase [Mycobacterium phage Turj99] diamond 1551 438 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Fromanvirus Mycobacterium phage Turj99
15625425 15625425 PRJNA1196384_S_NODE_13_length_4905_cov_7.031841_g1_i6 PRJNA1196384 13 4905 7.031841 344.91180105 Mycobacterium phage Turj99 1701849 Viruses Viruses 437 4.729999999999998e-134   NR YP_009211765.1 1701849 g1 i6 47.2 0.316207951070336 517 249 30.9 12 3306 4820 9 513 YP_009211765.1 intein-containing topoisomerase primase [Mycobacterium phage Turj99] diamond 1551 437 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Fromanvirus Mycobacterium phage Turj99
19448690 19448690 PRJNA1196384_S_NODE_16_length_4571_cov_6.499338_g6_i0 PRJNA1196384 16 4571 6.499338 297.08473998 Caudoviricetes sp. 2832643 Viruses Viruses 391 1.37e-115   NR XOR90815.1 2832643 g6 i0 46 0.305184861080726 465 169 25.1 3 3421 4569 2 466 XOR90815.1 MAG: tail protein [Caudoviricetes sp.] diamond 1395 391 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24548766 24548766 PRJNA1196384_S_NODE_20_length_4037_cov_6.583000_g6_i1 PRJNA1196384 20 4037 6.583 265.75571 Caudoviricetes sp. 2832643 Viruses Viruses 171 6.69e-40   NR XOR90815.1 2832643 g6 i1 46.7 0.146395838493931 197 103 14.5 1 617 33 2 198 XOR90815.1 MAG: tail protein [Caudoviricetes sp.] diamond 591 171 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27009052 27009052 PRJNA1196384_S_NODE_2722_length_235_cov_1.838384_g2658_i0 PRJNA1196384 2722 235 1.838384 4.3202024 Caudoviricetes sp. 2832643 Viruses Viruses 52.4 5.85e-7   NR XOR28926.1 2832643 g2658 i0 79.3 0.370212765957447 29 6 37 0 1 87 32 60 XOR28926.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 87 52.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27167105 27167105 PRJNA1196384_S_NODE_762_length_438_cov_3.840399_g698_i0 PRJNA1196384 762 438 3.840399 16.82094762 Caudoviricetes sp. 2832643 Viruses Viruses 81.6 5.99e-16   NR XOS35576.1 2832643 g698 i0 42.7 0.801369863013699 117 64 80.1 2 3 353 80 193 XOS35576.1 MAG: putative HNH endonuclease [Caudoviricetes sp.] diamond 351 81.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27262213 27262213 PRJNA1196384_S_NODE_43_length_1292_cov_3.658964_g2_i3 PRJNA1196384 43 1292 3.658964 47.27381488 Caudoviricetes sp. 2832643 Viruses Viruses 154 2.35e-36   NR XOS35484.1 2832643 g2 i3 32.8 0.694272445820433 299 181 69 6 1290 400 481 761 XOS35484.1 MAG: tail fiber protein [Caudoviricetes sp.] diamond 897 154 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27577966 27577966 PRJNA1196384_S_NODE_6504_length_164_cov_2.755906_g6440_i0 PRJNA1196384 6504 164 2.755906 4.51968584 Caudoviricetes sp. 2832643 Viruses Viruses 48.5 1.8e-5   NR XOQ96745.1 2832643 g6440 i0 84.6 0.475609756097561 26 4 47.6 0 153 76 38 63 XOQ96745.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 78 48.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27799170 27799170 PRJNA1196384_S_NODE_4_length_7013_cov_6.243693_g2_i0 PRJNA1196384 4 7013 6.243693 437.87019009 Caudoviricetes sp. 2832643 Viruses Viruses 423 1.31e-118   NR XOS35484.1 2832643 g2 i0 34.4 0.332382717809782 777 477 32.7 10 2694 400 6 761 XOS35484.1 MAG: tail fiber protein [Caudoviricetes sp.] diamond 2331 423 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27862032 27862032 PRJNA1196384_S_NODE_5_length_6645_cov_6.369855_g2_i1 PRJNA1196384 5 6645 6.369855 423.27686475 Caudoviricetes sp. 2832643 Viruses Viruses 424 5.819999999999999e-119   NR XOS35484.1 2832643 g2 i1 34.4 0.35079006772009 777 477 34.5 10 4320 6614 6 761 XOS35484.1 MAG: tail fiber protein [Caudoviricetes sp.] diamond 2331 424 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28020164 28020164 PRJNA1196384_S_NODE_6745_length_162_cov_1.784000_g6681_i0 PRJNA1196384 6745 162 1.784 2.89008 Mycobacterium phage Anglerfish 2596980 Viruses Viruses 59.3 1.73e-8   NR QEA11474.1 2596980 g6681 i0 49.1 0.981481481481482 53 26 96.3 1 5 160 105 157 QEA11474.1 terminase large subunit [Mycobacterium phage Anglerfish] diamond 159 59.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Fromanvirus Mycobacterium phage Anglerfish
28683244 28683244 PRJNA1196384_S_NODE_4767_length_185_cov_1.729730_g4703_i0 PRJNA1196384 4767 185 1.72973 3.2000005 Caudoviricetes sp. 2832643 Viruses Viruses 43.9 0.00686   NR XOS35484.1 2832643 g4703 i0 42.1 0.924324324324324 57 28 92.4 2 6 176 1122 1173 XOS35484.1 MAG: tail fiber protein [Caudoviricetes sp.] diamond 171 43.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28777671 28777671 PRJNA1196384_S_NODE_4487_length_189_cov_1.782895_g4423_i0 PRJNA1196384 4487 189 1.782895 3.36967155 Caudoviricetes sp. 2832643 Viruses Viruses 77.4 1.78e-16   NR XOS40640.1 2832643 g4423 i0 76 0.793650793650794 50 11 79.4 1 150 1 1 49 XOS40640.1 MAG: hypothetical protein MSP1023_1 [Caudoviricetes sp.] diamond 150 77.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28872437 28872437 PRJNA1196384_S_NODE_8_length_6063_cov_6.572519_g2_i2 PRJNA1196384 8 6063 6.572519 398.49182697 Caudoviricetes sp. 2832643 Viruses Viruses 345 4.36e-93   NR XOS35484.1 2832643 g2 i2 35.9 0.2894606630381 585 360 28.4 6 4320 6041 6 586 XOS35484.1 MAG: tail fiber protein [Caudoviricetes sp.] diamond 1755 345 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29251200 29251200 PRJNA1196384_S_NODE_5069_length_181_cov_1.354167_g5005_i0 PRJNA1196384 5069 181 1.354167 2.45104227 Caudoviricetes sp. 2832643 Viruses Viruses 117 1.3e-30   NR XOQ97230.1 2832643 g5005 i0 93.2 2.93370165745856 59 4 97.8 0 179 3 123 181 XOQ97230.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 531 117 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30546388 30546388 PRJNA1196384_S_NODE_4833_length_184_cov_2.020408_g4769_i0 PRJNA1196384 4833 184 2.020408 3.71755072 Caudoviricetes sp. 2832643 Viruses Viruses 103 1.95e-25   NR XOS39669.1 2832643 g4769 i0 76.7 0.978260869565217 60 14 97.8 0 4 183 79 138 XOS39669.1 MAG: hypothetical protein MSP1057_49 [Caudoviricetes sp.] diamond 180 103 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30830689 30830689 PRJNA1196384_S_NODE_4174_length_195_cov_1.234177_g4110_i0 PRJNA1196384 4174 195 1.234177 2.40664515 Caudoviricetes sp. 2832643 Viruses Viruses 98.2 1.28e-24   NR XOQ97229.1 2832643 g4110 i0 69.4 3.78461538461538 62 19 95.4 0 1 186 57 118 XOQ97229.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 738 98.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31304717 31304717 PRJNA1196384_S_NODE_1055_length_373_cov_1.723214_g991_i0 PRJNA1196384 1055 373 1.723214 6.42758822 Caudoviricetes sp. 2832643 Viruses Viruses 188 4.02e-56   NR XOQ97232.1 2832643 g991 i0 90.6 1.70509383378016 106 10 85.3 0 53 370 70 175 XOQ97232.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 636 188 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31463136 31463136 PRJNA1196384_S_NODE_5296_length_178_cov_1.340426_g5232_i0 PRJNA1196384 5296 178 1.340426 2.38595828 Caudoviricetes sp. 2832643 Viruses Viruses 49.3 1.97e-5   NR XOR36761.1 2832643 g5232 i0 73.1 0.438202247191011 26 7 43.8 0 178 101 67 92 XOR36761.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 78 49.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31684164 31684164 PRJNA1196384_S_NODE_117_length_924_cov_3.526494_g2_i4 PRJNA1196384 117 924 3.526494 32.58480456 Caudoviricetes sp. 2832643 Viruses Viruses 154 5.46e-38   NR XOS35484.1 2832643 g2 i4 32.8 0.970779220779221 299 181 96.4 6 922 32 481 761 XOS35484.1 MAG: tail fiber protein [Caudoviricetes sp.] diamond 897 154 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31747507 31747507 PRJNA1196384_S_NODE_4897_length_183_cov_1.835616_g4833_i0 PRJNA1196384 4897 183 1.835616 3.35917728 Caudoviricetes sp. 2832643 Viruses Viruses 73.9 1.64e-13   NR XOQ97202.1 2832643 g4833 i0 76.4 0.901639344262295 55 9 90.2 1 166 2 565 615 XOQ97202.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 165 73.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32380487 32380487 PRJNA1196384_S_NODE_39_length_1377_cov_5.175373_g21_i0 PRJNA1196384 39 1377 5.175373 71.26488621 Caudoviricetes sp. 2832643 Viruses Viruses 350 5.51e-110   NR XOR90815.1 2832643 g21 i0 73 0.501089324618736 230 62 50.1 0 1377 688 465 694 XOR90815.1 MAG: tail protein [Caudoviricetes sp.] diamond 690 350 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32475496 32475496 PRJNA1196384_S_NODE_6219_length_167_cov_1.476923_g6155_i0 PRJNA1196384 6219 167 1.476923 2.46646141 Caudoviricetes sp. 2832643 Viruses Viruses 77.8 9.71e-17   NR XOS39659.1 2832643 g6155 i0 74.5 0.988023952095808 55 14 98.8 0 2 166 64 118 XOS39659.1 MAG: putative thymidylate synthase complementing protein ThyX [Caudoviricetes sp.] diamond 165 77.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32475497 32475497 PRJNA1196384_S_NODE_6459_length_165_cov_1.132812_g6395_i0 PRJNA1196384 6459 165 1.132812 1.8691398 Caudoviricetes sp. 2832643 Viruses Viruses 94.7 6.16e-21   NR XOR28914.1 2832643 g6395 i0 85.2 0.981818181818182 54 8 98.2 0 3 164 471 524 XOR28914.1 MAG: terminase large subunit [Caudoviricetes sp.] diamond 162 94.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32632918 32632918 PRJNA1196384_S_NODE_5140_length_180_cov_1.622378_g5076_i0 PRJNA1196384 5140 180 1.622378 2.9202804 Caudoviricetes sp. 2832643 Viruses Viruses 126 4.18e-36   NR XOR11285.1 2832643 g5076 i0 86.7 1 60 8 100 0 180 1 34 93 XOR11285.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 180 126 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32759123 32759123 PRJNA1196384_S_NODE_340_length_620_cov_3.161235_g283_i0 PRJNA1196384 340 620 3.161235 19.599657 Caudoviricetes sp. 2832643 Viruses Viruses 71.6 1.1e-10   NR XOR08276.1 2832643 g283 i0 29.8 0.861290322580645 178 85 75 5 508 44 46 206 XOR08276.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 534 71.6 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);;