RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA638138" and tax_phylum = "Preplasmiviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Preplasmiviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA638138 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
26891411 26891411 PRJNA638138_P_NODE_3941_length_487_cov_1.101449_g3727_i0 PRJNA638138 3941 487 1.101449 5.36405663 Astyanax tetra cavefish adintovirus 2609866 Viruses Viruses 66.2 2.38e-9   NR DAC81252.1 2609866 g3727 i0 50.9 1.01642710472279 55 27 33.9 0 321 485 1 55 DAC81252.1 TPA_asm: integrase [Astyanax tetra cavefish adintovirus] diamond 495 66.6 0.993993993993994 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Astyanax tetra cavefish adintovirus
27397223 27397223 PRJNA638138_P_NODE_2523_length_599_cov_0.931559_g2311_i0 PRJNA638138 2523 599 0.931559 5.58003841 Adintovirus anguilla10665 3115889 Viruses Viruses 242 4.76e-76   NR DBA49779.1 3115889 g2311 i0 60.5 2.85475792988314 190 75 95.2 0 570 1 159 348 DBA49779.1 MAG TPA_asm: Integrase [Adintovirus anguilla10665] diamond 1710 242 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665
28028678 28028678 PRJNA638138_P_NODE_20605_length_250_cov_0.870056_g20390_i0 PRJNA638138 20605 250 0.870056 2.17514 Astyanax tetra cavefish adintovirus 2609866 Viruses Viruses 42 0.0223   NR DAC81258.1 2609866 g20390 i0 58.1 0.372 31 13 37.2 0 95 3 33 63 DAC81258.1 TPA_asm: gasderminX [Astyanax tetra cavefish adintovirus] diamond 93 42 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Astyanax tetra cavefish adintovirus
28691830 28691830 PRJNA638138_P_NODE_23567_length_249_cov_0.875000_g23352_i0 PRJNA638138 23567 249 0.875 2.17875 Larimichthys croaker adintovirus 2609857 Viruses Viruses 62.4 2.01e-9   NR DAC81316.1 2609857 g23352 i0 42.9 0.674698795180723 56 32 67.5 0 247 80 81 136 DAC81316.1 TPA_asm: FtsK [Larimichthys croaker adintovirus] diamond 168 62.4 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Larimichthys croaker adintovirus
29070700 29070700 PRJNA638138_P_NODE_27728_length_246_cov_0.890173_g27513_i0 PRJNA638138 27728 246 0.890173 2.18982558 Adintovirus pavo15764 3115938 Viruses Viruses 66.2 6.5500000000000006e-11   NR DBA50340.1 3115938 g27513 i0 71.4 0.853658536585366 35 10 42.7 0 140 244 52 86 DBA50340.1 MAG TPA_asm: PacK [Adintovirus pavo15764] diamond 210 66.2 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus pavo15764
29449149 29449149 PRJNA638138_P_NODE_25250_length_247_cov_1.034483_g25035_i0 PRJNA638138 25250 247 1.034483 2.55517301 Astyanax tetra cavefish adintovirus 2609866 Viruses Viruses 75.5 3.31e-14   NR DAC81253.1 2609866 g25035 i0 66 0.607287449392713 50 17 60.7 0 151 2 1 50 DAC81253.1 TPA_asm: penton [Astyanax tetra cavefish adintovirus] diamond 150 75.5 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Astyanax tetra cavefish adintovirus
29954666 29954666 PRJNA638138_P_NODE_8911_length_345_cov_1.466912_g8696_i0 PRJNA638138 8911 345 1.466912 5.0608464 Adintovirus anguilla10665 3115889 Viruses Viruses 82.8 4.89e-17   NR DBA49783.1 3115889 g8696 i0 50 0.678260869565217 78 39 67.8 0 1 234 104 181 DBA49783.1 MAG TPA_asm: Adenain [Adintovirus anguilla10665] diamond 234 82.8 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665
30776216 30776216 PRJNA638138_P_NODE_4954_length_439_cov_2.040984_g4740_i0 PRJNA638138 4954 439 2.040984 8.95991976 Adintovirus anguilla10665 3115889 Viruses Viruses 97.1 6.339999999999999e-23   NR DBA49785.1 3115889 g4740 i0 61.3 0.5125284738041 75 29 51.3 0 1 225 37 111 DBA49785.1 MAG TPA_asm: GasderminX [Adintovirus anguilla10665] diamond 225 97.1 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665
31629670 31629670 PRJNA638138_P_NODE_2716_length_580_cov_0.962525_g2504_i0 PRJNA638138 2716 580 0.962525 5.582645 Adintovirus anguilla10665 3115889 Viruses Viruses 134 5.259999999999998e-35   NR DAC81257.1 3115889 g2504 i0 45.9 0.76551724137931 148 73 72.9 1 579 157 106 253 DAC81257.1 TPA_asm: acintoc2 [Astyanax tetra cavefish adintovirus] diamond 444 134 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665
31756138 31756138 PRJNA638138_P_NODE_18457_length_256_cov_0.983607_g18242_i0 PRJNA638138 18457 256 0.983607 2.51803392 Larimichthys croaker adintovirus 2609857 Viruses Viruses 86.7 1.53e-17   NR DBA47698.1 2609857 g18242 i0 69.8 6.22265625 53 16 62.1 0 3 161 987 1039 DBA47698.1 MAG TPA_asm: PolBb [Adintovirus homo13306] diamond 1593 87.4 0.991990846681922 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Larimichthys croaker adintovirus
32009282 32009282 PRJNA638138_P_NODE_1198_length_831_cov_1.100264_g1010_i0 PRJNA638138 1198 831 1.100264 9.14319384 Adintovirus anguilla10665 3115889 Viruses Viruses 128 7.61e-32   NR DBA49780.1 3115889 g1010 i0 52.4 0.447653429602888 124 57 44.4 2 765 397 109 231 DBA49780.1 MAG TPA_asm: Penton [Adintovirus anguilla10665] diamond 372 128 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665
32199151 32199151 PRJNA638138_P_NODE_4878_length_443_cov_0.897297_g4664_i0 PRJNA638138 4878 443 0.897297 3.97502571 Adintovirus anguilla10665 3115889 Viruses Viruses 136 5.6199999999999996e-34   NR DBA49787.1 3115889 g4664 i0 58.3 2.09255079006772 103 43 69.8 0 3 311 51 153 DBA49787.1 MAG TPA_asm: PolBb [Adintovirus anguilla10665] diamond 927 136 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665

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