RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA400391 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
18932501 18932501 PRJNA400391_S_NODE_1415_length_317_cov_14.514184_g1354_i0 PRJNA400391 1415 317 14.514184 46.00996328 Magnoliopsida 3398 Plants Plants 67 2.69e-10   NR PHT26171.1 33114 g1354 i0 60.8 2.87697160883281 51 20 48.3 0 164 316 184 234 PHT26171.1 Protein TAR1 [Capsicum baccatum] diamond 912 67 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Capsicum Capsicum baccatum
27106844 27106844 PRJNA400391_S_NODE_5842_length_162_cov_3.251969_g5781_i0 PRJNA400391 5842 162 3.251969 5.26818978 Ceratodon purpureus 3225 Plants Plants 45.1 5.48e-4   NR KAG0595991.1 3225 g5781 i0 59.5 1.40740740740741 37 15 68.5 0 112 2 7 43 KAG0595991.1 hypothetical protein M758_UG215000 [Ceratodon purpureus] diamond 228 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pseudoditrichales Ditrichaceae Ceratodon Ceratodon purpureus
27233492 27233492 PRJNA400391_S_NODE_5283_length_172_cov_1.284672_g5222_i0 PRJNA400391 5283 172 1.284672 2.20963584 Hordeum vulgare subsp. vulgare 112509 Plants Plants 53.5 1.82e-6   NR BAJ93551.1 112509 g5222 i0 61 0.715116279069767 41 15 69.8 1 169 50 219 259 BAJ93551.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 123 53.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
28749179 28749179 PRJNA400391_S_NODE_6207_length_157_cov_2.032787_g6146_i0 PRJNA400391 6207 157 2.032787 3.19147559 Prunus brigantina 151428 Plants Plants 42 0.00938   NR CAL8988860.1 151428 g6146 i0 63.6 1.26114649681529 33 12 63.1 0 99 1 66 98 CAL8988860.1 unnamed protein product, partial [Prunus brigantina] diamond 198 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus brigantina
29176552 29176552 PRJNA400391_S_NODE_4589_length_186_cov_7.324503_g4528_i0 PRJNA400391 4589 186 7.324503 13.62357558 Magnoliopsida 3398 Plants Plants 56.6 2.1e-7   NR WZY99812.1 3708 g4528 i0 57.1 2.54838709677419 49 21 79 0 2 148 179 227 WZY99812.1 hypothetical protein YC2023_072141 [Brassica napus] diamond 474 57 0.992982456140351 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
30313831 30313831 PRJNA400391_S_NODE_3752_length_208_cov_1.364162_g3691_i0 PRJNA400391 3752 208 1.364162 2.83745696 Magnoliopsida 3398 Plants Plants 52 1.29e-5   NR KAI3475460.1 114280 g3691 i0 65.9 1.18269230769231 41 14 59.1 0 4 126 115 155 KAI3475460.1 hypothetical protein L1887_63148 [Cichorium endivia] diamond 246 52 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Cichorium Cichorium endivia
30692371 30692371 PRJNA400391_S_NODE_5133_length_174_cov_4.539568_g5072_i0 PRJNA400391 5133 174 4.539568 7.89884832 Eukaryota 2759 Plants Plants 42.4 0.0209   NR KAE8729904.1 106335 g5072 i0 47.2 8.36206896551724 53 25 86.2 1 174 25 201 253 KAE8729904.1 hypothetical protein F3Y22_tig00003041pilonHSYRG00071 [Hibiscus syriacus] diamond 1455 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Hibiscus Hibiscus syriacus

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