RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1104180" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1104180 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
15514986 15514986 PRJNA1104180_P_NODE_21433_length_249_cov_0.875000_g21290_i0 PRJNA1104180 21433 249 0.875 2.17875 Magnoliopsida 3398 Plants Plants 150 4.17e-45   NR CAH9132305.1 186058 g21290 i0 82.9 30.5421686746988 82 14 98.8 0 248 3 38 119 CAH9132305.1 unnamed protein product, partial [Cuscuta epithymum] diamond 7605 151 0.993377483443709 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Cuscuta Cuscuta epithymum
26624477 26624477 PRJNA1104180_P_NODE_24201_length_244_cov_1.801170_g24058_i0 PRJNA1104180 24201 244 1.80117 4.3948548 Capsicum annuum 4072 Plants Plants 47 0.00114   NR XP_016578898.1 4072 g24058 i0 70 0.663934426229508 30 9 36.9 0 189 100 149 178 XP_016578898.1 uncharacterized protein LOC107876503 [Capsicum annuum] diamond 162 47 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Capsicum Capsicum annuum
26687803 26687803 PRJNA1104180_P_NODE_13741_length_285_cov_1.117925_g13599_i0 PRJNA1104180 13741 285 1.117925 3.18608625 Abrus precatorius 3816 Plants Plants 46.2 0.00371   NR XP_027338376.1 3816 g13599 i0 62.1 0.305263157894737 29 11 30.5 0 170 84 843 871 XP_027338376.1 uncharacterized protein LOC113852348 [Abrus precatorius] diamond 87 46.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Abrus Abrus precatorius
27067596 27067596 PRJNA1104180_P_NODE_15562_length_274_cov_1.532338_g15420_i0 PRJNA1104180 15562 274 1.532338 4.19860612 Carex littledalei 544730 Plants Plants 141 7.829999999999999e-38   NR KAF3334956.1 544730 g15420 i0 81.8 0.963503649635037 88 16 96.4 0 10 273 18 105 KAF3334956.1 UBP1-associated protein 2C [Carex littledalei] diamond 264 141 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Cyperaceae Carex Carex littledalei
27194004 27194004 PRJNA1104180_P_NODE_18042_length_261_cov_1.425532_g17900_i0 PRJNA1104180 18042 261 1.425532 3.72063852 Citrus sinensis 2711 Plants Plants 105 2.87e-24   NR KAH9669964.1 2711 g17900 i0 73.8 3.73563218390805 65 17 74.7 0 3 197 362 426 KAH9669964.1 Integrase catalytic domain-containing protein [Citrus sinensis] diamond 975 105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
27447170 27447170 PRJNA1104180_P_NODE_14863_length_278_cov_1.502439_g14721_i0 PRJNA1104180 14863 278 1.502439 4.17678042 Capsicum annuum 4072 Plants Plants 78.2 1.9e-14   NR KAF3620933.1 4072 g14721 i0 85.4 1.03597122302158 48 7 51.8 0 148 5 442 489 KAF3620933.1 hypothetical protein FXO37_33041 [Capsicum annuum] diamond 288 78.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Capsicum Capsicum annuum
28078319 28078319 PRJNA1104180_P_NODE_21165_length_249_cov_2.232955_g21022_i0 PRJNA1104180 21165 249 2.232955 5.56005795 Nicotiana sylvestris 4096 Plants Plants 50.4 7.44e-5   NR XP_070017332.1 4096 g21022 i0 46.8 0.746987951807229 62 27 67.5 1 81 248 437 498 XP_070017332.1 uncharacterized protein [Nicotiana sylvestris] diamond 186 50.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana sylvestris
28353832 28353832 PRJNA1104180_P_NODE_17806_length_262_cov_1.629630_g17664_i0 PRJNA1104180 17806 262 1.62963 4.2696306 Citrus 2706 Plants Plants 55.5 1.61e-6   NR KAH9668917.1 2711 g17664 i0 81.5 1.23664122137405 27 5 30.9 0 202 122 1049 1075 KAH9668917.1 UDP-glycosyltransferase 92A1 [Citrus sinensis] diamond 324 55.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
28804364 28804364 PRJNA1104180_P_NODE_14028_length_283_cov_1.461905_g13886_i0 PRJNA1104180 14028 283 1.461905 4.13719115 Acacia crassicarpa 499986 Plants Plants 43.9 0.0224   NR KAK4254594.1 499986 g13886 i0 30 0.954063604240283 90 34 80.6 4 31 258 38 112 KAK4254594.1 hypothetical protein QN277_009952 [Acacia crassicarpa] diamond 270 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Acacia Acacia crassicarpa
28962722 28962722 PRJNA1104180_P_NODE_20388_length_251_cov_0.865169_g20245_i0 PRJNA1104180 20388 251 0.865169 2.17157419 Klebsormidium nitens 105231 Plants Plants 67.8 6.28e-11   NR GAQ88260.1 105231 g20245 i0 93.9 0.394422310756972 33 2 39.4 0 152 250 11 43 GAQ88260.1 Ca2+ transporting ATPase [Klebsormidium nitens] diamond 99 67.8 1 Eukaryota   Viridiplantae Streptophyta Klebsormidiophyceae Klebsormidiales Klebsormidiaceae Klebsormidium Klebsormidium nitens
29278046 29278046 PRJNA1104180_P_NODE_19009_length_256_cov_1.683060_g18867_i0 PRJNA1104180 19009 256 1.68306 4.3086336 Carya illinoinensis 32201 Plants Plants 124 1.15e-30   NR XP_042964743.1 32201 g18867 i0 63.9 0.97265625 83 28 94.9 2 2 244 245 327 XP_042964743.1 uncharacterized protein LOC122298967 [Carya illinoinensis] diamond 249 124 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Juglandaceae Carya Carya illinoinensis
30722373 30722373 PRJNA1104180_P_NODE_21454_length_249_cov_0.875000_g21311_i0 PRJNA1104180 21454 249 0.875 2.17875 Cannabaceae 3481 Plants Plants 148 2.56e-39   NR XP_060972445.1 3483 g21311 i0 80.2 6.86746987951807 81 16 97.6 0 245 3 1261 1341 XP_060972445.1 uncharacterized protein LOC133038339 [Cannabis sativa] diamond 1710 149 0.993288590604027 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
30762887 30762887 PRJNA1104180_P_NODE_28694_length_200_cov_4.582677_g28551_i0 PRJNA1104180 28694 200 4.582677 9.165354 Magnolia sinica 86752 Plants Plants 52 1.11e-5   NR XP_058099697.1 86752 g28551 i0 39.1 1.92 64 39 96 0 5 196 122 185 XP_058099697.1 uncharacterized protein LOC131244048 [Magnolia sinica] diamond 384 52 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Magnoliales Magnoliaceae Magnolia Magnolia sinica
31670805 31670805 PRJNA1104180_P_NODE_19257_length_255_cov_1.456044_g19114_i0 PRJNA1104180 19257 255 1.456044 3.7129122 Rhynchospora 46332 Plants Plants 153 2.4899999999999998e-42   NR KAJ3704163.1 198213 g19114 i0 90.9 3.10588235294118 88 4 98.8 1 253 2 117 204 KAJ3704163.1 hypothetical protein LUZ61_007868 [Rhynchospora tenuis] diamond 792 153 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Cyperaceae Rhynchospora Rhynchospora tenuis
31742706 31742706 PRJNA1104180_P_NODE_26657_length_241_cov_0.886905_g26514_i0 PRJNA1104180 26657 241 0.886905 2.13744105 Paspalum vaginatum 158149 Plants Plants 54.3 2.61e-6   NR KAJ1295722.1 158149 g26514 i0 52 0.622406639004149 50 21 58.5 1 235 95 83 132 KAJ1295722.1 hypothetical protein BS78_01G244800 [Paspalum vaginatum] diamond 150 54.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Paspalum Paspalum vaginatum
31774364 31774364 PRJNA1104180_P_NODE_20757_length_250_cov_0.870056_g20614_i0 PRJNA1104180 20757 250 0.870056 2.17514 Lactuca sativa 4236 Plants Plants 42.7 0.0403   NR XP_023749567.3 4236 g20614 i0 50 0.984 46 22 55.2 1 205 68 407 451 XP_023749567.3 uncharacterized protein LOC111897859 [Lactuca sativa] diamond 246 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca sativa
31837548 31837548 PRJNA1104180_P_NODE_24077_length_245_cov_0.895349_g23934_i0 PRJNA1104180 24077 245 0.895349 2.19360505 Abeliophyllum distichum 126358 Plants Plants 44.7 0.00799   NR KAL2510650.1 126358 g23934 i0 36.7 0.73469387755102 60 34 68.6 2 21 188 25 84 KAL2510650.1 putative PhzC/PhzF-type epimerase [Abeliophyllum distichum] diamond 180 44.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Abeliophyllum Abeliophyllum distichum
31932562 31932562 PRJNA1104180_P_NODE_21377_length_249_cov_0.875000_g21234_i0 PRJNA1104180 21377 249 0.875 2.17875 Nicotiana tomentosiformis 4098 Plants Plants 110 7.57e-26   NR XP_070037104.1 4098 g21234 i0 66.3 11 83 28 100 0 1 249 444 526 XP_070037104.1 uncharacterized protein [Nicotiana tomentosiformis] diamond 2739 110 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana tomentosiformis
32502414 32502414 PRJNA1104180_P_NODE_27279_length_232_cov_2.465409_g27136_i0 PRJNA1104180 27279 232 2.465409 5.71974888 Daucus carota subsp. sativus 79200 Plants Plants 48.9 2.22e-4   NR XP_063945924.1 79200 g27136 i0 55.6 0.581896551724138 45 18 55.6 1 130 2 831 875 XP_063945924.1 uncharacterized protein LOC135151408 [Daucus carota subsp. sativus] diamond 135 48.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Daucus Daucus carota
32659663 32659663 PRJNA1104180_P_NODE_20220_length_251_cov_0.865169_g20077_i0 PRJNA1104180 20220 251 0.865169 2.17157419 Papaver somniferum 3469 Plants Plants 78.2 1.36e-14   NR XP_026443285.1 3469 g20077 i0 42.5 0.956175298804781 80 46 95.6 0 241 2 304 383 XP_026443285.1 uncharacterized protein K02A2.6-like [Papaver somniferum] diamond 240 78.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Papaveraceae Papaver Papaver somniferum
32880278 32880278 PRJNA1104180_P_NODE_21560_length_249_cov_0.875000_g21417_i0 PRJNA1104180 21560 249 0.875 2.17875 Lactuca sativa 4236 Plants Plants 108 4.61e-27   NR KAJ0187178.1 4236 g21417 i0 67.9 0.939759036144578 78 23 91.6 1 247 20 103 180 KAJ0187178.1 hypothetical protein LSAT_V11C900480560 [Lactuca sativa] diamond 234 108 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca sativa

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