RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJEB30004" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB30004 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
3539287 3539287 PRJEB30004_P_NODE_652463_length_156_cov_2.692308_g636836_i0 PRJEB30004 652463 156 2.692308 4.20000048 Olea europaea subsp. europaea 158383 Plants Plants 99 1.76e-22   NR CAA2977210.1 158383 g636836 i0 100 2.94230769230769 51 0 98.1 0 2 154 951 1001 CAA2977210.1 efflux RND transporter periplasmic adaptor subunit, partial [Olea europaea subsp. europaea] diamond 459 99 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
3864665 3864665 PRJEB30004_P_NODE_355564_length_248_cov_2.019139_g339937_i0 PRJEB30004 355564 248 2.019139 5.00746472 root 1 Root_unresolved Root_unresolved 164 5.3599999999999995e-45   NR CAA2991155.1 158383 g339937 i0 100 2.9758064516129 82 0 99.2 0 246 1 396 477 CAA2991155.1 ATP-dependent exoDNAse (exonuclease V) beta subunit (contains helicase and exonuclease domains), partial [Olea europaea subsp. europaea] diamond 738 164 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
27184639 27184639 PRJEB30004_P_NODE_228262_length_344_cov_1.885246_g212635_i0 PRJEB30004 228262 344 1.885246 6.48524624 root 1 Root_unresolved Root_unresolved 223 5.43e-72   NR CAA2962656.1 158383 g212635 i0 100 3.97674418604651 114 0 99.4 0 2 343 93 206 CAA2962656.1 Hypothetical predicted protein, partial [Olea europaea subsp. europaea] diamond 1368 223 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
27570348 27570348 PRJEB30004_P_NODE_369124_length_241_cov_2.430693_g353497_i0 PRJEB30004 369124 241 2.430693 5.85797013 Olea europaea subsp. europaea 158383 Plants Plants 164 9.2e-45   NR CAA2977210.1 158383 g353497 i0 100 0.995850622406639 80 0 99.6 0 1 240 719 798 CAA2977210.1 efflux RND transporter periplasmic adaptor subunit, partial [Olea europaea subsp. europaea] diamond 240 164 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
27570379 27570379 PRJEB30004_P_NODE_616244_length_163_cov_2.354839_g600617_i0 PRJEB30004 616244 163 2.354839 3.83838757 Olea europaea subsp. europaea 158383 Plants Plants 102 1.66e-23   NR CAA2991155.1 158383 g600617 i0 100 0.993865030674847 54 0 99.4 0 163 2 813 866 CAA2991155.1 ATP-dependent exoDNAse (exonuclease V) beta subunit (contains helicase and exonuclease domains), partial [Olea europaea subsp. europaea] diamond 162 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
27602161 27602161 PRJEB30004_P_NODE_474304_length_199_cov_1.875000_g458677_i0 PRJEB30004 474304 199 1.875 3.73125 Olea europaea subsp. europaea 158383 Plants Plants 134 6.2e-38   NR CAA2991217.1 158383 g458677 i0 100 0.994974874371859 66 0 99.5 0 1 198 4 69 CAA2991217.1 Hypothetical predicted protein, partial [Olea europaea subsp. europaea] diamond 198 134 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
27980933 27980933 PRJEB30004_P_NODE_592605_length_168_cov_1.906977_g576978_i0 PRJEB30004 592605 168 1.906977 3.20372136 Olea europaea subsp. europaea 158383 Plants Plants 105 7.72e-25   NR CAA2977210.1 158383 g576978 i0 100 2.94642857142857 55 0 98.2 0 167 3 178 232 CAA2977210.1 efflux RND transporter periplasmic adaptor subunit, partial [Olea europaea subsp. europaea] diamond 495 105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
28107058 28107058 PRJEB30004_P_NODE_542005_length_180_cov_1.687943_g526378_i0 PRJEB30004 542005 180 1.687943 3.0382974 Olea europaea subsp. europaea 158383 Plants Plants 111 8.640000000000001e-27   NR CAA2977210.1 158383 g526378 i0 100 0.983333333333333 59 0 98.3 0 178 2 245 303 CAA2977210.1 efflux RND transporter periplasmic adaptor subunit, partial [Olea europaea subsp. europaea] diamond 177 111 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
28132348 28132348 PRJEB30004_P_NODE_683425_length_151_cov_1.464286_g667798_i0 PRJEB30004 683425 151 1.464286 2.21107186 root 1 Root_unresolved Root_unresolved 95.5 2.77e-21   NR CAA2991155.1 158383 g667798 i0 100 1.98675496688742 50 0 99.3 0 2 151 138 187 CAA2991155.1 ATP-dependent exoDNAse (exonuclease V) beta subunit (contains helicase and exonuclease domains), partial [Olea europaea subsp. europaea] diamond 300 95.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
28486054 28486054 PRJEB30004_P_NODE_223927_length_349_cov_1.725806_g208300_i0 PRJEB30004 223927 349 1.725806 6.02306294 Olea europaea subsp. europaea 158383 Plants Plants 232 4.0799999999999996e-74   NR CAA2962657.1 158383 g208300 i0 100 1.99426934097421 116 0 99.7 0 1 348 187 302 CAA2962657.1 crotonase, partial [Olea europaea subsp. europaea] diamond 696 232 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
28928087 28928087 PRJEB30004_P_NODE_545148_length_179_cov_1.900000_g529521_i0 PRJEB30004 545148 179 1.9 3.401 Olea europaea subsp. europaea 158383 Plants Plants 115 6.419999999999999e-31   NR CAA3004955.1 158383 g529521 i0 100 0.988826815642458 59 0 98.9 0 179 3 88 146 CAA3004955.1 Hypothetical predicted protein [Olea europaea subsp. europaea] diamond 177 115 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
29432948 29432948 PRJEB30004_P_NODE_213850_length_360_cov_14.429907_g198224_i0 PRJEB30004 213850 360 14.429907 51.9476652 Aristolochia fimbriata 158543 Plants Plants 45.8 0.0109   NR KAG9438328.1 158543 g198224 i0 47.2 0.441666666666667 53 26 44.2 1 86 244 193 243 KAG9438328.1 hypothetical protein H6P81_021735 [Aristolochia fimbriata] diamond 159 45.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Piperales Aristolochiaceae Aristolochia Aristolochia fimbriata
30507267 30507267 PRJEB30004_P_NODE_556933_length_176_cov_2.306569_g541306_i0 PRJEB30004 556933 176 2.306569 4.05956144 Olea europaea subsp. europaea 158383 Plants Plants 109 7.640000000000001e-29   NR CAA2977293.1 158383 g541306 i0 100 0.988636363636364 58 0 98.9 0 3 176 20 77 CAA2977293.1 type II secretion system M [Olea europaea subsp. europaea] diamond 174 109 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
30791551 30791551 PRJEB30004_P_NODE_546174_length_179_cov_1.464286_g530547_i0 PRJEB30004 546174 179 1.464286 2.62107194 Olea europaea subsp. europaea 158383 Plants Plants 122 3.1599999999999997e-32   NR CAA2962657.1 158383 g530547 i0 100 1.97765363128492 59 0 98.9 0 178 2 84 142 CAA2962657.1 crotonase, partial [Olea europaea subsp. europaea] diamond 354 122 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
30791557 30791557 PRJEB30004_P_NODE_653554_length_156_cov_1.811966_g637927_i0 PRJEB30004 653554 156 1.811966 2.82666696 Olea europaea subsp. europaea 158383 Plants Plants 117 1.1299999999999998e-31   NR CAA3004955.1 158383 g637927 i0 100 0.980769230769231 51 0 98.1 0 3 155 38 88 CAA3004955.1 Hypothetical predicted protein [Olea europaea subsp. europaea] diamond 153 117 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
31644990 31644990 PRJEB30004_P_NODE_623277_length_162_cov_1.487805_g607650_i0 PRJEB30004 623277 162 1.487805 2.4102441 Olea europaea subsp. europaea 158383 Plants Plants 76.3 9.21e-15   NR CAA2962657.1 158383 g607650 i0 97.2 0.666666666666667 36 1 66.7 0 110 3 1 36 CAA2962657.1 crotonase, partial [Olea europaea subsp. europaea] diamond 108 76.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
32246575 32246575 PRJEB30004_P_NODE_583578_length_170_cov_1.877863_g567951_i0 PRJEB30004 583578 170 1.877863 3.1923671 Olea europaea subsp. europaea 158383 Plants Plants 125 8.769999999999998e-35   NR CAA2991217.1 158383 g567951 i0 100 0.988235294117647 56 0 98.8 0 1 168 68 123 CAA2991217.1 Hypothetical predicted protein, partial [Olea europaea subsp. europaea] diamond 168 125 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
32720116 32720116 PRJEB30004_P_NODE_425960_length_216_cov_2.152542_g410333_i0 PRJEB30004 425960 216 2.152542 4.64949072 Olea europaea subsp. europaea 158383 Plants Plants 127 3.21e-32   NR CAA2991155.1 158383 g410333 i0 100 1 72 0 100 0 1 216 301 372 CAA2991155.1 ATP-dependent exoDNAse (exonuclease V) beta subunit (contains helicase and exonuclease domains), partial [Olea europaea subsp. europaea] diamond 216 127 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea

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