RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA390533" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA390533 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
27328264 27328264 PRJNA390533_P_NODE_44023_length_166_cov_1.188976_g42996_i0 PRJNA390533 44023 166 1.188976 1.97370016 Didymodactylos carnosus 1234261 Rotifera other_Eukaryota 106 3.1300000000000003e-26   NR CAF1558092.1 1234261 g42996 i0 100 1.95180722891566 54 0 97.6 0 164 3 213 266 CAF1558092.1 unnamed protein product, partial [Didymodactylos carnosus] diamond 324 106 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Didymodactylos Didymodactylos carnosus
29002032 29002032 PRJNA390533_P_NODE_31268_length_239_cov_1.080000_g30241_i0 PRJNA390533 31268 239 1.08 2.5812 Adineta ricciae 249248 Rotifera other_Eukaryota 65.9 2.57e-10   NR CAF1487125.1 249248 g30241 i0 41 1.9581589958159 78 41 97.9 4 237 4 1334 1406 CAF1487125.1 unnamed protein product [Adineta ricciae] diamond 468 65.9 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
30896925 30896925 PRJNA390533_P_NODE_21694_length_359_cov_2.565625_g20670_i0 PRJNA390533 21694 359 2.565625 9.21059375 Adineta ricciae 249248 Rotifera other_Eukaryota 55.5 9.4e-7   NR CAF1189022.1 249248 g20670 i0 57.1 0.292479108635098 35 15 29.2 0 23 127 98 132 CAF1189022.1 unnamed protein product [Adineta ricciae] diamond 105 55.5 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae

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