RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB28062", tax_phylum = "Preplasmiviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 7 ✖

tax_phylum 1

  • Preplasmiviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB28062 · 7 ✖

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
11190307 11190307 PRJEB28062_P_NODE_118609_length_264_cov_1.602094_g116246_i0 PRJEB28062 118609 264 1.602094 4.22952816 root 1 Root_unresolved Root_unresolved 488 1.5499999999999999e-133   NTclustered gi|2452970428|gb|OQ518271.1| 10515 g116246 i0 100 100 264 0 100 0 1 264 14740 15003 Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome blastn 26400 488 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
16290035 16290035 PRJEB28062_P_NODE_32053_length_649_cov_11.012153_g29752_i0 PRJEB28062 32053 649 11.012153 71.46887297 root 1 Root_unresolved Root_unresolved 1107 0   NTclustered gi|56160492|ref|AC_000007.1| 10515 g29752 i0 100 92.2973805855162 599 0 92 0 24 622 11556 12154 Human adenovirus 2, complete genome blastn 59901 1107 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
18838927 18838927 PRJEB28062_P_NODE_16275_length_942_cov_4.337169_g14361_i0 PRJEB28062 16275 942 4.337169 40.85613198 root 1 Root_unresolved Root_unresolved 1661 0   NTclustered gi|2079660852|emb|OU501478.1| 10515 g14361 i0 100 95.4363057324841 899 0 95 0 22 920 17381 18279 Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE blastn 89901 1661 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
29622214 29622214 PRJEB28062_P_NODE_89790_length_345_cov_15.448529_g87428_i0 PRJEB28062 89790 345 15.448529 53.29742505 Thermus phage phiKo 2301535 Viruses Viruses 53.1 2.7e-6   NR AYJ74683.1 2301535 g87428 i0 45.3 0.652173913043478 75 37 62.6 2 327 112 28 101 AYJ74683.1 hypothetical protein phiKo_08 [Thermus phage phiKo] diamond 225 53.1 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
29843650 29843650 PRJEB28062_P_NODE_108191_length_291_cov_3.504587_g105828_i0 PRJEB28062 108191 291 3.504587 10.19834817 Thermus phage phiKo 2301535 Viruses Viruses 118 1.06e-32   NR AYJ74693.1 2301535 g105828 i0 77.8 0.742268041237113 72 16 74.2 0 274 59 1 72 AYJ74693.1 hypothetical protein phiKo_18 [Thermus phage phiKo] diamond 216 118 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
31265530 31265530 PRJEB28062_P_NODE_46075_length_529_cov_21.065789_g43732_i0 PRJEB28062 46075 529 21.065789 111.43802381 Thermus phage phiKo 2301535 Viruses Viruses 125 2.5899999999999993e-34   NR AYJ74693.1 2301535 g43732 i0 83.3 0.408317580340265 72 12 40.8 0 19 234 1 72 AYJ74693.1 hypothetical protein phiKo_18 [Thermus phage phiKo] diamond 216 125 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
31581950 31581950 PRJEB28062_P_NODE_49536_length_507_cov_8.983871_g47188_i0 PRJEB28062 49536 507 8.983871 45.54822597 Thermus phage phiKo 2301535 Viruses Viruses 49.7 1e-4   NR AYJ74697.1 2301535 g47188 i0 58.5 0.242603550295858 41 15 23.1 1 196 312 31 71 AYJ74697.1 hypothetical protein phiKo_22 [Thermus phage phiKo] diamond 123 49.7 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo

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