RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA763243" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 21 ✖

bioproject 1

  • PRJNA763243 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
26704787 26704787 PRJNA763243_P_NODE_69421_length_223_cov_8.693333_g69075_i0 PRJNA763243 69421 223 8.693333 19.38613259 Caudoviricetes sp. 2832643 Viruses Viruses 144 1.6799999999999994e-42   NR XOR52206.1 2832643 g69075 i0 98.6 0.955156950672646 71 1 95.5 0 8 220 47 117 XOR52206.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 213 144 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27464133 27464133 PRJNA763243_P_NODE_64483_length_239_cov_35.180723_g64137_i0 PRJNA763243 64483 239 35.180723 84.08192797 uncultured Caudovirales phage 2100421 Viruses Viruses 77 2.29e-14   NR CAB4151640.1 2100421 g64137 i0 56.7 0.841004184100418 67 28 84.1 1 1 201 258 323 CAB4151640.1 major_cap_HK97, phage major capsid protein, HK97 family [uncultured Caudovirales phage] diamond 201 77 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
27495644 27495644 PRJNA763243_P_NODE_73783_length_203_cov_4.469231_g73437_i0 PRJNA763243 73783 203 4.469231 9.07253893 Caudoviricetes sp. 2832643 Viruses Viruses 116 1.06e-29   NR XOR55031.1 2832643 g73437 i0 95.2 0.916256157635468 62 3 91.6 0 202 17 184 245 XOR55031.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 186 116 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27685316 27685316 PRJNA763243_P_NODE_63544_length_241_cov_0.916667_g63198_i0 PRJNA763243 63544 241 0.916667 2.20916747 Caudoviricetes sp. 2832643 Viruses Viruses 60.5 2.13e-8   NR XOR55153.1 2832643 g63198 i0 72.1 0.535269709543568 43 11 52.3 1 5 130 2000 2042 XOR55153.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 129 60.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28000957 28000957 PRJNA763243_P_NODE_65965_length_235_cov_2.376543_g65619_i0 PRJNA763243 65965 235 2.376543 5.58487605 Pseudomonas phage pPa_SNUABM_DT 2820398 Viruses Viruses 119 1.04e-29   NR QTH80274.1 2820398 g65619 i0 77.1 0.893617021276596 70 16 89.4 0 232 23 235 304 QTH80274.1 hypothetical protein PA10_00074 [Pseudomonas phage pPa_SNUABM_DT01] diamond 210 119 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage pPa_SNUABM_DT01
28127156 28127156 PRJNA763243_P_NODE_65325_length_237_cov_2.256098_g64979_i0 PRJNA763243 65325 237 2.256098 5.34695226 Pseudomonas phage pPa_SNUABM_DT 2820398 Viruses Viruses 83.6 1.51e-18   NR QTH80462.1 2820398 g64979 i0 55.6 0.911392405063291 72 32 91.1 0 14 229 35 106 QTH80462.1 hypothetical protein PA10_00264 [Pseudomonas phage pPa_SNUABM_DT01] diamond 216 83.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage pPa_SNUABM_DT01
28379624 28379624 PRJNA763243_P_NODE_71346_length_213_cov_122.264286_g71000_i0 PRJNA763243 71346 213 122.264286 260.42292918 Caudoviricetes sp. 2832643 Viruses Viruses 83.6 1.83e-17   NR XOQ89701.1 2832643 g71000 i0 70.2 0.802816901408451 57 17 80.3 0 176 6 1 57 XOQ89701.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 171 83.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28442894 28442894 PRJNA763243_P_NODE_24286_length_327_cov_1.956693_g23940_i0 PRJNA763243 24286 327 1.956693 6.39838611 Caudoviricetes sp. 2832643 Viruses Viruses 68.2 3.2e-11   NR DAY69239.1 2832643 g23940 i0 54.2 0.541284403669725 59 26 53.2 1 323 150 162 220 DAY69239.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 177 68.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28569021 28569021 PRJNA763243_P_NODE_74987_length_198_cov_5.552000_g74641_i0 PRJNA763243 74987 198 5.552 10.99296 Caudoviricetes sp. 2832643 Viruses Viruses 97.8 6.63e-25   NR XOS31904.1 2832643 g74641 i0 83.7 0.742424242424242 49 8 74.2 0 149 3 30 78 XOS31904.1 MAG: hypothetical protein MSP0777_56 [Caudoviricetes sp.] diamond 147 97.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28663889 28663889 PRJNA763243_P_NODE_74107_length_201_cov_25.445312_g73761_i0 PRJNA763243 74107 201 25.445312 51.14507712 Caudoviricetes sp. 2832643 Viruses Viruses 55.1 5.6e-7   NR XOS40273.1 2832643 g73761 i0 52.4 0.940298507462687 63 30 94 0 194 6 24 86 XOS40273.1 MAG: hypothetical protein MSP1038_61 [Caudoviricetes sp.] diamond 189 55.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29452810 29452810 PRJNA763243_P_NODE_30830_length_306_cov_1.450644_g30484_i0 PRJNA763243 30830 306 1.450644 4.43897064 Ralstonia phage phiRSL1 1980924 Viruses Viruses 91.3 2.92e-19   NR YP_001950011.1 1980924 g30484 i0 48.5 0.950980392156863 97 49 94.1 1 290 3 16 112 YP_001950011.1 major head protein [Ralstonia phage phiRSL1] diamond 291 91.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Mieseafarmvirus Mieseafarmvirus RSL1
29863580 29863580 PRJNA763243_P_NODE_28691_length_310_cov_6.105485_g28345_i0 PRJNA763243 28691 310 6.105485 18.9270035 Caudoviricetes sp. 2832643 Viruses Viruses 48.5 6.77e-4   NR DAY69152.1 2832643 g28345 i0 56.4 0.37741935483871 39 17 37.7 0 122 6 178 216 DAY69152.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 117 48.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30021717 30021717 PRJNA763243_P_NODE_45271_length_264_cov_2.350785_g44925_i0 PRJNA763243 45271 264 2.350785 6.2060724 Burkholderia phage BCSR5 2805747 Viruses Viruses 137 7.69e-37   NR QRE00273.1 2805747 g44925 i0 67.1 4.82954545454545 85 28 96.6 0 256 2 231 315 QRE00273.1 hypothetical protein [Burkholderia phage BCSR5] diamond 1275 137 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage BCSR5
30179397 30179397 PRJNA763243_P_NODE_11872_length_440_cov_2.569482_g11528_i0 PRJNA763243 11872 440 2.569482 11.3057208 Achromobacter phage Motura 2591403 Viruses Viruses 56.6 4.15e-6   NR YP_009903801.1 2591403 g11528 i0 31.9 0.940909090909091 138 81 85.9 3 432 55 406 542 YP_009903801.1 ATPase [Achromobacter phage Motura] diamond 414 56.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Moturavirus Moturavirus motura
30464308 30464308 PRJNA763243_P_NODE_29073_length_310_cov_4.497890_g28727_i0 PRJNA763243 29073 310 4.49789 13.943459 Achromobacter phage Motura 2591403 Viruses Viruses 45.8 0.00706   NR YP_009903805.1 2591403 g28727 i0 50 0.406451612903226 42 21 40.6 0 184 309 1398 1439 YP_009903805.1 DNA helicase [Achromobacter phage Motura] diamond 126 45.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Moturavirus Moturavirus motura
30464331 30464331 PRJNA763243_P_NODE_54873_length_248_cov_1.588571_g54527_i0 PRJNA763243 54873 248 1.588571 3.93965608 Caudoviricetes sp. 2832643 Viruses Viruses 65.1 6.54e-12   NR DAO47508.1 2832643 g54527 i0 55.4 0.786290322580645 65 23 78.6 1 50 244 1 59 DAO47508.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 195 65.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30653300 30653300 PRJNA763243_P_NODE_31993_length_301_cov_2.065789_g31647_i0 PRJNA763243 31993 301 2.065789 6.21802489 Achromobacter phage Motura 2591403 Viruses Viruses 82.4 8.49e-16   NR YP_009903599.1 2591403 g31647 i0 45.9 0.976744186046512 98 42 97.7 1 6 299 607 693 YP_009903599.1 exonuclease [Achromobacter phage Motura] diamond 294 82.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Moturavirus Moturavirus motura
31253817 31253817 PRJNA763243_P_NODE_52495_length_250_cov_3.847458_g52149_i0 PRJNA763243 52495 250 3.847458 9.618645 Caudoviricetes sp. 2832643 Viruses Viruses 79.3 7.27e-17   NR XOR52204.1 2832643 g52149 i0 80.5 0.492 41 8 49.2 0 243 121 75 115 XOR52204.1 MAG: p010 protein [Caudoviricetes sp.] diamond 123 79.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32329734 32329734 PRJNA763243_P_NODE_26039_length_318_cov_1.791837_g25693_i0 PRJNA763243 26039 318 1.791837 5.69804166 Achromobacter phage Motura 2591403 Viruses Viruses 61.2 1.82e-8   NR YP_009903851.1 2591403 g25693 i0 33.3 0.933962264150943 99 58 93.4 2 17 313 102 192 YP_009903851.1 hypothetical protein H1O15_gp136 [Achromobacter phage Motura] diamond 297 61.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Moturavirus Moturavirus motura
32424384 32424384 PRJNA763243_P_NODE_54759_length_248_cov_2.091429_g54413_i0 PRJNA763243 54759 248 2.091429 5.18674392 Caudoviricetes sp. 2832643 Viruses Viruses 110 5.75e-26   NR XOR33961.1 2832643 g54413 i0 74.6 0.810483870967742 67 17 81 0 243 43 484 550 XOR33961.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 201 110 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32771271 32771271 PRJNA763243_P_NODE_28960_length_310_cov_4.856540_g28614_i0 PRJNA763243 28960 310 4.85654 15.055274 Stenotrophomonas phage RAS14 2996120 Viruses Viruses 55.8 2.05e-6   NR WAX21782.1 2996120 g28614 i0 27.4 2.25483870967742 135 62 96.8 2 8 307 224 357 WAX21782.1 hypothetical protein [Stenotrophomonas phage RAS14] diamond 699 55.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Stenotrophomonas phage RAS14

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