RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJEB75017" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 16 ✖

tax_clade 1

bioproject 1

  • PRJEB75017 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
135429 135429 PRJEB75017_P_NODE_921_length_887_cov_1.864865_g820_i0 PRJEB75017 921 887 1.864865 16.54135255 Edafosvirus sp. 2487765 Viruses Viruses 361 1.9599999999999993e-119   NR AYV78014.1 2487765 g820 i0 62.2 3.76099210822999 278 103 94 1 3 836 199 474 AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.] diamond 3336 361 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Edafosvirus sp.
27097307 27097307 PRJEB75017_P_NODE_562_length_1091_cov_1.584479_g485_i0 PRJEB75017 562 1091 1.584479 17.28666589 Inner Mongolia sediment arena-like virus 2824520 Viruses Viruses 135 6.1e-31   NR YP_010840782.1 2824520 g485 i0 26.9 0.98166819431714 357 244 97.3 8 25 1086 213 555 YP_010840782.1 MAG: putative glycoprotein [Inner Mongolia sediment arena-like virus] diamond 1071 135 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Hareavirales Arenaviridae   Inner Mongolia sediment arena-like virus
27255326 27255326 PRJEB75017_P_NODE_13363_length_256_cov_1.486339_g13234_i0 PRJEB75017 13363 256 1.486339 3.80502784 uncultured virus 340016 Viruses Viruses 52.8 1.18e-5   NR CAH6421355.1 340016 g13234 i0 40.5 0.92578125 79 45 91.4 2 6 239 118 195 CAH6421355.1 Hypothetical protein UVM_LOCUS462 [uncultured virus] diamond 237 52.8 1 Viruses               uncultured virus
27413662 27413662 PRJEB75017_P_NODE_14403_length_252_cov_0.871508_g14274_i0 PRJEB75017 14403 252 0.871508 2.19620016 Pseudomonas phage vB_PaeM_PA5oct 2163605 Viruses Viruses 83.6 6.18e-17   NR YP_010679021.1 2163605 g14274 i0 51.9 1.80952380952381 79 38 94 0 245 9 101 179 YP_010679021.1 hypothetical protein PQE65_gp193 [Pseudomonas phage vB_PaeM_PA5oct] diamond 456 83.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Arenbergviridae Wroclawvirus Wroclawvirus PA5oct
27886960 27886960 PRJEB75017_P_NODE_17085_length_245_cov_0.906977_g16956_i0 PRJEB75017 17085 245 0.906977 2.22209365 Vibrio phage VvAW1 1168281 Viruses Viruses 77.8 7.2e-15   NR YP_007518375.1 1168281 g16956 i0 59.4 0.844897959183673 69 24 82 2 243 43 230 296 YP_007518375.1 replication initiation protein [Vibrio phage VvAW1] diamond 207 77.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage VvAW1
29024095 29024095 PRJEB75017_P_NODE_9268_length_298_cov_0.933333_g9139_i0 PRJEB75017 9268 298 0.933333 2.78133234 Cotonvirus japonicus 2811091 Viruses Viruses 72.8 2.06e-12   NR YP_010841863.1 2811091 g9139 i0 41.4 0.996644295302013 99 52 99.7 1 297 1 573 665 YP_010841863.1 hypothetical protein QLL95_gp0868 [Cotonvirus japonicus] diamond 297 72.8 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Cotonvirus Cotonvirus japonicum
29111338 29111338 PRJEB75017_P_NODE_17668_length_244_cov_0.912281_g17539_i0 PRJEB75017 17668 244 0.912281 2.22596564 Mimiviridae 549779 Viruses Viruses 79.3 4.18e-15   NR YP_010781373.1 2126985 g17539 i0 46.9 2.98770491803279 81 32 99.6 2 244 2 273 342 YP_010781373.1 putative histone demethylase [Tupanvirus soda lake] diamond 729 79.7 0.994981179422836 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Tupanvirus Tupanvirus salinum
29591650 29591650 PRJEB75017_P_NODE_8170_length_314_cov_1.941909_g8041_i0 PRJEB75017 8170 314 1.941909 6.09759426 Tupanvirus soda lake 2126985 Viruses Viruses 50.8 9.19e-5   NR YP_010782386.1 2126985 g8041 i0 41.5 0.621019108280255 65 37 61.1 1 194 3 42 106 YP_010782386.1 hypothetical protein QJ857_gp0321 [Tupanvirus soda lake] diamond 195 50.8 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Tupanvirus Tupanvirus salinum
29970970 29970970 PRJEB75017_P_NODE_13251_length_257_cov_1.690217_g13122_i0 PRJEB75017 13251 257 1.690217 4.34385769 Pithovirus sibericum 1450746 Viruses Viruses 55.5 5.85e-7   NR YP_009001323.1 1450746 g13122 i0 46.9 0.747081712062257 64 33 74.7 1 66 257 119 181 YP_009001323.1 transcription initiation factor TFIIB [Pithovirus sibericum] diamond 192 55.5 1 Viruses Pithoviruses           Alphapithovirus Alphapithovirus sibericum
30280119 30280119 PRJEB75017_P_NODE_12712_length_262_cov_1.650794_g12583_i0 PRJEB75017 12712 262 1.650794 4.32508028 Chuvivirus 2842604 Viruses Viruses 105 3.29e-24   NR WET19887.1 2842604 g12583 i0 61.6 1.96946564885496 86 33 98.5 0 260 3 261 346 WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] diamond 516 105 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Chuvivirus
30508103 30508103 PRJEB75017_P_NODE_6333_length_352_cov_1.118280_g6204_i0 PRJEB75017 6333 352 1.11828 3.9363456 Haloquadratum phage sp. 2768784 Viruses Viruses 57.8 1.61e-8   NR UXF50848.1 2768784 g6204 i0 65.3 0.417613636363636 49 17 41.8 0 204 350 1 49 UXF50848.1 MAG: hypothetical protein HQRvContig01_40 [Haloquadratum phage sp.] diamond 147 57.8 1 Viruses               Haloquadratum phage sp.
30634303 30634303 PRJEB75017_P_NODE_7513_length_326_cov_2.407115_g7384_i0 PRJEB75017 7513 326 2.407115 7.8471949 Acanthamoeba castellanii mamavirus 554168 Viruses Viruses 120 1.41e-29   NR AEQ60860.1 554168 g7384 i0 53.8 0.855828220858896 93 43 85.6 0 46 324 28 120 AEQ60860.1 FAD dependent oxidoreductase family protein [Acanthamoeba castellanii mamavirus] diamond 279 120 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Mimivirus Acanthamoeba castellanii mamavirus
31835605 31835605 PRJEB75017_P_NODE_8137_length_315_cov_1.289256_g8008_i0 PRJEB75017 8137 315 1.289256 4.0611564 Terrestrivirus sp. 2487775 Viruses Viruses 96.3 2.3400000000000003e-21   NR AYV76217.1 2487775 g8008 i0 42 1.06666666666667 112 58 100 3 1 315 138 249 AYV76217.1 MAG: DUF3050 domain-containing protein [Terrestrivirus sp.] diamond 336 96.3 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Terrestrivirus sp.
31962294 31962294 PRJEB75017_P_NODE_16218_length_247_cov_0.896552_g16089_i0 PRJEB75017 16218 247 0.896552 2.21448344 Salicola phage SCTP-2 2015814 Viruses Viruses 46.6 0.00154   NR ASV44093.1 2015814 g16089 i0 50 0.510121457489879 42 20 51 1 12 137 253 293 ASV44093.1 dihydrofolate-thymadylate synthase-like protein [Salicola phage SCTP-2] diamond 126 46.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Salicola phage SCTP-2
32493147 32493147 PRJEB75017_P_NODE_8579_length_308_cov_0.995745_g8450_i0 PRJEB75017 8579 308 0.995745 3.0668946 Mimiviridae 549779 Viruses Viruses 111 3.79e-26   NR AEQ60860.1 554168 g8450 i0 47.9 1.81168831168831 94 48 91.6 1 284 3 27 119 AEQ60860.1 FAD dependent oxidoreductase family protein [Acanthamoeba castellanii mamavirus] diamond 558 111 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Mimivirus Acanthamoeba castellanii mamavirus
32595140 32595140 PRJEB75017_P_NODE_7920_length_319_cov_1.268293_g7791_i0 PRJEB75017 7920 319 1.268293 4.04585467 uncultured Caudovirales phage 2100421 Viruses Viruses 64.3 1.27e-9   NR CAB4185846.1 2100421 g7791 i0 33.3 0.987460815047022 105 61 98.7 3 315 1 88 183 CAB4185846.1 Glycosyltransferase, DXD sugar-binding motif [uncultured Caudovirales phage] diamond 315 64.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch

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