RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA397733" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA397733 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
27154918 27154918 PRJNA397733_S_NODE_8522_length_206_cov_2.711864_g8434_i0 PRJNA397733 8522 206 2.711864 5.58643984 Eukaryota 2759 Plants Plants 62.4 2.26e-9   NR KAI3786834.1 185202 g8434 i0 93.5 4.4126213592233 31 2 45.1 0 114 206 71 101 KAI3786834.1 hypothetical protein L1987_40841 [Smallanthus sonchifolius] diamond 909 62.8 0.993630573248408 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Smallanthus Smallanthus sonchifolius
27201606 27201606 PRJNA397733_S_NODE_7502_length_220_cov_5.172775_g7414_i0 PRJNA397733 7502 220 5.172775 11.380105 Tripterygium wilfordii 458696 Plants Plants 55.8 5.08e-7   NR KAF5742819.1 458696 g7414 i0 85.7 0.381818181818182 28 4 38.2 0 136 219 43 70 KAF5742819.1 ras-related protein RABB1c-like [Tripterygium wilfordii] diamond 84 55.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Celastrales Celastraceae Tripterygium Tripterygium wilfordii
27770559 27770559 PRJNA397733_S_NODE_14584_length_160_cov_14.419847_g14496_i0 PRJNA397733 14584 160 14.419847 23.0717552 Anisodus tanguticus 243964 Plants Plants 84.7 3.76e-19   NR KAK4336725.1 243964 g14496 i0 97.6 27.5625 42 1 78.8 0 160 35 110 151 KAK4336725.1 hypothetical protein RND71_043626 [Anisodus tanguticus] diamond 4410 85.1 0.995299647473561 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Anisodus Anisodus tanguticus
28955570 28955570 PRJNA397733_S_NODE_16128_length_153_cov_6.201613_g16040_i0 PRJNA397733 16128 153 6.201613 9.48846789 Eukaryota 2759 Plants Plants 98.6 3.769999999999999e-23   NR XP_028098949.1 4442 g16040 i0 100 1302.96078431373 51 0 100 0 153 1 14 64 XP_028098949.1 ADP-ribosylation factor 1-like [Camellia sinensis] diamond 199353 98.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
29776113 29776113 PRJNA397733_S_NODE_9511_length_195_cov_5.192771_g9423_i0 PRJNA397733 9511 195 5.192771 10.12590345 Eukaryota 2759 Plants Plants 144 4.74e-43   NR KAG0582699.1 3225 g9423 i0 100 575.092307692308 63 0 96.9 0 194 6 38 100 KAG0582699.1 hypothetical protein KC19_3G078100 [Ceratodon purpureus] diamond 112143 145 0.993103448275862 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pseudoditrichales Ditrichaceae Ceratodon Ceratodon purpureus
31149189 31149189 PRJNA397733_S_NODE_8115_length_211_cov_2.983516_g8027_i0 PRJNA397733 8115 211 2.983516 6.29521876 Nelumbo nucifera 4432 Plants Plants 42.7 0.0245   NR XP_010257582.1 4432 g8027 i0 37.3 0.95260663507109 67 35 88.2 2 202 17 338 402 XP_010257582.1 PREDICTED: major facilitator superfamily domain-containing protein 12-like isoform X4 [Nelumbo nucifera] diamond 201 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Proteales Nelumbonaceae Nelumbo Nelumbo nucifera

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