RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA207719" and tax_clade = "Embryophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Embryophyta · 5 ✖

bioproject 1

  • PRJNA207719 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
4884002 4884002 PRJNA207719_P_NODE_964_length_193_cov_7.579268_g944_i0 PRJNA207719 964 193 7.579268 14.62798724 root 1 Root_unresolved Root_unresolved 54.7 0.005   NTclustered gi|1241299067|gb|KY965816.2| 149440 g944 i0 100 0.735751295336788 29 0 15 0 1 29 106092 106064 Lasthenia californica chloroplast blastn 142 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lasthenia Lasthenia californica
5470426 5470426 PRJNA207719_P_NODE_1085_length_178_cov_14.476510_g1065_i0 PRJNA207719 1085 178 14.47651 25.7681878 Hordeum vulgare 4513 Plants Plants 329 6.21e-86   NTclustered gi|2133473874|ref|XR_006616617.1| 112509 g1065 i0 100 1119.78651685393 178 0 100 0 1 178 1450 1273 PREDICTED: Hordeum vulgare subsp. vulgare 28S ribosomal RNA (LOC123417155), rRNA blastn 199322 329 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
15669874 15669874 PRJNA207719_P_NODE_713_length_235_cov_9.077670_g693_i0 PRJNA207719 713 235 9.07767 21.3325245 Justicia demissa 1685546 Plants Plants 435 1.79e-117   NTclustered gi|2482680364|gb|OQ785890.1| 1685546 g693 i0 100 105.676595744681 235 0 100 0 1 235 5073 4839 Justicia demissa small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 24834 435 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Acanthaceae Justicia Justicia demissa
18907492 18907492 PRJNA207719_P_NODE_215_length_467_cov_6.915525_g195_i0 PRJNA207719 215 467 6.915525 32.29550175 Eukaryota 2759 Plants Plants 521 2.879999999999999e-143   NTclustered gi|6273812|gb|AF168852.1| 4517 g195 i0 100 2212.6852248394 282 0 93 0 186 467 290 9 Hordeum jubatum 18S small subunit ribosomal RNA gene, partial sequence blastn 1033324 521 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum jubatum
22732810 22732810 PRJNA207719_P_NODE_1158_length_171_cov_2.690141_g1138_i0 PRJNA207719 1158 171 2.690141 4.60014111 Ananas 4614 Plants Plants 126 8.32e-25   NTclustered gi|1147599615|ref|XM_020248139.1| 4615 g1138 i0 83.704 42.2222222222222 135 20 78 2 31 164 425 292 PREDICTED: Ananas comosus 60S ribosomal protein L10-like (LOC109720811), mRNA blastn 7220 126 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Bromeliaceae Ananas Ananas comosus

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