RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJEB14803", tax_phylum = "Preplasmiviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 11 ✖

tax_phylum 1

  • Preplasmiviricota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14803 · 11 ✖

analysis 1

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
27349408 27349408 PRJEB14803_P_NODE_25023_length_223_cov_1.180851_g24557_i0 PRJEB14803 25023 223 1.180851 2.63329773 Pimephales minnow adintovirus 2609864 Viruses Viruses 85.1 2.13e-19   NR DAC81395.1 2609864 g24557 i0 55.4 0.995515695067265 74 33 99.6 0 2 223 15 88 DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus] diamond 222 85.1 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
28422933 28422933 PRJEB14803_P_NODE_15406_length_307_cov_5.761029_g14940_i0 PRJEB14803 15406 307 5.761029 17.68635903 Pimephales minnow adintovirus 2609864 Viruses Viruses 90.9 1.49e-19   NR DAC81400.1 2609864 g14940 i0 45.5 0.986970684039088 101 55 98.7 0 303 1 93 193 DAC81400.1 TPA_asm: penton [Pimephales minnow adintovirus] diamond 303 90.9 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
29457977 29457977 PRJEB14803_P_NODE_2030_length_1008_cov_3.526208_g1779_i0 PRJEB14803 2030 1008 3.526208 35.54417664 Viruses 10239 Viruses Viruses 223 2.1e-66   NR DAC81401.1 2609864 g1779 i0 63.1 2 168 62 50 0 505 1008 1 168 DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] diamond 2016 223 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
30159235 30159235 PRJEB14803_P_NODE_23672_length_231_cov_1.658163_g23206_i0 PRJEB14803 23672 231 1.658163 3.83035653 Pimephales minnow adintovirus 2609864 Viruses Viruses 99.4 1.05e-22   NR DAC81401.1 2609864 g23206 i0 70.7 2.92207792207792 75 22 97.4 0 6 230 19 93 DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] diamond 675 99.4 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
30222619 30222619 PRJEB14803_P_NODE_37692_length_172_cov_0.956204_g37226_i0 PRJEB14803 37692 172 0.956204 1.64467088 Pimephales minnow adintovirus 2609864 Viruses Viruses 67.4 1.05e-11   NR DAC81394.1 2609864 g37226 i0 50 0.976744186046512 56 28 97.7 0 2 169 41 96 DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] diamond 168 67.4 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
30412552 30412552 PRJEB14803_P_NODE_18613_length_271_cov_3.012712_g18147_i0 PRJEB14803 18613 271 3.012712 8.16444952 Adintovirus bos4377 3115894 Viruses Viruses 98.6 6.25e-23   NR DBA50496.1 3115894 g18147 i0 57.3 0.985239852398524 89 38 98.5 0 269 3 116 204 DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] diamond 267 98.6 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus bos4377
30475572 30475572 PRJEB14803_P_NODE_40693_length_164_cov_1.108527_g40227_i0 PRJEB14803 40693 164 1.108527 1.81798428 Pimephales minnow adintovirus 2609864 Viruses Viruses 77.8 3.94e-15   NR DAC81401.1 2609864 g40227 i0 75.9 1.97560975609756 54 13 98.8 0 162 1 159 212 DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] diamond 324 77.8 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
31739662 31739662 PRJEB14803_P_NODE_20517_length_254_cov_4.981735_g20051_i0 PRJEB14803 20517 254 4.981735 12.6536069 Pimephales minnow adintovirus 2609864 Viruses Viruses 75.1 6.77e-14   NR DAC81400.1 2609864 g20051 i0 39.8 0.980314960629921 83 50 98 0 2 250 36 118 DAC81400.1 TPA_asm: penton [Pimephales minnow adintovirus] diamond 249 75.1 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
32151179 32151179 PRJEB14803_P_NODE_19958_length_259_cov_3.366071_g19492_i0 PRJEB14803 19958 259 3.366071 8.71812389 Pimephales minnow adintovirus 2609864 Viruses Viruses 90.1 3.5e-21   NR DAC81395.1 2609864 g19492 i0 62.4 0.984555984555985 85 32 98.5 0 257 3 4 88 DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus] diamond 255 90.1 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
32182844 32182844 PRJEB14803_P_NODE_14138_length_325_cov_2.255172_g13673_i0 PRJEB14803 14138 325 2.255172 7.329309 Adintovirus bos4377 3115894 Viruses Viruses 67 1.26e-10   NR DBA50496.1 3115894 g13673 i0 59.7 0.618461538461539 67 27 61.8 0 231 31 142 208 DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] diamond 201 67 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus bos4377
32309678 32309678 PRJEB14803_P_NODE_5799_length_571_cov_3.500000_g964_i2 PRJEB14803 5799 571 3.5 19.985 Adintovirus bos4377 3115894 Viruses Viruses 105 7.13e-25   NR DBA50495.1 3115894 g964 i2 38.1 0.882661996497373 168 104 88.3 0 569 66 3 170 DBA50495.1 MAG TPA_asm: Adenain [Adintovirus bos4377] diamond 504 105 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus bos4377

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