RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA703759" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA703759 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
12163839 12163839 PRJNA703759_P_NODE_38850_length_250_cov_0.881356_g38374_i0 PRJNA703759 38850 250 0.881356 2.20339 Caudoviricetes sp. 2832643 Viruses Viruses 77 3.45e-14   NR BCV07774.1 2832643 g38374 i0 49.4 1.908 79 40 94.8 0 245 9 1419 1497 BCV07774.1 MAG: hypothetical protein CM15mL2_2500 [Caudoviricetes sp.] diamond 477 77 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26956118 26956118 PRJNA703759_P_NODE_3802_length_802_cov_1.397805_g3344_i0 PRJNA703759 3802 802 1.397805 11.2103961 Caudoviricetes sp. 2832643 Viruses Viruses 295 3.7999999999999997e-90   NR XOR69605.1 2832643 g3344 i0 64.4 0.841645885286783 225 79 83.8 1 801 130 641 865 XOR69605.1 MAG: putative phage replicative helicase/primease [Caudoviricetes sp.] diamond 675 295 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27145604 27145604 PRJNA703759_P_NODE_43182_length_247_cov_0.896552_g42706_i0 PRJNA703759 43182 247 0.896552 2.21448344 Klebsiella phage KpLz-2_45 2698923 Viruses Viruses 131 4.57e-34   NR YP_010297822.1 2698923 g42706 i0 74.4 0.947368421052632 78 20 94.7 0 14 247 1 78 YP_010297822.1 RNA polymerase beta subunit [Klebsiella phage KpLz-2_45] diamond 234 131 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Siatvirus Siatvirus Lz245
27556543 27556543 PRJNA703759_P_NODE_41884_length_248_cov_0.891429_g41408_i0 PRJNA703759 41884 248 0.891429 2.21074392 EBPR siphovirus 3 1048522 Viruses Viruses 49.3 1.7e-4   NR AEI71094.1 1048522 g41408 i0 45.6 1.57258064516129 68 25 82.3 4 43 246 103 158 AEI71094.1 hypothetical protein [EBPR siphovirus 3] diamond 390 49.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       EBPR siphovirus 3
27935726 27935726 PRJNA703759_P_NODE_47985_length_244_cov_0.912281_g47509_i0 PRJNA703759 47985 244 0.912281 2.22596564 Caudoviricetes sp. 2832643 Viruses Viruses 52.4 2.4e-6   NR UOF79944.1 2832643 g47509 i0 32.5 0.983606557377049 80 52 95.9 2 236 3 39 118 UOF79944.1 hypothetical protein [Caudoviricetes sp.] diamond 240 52.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28030412 28030412 PRJNA703759_P_NODE_41905_length_248_cov_0.891429_g41429_i0 PRJNA703759 41905 248 0.891429 2.21074392 Caudoviricetes sp. 2832643 Viruses Viruses 103 1.5999999999999999e-24   NR XOS72699.1 2832643 g41429 i0 63 0.979838709677419 81 30 98 0 5 247 125 205 XOS72699.1 MAG: hypothetical protein MSP0465_122 [Caudoviricetes sp.] diamond 243 103 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28377572 28377572 PRJNA703759_P_NODE_40506_length_249_cov_0.886364_g40030_i0 PRJNA703759 40506 249 0.886364 2.20704636 Synechococcus phage S-CAM1 754037 Viruses Viruses 72 2.04e-14   NR YP_007673007.1 754037 g40030 i0 72.3 1.07228915662651 47 13 56.6 0 107 247 5 51 YP_007673007.1 late promoter transcriptional regulator [Synechococcus phage S-CAM1] diamond 267 72 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae Anaposvirus Anaposvirus socalone
28409284 28409284 PRJNA703759_P_NODE_49306_length_243_cov_0.917647_g48830_i0 PRJNA703759 49306 243 0.917647 2.22988221 Gordonia phage Phendrix 2593335 Viruses Viruses 153 1.36e-41   NR YP_010649190.1 2593335 g48830 i0 88.8 0.987654320987654 80 9 98.8 0 242 3 227 306 YP_010649190.1 DNA polymerase [Gordonia phage Phendrix] diamond 240 153 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Godonkavirus Godonkavirus phendrix
29009553 29009553 PRJNA703759_P_NODE_42628_length_247_cov_1.540230_g42152_i0 PRJNA703759 42628 247 1.54023 3.8043681 uncultured Caudovirales phage 2100421 Viruses Viruses 45.1 0.00563   NR CAB4147553.1 2100421 g42152 i0 39.4 0.862348178137652 71 41 83.8 1 3 209 260 330 CAB4147553.1 hypothetical protein UFOVP512_32 [uncultured Caudovirales phage] diamond 213 45.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29261545 29261545 PRJNA703759_P_NODE_35749_length_252_cov_1.178771_g35273_i0 PRJNA703759 35749 252 1.178771 2.97050292 Caudoviricetes sp. 2832643 Viruses Viruses 115 5.9899999999999985e-28   NR XOF00883.1 2832643 g35273 i0 71.1 0.988095238095238 83 23 98.8 1 250 2 104 185 XOF00883.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 249 115 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29419464 29419464 PRJNA703759_P_NODE_25789_length_282_cov_1.119617_g25313_i0 PRJNA703759 25789 282 1.119617 3.15731994 Caudoviricetes sp. 2832643 Viruses Viruses 42.4 0.018   NR XOR69615.1 2832643 g25313 i0 78.3 0.24468085106383 23 5 24.5 0 132 64 74 96 XOR69615.1 MAG: gp48 protein [Caudoviricetes sp.] diamond 69 42.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30240807 30240807 PRJNA703759_P_NODE_12012_length_387_cov_1.652866_g11536_i0 PRJNA703759 12012 387 1.652866 6.39659142 Caudoviricetes sp. 2832643 Viruses Viruses 146 6.08e-40   NR XOE98924.1 2832643 g11536 i0 68.4 0.75968992248062 98 31 76 0 385 92 137 234 XOE98924.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 294 146 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30493640 30493640 PRJNA703759_P_NODE_40973_length_249_cov_0.886364_g40497_i0 PRJNA703759 40973 249 0.886364 2.20704636 Caudoviricetes sp. 2832643 Viruses Viruses 43.5 0.00264   NR XOS04970.1 2832643 g40497 i0 37.3 0.614457831325301 51 32 61.4 0 97 249 15 65 XOS04970.1 MAG: hypothetical protein MSP1124_53 [Caudoviricetes sp.] diamond 153 43.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30809518 30809518 PRJNA703759_P_NODE_41054_length_248_cov_2.211429_g40578_i0 PRJNA703759 41054 248 2.211429 5.48434392 Caudoviricetes sp. 2832643 Viruses Viruses 93.2 1.3e-21   NR XOR06079.1 2832643 g40578 i0 59.3 0.979838709677419 81 33 98 0 246 4 7 87 XOR06079.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 243 93.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30872669 30872669 PRJNA703759_P_NODE_36634_length_252_cov_0.871508_g36158_i0 PRJNA703759 36634 252 0.871508 2.19620016 Caudoviricetes sp. 2832643 Viruses Viruses 53.9 8.84e-7   NR XOR01049.1 2832643 g36158 i0 34.1 0.976190476190476 82 52 95.2 1 245 6 5 86 XOR01049.1 MAG: gp18 protein [Caudoviricetes sp.] diamond 246 53.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31694653 31694653 PRJNA703759_P_NODE_7257_length_519_cov_1.298206_g6781_i0 PRJNA703759 7257 519 1.298206 6.73768914 Siphoviridae sp. ctdc_1 2675441 Viruses Viruses 202 4.4e-61   NR AXH72176.1 2675441 g6781 i0 69.4 0.832369942196532 144 34 77.5 2 413 12 106 249 AXH72176.1 MAG: DNA methylase [Siphoviridae sp. ctdc_1] diamond 432 202 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctdc_1
31800498 31800498 PRJNA703759_P_NODE_38097_length_251_cov_0.876404_g37621_i0 PRJNA703759 38097 251 0.876404 2.19977404 Rogerhendrixvirus 2733204 Viruses Viruses 60.5 2.31e-8   NR YP_009801943.1 2182341 g37621 i0 51.5 1.45816733067729 66 25 70.5 1 251 75 525 590 YP_009801943.1 terminase large subunit [Microbacterium phage Hendrix] diamond 366 60.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Rogerhendrixvirus Rogerhendrixvirus hendrix
31979340 31979340 PRJNA703759_P_NODE_44178_length_246_cov_1.352601_g43702_i0 PRJNA703759 44178 246 1.352601 3.32739846 Caudoviricetes sp. 2832643 Viruses Viruses 77.4 1.78e-14   NR XOQ92169.1 2832643 g43702 i0 55.6 1.98780487804878 81 34 96.3 1 239 3 191 271 XOQ92169.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 489 77.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32832408 32832408 PRJNA703759_P_NODE_33800_length_254_cov_1.723757_g33324_i0 PRJNA703759 33800 254 1.723757 4.37834278 Caudoviricetes sp. 2832643 Viruses Viruses 60.5 5.7e-10   NR XOF04708.1 2832643 g33324 i0 61.4 1.03937007874016 44 17 52 0 252 121 20 63 XOF04708.1 MAG: hypothetical protein, partial [Caudoviricetes sp.] diamond 264 60.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);;