RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJEB39269" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB39269 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
2607022 2607022 PRJEB39269_P_NODE_88003_length_152_cov_2.805310_g87598_i0 PRJEB39269 88003 152 2.80531 4.2640712 Nicotiana sylvestris 4096 Plants Plants 90.1 3.86e-20   NR XP_070014097.1 4096 g87598 i0 88 4.93421052631579 50 6 98.7 0 2 151 37 86 XP_070014097.1 uncharacterized protein [Nicotiana sylvestris] diamond 750 90.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana sylvestris
26969939 26969939 PRJEB39269_P_NODE_83402_length_156_cov_1.641026_g82997_i0 PRJEB39269 83402 156 1.641026 2.56000056 Olea europaea subsp. europaea 158383 Plants Plants 103 7.580000000000001e-27   NR CAA3019456.1 158383 g82997 i0 100 0.980769230769231 51 0 98.1 0 155 3 49 99 CAA3019456.1 type II secretion system [Olea europaea subsp. europaea] diamond 153 103 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
27349677 27349677 PRJEB39269_P_NODE_67483_length_170_cov_2.503817_g67078_i0 PRJEB39269 67483 170 2.503817 4.2564889 Nicotiana sylvestris 4096 Plants Plants 58.2 3.64e-8   NR XP_070020214.1 4096 g67078 i0 84.6 0.458823529411765 26 4 45.9 0 91 168 205 230 XP_070020214.1 uncharacterized protein [Nicotiana sylvestris] diamond 78 58.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana sylvestris
28201763 28201763 PRJEB39269_P_NODE_84306_length_155_cov_2.982759_g83901_i0 PRJEB39269 84306 155 2.982759 4.62327645 Nicotiana sylvestris 4096 Plants Plants 52 4.28e-6   NR XP_070010304.1 4096 g83901 i0 57.6 1.14193548387097 59 17 98.7 2 154 2 34 92 XP_070010304.1 GRIP domain-containing protein RUD3-like [Nicotiana sylvestris] diamond 177 52 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana sylvestris
28864975 28864975 PRJEB39269_P_NODE_89208_length_151_cov_4.339286_g88803_i0 PRJEB39269 89208 151 4.339286 6.55232186 Nicotiana sylvestris 4096 Plants Plants 91.3 1.16e-20   NR XP_070022303.1 4096 g88803 i0 90 2.98013245033113 50 5 99.3 0 151 2 111 160 XP_070022303.1 uncharacterized protein [Nicotiana sylvestris] diamond 450 91.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana sylvestris
29212521 29212521 PRJEB39269_P_NODE_90929_length_150_cov_2.081081_g90524_i0 PRJEB39269 90929 150 2.081081 3.1216215 Oryza sativa Japonica Group 39947 Plants Plants 43.1 0.00795   NR BAF21410.1 39947 g90524 i0 54.3 2.58 35 16 70 0 144 40 68 102 BAF21410.1 Os07g0434200, partial [Oryza sativa Japonica Group] diamond 387 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
29338704 29338704 PRJEB39269_P_NODE_33009_length_240_cov_3.427861_g32604_i0 PRJEB39269 33009 240 3.427861 8.2268664 Camellia sinensis var. sinensis 542762 Plants Plants 41.2 0.0367   NR GMP76124.1 542762 g32604 i0 36.9 0.8125 65 31 70 2 6 173 33 96 GMP76124.1 hypothetical protein CsSME_00032934 [Camellia sinensis var. sinensis] diamond 195 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
30949778 30949778 PRJEB39269_P_NODE_86974_length_153_cov_1.964912_g86569_i0 PRJEB39269 86974 153 1.964912 3.00631536 Olea europaea subsp. europaea 158383 Plants Plants 101 1.9e-23   NR CAA2977210.1 158383 g86569 i0 98 0.980392156862745 50 1 98 0 3 152 484 533 CAA2977210.1 efflux RND transporter periplasmic adaptor subunit, partial [Olea europaea subsp. europaea] diamond 150 101 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
31006200 31006200 PRJEB39269_P_NODE_85554_length_154_cov_2.139130_g85149_i0 PRJEB39269 85554 154 2.13913 3.2942602 root 1 Root_unresolved Root_unresolved 101 2.71e-23   NR CAA2977210.1 158383 g85149 i0 100 1.98701298701299 51 0 99.4 0 153 1 348 398 CAA2977210.1 efflux RND transporter periplasmic adaptor subunit, partial [Olea europaea subsp. europaea] diamond 306 101 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
31417216 31417216 PRJEB39269_P_NODE_78436_length_159_cov_5.725000_g78031_i0 PRJEB39269 78436 159 5.725 9.10275 Nicotiana 4085 Plants Plants 42 0.0219   NR XP_070018047.1 4096 g78031 i0 57.1 4.22641509433962 28 12 52.8 0 158 75 153 180 XP_070018047.1 uncharacterized protein [Nicotiana sylvestris] diamond 672 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana sylvestris
31676717 31676717 PRJEB39269_P_NODE_69177_length_169_cov_1.261538_g68772_i0 PRJEB39269 69177 169 1.261538 2.13199922 Olea europaea subsp. europaea 158383 Plants Plants 110 4.05e-27   NR CAA2991188.1 158383 g68772 i0 100 0.976331360946746 55 0 97.6 0 167 3 35 89 CAA2991188.1 thymidylate kinase, partial [Olea europaea subsp. europaea] diamond 165 110 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
31898237 31898237 PRJEB39269_P_NODE_78877_length_159_cov_3.225000_g78472_i0 PRJEB39269 78877 159 3.225 5.12775 Nicotiana tomentosiformis 4098 Plants Plants 52.4 4.19e-6   NR XP_070050158.1 4098 g78472 i0 66.7 0.962264150943396 27 9 50.9 0 3 83 251 277 XP_070050158.1 uncharacterized protein [Nicotiana tomentosiformis] diamond 153 52.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana tomentosiformis

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