RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA512489" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 24 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA512489 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
486596 486596 PRJNA512489_S_NODE_661_length_210_cov_5.365269_g656_i0 PRJNA512489 661 210 5.365269 11.2670649 root 1 Root_unresolved Root_unresolved 122 2.5899999999999997e-31   NR NP_172750.1 3702 g656 i0 94.1 15.5428571428571 68 4 97.1 0 205 2 294 361 NP_172750.1 glyceraldehyde 3-phosphate dehydrogenase A subunit 2 [Arabidopsis thaliana] diamond 3264 123 0.991869918699187 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
22787909 22787909 PRJNA512489_S_NODE_1418_length_167_cov_1.629032_g1413_i0 PRJNA512489 1418 167 1.629032 2.72048344 Magnoliopsida 3398 Plants Plants 101 1.0799999999999999e-24   NR NP_175137.1 3702 g1413 i0 87 9.8622754491018 54 7 97 0 5 166 198 251 NP_175137.1 photosystem I light harvesting complex protein 5 [Arabidopsis thaliana] diamond 1647 102 0.990196078431373 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
26918993 26918993 PRJNA512489_S_NODE_1502_length_163_cov_14.208333_g1497_i0 PRJNA512489 1502 163 14.208333 23.15958279 Brassica napus 3708 Plants Plants 73.9 8.48e-14   NR XP_013723247.2 3708 g1497 i0 83.6 1.01226993865031 55 6 97.5 2 4 162 81 134 XP_013723247.2 oxygen-evolving enhancer protein 2, chloroplastic [Brassica napus] diamond 165 73.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
27108554 27108554 PRJNA512489_S_NODE_522_length_226_cov_5.590164_g517_i0 PRJNA512489 522 226 5.590164 12.63377064 Brassica carinata 52824 Plants Plants 42 0.0334   NR KAL0732536.1 52824 g517 i0 75 0.849557522123894 32 5 38.5 1 6 92 129 160 KAL0732536.1 hypothetical protein Bca4012_008745 [Brassica carinata] diamond 192 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica carinata
27155370 27155370 PRJNA512489_S_NODE_1122_length_178_cov_9.600000_g1117_i0 PRJNA512489 1122 178 9.6 17.088 Magnoliopsida 3398 Plants Plants 42.4 0.0194   NR XP_021899402.1 3649 g1117 i0 81.5 0.910112359550562 27 3 42.1 1 1 75 197 223 XP_021899402.1 photosystem I reaction center subunit III, chloroplastic [Carica papaya] diamond 162 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Caricaceae Carica Carica papaya
27203353 27203353 PRJNA512489_S_NODE_902_length_191_cov_1.864865_g897_i0 PRJNA512489 902 191 1.864865 3.56189215 Raphanus sativus 3726 Plants Plants 124 3.57e-34   NR XP_018487223.1 3726 g897 i0 92.1 2.96858638743455 63 5 99 0 1 189 106 168 XP_018487223.1 14 kDa zinc-binding protein [Raphanus sativus] diamond 567 124 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Raphanus Raphanus sativus
27250563 27250563 PRJNA512489_S_NODE_1503_length_163_cov_9.266667_g1498_i0 PRJNA512489 1503 163 9.266667 15.10466721 Malvaceae 3629 Plants Plants 99 5.04e-24   NR PPD84872.1 3634 g1498 i0 90.6 7.80368098159509 53 5 97.5 0 3 161 1 53 PPD84872.1 hypothetical protein GOBAR_DD18188 [Gossypium barbadense] diamond 1272 99 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium barbadense
27488009 27488009 PRJNA512489_S_NODE_1043_length_183_cov_1.650000_g1038_i0 PRJNA512489 1043 183 1.65 3.0195 Cardamine amara subsp. amara 228776 Plants Plants 92.8 7.85e-22   NR KAL1218993.1 228776 g1038 i0 76.7 4.91803278688525 60 12 95.1 1 6 179 12 71 KAL1218993.1 hypothetical protein V5N11_028450 [Cardamine amara subsp. amara] diamond 900 92.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Cardamine Cardamine amara
27913647 27913647 PRJNA512489_S_NODE_1845_length_152_cov_18.229358_g1840_i0 PRJNA512489 1845 152 18.229358 27.70862416 Brassicaceae 3700 Plants Plants 77.4 4.92e-15   NR KFK41796.1 50452 g1840 i0 69.2 5.05263157894737 52 14 98.7 1 2 151 121 172 KFK41796.1 hypothetical protein AALP_AA2G173200 [Arabis alpina] diamond 768 77.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabis Arabis alpina
28766223 28766223 PRJNA512489_S_NODE_347_length_262_cov_6.324201_g342_i0 PRJNA512489 347 262 6.324201 16.56940662 Brassicaceae 3700 Plants Plants 140 5.73e-41   NR AAL24214.1 3702 g342 i0 82.6 8.86259541984733 86 14 98.5 1 5 262 9 93 AAL24214.1 At1g10960/T19D16_12 [Arabidopsis thaliana] diamond 2322 140 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
28829373 28829373 PRJNA512489_S_NODE_908_length_190_cov_7.666667_g903_i0 PRJNA512489 908 190 7.666667 14.5666673 Brassicaceae 3700 Plants Plants 103 4.94e-24   NR KAG2272541.1 52824 g903 i0 82 1.92631578947368 61 9 96.3 1 6 188 473 531 KAG2272541.1 hypothetical protein Bca52824_067096 [Brassica carinata] diamond 366 103 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica carinata
29050625 29050625 PRJNA512489_S_NODE_468_length_234_cov_7.251309_g463_i0 PRJNA512489 468 234 7.251309 16.96806306 Magnoliopsida 3398 Plants Plants 62 4.84e-10   NR CAG7900112.1 3711 g463 i0 92.6 16.2692307692308 27 2 34.6 0 3 83 103 129 CAG7900112.1 unnamed protein product [Brassica rapa] diamond 3807 62.4 0.993589743589744 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica rapa
29224791 29224791 PRJNA512489_S_NODE_1909_length_151_cov_2.814815_g1904_i0 PRJNA512489 1909 151 2.814815 4.25037065 Arabidopsis thaliana 3702 Plants Plants 92.8 5.120000000000001e-22   NR NP_001189719.1 3702 g1904 i0 77.6 2.9205298013245 49 11 97.4 0 147 1 12 60 NP_001189719.1 light harvesting complex photosystem II [Arabidopsis thaliana] diamond 441 92.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
29334676 29334676 PRJNA512489_S_NODE_669_length_210_cov_2.053892_g664_i0 PRJNA512489 669 210 2.053892 4.3131732 Brassica 3705 Plants Plants 51.6 1.7e-5   NR KAH0860807.1 3708 g664 i0 96.3 1.54285714285714 27 1 38.6 0 4 84 171 197 KAH0860807.1 hypothetical protein HID58_089068 [Brassica napus] diamond 324 51.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
29919343 29919343 PRJNA512489_S_NODE_1851_length_152_cov_5.422018_g1846_i0 PRJNA512489 1851 152 5.422018 8.24146736 Brassica napus 3708 Plants Plants 67 2.78e-11   NR KAH0910893.1 3708 g1846 i0 58.3 5.48684210526316 48 20 94.7 0 145 2 214 261 KAH0910893.1 hypothetical protein HID58_034214 [Brassica napus] diamond 834 67 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
30661271 30661271 PRJNA512489_S_NODE_893_length_191_cov_3.959459_g888_i0 PRJNA512489 893 191 3.959459 7.56256669 Brassicaceae 3700 Plants Plants 105 1.9800000000000003e-27   NR NP_568905.1 3702 g888 i0 74.6 7.91623036649215 63 16 99 0 2 190 47 109 NP_568905.1 lipid transfer protein 3 [Arabidopsis thaliana] diamond 1512 106 0.990566037735849 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
30787678 30787678 PRJNA512489_S_NODE_774_length_200_cov_3.656051_g769_i0 PRJNA512489 774 200 3.656051 7.312102 Brassicaceae 3700 Plants Plants 114 1.59e-29   NR NP_001319873.1 3702 g769 i0 87.7 1.95 65 8 97.5 0 197 3 59 123 NP_001319873.1 photosystem II subunit Q-2 [Arabidopsis thaliana] diamond 390 114 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
31214158 31214158 PRJNA512489_S_NODE_1135_length_178_cov_3.407407_g1130_i0 PRJNA512489 1135 178 3.407407 6.06518446 Malania oleifera 397392 Plants Plants 84.7 5.23e-18   NR XP_057949585.1 397392 g1130 i0 69.5 3.92696629213483 59 18 99.4 0 178 2 16 74 XP_057949585.1 chlorophyll a-b binding protein, chloroplastic isoform X2 [Malania oleifera] diamond 699 84.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Santalales Ximeniaceae Malania Malania oleifera
31246220 31246220 PRJNA512489_S_NODE_1835_length_153_cov_1.818182_g1830_i0 PRJNA512489 1835 153 1.818182 2.78181846 Arabidopsis arenosa 38785 Plants Plants 64.7 1.99e-10   NR CAE6160418.1 38785 g1830 i0 67.4 1.90196078431373 46 7 90.2 1 7 144 1350 1387 CAE6160418.1 unnamed protein product [Arabidopsis arenosa] diamond 291 64.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis arenosa
31261650 31261650 PRJNA512489_S_NODE_1195_length_175_cov_7.984848_g1190_i0 PRJNA512489 1195 175 7.984848 13.973484 Arabidopsis 3701 Plants Plants 83.2 6.09e-17   NR CAL9233442.1 81970 g1190 i0 63.8 2.98285714285714 58 19 96 1 8 175 132 189 CAL9233442.1 unnamed protein product [Arabidopsis halleri] diamond 522 83.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis halleri
31309407 31309407 PRJNA512489_S_NODE_1615_length_160_cov_1.487179_g1610_i0 PRJNA512489 1615 160 1.487179 2.3794864 Arachis hypogaea 3818 Plants Plants 51.6 2.07e-6   NR QHN91306.1 3818 g1610 i0 48 0.9375 50 26 93.8 0 151 2 78 127 QHN91306.1 uncharacterized protein DS421_17g573710 [Arachis hypogaea] diamond 150 51.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Arachis Arachis hypogaea
31752181 31752181 PRJNA512489_S_NODE_1437_length_166_cov_3.333333_g1432_i0 PRJNA512489 1437 166 3.333333 5.53333278 Arabis alpina 50452 Plants Plants 82 6.12e-17   NR KFK41795.1 50452 g1432 i0 60 3.97590361445783 55 22 99.4 0 2 166 161 215 KFK41795.1 hypothetical protein AALP_AA2G173100 [Arabis alpina] diamond 660 82 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabis Arabis alpina
31847095 31847095 PRJNA512489_S_NODE_1877_length_152_cov_1.688073_g1872_i0 PRJNA512489 1877 152 1.688073 2.56587096 Camelina sativa 90675 Plants Plants 82.4 1.66e-18   NR XP_010497714.1 90675 g1872 i0 81.3 0.947368421052632 48 9 94.7 0 145 2 77 124 XP_010497714.1 PREDICTED: uncharacterized protein LOC104775174, partial [Camelina sativa] diamond 144 82.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Camelina Camelina sativa
31925830 31925830 PRJNA512489_S_NODE_1577_length_161_cov_1.923729_g1572_i0 PRJNA512489 1577 161 1.923729 3.09720369 Brassica 3705 Plants Plants 50.8 1.68e-5   NR VDD47607.1 3712 g1572 i0 57.6 3.29813664596273 59 16 93.2 2 151 2 4 62 VDD47607.1 unnamed protein product [Brassica oleracea] diamond 531 51.2 0.9921875 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica oleracea

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