RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1247234" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 17 ✖

bioproject 1

  • PRJNA1247234 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
2902234 2902234 PRJNA1247234_P_NODE_18763_length_262_cov_1.238095_g18607_i0 PRJNA1247234 18763 262 1.238095 3.2438089 Caudoviricetes sp. 2832643 Viruses Viruses 77.4 9.88e-15   NR DAP78512.1 2832643 g18607 i0 69.4 0.561068702290076 49 15 56.1 0 2 148 206 254 DAP78512.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 147 77.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26852330 26852330 PRJNA1247234_P_NODE_22121_length_250_cov_0.881356_g21965_i0 PRJNA1247234 22121 250 0.881356 2.20339 Caudoviricetes sp. 2832643 Viruses Viruses 73.9 4.15e-13   NR DAK57333.1 2832643 g21965 i0 45.8 0.996 83 45 99.6 0 250 2 165 247 DAK57333.1 MAG TPA: portal protein [Caudoviricetes sp.] diamond 249 73.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26883908 26883908 PRJNA1247234_P_NODE_20421_length_253_cov_0.866667_g20265_i0 PRJNA1247234 20421 253 0.866667 2.19266751 Bacteriophage sp. 38018 Viruses Viruses 122 1.71e-33   NR DAM35135.1 38018 g20265 i0 64.7 2.97628458498024 85 29 99.6 1 2 253 18 102 DAM35135.1 MAG TPA: portal protein [Bacteriophage sp.] diamond 753 122 1 Viruses               Bacteriophage sp.
27073551 27073551 PRJNA1247234_P_NODE_16502_length_279_cov_0.922330_g16346_i0 PRJNA1247234 16502 279 0.92233 2.5733007 Caudoviricetes sp. 2832643 Viruses Viruses 75.1 5.09e-15   NR DAX54019.1 2832643 g16346 i0 83.7 0.462365591397849 43 7 46.2 0 2 130 75 117 DAX54019.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 129 75.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27515957 27515957 PRJNA1247234_P_NODE_8123_length_371_cov_0.768456_g7967_i0 PRJNA1247234 8123 371 0.768456 2.85097176 Caudoviricetes sp. 2832643 Viruses Viruses 55.5 2.12e-6   NR DAQ94204.1 2832643 g7967 i0 53.5 0.347708894878706 43 18 34 2 140 15 69 110 DAQ94204.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 129 55.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27534052 27534052 PRJNA1247234_P_NODE_23923_length_248_cov_0.862857_g23767_i0 PRJNA1247234 23923 248 0.862857 2.13988536 Viruses 10239 Viruses Viruses 71.2 2.22e-13   NR DAE22273.1 2826552 g23767 i0 47.1 2.16532258064516 68 36 82.3 0 204 1 1 68 DAE22273.1 MAG TPA: putative zinc-ribbon domain protein [Podoviridae sp. ctKS020] diamond 537 71.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Podoviridae sp. ctKS020
27579056 27579056 PRJNA1247234_P_NODE_27744_length_242_cov_0.923077_g27588_i0 PRJNA1247234 27744 242 0.923077 2.23384634 Bacteriophage Phi NF-1 2900273 Viruses Viruses 151 3e-43   NR UMO77818.1 2900273 g27588 i0 83.8 0.991735537190083 80 13 99.2 0 240 1 100 179 UMO77818.1 putative phosphodiesterase [Bacteriophage Phi NF-1] diamond 240 151 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autoscriptoviridae Catalonvirus Catalonvirus NF1
27674009 27674009 PRJNA1247234_P_NODE_23704_length_248_cov_0.891429_g23548_i0 PRJNA1247234 23704 248 0.891429 2.21074392 Caudoviricetes sp. 2832643 Viruses Viruses 93.6 5.19e-20   NR DAV01301.1 2832643 g23548 i0 56.8 2.93951612903226 81 33 98 1 6 248 9 87 DAV01301.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 729 93.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28715868 28715868 PRJNA1247234_P_NODE_6687_length_402_cov_0.869301_g6531_i0 PRJNA1247234 6687 402 0.869301 3.49459002 Caudoviricetes sp. 2832643 Viruses Viruses 208 1.5899999999999998e-66   NR DAN07490.1 2832643 g6531 i0 78.3 0.895522388059702 120 26 89.6 0 39 398 14 133 DAN07490.1 MAG TPA: Protein of unknown function (DUF2833) [Caudoviricetes sp.] diamond 360 208 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29000315 29000315 PRJNA1247234_P_NODE_26548_length_244_cov_0.912281_g26392_i0 PRJNA1247234 26548 244 0.912281 2.22596564 Caudoviricetes sp. 2832643 Viruses Viruses 51.2 3.68e-5   NR DAH72602.1 2832643 g26392 i0 34.8 0.811475409836066 66 43 81.1 0 27 224 103 168 DAH72602.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 198 51.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29144639 29144639 PRJNA1247234_P_NODE_14609_length_293_cov_1.677273_g14453_i0 PRJNA1247234 14609 293 1.677273 4.91440989 Viruses 10239 Viruses Viruses 67 2.07e-10   NR AVM87439.1 2116200 g14453 i0 54.2 2.31399317406143 59 27 60.4 0 116 292 928 986 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 678 67 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Wuhan sharpbelly picornavirus 1
29536695 29536695 PRJNA1247234_P_NODE_25670_length_245_cov_0.906977_g25514_i0 PRJNA1247234 25670 245 0.906977 2.22209365 Shigella phage 2 2736192 Viruses Viruses 46.2 3.88e-4   NR YP_009901454.1 2848074 g25514 i0 42.1 0.697959183673469 57 32 69.8 1 51 221 3 58 YP_009901454.1 hypothetical protein H1N84_gp64 [Shigella phage 2019SD1] diamond 171 46.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Hanrivervirus Hanrivervirus hv2019SD1
30295166 30295166 PRJNA1247234_P_NODE_27992_length_242_cov_0.923077_g27836_i0 PRJNA1247234 27992 242 0.923077 2.23384634 Caudoviricetes sp. 2832643 Viruses Viruses 63.2 1.62e-9   NR DAV74624.1 2832643 g27836 i0 61.7 0.582644628099174 47 18 58.3 0 11 151 242 288 DAV74624.1 MAG TPA: Baseplate protein [Caudoviricetes sp.] diamond 141 63.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30358411 30358411 PRJNA1247234_P_NODE_22112_length_250_cov_1.050847_g21956_i0 PRJNA1247234 22112 250 1.050847 2.6271175 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 6.51e-6   NR DAP34661.1 2832643 g21956 i0 47.4 1.524 57 30 68.4 0 247 77 60 116 DAP34661.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 381 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31400991 31400991 PRJNA1247234_P_NODE_24996_length_246_cov_0.901734_g24840_i0 PRJNA1247234 24996 246 0.901734 2.21826564 Caudoviricetes sp. 2832643 Viruses Viruses 40.4 0.0225   NR DAL54142.1 2832643 g24840 i0 44.7 0.573170731707317 47 18 57.3 1 178 38 1 39 DAL54142.1 MAG TPA_asm: putative lipoprotein [Caudoviricetes sp.] diamond 141 40.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31495875 31495875 PRJNA1247234_P_NODE_28016_length_242_cov_0.917160_g27860_i0 PRJNA1247234 28016 242 0.91716 2.2195272 Caudoviricetes sp. 2832643 Viruses Viruses 53.1 8.07e-7   NR XOQ95425.1 2832643 g27860 i0 44.4 1.48760330578512 54 30 66.9 0 10 171 30 83 XOQ95425.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 360 53.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32854620 32854620 PRJNA1247234_P_NODE_21160_length_252_cov_0.871508_g21004_i0 PRJNA1247234 21160 252 0.871508 2.19620016 Caudoviricetes sp. 2832643 Viruses Viruses 103 6.5099999999999996e-24   NR XOR55036.1 2832643 g21004 i0 64.6 0.94047619047619 79 27 94 1 15 251 2 79 XOR55036.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 237 103 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);;