RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Preplasmiviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Preplasmiviricota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1148190 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
18144338 18144338 PRJNA1148190_P_NODE_232095_length_354_cov_0.914591_g220925_i0 PRJNA1148190 232095 354 0.914591 3.23765214 Bos-associated insect adintovirus 2 2609867 Viruses Viruses 74.7 1.72e-13   NR DAC81269.1 2609867 g220925 i0 62 0.423728813559322 50 19 42.4 0 354 205 179 228 DAC81269.1 TPA_asm: FtsK [Bos-associated insect adintovirus 2] diamond 150 74.7 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Bos-associated insect adintovirus 2
27513043 27513043 PRJNA1148190_P_NODE_111443_length_502_cov_2.438228_g100282_i0 PRJNA1148190 111443 502 2.438228 12.23990456 Adintovirus macaca128 3115921 Viruses Viruses 129 9.67e-34   NR DBA46383.1 3115921 g100282 i0 64 3.16733067729084 86 31 51.4 0 491 234 136 221 DBA46383.1 MAG TPA_asm: PacK [Adintovirus macaca12800] diamond 1590 129 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus macaca12800
27545072 27545072 PRJNA1148190_P_NODE_375544_length_291_cov_2.119266_g364371_i0 PRJNA1148190 375544 291 2.119266 6.16706406 Enterobacteria phage PRD1 10658 Viruses Viruses 81.6 3.08e-16   NR YP_009639979.1 10658 g364371 i0 66.7 1.23711340206186 60 19 61.9 1 2 181 57 115 YP_009639979.1 transglycosylase [Enterobacteria phage PRD1] diamond 360 81.6 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae Alphatectivirus Alphatectivirus PRD1
28997510 28997510 PRJNA1148190_P_NODE_226388_length_357_cov_1.637324_g215218_i0 PRJNA1148190 226388 357 1.637324 5.84524668 Lake Baikal virophage 14 3086119 Viruses Viruses 72.4 1.77e-12   NR WPF46841.1 3086119 g215218 i0 44.7 0.638655462184874 76 42 63.9 0 6 233 174 249 WPF46841.1 MAG: putative packaging ATPase [Lake Baikal virophage 14] diamond 228 72.4 1 Viruses   Bamfordvirae Preplasmiviricota Virophaviricetes Priklausovirales Lavidaviridae   Lake Baikal virophage 14
29629146 29629146 PRJNA1148190_P_NODE_71610_length_657_cov_1.311644_g60518_i0 PRJNA1148190 71610 657 1.311644 8.61750108 Lake Baikal virophage 9 3086132 Viruses Viruses 55.5 4.35e-5   NR WPF46697.1 3086132 g60518 i0 30.4 0.616438356164384 135 69 51.6 6 305 643 7 138 WPF46697.1 MAG: putative minor capsid protein [Lake Baikal virophage 9] diamond 405 55.5 1 Viruses   Bamfordvirae Preplasmiviricota Virophaviricetes Priklausovirales Lavidaviridae   Lake Baikal virophage 9
29755510 29755510 PRJNA1148190_P_NODE_637771_length_248_cov_1.497143_g626598_i0 PRJNA1148190 637771 248 1.497143 3.71291464 Bos-associated insect adintovirus 2 2609867 Viruses Viruses 73.2 4.2e-13   NR DAC81267.1 2609867 g626598 i0 67.3 0.629032258064516 52 16 61.7 1 153 1 194 245 DAC81267.1 TPA_asm: integrase [Bos-associated insect adintovirus 2] diamond 156 73.2 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Bos-associated insect adintovirus 2
30797679 30797679 PRJNA1148190_P_NODE_357634_length_298_cov_0.986667_g346461_i0 PRJNA1148190 357634 298 0.986667 2.94026766 Adintovirus macaca128 3115921 Viruses Viruses 75.5 6.36e-14   NR DBA46383.1 3115921 g346461 i0 73.8 0.422818791946309 42 11 42.3 0 98 223 206 247 DBA46383.1 MAG TPA_asm: PacK [Adintovirus macaca12800] diamond 126 75.5 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus macaca12800
30893201 30893201 PRJNA1148190_P_NODE_656034_length_247_cov_1.672414_g644861_i0 PRJNA1148190 656034 247 1.672414 4.13086258 Adintovirus sus1 3115948 Viruses Viruses 75.9 2.28e-15   NR DBA49357.1 3115948 g644861 i0 62.1 0.704453441295547 58 22 70.4 0 246 73 71 128 DBA49357.1 MAG TPA_asm: Adenain, partial [Adintovirus sus10555] diamond 174 75.9 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus sus10555
30924391 30924391 PRJNA1148190_P_NODE_363014_length_296_cov_1.035874_g351841_i0 PRJNA1148190 363014 296 1.035874 3.06618704 Lake Baikal virophage 2 3086125 Viruses Viruses 45.8 0.00568   NR WPF46440.1 3086125 g351841 i0 32.7 1.05405405405405 104 61 97.3 3 296 9 51 153 WPF46440.1 MAG: putative major capsid protein [Lake Baikal virophage 2] diamond 312 45.8 1 Viruses   Bamfordvirae Preplasmiviricota Virophaviricetes Priklausovirales Lavidaviridae   Lake Baikal virophage 2
30956233 30956233 PRJNA1148190_P_NODE_540254_length_259_cov_1.241935_g529081_i0 PRJNA1148190 540254 259 1.241935 3.21661165 Bos-associated insect adintovirus 2 2609867 Viruses Viruses 54.7 2.9e-6   NR DAC81262.1 2609867 g529081 i0 38.4 0.845559845559846 73 45 84.6 0 235 17 12 84 DAC81262.1 TPA_asm: PolB [Bos-associated insect adintovirus 2] diamond 219 54.7 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Bos-associated insect adintovirus 2
31588795 31588795 PRJNA1148190_P_NODE_690916_length_246_cov_0.890173_g679743_i0 PRJNA1148190 690916 246 0.890173 2.18982558 Adintovirus macaca128 3115921 Viruses Viruses 115 1.2799999999999999e-28   NR DBA46384.1 3115921 g679743 i0 81.1 1.80487804878049 74 14 90.2 0 16 237 188 261 DBA46384.1 MAG TPA_asm: PLA2X-Adenain [Adintovirus macaca12800] diamond 444 115 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus macaca12800
32285054 32285054 PRJNA1148190_P_NODE_745099_length_243_cov_0.905882_g733926_i0 PRJNA1148190 745099 243 0.905882 2.20129326 Adintovirus macaca128 3115921 Viruses Viruses 53.9 3.17e-6   NR DBA46383.1 3115921 g733926 i0 50 0.641975308641975 52 26 64.2 0 44 199 204 255 DBA46383.1 MAG TPA_asm: PacK [Adintovirus macaca12800] diamond 156 53.9 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus macaca12800
32442080 32442080 PRJNA1148190_P_NODE_104739_length_521_cov_1.017857_g93582_i0 PRJNA1148190 104739 521 1.017857 5.30303497 Enterobacteria phage PRDaquamarine 3127581 Viruses Viruses 56.2 4.19e-6   NR WWT37740.1 3127581 g93582 i0 50 0.886756238003839 54 27 31.1 0 284 445 108 161 WWT37740.1 assembly protein [Enterobacteria phage PRDaquamarine] diamond 462 56.2 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Enterobacteria phage PRDaquamarine
32599921 32599921 PRJNA1148190_P_NODE_1120_length_14380_cov_5.234431_g590_i0 PRJNA1148190 1120 14380 5.234431 752.7111778 Lake Baikal virophage 11 3086116 Viruses Viruses 93.6 9.770000000000001e-16   NR WPF46733.1 3086116 g590 i0 24.4 0.0675938803894298 324 214 6.6 9 3386 4330 11 312 WPF46733.1 MAG: hypothetical protein [Lake Baikal virophage 11] diamond 972 93.6 1 Viruses   Bamfordvirae Preplasmiviricota Virophaviricetes Priklausovirales Lavidaviridae   Lake Baikal virophage 11
32789529 32789529 PRJNA1148190_P_NODE_643480_length_248_cov_0.880000_g632307_i0 PRJNA1148190 643480 248 0.88 2.1824 Adintovirus panthera8 3115937 Viruses Viruses 65.1 2.1e-10   NR DBA50800.1 3115937 g632307 i0 41.3 0.967741935483871 80 42 90.7 2 226 2 114 193 DBA50800.1 MAG TPA_asm: Penton [Adintovirus panthera8025] diamond 240 65.1 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus panthera8025

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