RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA725806" and tax_phylum = "Nucleocytoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nucleocytoviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA725806 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
26767444 26767444 PRJNA725806_P_NODE_78141_length_215_cov_3.893258_g77840_i0 PRJNA725806 78141 215 3.893258 8.3705047 Androctonus mauritanicus toursvirus 3394651 Viruses Viruses 73.9 1.63e-13   NR XNL98191.1 3394651 g77840 i0 76.9 0.544186046511628 39 9 54.4 0 137 21 11 49 XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] diamond 117 73.9 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Ascoviridae Toursvirus Androctonus mauritanicus toursvirus
27652696 27652696 PRJNA725806_P_NODE_3924_length_469_cov_2.379630_g3655_i0 PRJNA725806 3924 469 2.37963 11.1604647 Androctonus mauritanicus toursvirus 3394651 Viruses Viruses 180 6.42e-53   NR XNL98191.1 3394651 g3655 i0 67 0.735607675906183 115 38 73.6 0 378 34 119 233 XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] diamond 345 180 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Ascoviridae Toursvirus Androctonus mauritanicus toursvirus
28157966 28157966 PRJNA725806_P_NODE_143885_length_171_cov_7.723881_g143583_i0 PRJNA725806 143885 171 7.723881 13.20783651 Androctonus mauritanicus toursvirus 3394651 Viruses Viruses 52 7.27e-6   NR XNL98191.1 3394651 g143583 i0 54.5 1.47368421052632 33 15 57.9 0 53 151 270 302 XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] diamond 252 52 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Ascoviridae Toursvirus Androctonus mauritanicus toursvirus
29231369 29231369 PRJNA725806_P_NODE_112689_length_188_cov_13.105960_g112387_i0 PRJNA725806 112689 188 13.10596 24.6392048 Androctonus mauritanicus toursvirus 3394651 Viruses Viruses 63.9 4.98e-10   NR XNL98191.1 3394651 g112387 i0 52.9 0.813829787234043 51 22 78.2 1 148 2 270 320 XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] diamond 153 63.9 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Ascoviridae Toursvirus Androctonus mauritanicus toursvirus
30020839 30020839 PRJNA725806_P_NODE_138271_length_174_cov_4.204380_g137969_i0 PRJNA725806 138271 174 4.20438 7.3156212 Androctonus mauritanicus toursvirus 3394651 Viruses Viruses 66.6 4.47e-11   NR XNL98191.1 3394651 g137969 i0 53.1 0.844827586206897 49 23 84.5 0 13 159 273 321 XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] diamond 147 66.6 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Ascoviridae Toursvirus Androctonus mauritanicus toursvirus
30494749 30494749 PRJNA725806_P_NODE_82833_length_211_cov_2.247126_g82532_i0 PRJNA725806 82833 211 2.247126 4.74143586 Cafeteria roenbergensis virus BV-PW1 693272 Viruses Viruses 43.1 0.0173   NR YP_003969900.1 693272 g82532 i0 39.6 0.753554502369668 53 30 72.5 1 48 200 182 234 YP_003969900.1 hypothetical protein crov268 [Cafeteria roenbergensis virus BV-PW1] diamond 159 43.1 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Rheavirus Rheavirus sinusmexicani

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