RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA981359" 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 · 6 ✖

bioproject 1

  • PRJNA981359 · 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
27279256 27279256 PRJNA981359_S_NODE_66903_length_250_cov_0.881356_g66803_i0 PRJNA981359 66903 250 0.881356 2.20339 Forsythia ovata 205694 Plants Plants 70.1 8.38e-13   NR KAL2548042.1 205694 g66803 i0 53.2 0.744 62 20 74.4 1 1 186 14 66 KAL2548042.1 Rapid ALkalinization Factor [Forsythia ovata] diamond 186 70.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Forsythia Forsythia ovata
29363238 29363238 PRJNA981359_S_NODE_58889_length_263_cov_2.052632_g58789_i0 PRJNA981359 58889 263 2.052632 5.39842216 Selaginella moellendorffii 88036 Plants Plants 55.1 5.3e-7   NR XP_024515236.1 88036 g58789 i0 44.9 0.787072243346008 69 35 78.7 1 39 245 90 155 XP_024515236.1 histone H3.3 isoform X1 [Selaginella moellendorffii] diamond 207 55.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Selaginellales Selaginellaceae Selaginella Selaginella moellendorffii
29805131 29805131 PRJNA981359_S_NODE_70351_length_245_cov_2.994186_g70251_i0 PRJNA981359 70351 245 2.994186 7.3357557 Brachypodium distachyon 15368 Plants Plants 42.7 0.0385   NR XP_024318770.1 15368 g70251 i0 32.7 0.636734693877551 52 33 63.7 1 184 29 725 774 XP_024318770.1 putative receptor protein kinase ZmPK1 isoform X2 [Brachypodium distachyon] diamond 156 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Brachypodium Brachypodium distachyon
30120949 30120949 PRJNA981359_S_NODE_54652_length_271_cov_2.550505_g54552_i0 PRJNA981359 54652 271 2.550505 6.91186855 Prunus armeniaca 36596 Plants Plants 42 0.0359   NR CAB4290470.1 36596 g54552 i0 39.2 1.12915129151292 51 29 54.2 1 215 69 63 113 CAB4290470.1 unnamed protein product [Prunus armeniaca] diamond 306 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus armeniaca
31897224 31897224 PRJNA981359_S_NODE_15777_length_380_cov_2.527687_g15677_i0 PRJNA981359 15777 380 2.527687 9.6052106 Cupressales 1446379 Plants Plants 62.8 1.65e-8   NR XP_059075804.1 3369 g15677 i0 54.1 1.89473684210526 61 26 48.2 1 371 189 384 442 XP_059075804.1 uncharacterized protein LOC131043866 [Cryptomeria japonica] diamond 720 63.2 0.993670886075949 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
32492569 32492569 PRJNA981359_S_NODE_76999_length_221_cov_15.858108_g76899_i0 PRJNA981359 76999 221 15.858108 35.04641868 Arabidopsis suecica 45249 Plants Plants 42.4 0.0386   NR KAG7563338.1 45249 g76899 i0 34.8 0.936651583710407 69 31 74.7 2 39 203 435 503 KAG7563338.1 Protein kinase C-like phorbol ester/diacylglycerol-binding domain [Arabidopsis suecica] diamond 207 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis suecica

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