RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA436017 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
26695895 26695895 PRJNA436017_P_NODE_6541_length_350_cov_1.495208_g6245_i0 PRJNA436017 6541 350 1.495208 5.233228 Shewanella phage FishSpeaker 2985553 Viruses Viruses 227 3.45e-66   NR UYE93527.1 2985553 g6245 i0 89.7 0.994285714285714 116 12 99.4 0 349 2 918 1033 UYE93527.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 348 227 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
26727264 26727264 PRJNA436017_P_NODE_28761_length_152_cov_1.356522_g28463_i0 PRJNA436017 28761 152 1.356522 2.06191344 Shewanella phage FishSpeaker 2985553 Viruses Viruses 50.1 2.79e-5   NR UYE93525.1 2985553 g28463 i0 76.9 0.513157894736842 26 6 51.3 0 2 79 880 905 UYE93525.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 78 50.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
27138666 27138666 PRJNA436017_P_NODE_20502_length_181_cov_0.805556_g20204_i0 PRJNA436017 20502 181 0.805556 1.45805636 Shewanella phage FishSpeaker 2985553 Viruses Viruses 95.5 4.03e-21   NR UYE93541.1 2985553 g20204 i0 66.1 0.977900552486188 59 20 97.8 0 178 2 81 139 UYE93541.1 virion structural protein [Shewanella phage FishSpeaker] diamond 177 95.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
27833858 27833858 PRJNA436017_P_NODE_20444_length_181_cov_1.083333_g20146_i0 PRJNA436017 20444 181 1.083333 1.96083273 Shewanella phage FishSpeaker 2985553 Viruses Viruses 94.7 1.91e-21   NR UYE93544.1 2985553 g20146 i0 64.4 0.977900552486188 59 21 97.8 0 4 180 137 195 UYE93544.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 177 94.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
28339172 28339172 PRJNA436017_P_NODE_14706_length_217_cov_1.300000_g14408_i0 PRJNA436017 14706 217 1.3 2.821 Shewanella phage FishSpeaker 2985553 Viruses Viruses 146 1.35e-41   NR UYE93579.1 2985553 g14408 i0 94.4 0.995391705069124 72 4 99.5 0 1 216 47 118 UYE93579.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 216 146 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
29128726 29128726 PRJNA436017_P_NODE_19009_length_188_cov_1.033113_g18711_i0 PRJNA436017 19009 188 1.033113 1.94225244 Shewanella phage FishSpeaker 2985553 Viruses Viruses 100 1.5699999999999994e-23   NR UYE93511.1 2985553 g18711 i0 80.6 0.98936170212766 62 12 98.9 0 187 2 194 255 UYE93511.1 tail fiber protein [Shewanella phage FishSpeaker] diamond 186 100 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
29317875 29317875 PRJNA436017_P_NODE_11449_length_252_cov_1.813953_g11151_i0 PRJNA436017 11449 252 1.813953 4.57116156 Shewanella phage FishSpeaker 2985553 Viruses Viruses 55.1 1.52e-6   NR UYE93496.1 2985553 g11151 i0 65.8 0.452380952380952 38 13 45.2 0 137 250 1 38 UYE93496.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 114 55.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
29633260 29633260 PRJNA436017_P_NODE_21770_length_175_cov_1.521739_g21472_i0 PRJNA436017 21770 175 1.521739 2.66304325 Shewanella phage FishSpeaker 2985553 Viruses Viruses 94.4 1e-20   NR UYE93525.1 2985553 g21472 i0 77.6 0.994285714285714 58 13 99.4 0 175 2 754 811 UYE93525.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 174 94.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
31118225 31118225 PRJNA436017_P_NODE_18195_length_192_cov_1.509677_g17897_i0 PRJNA436017 18195 192 1.509677 2.89857984 Shewanella phage FishSpeaker 2985553 Viruses Viruses 76.6 2.21e-14   NR UYE93527.1 2985553 g17897 i0 57.8 1 64 26 100 1 1 192 1472 1534 UYE93527.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 192 76.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
31434599 31434599 PRJNA436017_P_NODE_11756_length_248_cov_2.402844_g11458_i0 PRJNA436017 11756 248 2.402844 5.95905312 Shewanella phage FishSpeaker 2985553 Viruses Viruses 73.2 1.45e-13   NR UYE93547.1 2985553 g11458 i0 72.9 0.580645161290323 48 13 58.1 0 173 30 1 48 UYE93547.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 144 73.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
31529722 31529722 PRJNA436017_P_NODE_12476_length_239_cov_1.727723_g12178_i0 PRJNA436017 12476 239 1.727723 4.12925797 Shewanella phage FishSpeaker 2985553 Viruses Viruses 60.1 2.8e-8   NR UYE93527.1 2985553 g12178 i0 58.6 0.728033472803347 58 24 72.8 0 175 2 1087 1144 UYE93527.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 174 60.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
31593038 31593038 PRJNA436017_P_NODE_29436_length_150_cov_2.415929_g29138_i0 PRJNA436017 29436 150 2.415929 3.6238935 Shewanella phage FishSpeaker 2985553 Viruses Viruses 99.8 2.8299999999999993e-24   NR UYE93446.1 2985553 g29138 i0 98 0.98 49 1 98 0 148 2 65 113 UYE93446.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 147 99.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
31719355 31719355 PRJNA436017_P_NODE_16337_length_204_cov_1.389222_g16039_i0 PRJNA436017 16337 204 1.389222 2.83401288 Shewanella phage FishSpeaker 2985553 Viruses Viruses 142 2.01e-37   NR UYE93509.1 2985553 g16039 i0 95.6 1 68 3 100 0 204 1 339 406 UYE93509.1 virion structural protein [Shewanella phage FishSpeaker] diamond 204 142 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
31814246 31814246 PRJNA436017_P_NODE_16477_length_203_cov_1.409639_g16179_i0 PRJNA436017 16477 203 1.409639 2.86156717 Shewanella phage FishSpeaker 2985553 Viruses Viruses 104 3.3e-24   NR UYE93509.1 2985553 g16179 i0 79.1 0.990147783251232 67 14 99 0 3 203 181 247 UYE93509.1 virion structural protein [Shewanella phage FishSpeaker] diamond 201 104 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
32193997 32193997 PRJNA436017_P_NODE_26178_length_159_cov_1.598361_g25880_i0 PRJNA436017 26178 159 1.598361 2.54139399 Shewanella phage FishSpeaker 2985553 Viruses Viruses 86.7 2.14e-20   NR UYE93429.1 2985553 g25880 i0 79.2 1 53 11 100 0 1 159 5 57 UYE93429.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 159 86.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker
32856919 32856919 PRJNA436017_P_NODE_4880_length_414_cov_1.809019_g4584_i0 PRJNA436017 4880 414 1.809019 7.48933866 Shewanella phage FishSpeaker 2985553 Viruses Viruses 60.5 1.69e-7   NR UYE93527.1 2985553 g4584 i0 30.1 1.03623188405797 143 81 97.1 5 414 13 1605 1737 UYE93527.1 hypothetical protein [Shewanella phage FishSpeaker] diamond 429 60.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella phage FishSpeaker

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