RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1047749" 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

  • PRJNA1047749 · 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
9102690 9102690 PRJNA1047749_P_NODE_308_length_1394_cov_8.392884_g232_i0 PRJNA1047749 308 1394 8.392884 116.99680296 Amaranthus tricolor 29722 Plants Plants 263 1.32e-80   NR XP_057548592.1 29722 g232 i0 62.2 0.563845050215208 262 31 56.4 1 1394 609 129 322 XP_057548592.1 ATP synthase subunit a, chloroplastic-like [Amaranthus tricolor] diamond 786 263 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Amaranthaceae Amaranthus Amaranthus tricolor
11213855 11213855 PRJNA1047749_P_NODE_40449_length_248_cov_8.337143_g40182_i0 PRJNA1047749 40449 248 8.337143 20.67611464 Triticum aestivum 4565 Plants Plants 61.6 2.01e-9   NR KAF6988046.1 4565 g40182 i0 86.7 0.362903225806452 30 4 36.3 0 159 248 1 30 KAF6988046.1 hypothetical protein CFC21_005632 [Triticum aestivum] diamond 90 61.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
11653849 11653849 PRJNA1047749_P_NODE_45450_length_233_cov_2.662500_g45183_i0 PRJNA1047749 45450 233 2.6625 6.203625 Magnoliopsida 3398 Plants Plants 87.8 4.45e-18   NR KAE8800699.1 4513 g45183 i0 51.5 21.7596566523605 66 32 85 0 209 12 315 380 KAE8800699.1 hypothetical protein D1007_23698 [Hordeum vulgare] diamond 5070 88.2 0.99546485260771 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
26718337 26718337 PRJNA1047749_P_NODE_23961_length_301_cov_4.057018_g23694_i0 PRJNA1047749 23961 301 4.057018 12.21162418 Miscanthus floridulus 154761 Plants Plants 81.6 1.59e-15   NR XP_066373432.1 154761 g23694 i0 73.3 1.67441860465116 45 12 44.9 0 21 155 401 445 XP_066373432.1 uncharacterized protein [Miscanthus floridulus] diamond 504 81.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Miscanthus Miscanthus floridulus
27066801 27066801 PRJNA1047749_P_NODE_44782_length_235_cov_3.691358_g44515_i0 PRJNA1047749 44782 235 3.691358 8.6746913 Cichorium endivia 114280 Plants Plants 98.6 7.31e-22   NR KAI3488032.1 114280 g44515 i0 90.9 1.40425531914894 55 5 70.2 0 232 68 154 208 KAI3488032.1 hypothetical protein L1887_47960 [Cichorium endivia] diamond 330 98.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Cichorium Cichorium endivia
27256526 27256526 PRJNA1047749_P_NODE_51943_length_197_cov_6.419355_g51676_i0 PRJNA1047749 51943 197 6.419355 12.64612935 Acer negundo 4023 Plants Plants 42 0.0377   NR KAI9195332.1 4023 g51676 i0 51.7 0.883248730964467 58 25 83.8 3 197 33 191 248 KAI9195332.1 hypothetical protein LWI28_013923 [Acer negundo] diamond 174 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer negundo
27572408 27572408 PRJNA1047749_P_NODE_6824_length_473_cov_3.885000_g6567_i0 PRJNA1047749 6824 473 3.885 18.37605 Cichorium endivia 114280 Plants Plants 260 4.94e-81   NR KAI3488032.1 114280 g6567 i0 85.8 0.938689217758985 148 21 93.9 0 30 473 377 524 KAI3488032.1 hypothetical protein L1887_47960 [Cichorium endivia] diamond 444 260 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Cichorium Cichorium endivia
27888054 27888054 PRJNA1047749_P_NODE_40425_length_249_cov_0.886364_g40158_i0 PRJNA1047749 40425 249 0.886364 2.20704636 Punica granatum 22663 Plants Plants 46.2 0.00175   NR PKI68145.1 22663 g40158 i0 40.8 0.855421686746988 71 36 78.3 1 232 38 3 73 PKI68145.1 hypothetical protein CRG98_011444 [Punica granatum] diamond 213 46.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Myrtales Lythraceae Punica Punica granatum
27951390 27951390 PRJNA1047749_P_NODE_50225_length_207_cov_4.022388_g49958_i0 PRJNA1047749 50225 207 4.022388 8.32634316 Lolium rigidum 89674 Plants Plants 122 1.55e-30   NR XP_047042828.1 89674 g49958 i0 80.9 0.985507246376812 68 13 98.6 0 206 3 1326 1393 XP_047042828.1 uncharacterized protein LOC124646819 [Lolium rigidum] diamond 204 122 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium rigidum
28045988 28045988 PRJNA1047749_P_NODE_25645_length_300_cov_3.731278_g25378_i0 PRJNA1047749 25645 300 3.731278 11.193834 Olea europaea var. sylvestris 158386 Plants Plants 67.4 9.44e-11   NR XP_022872607.1 158386 g25378 i0 61.7 2.35 47 18 47 0 295 155 100 146 XP_022872607.1 uncharacterized protein LOC111391588 [Olea europaea var. sylvestris] diamond 705 67.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
28172239 28172239 PRJNA1047749_P_NODE_10166_length_392_cov_6.705329_g9902_i0 PRJNA1047749 10166 392 6.705329 26.28488968 Arctium lappa 4217 Plants Plants 138 1.0299999999999998e-37   NR KAI3663126.1 4217 g9902 i0 97.1 0.528061224489796 69 2 52.8 0 372 166 140 208 KAI3663126.1 hypothetical protein L6452_46379 [Arctium lappa] diamond 207 138 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Arctium Arctium lappa
28614404 28614404 PRJNA1047749_P_NODE_42427_length_243_cov_3.876471_g42160_i0 PRJNA1047749 42427 243 3.876471 9.41982453 Picea glauca 3330 Plants Plants 47 5.58e-4   NR KUM48010.1 3330 g42160 i0 35.7 0.864197530864197 70 45 86.4 0 236 27 84 153 KUM48010.1 hypothetical protein ABT39_MTgene5005 [Picea glauca] diamond 210 47 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea glauca
29782597 29782597 PRJNA1047749_P_NODE_49091_length_214_cov_4.078014_g48824_i0 PRJNA1047749 49091 214 4.078014 8.72694996 Trifolium pratense 57577 Plants Plants 70.1 5.91e-12   NR PNY11358.1 57577 g48824 i0 57.4 2.27102803738318 54 23 75.7 0 183 22 494 547 PNY11358.1 gag-pol polyprotein, partial [Trifolium pratense] diamond 486 70.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium pratense
30066820 30066820 PRJNA1047749_P_NODE_2372_length_709_cov_6.061321_g2174_i0 PRJNA1047749 2372 709 6.061321 42.97476589 Cichorium endivia 114280 Plants Plants 183 5.349999999999998e-54   NR KAI3488033.1 114280 g2174 i0 94.9 1.29055007052186 99 5 41.9 0 77 373 1 99 KAI3488033.1 hypothetical protein L1887_47961 [Cichorium endivia] diamond 915 183 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Cichorium Cichorium endivia
30785480 30785480 PRJNA1047749_P_NODE_51934_length_197_cov_6.637097_g51667_i0 PRJNA1047749 51934 197 6.637097 13.07508109 Magnoliopsida 3398 Plants Plants 120 1.16e-33   NR KNA03294.1 3562 g51667 i0 100 1.85786802030457 61 0 92.9 0 3 185 26 86 KNA03294.1 hypothetical protein SOVF_210520, partial [Spinacia oleracea] diamond 366 120 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Spinacia Spinacia oleracea
31203871 31203871 PRJNA1047749_P_NODE_13995_length_331_cov_3.705426_g13730_i0 PRJNA1047749 13995 331 3.705426 12.26496006 Sorghum bicolor 4558 Plants Plants 46.2 0.00232   NR KAG0521463.1 4558 g13730 i0 92 0.226586102719033 25 2 22.7 0 257 331 1 25 KAG0521463.1 hypothetical protein BDA96_08G162700 [Sorghum bicolor] diamond 75 46.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Sorghum Sorghum bicolor
31457479 31457479 PRJNA1047749_P_NODE_23596_length_301_cov_4.907895_g23329_i0 PRJNA1047749 23596 301 4.907895 14.77276395 Lotus japonicus 34305 Plants Plants 70.1 1.83e-11   NR XP_057419764.1 34305 g23329 i0 61.4 3.01993355481728 44 17 43.9 0 137 6 915 958 XP_057419764.1 uncharacterized protein LOC130713954 [Lotus japonicus] diamond 909 70.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
31584097 31584097 PRJNA1047749_P_NODE_38836_length_253_cov_1.683333_g38569_i0 PRJNA1047749 38836 253 1.683333 4.25883249 Cryptomeria japonica 3369 Plants Plants 48.5 2.47e-4   NR XP_059068709.1 3369 g38569 i0 30.1 0.865612648221344 73 51 86.6 0 7 225 16 88 XP_059068709.1 uncharacterized protein LOC131859164 [Cryptomeria japonica] diamond 219 48.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
31963387 31963387 PRJNA1047749_P_NODE_38358_length_254_cov_6.331492_g38091_i0 PRJNA1047749 38358 254 6.331492 16.08198968 Taxus chinensis 29808 Plants Plants 72 3.73e-13   NR KAH9306753.1 29808 g38091 i0 41.5 0.968503937007874 82 48 96.9 0 3 248 26 107 KAH9306753.1 hypothetical protein KI387_011157, partial [Taxus chinensis] diamond 246 72 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
32018650 32018650 PRJNA1047749_P_NODE_17338_length_312_cov_4.836820_g17071_i0 PRJNA1047749 17338 312 4.83682 15.0908784 Magnoliopsida 3398 Plants Plants 99.8 8.2100000000000005e-22   NR XP_049357105.1 315347 g17071 i0 47.5 4.74038461538461 101 47 91.3 1 307 23 689 789 XP_049357105.1 LOW QUALITY PROTEIN: uncharacterized protein LOC125821768 [Solanum verrucosum] diamond 1479 100 0.998 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum verrucosum
32533228 32533228 PRJNA1047749_P_NODE_23599_length_301_cov_4.899123_g23332_i0 PRJNA1047749 23599 301 4.899123 14.74636023 Cichorium endivia 114280 Plants Plants 62.4 9.18e-9   NR KAI3488032.1 114280 g23332 i0 82.9 0.697674418604651 35 6 34.9 0 2 106 24 58 KAI3488032.1 hypothetical protein L1887_47960 [Cichorium endivia] diamond 210 62.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Cichorium Cichorium endivia

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