RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1098727 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
211122 211122 PRJNA1098727_P_NODE_7161_length_232_cov_1.688525_g6920_i0 PRJNA1098727 7161 232 1.688525 3.917378 Olea europaea subsp. europaea 158383 Plants Plants 134 5.68e-35   NR CAA2996546.1 158383 g6920 i0 90.8 0.84051724137931 65 6 84.1 0 230 36 458 522 CAA2996546.1 GDSL esterase lipase At3g48460-like [Olea europaea subsp. europaea] diamond 195 134 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
27193962 27193962 PRJNA1098727_P_NODE_14062_length_166_cov_0.888889_g13821_i0 PRJNA1098727 14062 166 0.888889 1.47555574 Fraxinus pennsylvanica 56036 Plants Plants 53.1 2.82e-6   NR CAI9766629.1 56036 g13821 i0 94.5 0.993975903614458 55 3 99.4 0 2 166 219 273 CAI9766629.1 unnamed protein product [Fraxinus pennsylvanica] diamond 165 53.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus pennsylvanica
27352363 27352363 PRJNA1098727_P_NODE_15403_length_163_cov_0.912281_g15162_i0 PRJNA1098727 15403 163 0.912281 1.48701803 Quillaja saponaria 32244 Plants Plants 63.9 2.23e-11   NR KAJ7951871.1 32244 g15162 i0 68 2.61349693251534 50 16 92 0 151 2 31 80 KAJ7951871.1 Late embryogenesis abundant protein [Quillaja saponaria] diamond 426 63.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Quillajaceae Quillaja Quillaja saponaria
27731369 27731369 PRJNA1098727_P_NODE_14344_length_165_cov_0.896552_g14103_i0 PRJNA1098727 14344 165 0.896552 1.4793108 Fraxinus pennsylvanica 56036 Plants Plants 107 5.54e-26   NR CAI9769673.1 56036 g14103 i0 100 0.981818181818182 54 0 98.2 0 4 165 51 104 CAI9769673.1 unnamed protein product [Fraxinus pennsylvanica] diamond 162 107 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus pennsylvanica
28204455 28204455 PRJNA1098727_P_NODE_8266_length_214_cov_1.521212_g8025_i0 PRJNA1098727 8266 214 1.521212 3.25539368 Forsythia ovata 205694 Plants Plants 77.8 5.29e-16   NR KAL2548042.1 205694 g8025 i0 65.5 1.66822429906542 55 19 77.1 0 198 34 1 55 KAL2548042.1 Rapid ALkalinization Factor [Forsythia ovata] diamond 357 77.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Forsythia Forsythia ovata
28330861 28330861 PRJNA1098727_P_NODE_14126_length_166_cov_0.863248_g13885_i0 PRJNA1098727 14126 166 0.863248 1.43299168 Tanacetum cinerariifolium 118510 Plants Plants 43.1 0.00935   NR GEY58944.1 118510 g13885 i0 55.3 7.30120481927711 38 15 68.7 1 52 165 43 78 GEY58944.1 uncharacterized protein [Tanacetum cinerariifolium] diamond 1212 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
28804313 28804313 PRJNA1098727_P_NODE_11648_length_177_cov_1.140625_g11407_i0 PRJNA1098727 11648 177 1.140625 2.01890625 Forsythia ovata 205694 Plants Plants 64.7 4e-11   NR KAL2548042.1 205694 g11407 i0 62.3 0.898305084745763 53 18 86.4 1 174 22 3 55 KAL2548042.1 Rapid ALkalinization Factor [Forsythia ovata] diamond 159 64.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Forsythia Forsythia ovata
29215243 29215243 PRJNA1098727_P_NODE_12369_length_171_cov_1.680328_g12128_i0 PRJNA1098727 12369 171 1.680328 2.87336088 Fraxinus pennsylvanica 56036 Plants Plants 116 1.26e-28   NR CAI9758994.1 56036 g12128 i0 100 0.982456140350877 56 0 98.2 0 168 1 414 469 CAI9758994.1 unnamed protein product [Fraxinus pennsylvanica] diamond 168 116 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus pennsylvanica
29246533 29246533 PRJNA1098727_P_NODE_12829_length_169_cov_0.866667_g12588_i0 PRJNA1098727 12829 169 0.866667 1.46466723 Lolium multiflorum 4521 Plants Plants 71.2 1.23e-12   NR KAK1662494.1 4521 g12588 i0 63.6 3.90532544378698 55 20 97.6 0 168 4 1471 1525 KAK1662494.1 hypothetical protein QYE76_050653 [Lolium multiflorum] diamond 660 71.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium multiflorum
29522026 29522026 PRJNA1098727_P_NODE_15350_length_163_cov_0.912281_g15109_i0 PRJNA1098727 15350 163 0.912281 1.48701803 Fabaceae 3803 Plants Plants 43.5 0.00661   NR XP_050895336.1 3888 g15109 i0 59.4 1.76687116564417 32 13 58.9 0 161 66 728 759 XP_050895336.1 subtilisin-like serine-protease S [Pisum sativum] diamond 288 43.9 0.990888382687927 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lathyrus Lathyrus oleraceus
29562215 29562215 PRJNA1098727_P_NODE_13290_length_168_cov_0.873950_g13049_i0 PRJNA1098727 13290 168 0.87395 1.468236 Fraxinus pennsylvanica 56036 Plants Plants 119 1.04e-32   NR CAI9756118.1 56036 g13049 i0 98.2 0.982142857142857 55 1 98.2 0 3 167 7 61 CAI9756118.1 unnamed protein product [Fraxinus pennsylvanica] diamond 165 119 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus pennsylvanica
31354621 31354621 PRJNA1098727_P_NODE_13136_length_168_cov_0.873950_g12895_i0 PRJNA1098727 13136 168 0.87395 1.468236 Orobanchaceae 91896 Plants Plants 103 3.87e-24   NR GFQ04104.1 374723 g12895 i0 80 5.89285714285714 55 11 98.2 0 166 2 353 407 GFQ04104.1 probable pectinesterase/pectinesterase inhibitor 58, partial [Phtheirospermum japonicum] diamond 990 103 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Phtheirospermum Phtheirospermum japonicum
31489991 31489991 PRJNA1098727_P_NODE_4416_length_309_cov_1.838462_g4175_i0 PRJNA1098727 4416 309 1.838462 5.68084758 Fraxinus pennsylvanica 56036 Plants Plants 214 5.17e-66   NR CAI9761477.1 56036 g4175 i0 100 0.990291262135922 102 0 99 0 3 308 55 156 CAI9761477.1 unnamed protein product [Fraxinus pennsylvanica] diamond 306 214 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus pennsylvanica
31679393 31679393 PRJNA1098727_P_NODE_8277_length_214_cov_1.248485_g8036_i0 PRJNA1098727 8277 214 1.248485 2.6717579 Fraxinus pennsylvanica 56036 Plants Plants 99.8 4.52e-24   NR CAI9759606.1 56036 g8036 i0 98.2 0.785046728971963 56 1 78.5 0 212 45 31 86 CAI9759606.1 unnamed protein product [Fraxinus pennsylvanica] diamond 168 99.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus pennsylvanica
32027557 32027557 PRJNA1098727_P_NODE_14878_length_164_cov_0.904348_g14637_i0 PRJNA1098727 14878 164 0.904348 1.48313072 Heracleum sosnowskyi 360622 Plants Plants 85.1 1.48e-17   NR KAK1379987.1 360622 g14637 i0 77.8 3.95121951219512 54 12 98.8 0 2 163 339 392 KAK1379987.1 hypothetical protein POM88_026731 [Heracleum sosnowskyi] diamond 648 85.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Heracleum Heracleum sosnowskyi

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