RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJEB28589" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB28589 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
11504047 11504047 PRJEB28589_S_NODE_3390_length_358_cov_7.073955_g3282_i0 PRJEB28589 3390 358 7.073955 25.3247589 Klebsormidium nitens 105231 Plants Plants 88.6 9.55e-18   NR GAQ77660.1 105231 g3282 i0 97.8 0.385474860335196 46 1 38.5 0 1 138 407 452 GAQ77660.1 cysteine synthase [Klebsormidium nitens] diamond 138 88.6 1 Eukaryota   Viridiplantae Streptophyta Klebsormidiophyceae Klebsormidiales Klebsormidiaceae Klebsormidium Klebsormidium nitens
26589770 26589770 PRJEB28589_S_NODE_4941_length_326_cov_4.906810_g4833_i0 PRJEB28589 4941 326 4.90681 15.9962006 Euphorbia lathyris 212925 Plants Plants 45.1 0.014   NR XP_065867274.1 212925 g4833 i0 31.6 1.1319018404908 57 39 52.5 0 196 26 242 298 XP_065867274.1 transcription termination factor MTERF8, chloroplastic-like isoform X1 [Euphorbia lathyris] diamond 369 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Euphorbia Euphorbia lathyris
26875340 26875340 PRJEB28589_S_NODE_7801_length_280_cov_4.227468_g7693_i0 PRJEB28589 7801 280 4.227468 11.8369104 Cicer arietinum 3827 Plants Plants 73.2 7.29e-13   NR XP_012573153.1 3827 g7693 i0 37.5 1.8 88 55 94.3 0 12 275 73 160 XP_012573153.1 ubiquitin recognition factor in ER-associated degradation protein 1-like [Cicer arietinum] diamond 504 73.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Cicer Cicer arietinum
29615880 29615880 PRJEB28589_S_NODE_10430_length_242_cov_3.430769_g10322_i0 PRJEB28589 10430 242 3.430769 8.30246098 Eukaryota 2759 Plants Plants 101 9.13e-23   NR RXI08480.1 3750 g10322 i0 71.6 55.6487603305785 67 19 83.1 0 242 42 581 647 RXI08480.1 hypothetical protein DVH24_022624 [Malus domestica] diamond 13467 102 0.990196078431373 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Malus Malus domestica
29717130 29717130 PRJEB28589_S_NODE_2930_length_371_cov_7.259259_g2822_i0 PRJEB28589 2930 371 7.259259 26.93185089 Nyssa sinensis 561372 Plants Plants 81.3 7.2e-16   NR KAA8548032.1 561372 g2822 i0 45.5 0.800539083557951 99 40 69.5 2 2 259 139 236 KAA8548032.1 hypothetical protein F0562_004707 [Nyssa sinensis] diamond 297 81.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cornales Nyssaceae Nyssa Nyssa sinensis
29780529 29780529 PRJEB28589_S_NODE_4251_length_340_cov_5.621160_g4143_i0 PRJEB28589 4251 340 5.62116 19.111944 Ceratodon purpureus 3225 Plants Plants 134 8.79e-38   NR KAG0568568.1 3225 g4143 i0 77.2 1.39411764705882 79 18 69.7 0 14 250 51 129 KAG0568568.1 hypothetical protein KC19_6G029500 [Ceratodon purpureus] diamond 474 134 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pseudoditrichales Ditrichaceae Ceratodon Ceratodon purpureus
29938569 29938569 PRJEB28589_S_NODE_7791_length_280_cov_5.635193_g7683_i0 PRJEB28589 7791 280 5.635193 15.7785404 Hibiscus syriacus 106335 Plants Plants 65.1 7.14e-11   NR XP_039048909.1 106335 g7683 i0 42.3 2.25 71 40 76.1 1 247 35 27 96 XP_039048909.1 S-protein homolog 2-like [Hibiscus syriacus] diamond 630 65.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Hibiscus Hibiscus syriacus
30216170 30216170 PRJEB28589_S_NODE_6352_length_303_cov_2.859375_g6244_i0 PRJEB28589 6352 303 2.859375 8.66390625 Prunus 3754 Plants Plants 122 1.12e-29   NR XP_021804739.1 42229 g6244 i0 53.8 3.6039603960396 91 40 88.1 1 36 302 1718 1808 XP_021804739.1 LOW QUALITY PROTEIN: uncharacterized protein LOC110749042 [Prunus avium] diamond 1092 122 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus avium
30349743 30349743 PRJEB28589_S_NODE_1872_length_422_cov_4.365333_g1764_i0 PRJEB28589 1872 422 4.365333 18.42170526 Oryza brachyantha 4533 Plants Plants 62 7.52e-9   NR XP_006660439.1 4533 g1764 i0 48.4 1.25829383886256 62 28 43.4 2 219 401 55 113 XP_006660439.1 E3 ubiquitin-protein ligase RNF181-like [Oryza brachyantha] diamond 531 62 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza brachyantha
30570106 30570106 PRJEB28589_S_NODE_9633_length_253_cov_3.655340_g9525_i0 PRJEB28589 9633 253 3.65534 9.2480102 Hevea brasiliensis 3981 Plants Plants 94.4 4.01e-22   NR KAF2325496.1 3981 g9525 i0 71.7 1.88537549407115 53 15 62.8 0 41 199 120 172 KAF2325496.1 hypothetical protein GH714_029565 [Hevea brasiliensis] diamond 477 94.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Hevea Hevea brasiliensis
31201835 31201835 PRJEB28589_S_NODE_6775_length_296_cov_4.317269_g6667_i0 PRJEB28589 6775 296 4.317269 12.77911624 Liquidambar formosana 63359 Plants Plants 82.4 2.66e-17   NR KAK9267831.1 63359 g6667 i0 87.5 0.486486486486487 48 6 48.6 0 3 146 120 167 KAK9267831.1 hypothetical protein L1049_010267 [Liquidambar formosana] diamond 144 82.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Saxifragales Altingiaceae Liquidambar Liquidambar formosana
31265557 31265557 PRJEB28589_S_NODE_18515_length_160_cov_3.336283_g18407_i0 PRJEB28589 18515 160 3.336283 5.3380528 Trifolium repens 3899 Plants Plants 54.3 9.72e-7   NR KAK2364431.1 3899 g18407 i0 48.2 4.275 56 25 97.5 1 158 3 1055 1110 KAK2364431.1 putative mitochondrial protein [Trifolium repens] diamond 684 54.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium repens
31392234 31392234 PRJEB28589_S_NODE_11276_length_230_cov_4.163934_g11168_i0 PRJEB28589 11276 230 4.163934 9.5770482 Klebsormidium nitens 105231 Plants Plants 61.2 6.39e-9   NR GAQ84037.1 105231 g11168 i0 100 0.391304347826087 30 0 39.1 0 2 91 243 272 GAQ84037.1 Biotin Carboxyl Carrier Protein [Klebsormidium nitens] diamond 90 61.2 1 Eukaryota   Viridiplantae Streptophyta Klebsormidiophyceae Klebsormidiales Klebsormidiaceae Klebsormidium Klebsormidium nitens
32902369 32902369 PRJEB28589_S_NODE_3780_length_349_cov_3.264901_g3672_i0 PRJEB28589 3780 349 3.264901 11.39450449 Streptophyta 35493 Plants Plants 48.9 8.53e-4   NR KAL1360522.1 3818 g3672 i0 32.1 4.28080229226361 84 55 72.2 2 322 71 540 621 KAL1360522.1 hypothetical protein AAHE18_04G183000 [Arachis hypogaea] diamond 1494 48.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Arachis Arachis hypogaea

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