RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1139127" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 11 ✖

bioproject 1

  • PRJNA1139127 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
27323309 27323309 PRJNA1139127_P_NODE_29963_length_321_cov_1.193548_g29471_i0 PRJNA1139127 29963 321 1.193548 3.83128908 Caudoviricetes sp. 2832643 Viruses Viruses 204 2.19e-59   NR XOR55186.1 2832643 g29471 i0 89.7 1 107 11 100 0 321 1 587 693 XOR55186.1 MAG: intein-containing putative ribonucleoside diphosphate reductase alpha subunit precursor [Caudoviricetes sp.] diamond 321 204 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27418293 27418293 PRJNA1139127_P_NODE_25723_length_356_cov_1.098940_g25231_i0 PRJNA1139127 25723 356 1.09894 3.9122264 Malassezia globosa associated totivirus 1 3048756 Viruses Viruses 156 1.12e-41   NR CAI9858973.1 3048756 g25231 i0 64.4 0.99438202247191 118 42 99.4 0 1 354 10 127 CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] diamond 354 156 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia globosa associated totivirus 1
28175647 28175647 PRJNA1139127_P_NODE_22046_length_397_cov_1.364198_g21555_i0 PRJNA1139127 22046 397 1.364198 5.41586606 Staphylococcus phage vB_StaM_PB5 2944247 Viruses Viruses 90.1 6.01e-18   NR WPH64261.1 3093914 g21555 i0 42.1 0.861460957178841 114 62 84.6 2 336 1 1733 1844 WPH64261.1 hypothetical protein [Staphylococcus phage vB_StaM_PB50] diamond 342 90.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage vB_StaM_PB50
29996422 29996422 PRJNA1139127_P_NODE_33051_length_299_cov_1.380531_g32558_i0 PRJNA1139127 33051 299 1.380531 4.12778769 Chloriridovirus 10491 Viruses Viruses 121 4.36e-30   NR YP_009010883.1 345198 g32558 i0 72 1.87625418060201 93 23 92.3 2 277 2 325 415 YP_009010883.1 Immediate early protein ICP-46 [Invertebrate iridescent virus 22] diamond 561 121 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae Chloriridovirus Chloriridovirus simulium1
30481182 30481182 PRJNA1139127_P_NODE_46833_length_245_cov_0.906977_g46340_i0 PRJNA1139127 46833 245 0.906977 2.22209365 Saccharomyces 2 3431059 Viruses Viruses 139 5.5e-36   NR NP_660178.1 186772 g46340 i0 82.7 0.991836734693878 81 14 99.2 0 2 244 63 143 NP_660178.1 RNA-dependent RNA polymerase [Saccharomyces 20S RNA narnavirus] diamond 243 139 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Narnavirus saccharominor
31144199 31144199 PRJNA1139127_P_NODE_5115_length_1009_cov_2.259615_g4788_i0 PRJNA1139127 5115 1009 2.259615 22.79951535 Hubei partiti-like virus 48 1923056 Viruses Viruses 273 7.31e-85   NR APG78218.1 1923056 g4788 i0 42.9 2.8780971258672 324 179 95.1 4 48 1007 12 333 APG78218.1 RdRp [Hubei partiti-like virus 48] diamond 2904 273 1 Viruses               Hubei partiti-like virus 48
31175949 31175949 PRJNA1139127_P_NODE_40875_length_257_cov_1.733696_g40382_i0 PRJNA1139127 40875 257 1.733696 4.45559872 Riboviria sp. 2585031 Viruses Viruses 60.1 3.33e-8   NR WWV90560.1 2585031 g40382 i0 43.2 0.863813229571984 74 41 85.2 1 24 242 334 407 WWV90560.1 MAG: hypothetical protein, partial [Riboviria sp.] diamond 222 60.1 1 Viruses               Riboviria sp.
31397735 31397735 PRJNA1139127_P_NODE_1436_length_1806_cov_2.743797_g1314_i0 PRJNA1139127 1436 1806 2.743797 49.55297382 Staphylococcus phage Madawaska 2797424 Viruses Viruses 457 2.48e-139   NR QQO92742.1 2797424 g1314 i0 45.5 1.03986710963455 626 281 99.7 14 1 1800 1133 1724 QQO92742.1 tape measure protein [Staphylococcus phage Madawaska] diamond 1878 457 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage Madawaska
31682052 31682052 PRJNA1139127_P_NODE_45397_length_247_cov_1.333333_g44904_i0 PRJNA1139127 45397 247 1.333333 3.29333251 Staphylococcus phage vB_StaM_SA1 2785444 Viruses Viruses 55.5 1.34e-6   NR QPI17073.1 2785444 g44904 i0 59.3 0.65587044534413 54 18 65.6 1 163 2 347 396 QPI17073.1 tail tape measure protein [Staphylococcus phage vB_StaM_SA1] diamond 162 55.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage vB_StaM_SA1
32220168 32220168 PRJNA1139127_P_NODE_47078_length_245_cov_0.901163_g46585_i0 PRJNA1139127 47078 245 0.901163 2.20784935 Malassezia globosa associated totivirus 1 3048756 Viruses Viruses 88.2 3.82e-18   NR CAI9858974.1 3048756 g46585 i0 82 0.612244897959184 50 9 61.2 0 243 94 638 687 CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] diamond 150 88.2 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia globosa associated totivirus 1
32599707 32599707 PRJNA1139127_P_NODE_13440_length_560_cov_1.414784_g12961_i0 PRJNA1139127 13440 560 1.414784 7.9227904 Staphylococcus phage Machias 2797423 Viruses Viruses 53.9 1.11e-4   NR QQO92481.1 2797423 g12961 i0 59.2 0.2625 49 20 26.3 0 414 560 1014 1062 QQO92481.1 tape measure protein [Staphylococcus phage Machias] diamond 147 53.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage Machias

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