RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA851399 · 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
2114675 2114675 PRJNA851399_P_NODE_21202_length_175_cov_1.246032_g20749_i0 PRJNA851399 21202 175 1.246032 2.180556 Brassica carinata 52824 Plants Plants 107 9.1e-26   NR KAL0713680.1 52824 g20749 i0 91.4 1.98857142857143 58 5 99.4 0 175 2 291 348 KAL0713680.1 hypothetical protein Bca4012_020658 [Brassica carinata] diamond 348 107 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica carinata
12318401 12318401 PRJNA851399_P_NODE_16370_length_188_cov_1.143885_g15917_i0 PRJNA851399 16370 188 1.143885 2.1505038 Salvia splendens 180675 Plants Plants 117 1.08e-28   NR XP_042045797.1 180675 g15917 i0 82.3 2.96808510638298 62 11 98.9 0 3 188 550 611 XP_042045797.1 vacuolar-sorting receptor 1-like [Salvia splendens] diamond 558 117 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Salvia Salvia splendens
26905122 26905122 PRJNA851399_P_NODE_31201_length_165_cov_0.879310_g30748_i0 PRJNA851399 31201 165 0.87931 1.4508615 Lamiales 4143 Plants Plants 92.4 3.96e-20   NR XP_011087984.1 4182 g30748 i0 75.9 3.92727272727273 54 13 98.2 0 163 2 159 212 XP_011087984.1 transcription factor GTE7-like [Sesamum indicum] diamond 648 92.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Pedaliaceae Sesamum Sesamum indicum
27497453 27497453 PRJNA851399_P_NODE_35963_length_163_cov_0.894737_g35510_i0 PRJNA851399 35963 163 0.894737 1.45842131 Perilla frutescens var. hirtella 608512 Plants Plants 78.6 2.79e-15   NR KAH6756593.1 608512 g35510 i0 70.4 0.993865030674847 54 16 99.4 0 1 162 82 135 KAH6756593.1 P-loop containing nucleoside triphosphate hydrolases superfamily protein [Perilla frutescens var. hirtella] diamond 162 78.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Perilla Perilla frutescens
27852834 27852834 PRJNA851399_P_NODE_31044_length_165_cov_0.879310_g30591_i0 PRJNA851399 31044 165 0.87931 1.4508615 Streptophyta 35493 Plants Plants 107 4.57e-26   NR ABK24364.1 3332 g30591 i0 87 20.5818181818182 54 7 98.2 0 164 3 254 307 ABK24364.1 unknown [Picea sitchensis] diamond 3396 107 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
28286495 28286495 PRJNA851399_P_NODE_36246_length_163_cov_0.894737_g35793_i0 PRJNA851399 36246 163 0.894737 1.45842131 Cucumis melo var. makuwa 1194695 Plants Plants 65.9 8.51e-11   NR KAA0051170.1 1194695 g35793 i0 73 4.76687116564417 37 10 68.1 0 113 3 151 187 KAA0051170.1 zinc finger BED domain-containing protein RICESLEEPER 3-like [Cucumis melo var. makuwa] diamond 777 65.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucumis Cucumis melo
28476189 28476189 PRJNA851399_P_NODE_36426_length_163_cov_0.894737_g35973_i0 PRJNA851399 36426 163 0.894737 1.45842131 Rehmannia glutinosa 99300 Plants Plants 52.8 3.52e-6   NR KAK6145513.1 99300 g35973 i0 59.5 0.773006134969325 42 15 73.6 1 122 3 51 92 KAK6145513.1 hypothetical protein DH2020_022333 [Rehmannia glutinosa] diamond 126 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Rehmannia Rehmannia glutinosa
29580942 29580942 PRJNA851399_P_NODE_41210_length_161_cov_0.910714_g40757_i0 PRJNA851399 41210 161 0.910714 1.46624954 Picea sitchensis 3332 Plants Plants 43.9 0.00423   NR QHR92899.1 3332 g40757 i0 51.1 0.875776397515528 47 23 87.6 0 160 20 165 211 QHR92899.1 hypothetical protein Q903MT_gene6948 [Picea sitchensis] diamond 141 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
29707113 29707113 PRJNA851399_P_NODE_41310_length_161_cov_0.910714_g40857_i0 PRJNA851399 41310 161 0.910714 1.46624954 Perilla frutescens var. frutescens 151328 Plants Plants 87.4 4.32e-19   NR KAH6808190.1 151328 g40857 i0 87 0.857142857142857 46 6 85.7 0 160 23 89 134 KAH6808190.1 Rossmann-fold superfamily protein [Perilla frutescens var. frutescens] diamond 138 87.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Perilla Perilla frutescens
29991855 29991855 PRJNA851399_P_NODE_39051_length_162_cov_0.876106_g38598_i0 PRJNA851399 39051 162 0.876106 1.41929172 Lolium multiflorum 4521 Plants Plants 81.3 3.22e-16   NR KAK1644039.1 4521 g38598 i0 65.4 1.92592592592593 52 18 96.3 0 5 160 30 81 KAK1644039.1 hypothetical protein QYE76_061844 [Lolium multiflorum] diamond 312 81.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium multiflorum
30054810 30054810 PRJNA851399_P_NODE_27771_length_166_cov_0.871795_g27318_i0 PRJNA851399 27771 166 0.871795 1.4471797 Picea glauca 3330 Plants Plants 63.2 4.28e-10   NR KUM49347.1 3330 g27318 i0 59.2 0.885542168674699 49 20 88.6 0 12 158 161 209 KUM49347.1 hypothetical protein ABT39_MTgene3896 [Picea glauca] diamond 147 63.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea glauca
30276476 30276476 PRJNA851399_P_NODE_30492_length_165_cov_0.879310_g30039_i0 PRJNA851399 30492 165 0.87931 1.4508615 Ceratopteris richardii 49495 Plants Plants 41.2 0.0458   NR KAH7297306.1 49495 g30039 i0 42.9 0.890909090909091 49 19 80 2 29 160 95 139 KAH7297306.1 hypothetical protein KP509_26G064700 [Ceratopteris richardii] diamond 147 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
30434486 30434486 PRJNA851399_P_NODE_32393_length_164_cov_0.886957_g31940_i0 PRJNA851399 32393 164 0.886957 1.45460948 Taxus chinensis 29808 Plants Plants 67.4 1.09e-11   NR KAH9293205.1 29808 g31940 i0 53.7 2.96341463414634 54 25 98.8 0 163 2 151 204 KAH9293205.1 hypothetical protein KI387_041589, partial [Taxus chinensis] diamond 486 67.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
31698468 31698468 PRJNA851399_P_NODE_10617_length_239_cov_3.768421_g10164_i0 PRJNA851399 10617 239 3.768421 9.00652619 Vigna unguiculata 3917 Plants Plants 42.4 0.0272   NR QCD80736.1 3917 g10164 i0 45.1 0.640167364016736 51 26 61.5 2 197 51 67 117 QCD80736.1 hypothetical protein DEO72_LG2g1058 [Vigna unguiculata] diamond 153 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Vigna Vigna unguiculata
31761720 31761720 PRJNA851399_P_NODE_38897_length_162_cov_0.902655_g38444_i0 PRJNA851399 38897 162 0.902655 1.4623011 Striga hermonthica 68872 Plants Plants 44.3 0.00344   NR CAA0836035.1 68872 g38444 i0 50 1.5 40 20 74.1 0 155 36 258 297 CAA0836035.1 Polynucleotidyl transferase- ribonuclease H-like superfamily protein [Striga hermonthica] diamond 243 44.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Striga Striga hermonthica
31888181 31888181 PRJNA851399_P_NODE_41117_length_161_cov_0.910714_g40664_i0 PRJNA851399 41117 161 0.910714 1.46624954 Triticum aestivum 4565 Plants Plants 84 3.11e-17   NR XBI64263.1 4565 g40664 i0 92.3 0.726708074534162 39 3 72.7 0 119 3 1 39 XBI64263.1 hypothetical protein VPH35_044458 [Triticum aestivum] diamond 117 84 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
32363141 32363141 PRJNA851399_P_NODE_18059_length_183_cov_1.134328_g17606_i0 PRJNA851399 18059 183 1.134328 2.07582024 Phtheirospermum japonicum 374723 Plants Plants 90.1 3.82e-22   NR GFP79670.1 374723 g17606 i0 77.4 0.868852459016393 53 12 86.9 0 2 160 12 64 GFP79670.1 protein ralf-like 19 [Phtheirospermum japonicum] diamond 159 90.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Phtheirospermum Phtheirospermum japonicum
32615763 32615763 PRJNA851399_P_NODE_23160_length_170_cov_1.685950_g22707_i0 PRJNA851399 23160 170 1.68595 2.866115 Malania oleifera 397392 Plants Plants 42.7 0.0139   NR XP_057976137.1 397392 g22707 i0 50 0.776470588235294 44 20 75.9 2 32 160 309 351 XP_057976137.1 putative disease resistance RPP13-like protein 1 [Malania oleifera] diamond 132 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Santalales Ximeniaceae Malania Malania oleifera

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