RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA688655" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA688655 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
1943050 1943050 PRJNA688655_P_NODE_10182_length_248_cov_0.880000_g10117_i0 PRJNA688655 10182 248 0.88 2.1824 Gossypium australe 47621 Plants Plants 102 6.61e-24   NR KAA3470154.1 47621 g10117 i0 63.3 1.91129032258065 79 25 95.6 1 237 1 214 288 KAA3470154.1 Gag protease polyprotein-like protein [Gossypium australe] diamond 474 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium australe
5770857 5770857 PRJNA688655_P_NODE_7985_length_251_cov_0.865169_g7920_i0 PRJNA688655 7985 251 0.865169 2.17157419 Zingiber officinale 94328 Plants Plants 121 1.02e-29   NR KAG6535161.1 94328 g7920 i0 78.8 1.57768924302789 66 14 78.9 0 202 5 1394 1459 KAG6535161.1 hypothetical protein ZIOFF_000120 [Zingiber officinale] diamond 396 121 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Zingiberaceae Zingiber Zingiber officinale
12656371 12656371 PRJNA688655_P_NODE_8190_length_251_cov_0.865169_g8125_i0 PRJNA688655 8190 251 0.865169 2.17157419 Zingiber officinale 94328 Plants Plants 143 2.07e-37   NR KAG6535161.1 94328 g8125 i0 81.9 0.99203187250996006 83 15 99.2 0 2 250 2016 2098 KAG6535161.1 hypothetical protein ZIOFF_000120 [Zingiber officinale] diamond 249 143 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Zingiberaceae Zingiber Zingiber officinale
16479749 16479749 PRJNA688655_P_NODE_4393_length_308_cov_1.089362_g4328_i0 PRJNA688655 4393 308 1.089362 3.35523496 Solanum 4107 Plants Plants 142 1.41e-41   NR KAH0729373.1 4113 g4328 i0 95.7 1.5 69 3 67.2 0 257 51 1 69 KAH0729373.1 hypothetical protein KY289_000561 [Solanum tuberosum] diamond 462 142 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum tuberosum
17245121 17245121 PRJNA688655_P_NODE_3114_length_343_cov_0.937037_g3049_i0 PRJNA688655 3114 343 0.937037 3.21403691 Rehmannia glutinosa 99300 Plants Plants 168 8.88e-51   NR KAK6121534.1 99300 g3049 i0 72 3.08746355685131 118 29 99.7 1 342 1 19 136 KAK6121534.1 hypothetical protein DH2020_044725 [Rehmannia glutinosa] diamond 1059 168 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Rehmannia Rehmannia glutinosa
26639065 26639065 PRJNA688655_P_NODE_8541_length_250_cov_0.870056_g8476_i0 PRJNA688655 8541 250 0.870056 2.17514 Zingiber officinale 94328 Plants Plants 132 9.13e-34   NR XP_042401007.1 94328 g8476 i0 67.1 1.968 82 27 98.4 0 248 3 162 243 XP_042401007.1 uncharacterized protein LOC121991043 [Zingiber officinale] diamond 492 132 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Zingiberaceae Zingiber Zingiber officinale
26967182 26967182 PRJNA688655_P_NODE_2722_length_358_cov_0.891228_g2657_i0 PRJNA688655 2722 358 0.891228 3.19059624 Magnoliopsida 3398 Plants Plants 175 1.0700000000000001e-49   NR WRX30367.1 3641 g2657 i0 60.5 7.57541899441341 119 45 98 1 4 354 44 162 WRX30367.1 Integrase [Theobroma cacao] diamond 2712 175 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Theobroma Theobroma cacao
27082258 27082258 PRJNA688655_P_NODE_14542_length_243_cov_0.905882_g14477_i0 PRJNA688655 14542 243 0.905882 2.20129326 Zingiber officinale 94328 Plants Plants 114 1.6300000000000002e-27   NR XP_042437174.1 94328 g14477 i0 66.3 0.987654320987654 80 27 98.8 0 4 243 11 90 XP_042437174.1 beta-fructofuranosidase, insoluble isoenzyme 3-like [Zingiber officinale] diamond 240 114 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Zingiberaceae Zingiber Zingiber officinale
27251796 27251796 PRJNA688655_P_NODE_1463_length_453_cov_1.394737_g1398_i0 PRJNA688655 1463 453 1.394737 6.31815861 Eukaryota 2759 Plants Plants 157 4.11e-46   NR MQL76887.1 4460 g1398 i0 68.3 36.2847682119205 120 37 78.8 1 2 358 23 142 MQL76887.1 hypothetical protein [Colocasia esculenta] diamond 16437 158 0.993670886075949 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Alismatales Araceae Colocasia Colocasia esculenta
27473045 27473045 PRJNA688655_P_NODE_9483_length_249_cov_0.875000_g9418_i0 PRJNA688655 9483 249 0.875 2.17875 Magnoliopsida 3398 Plants Plants 109 3.19e-26   NR KAK0575612.1 4024 g9418 i0 73.2 4.27710843373494 71 19 85.5 0 246 34 277 347 KAK0575612.1 hypothetical protein LWI29_003730 [Acer saccharum] diamond 1065 110 0.990909090909091 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer saccharum
27682834 27682834 PRJNA688655_P_NODE_8264_length_251_cov_0.865169_g8199_i0 PRJNA688655 8264 251 0.865169 2.17157419 Rehmannia glutinosa 99300 Plants Plants 140 7.03e-40   NR KAK6152942.1 99300 g8199 i0 81.9 0.99203187250996006 83 15 99.2 0 250 2 71 153 KAK6152942.1 hypothetical protein DH2020_012581 [Rehmannia glutinosa] diamond 249 140 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Rehmannia Rehmannia glutinosa
27903282 27903282 PRJNA688655_P_NODE_12905_length_245_cov_0.895349_g12840_i0 PRJNA688655 12905 245 0.895349 2.19360505 Zingiber officinale 94328 Plants Plants 110 4.28e-28   NR XP_042467063.1 94328 g12840 i0 64.2 0.991836734693878 81 29 99.2 0 244 2 21 101 XP_042467063.1 uncharacterized protein LOC122050201 [Zingiber officinale] diamond 243 110 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Zingiberaceae Zingiber Zingiber officinale
28250690 28250690 PRJNA688655_P_NODE_9286_length_249_cov_0.875000_g9221_i0 PRJNA688655 9286 249 0.875 2.17875 Zingiber officinale 94328 Plants Plants 101 1.07e-22   NR KAG6497747.1 94328 g9221 i0 61.7 0.975903614457831 81 26 92.8 2 249 19 634 713 KAG6497747.1 hypothetical protein ZIOFF_045652 [Zingiber officinale] diamond 243 101 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Zingiberaceae Zingiber Zingiber officinale
28578154 28578154 PRJNA688655_P_NODE_8967_length_250_cov_0.870056_g8902_i0 PRJNA688655 8967 250 0.870056 2.17514 Eukaryota 2759 Plants Plants 46.6 0.00175   NR KAI7728688.1 4212 g8902 i0 51.6 2.676 31 15 37.2 0 95 3 217 247 KAI7728688.1 hypothetical protein M8C21_019059 [Ambrosia artemisiifolia] diamond 669 47 0.991489361702128 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Ambrosia Ambrosia artemisiifolia
29356010 29356010 PRJNA688655_P_NODE_16509_length_241_cov_0.916667_g16444_i0 PRJNA688655 16509 241 0.916667 2.20916747 Cuscuta epithymum 186058 Plants Plants 130 6.95e-33   NR CAH9122858.1 186058 g16444 i0 70 11.9253112033195 80 24 99.6 0 1 240 470 549 CAH9122858.1 unnamed protein product [Cuscuta epithymum] diamond 2874 130 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Cuscuta Cuscuta epithymum
29924405 29924405 PRJNA688655_P_NODE_9071_length_250_cov_0.870056_g9006_i0 PRJNA688655 9071 250 0.870056 2.17514 Zingiber officinale 94328 Plants Plants 146 2.8999999999999996e-42   NR XP_042404634.1 94328 g9006 i0 83.1 1.992 83 14 99.6 0 1 249 73 155 XP_042404634.1 uncharacterized mitochondrial protein AtMg00860-like [Zingiber officinale] diamond 498 146 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Zingiberaceae Zingiber Zingiber officinale
30662516 30662516 PRJNA688655_P_NODE_12613_length_245_cov_0.895349_g12548_i0 PRJNA688655 12613 245 0.895349 2.19360505 Fabales 72025 Plants Plants 80.1 2.51e-15   NR KAJ7980123.1 32244 g12548 i0 76.1 1.66530612244898 46 11 56.3 0 45 182 436 481 KAJ7980123.1 ATP sulfurylase [Quillaja saponaria] diamond 408 80.5 0.995031055900621 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Quillajaceae Quillaja Quillaja saponaria
31219363 31219363 PRJNA688655_P_NODE_3115_length_343_cov_0.922222_g3050_i0 PRJNA688655 3115 343 0.922222 3.16322146 Zingiber officinale 94328 Plants Plants 146 6.029999999999999e-38   NR KAG6535161.1 94328 g3050 i0 59.6 1.9067055393586 109 40 91.8 2 317 3 1369 1477 KAG6535161.1 hypothetical protein ZIOFF_000120 [Zingiber officinale] diamond 654 146 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Zingiberaceae Zingiber Zingiber officinale
31662341 31662341 PRJNA688655_P_NODE_10677_length_248_cov_0.880000_g10612_i0 PRJNA688655 10677 248 0.88 2.1824 Zingiber officinale 94328 Plants Plants 136 1.97e-36   NR XP_042388062.1 94328 g10612 i0 80.2 5.87903225806452 81 16 98 0 244 2 232 312 XP_042388062.1 uncharacterized protein LOC121980165 [Zingiber officinale] diamond 1458 136 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Zingiberaceae Zingiber Zingiber officinale
31788807 31788807 PRJNA688655_P_NODE_12957_length_245_cov_0.895349_g12892_i0 PRJNA688655 12957 245 0.895349 2.19360505 Senna tora 362788 Plants Plants 42.7 0.0366   NR KAF7802284.1 362788 g12892 i0 33.8 0.83265306122449 68 43 80.8 1 17 214 58 125 KAF7802284.1 uncharacterized protein G2W53_041395 [Senna tora] diamond 204 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Senna Senna tora
31883851 31883851 PRJNA688655_P_NODE_9517_length_249_cov_0.875000_g9452_i0 PRJNA688655 9517 249 0.875 2.17875 Zingiber officinale 94328 Plants Plants 62.8 6.32e-10   NR XP_042409916.1 94328 g9452 i0 50.9 3.03614457831325 55 27 66.3 0 3 167 20 74 XP_042409916.1 uncharacterized protein LOC121999282 [Zingiber officinale] diamond 756 62.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Zingiberaceae Zingiber Zingiber officinale
31915539 31915539 PRJNA688655_P_NODE_12617_length_245_cov_0.895349_g12552_i0 PRJNA688655 12617 245 0.895349 2.19360505 Vigna mungo 3915 Plants Plants 43.9 0.00811   NR WVZ01768.1 3915 g12552 i0 40 0.551020408163265 45 27 55.1 0 174 40 22 66 WVZ01768.1 hypothetical protein V8G54_022574, partial [Vigna mungo] diamond 135 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Vigna Vigna mungo

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