RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1245487" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1245487 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
27168192 27168192 PRJNA1245487_P_NODE_4162_length_615_cov_1.990775_g3832_i0 PRJNA1245487 4162 615 1.990775 12.24326625 Adineta ricciae 249248 Rotifera other_Eukaryota 111 3.42e-27   NR CAF0829117.1 249248 g3832 i0 36 1.4780487804878 150 91 72.7 3 572 126 6 151 CAF0829117.1 unnamed protein product [Adineta ricciae] diamond 909 111 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
31640242 31640242 PRJNA1245487_P_NODE_18236_length_260_cov_1.663102_g17898_i0 PRJNA1245487 18236 260 1.663102 4.3240652 Eurotatoria 2816136 Rotifera other_Eukaryota 128 3.6899999999999996e-32   NR CAF0976413.1 433720 g17898 i0 80.2 2.97692307692308 86 11 99.2 3 2 259 416 495 CAF0976413.1 unnamed protein product [Adineta steineri] diamond 774 129 0.992248062015504 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta steineri
31970106 31970106 PRJNA1245487_P_NODE_19398_length_252_cov_0.871508_g19060_i0 PRJNA1245487 19398 252 0.871508 2.19620016 Didymodactylos carnosus 1234261 Rotifera other_Eukaryota 61.6 9.04e-9   NR CAF1036413.1 1234261 g19060 i0 50 3.47619047619048 58 29 69 0 3 176 186 243 CAF1036413.1 unnamed protein product, partial [Didymodactylos carnosus] diamond 876 61.6 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Didymodactylos Didymodactylos carnosus
32728791 32728791 PRJNA1245487_P_NODE_9180_length_399_cov_1.797546_g8842_i0 PRJNA1245487 9180 399 1.797546 7.17220854 Rotaria sp. Silwood2 2762512 Rotifera other_Eukaryota 104 5.67e-26   NR CAF3440507.1 2762512 g8842 i0 73.5 0.511278195488722 68 18 51.1 0 33 236 1 68 CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2] diamond 204 104 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sp. Silwood2

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