RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA745923" and tax_phylum = "Preplasmiviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Preplasmiviricota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA745923 · 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
27084440 27084440 PRJNA745923_S_NODE_37582_length_153_cov_3.054545_g37250_i0 PRJNA745923 37582 153 3.054545 4.67345385 Pimephales minnow adintovirus 2609864 Viruses Viruses 47.8 1.74e-4   NR DAC81400.1 2609864 g37250 i0 44.9 0.96078431372549 49 27 96.1 0 5 151 106 154 DAC81400.1 TPA_asm: penton [Pimephales minnow adintovirus] diamond 147 47.8 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
27242351 27242351 PRJNA745923_S_NODE_33843_length_163_cov_1.200000_g33511_i0 PRJNA745923 33843 163 1.2 1.956 Adintovirus bos4377 3115894 Viruses Viruses 68.6 9.62e-12   NR DBA50499.1 3115894 g33511 i0 66.7 7.91411042944785 54 18 99.4 0 162 1 146 199 DBA50499.1 MAG TPA_asm: PolBb, partial [Adintovirus bos4377] diamond 1290 68.6 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus bos4377
27347375 27347375 PRJNA745923_S_NODE_33523_length_164_cov_0.966942_g33191_i0 PRJNA745923 33523 164 0.966942 1.58578488 Viruses 10239 Viruses Viruses 52.4 4.52e-6   NR DAC81400.1 2609864 g33191 i0 46.3 1.73780487804878 54 27 98.8 1 164 3 32 83 DAC81400.1 TPA_asm: penton [Pimephales minnow adintovirus] diamond 285 52.8 0.992424242424242 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
27716551 27716551 PRJNA745923_S_NODE_31704_length_169_cov_1.134921_g31372_i0 PRJNA745923 31704 169 1.134921 1.91801649 Adintovirus bos4377 3115894 Viruses Viruses 47.4 1.82e-4   NR DBA50495.1 3115894 g31372 i0 46.8 0.834319526627219 47 25 83.4 0 29 169 101 147 DBA50495.1 MAG TPA_asm: Adenain [Adintovirus bos4377] diamond 141 47.4 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus bos4377
27874008 27874008 PRJNA745923_S_NODE_22305_length_206_cov_1.061350_g21973_i0 PRJNA745923 22305 206 1.06135 2.186381 Pimephales minnow adintovirus 2609864 Viruses Viruses 50.1 5.8e-5   NR DAC81401.1 2609864 g21973 i0 44.9 3.01456310679612 69 37 99 1 205 2 192 260 DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] diamond 621 50.4 0.994047619047619 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
28284290 28284290 PRJNA745923_S_NODE_24166_length_197_cov_1.597403_g23834_i0 PRJNA745923 24166 197 1.597403 3.14688391 Pimephales minnow adintovirus 2609864 Viruses Viruses 50.8 2.12e-5   NR DAC81394.1 2609864 g23834 i0 47.6 0.959390862944162 63 33 95.9 0 193 5 26 88 DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] diamond 189 50.8 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
29074031 29074031 PRJNA745923_S_NODE_36348_length_156_cov_2.548673_g36016_i0 PRJNA745923 36348 156 2.548673 3.97592988 Pimephales minnow adintovirus 2609864 Viruses Viruses 79.3 2.45e-16   NR DAC81394.1 2609864 g36016 i0 68.6 0.980769230769231 51 16 98.1 0 1 153 142 192 DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] diamond 153 79.3 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
29137262 29137262 PRJNA745923_S_NODE_20009_length_219_cov_2.181818_g19677_i0 PRJNA745923 20009 219 2.181818 4.77818142 Pimephales minnow adintovirus 2609864 Viruses Viruses 79.3 5.6e-16   NR DAC81394.1 2609864 g19677 i0 58.3 0.986301369863014 72 30 98.6 0 217 2 14 85 DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] diamond 216 79.3 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
29326343 29326343 PRJNA745923_S_NODE_32569_length_166_cov_2.024390_g32237_i0 PRJNA745923 32569 166 2.02439 3.3604874 Adintovirus bos4377 3115894 Viruses Viruses 43.5 0.00647   NR DBA50496.1 3115894 g32237 i0 62.5 0.578313253012048 32 12 57.8 0 3 98 178 209 DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] diamond 96 43.5 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus bos4377
30084232 30084232 PRJNA745923_S_NODE_40292_length_150_cov_1.168224_g39960_i0 PRJNA745923 40292 150 1.168224 1.752336 Adintovirus bos4377 3115894 Viruses Viruses 59.3 9.95e-9   NR DBA50496.1 3115894 g39960 i0 63.8 0.94 47 17 94 0 150 10 112 158 DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] diamond 141 59.3 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus bos4377
30115852 30115852 PRJNA745923_S_NODE_24892_length_194_cov_1.198675_g24560_i0 PRJNA745923 24892 194 1.198675 2.3254295 Adintovirus bos4377 3115894 Viruses Viruses 93.6 9.18e-21   NR DBA50491.1 3115894 g24560 i0 66.7 5.84536082474227 63 21 97.4 0 193 5 42 104 DBA50491.1 MAG TPA_asm: Integrase [Adintovirus bos4377] diamond 1134 93.6 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus bos4377
30369188 30369188 PRJNA745923_S_NODE_34972_length_160_cov_1.230769_g34640_i0 PRJNA745923 34972 160 1.230769 1.9692304 Adintovirus bos4377 3115894 Viruses Viruses 68.2 1.14e-11   NR DBA50491.1 3115894 g34640 i0 60.4 0.99375 53 21 99.4 0 159 1 140 192 DBA50491.1 MAG TPA_asm: Integrase [Adintovirus bos4377] diamond 159 68.2 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus bos4377
30874222 30874222 PRJNA745923_S_NODE_8534_length_359_cov_2.724684_g8202_i0 PRJNA745923 8534 359 2.724684 9.78161556 Pimephales minnow adintovirus 2609864 Viruses Viruses 134 2.17e-36   NR DAC81394.1 2609864 g8202 i0 55.1 1.97214484679666 118 53 98.6 0 358 5 85 202 DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] diamond 708 134 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
31316702 31316702 PRJNA745923_S_NODE_29635_length_175_cov_1.818182_g29303_i0 PRJNA745923 29635 175 1.818182 3.1818185 Adintovirus bos4377 3115894 Viruses Viruses 48.1 9.75e-5   NR DBA50495.1 3115894 g29303 i0 45.8 0.822857142857143 48 26 82.3 0 3 146 124 171 DBA50495.1 MAG TPA_asm: Adenain [Adintovirus bos4377] diamond 144 48.1 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus bos4377
31759459 31759459 PRJNA745923_S_NODE_36837_length_155_cov_1.714286_g36505_i0 PRJNA745923 36837 155 1.714286 2.6571433 Pimephales minnow adintovirus 2609864 Viruses Viruses 52 5.48e-6   NR DAC81400.1 2609864 g36505 i0 62.5 0.619354838709677 32 12 61.9 0 2 97 41 72 DAC81400.1 TPA_asm: penton [Pimephales minnow adintovirus] diamond 96 52 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
32676340 32676340 PRJNA745923_S_NODE_10260_length_324_cov_1.163701_g9928_i0 PRJNA745923 10260 324 1.163701 3.77039124 Pimephales minnow adintovirus 2609864 Viruses Viruses 114 6.57e-29   NR DAC81394.1 2609864 g9928 i0 57.1 0.972222222222222 105 45 97.2 0 315 1 41 145 DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] diamond 315 114 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus

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