RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA900028", tax_phylum = "Preplasmiviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 5 ✖

tax_phylum 1

  • Preplasmiviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA900028 · 5 ✖

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
6349191 6349191 PRJNA900028_P_NODE_29385_length_241_cov_1.328125_g28636_i0 PRJNA900028 29385 241 1.328125 3.20078125 root 1 Root_unresolved Root_unresolved 440 3.959999999999999e-119   NTclustered gi|2452970428|gb|OQ518271.1| 10515 g28636 i0 99.585 99.9958506224066 241 1 100 0 1 241 16944 16704 Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome blastn 24099 440 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
12725055 12725055 PRJNA900028_P_NODE_59510_length_197_cov_2.635135_g58761_i0 PRJNA900028 59510 197 2.635135 5.19121595 root 1 Root_unresolved Root_unresolved 364 1.929999999999999e-96   NTclustered gi|2452970428|gb|OQ518271.1| 10515 g58761 i0 100 100 197 0 100 0 1 197 13251 13055 Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome blastn 19700 364 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
13999324 13999324 PRJNA900028_P_NODE_4351_length_514_cov_4.666667_g3623_i0 PRJNA900028 4351 514 4.666667 23.98666838 root 1 Root_unresolved Root_unresolved 869 0   NTclustered gi|2620236085|gb|OR777220.1| 10515 g3623 i0 98.016 98.0544747081712 504 1 98 1 5 508 14729 15223 Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome blastn 50400 869 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
17823102 17823102 PRJNA900028_P_NODE_70814_length_189_cov_1.271429_g70065_i0 PRJNA900028 70814 189 1.271429 2.40300081 root 1 Root_unresolved Root_unresolved 350 5.14e-92   NTclustered gi|2452970428|gb|OQ518271.1| 10515 g70065 i0 100 100 189 0 100 0 1 189 17989 18177 Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome blastn 18900 350 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
20371540 20371540 PRJNA900028_P_NODE_3316_length_593_cov_3.027574_g2603_i0 PRJNA900028 3316 593 3.027574 17.95351382 root 1 Root_unresolved Root_unresolved 1074 0   NTclustered gi|2452970428|gb|OQ518271.1| 10515 g2603 i0 99.327 100.168634064081 594 3 100 1 1 593 11551 10958 Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome blastn 59400 1079 0.995366079703429 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari

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