RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA283169 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
4198861 4198861 PRJNA283169_P_NODE_1424_length_335_cov_1.335664_g1362_i0 PRJNA283169 1424 335 1.335664 4.4744744 Tanacetum cinerariifolium 118510 Plants Plants 65.9 8.76e-10   NR GEZ17793.1 118510 g1362 i0 61.7 48.134328358209 47 18 42.1 0 1 141 862 908 GEZ17793.1 RecQ helicase L2 [Tanacetum cinerariifolium] diamond 16125 65.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
4198918 4198918 PRJNA283169_P_NODE_5524_length_182_cov_1.165414_g5461_i0 PRJNA283169 5524 182 1.165414 2.12105348 Daucus carota subsp. sativus 79200 Plants Plants 112 3.55e-27   NR XP_063942643.1 79200 g5461 i0 88.1 10.5 59 7 97.3 0 2 178 321 379 XP_063942643.1 uncharacterized protein LOC135150309 [Daucus carota subsp. sativus] diamond 1911 112 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Daucus Daucus carota
9299898 9299898 PRJNA283169_S_NODE_2428_length_184_cov_1.133333_g2414_i0 PRJNA283169 2428 184 1.133333 2.08533272 Eukaryota 2759 Plants Plants 91.7 5.89e-21   NR KAH0913690.1 3708 g2414 i0 72.7 17.4782608695652 55 15 89.7 0 18 182 34 88 KAH0913690.1 hypothetical protein HID58_037011 [Brassica napus] diamond 3216 91.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
27390359 27390359 PRJNA283169_P_NODE_4723_length_195_cov_1.232877_g4660_i0 PRJNA283169 4723 195 1.232877 2.40411015 Cryptomeria japonica 3369 Plants Plants 53.5 1.22e-6   NR GLJ20861.1 3369 g4660 i0 61.1 1.10769230769231 36 14 55.4 0 71 178 104 139 GLJ20861.1 hypothetical protein SUGI_0380490 [Cryptomeria japonica] diamond 216 53.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
27597454 27597454 PRJNA283169_P_NODE_4264_length_204_cov_0.987097_g4201_i0 PRJNA283169 4264 204 0.987097 2.01367788 Magnoliopsida 3398 Plants Plants 52 9.4e-6   NR KAH9735168.1 2711 g4201 i0 52.2 6.07352941176471 46 22 67.6 0 6 143 96 141 KAH9735168.1 zf-RVT domain-containing protein [Citrus sinensis] diamond 1239 52 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
27769331 27769331 PRJNA283169_P_NODE_4884_length_193_cov_0.916667_g4821_i0 PRJNA283169 4884 193 0.916667 1.76916731 Cannabis sativa 3483 Plants Plants 42.4 0.0271   NR KAF4368741.1 3483 g4821 i0 37.3 2.75129533678756 59 32 83.9 1 22 183 485 543 KAF4368741.1 hypothetical protein G4B88_003614 [Cannabis sativa] diamond 531 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
28684921 28684921 PRJNA283169_P_NODE_4327_length_202_cov_1.686275_g4264_i0 PRJNA283169 4327 202 1.686275 3.4062755 Sphagnum balticum 128184 Plants Plants 97.8 7.64e-22   NR CAM6003861.1 128184 g4264 i0 68.2 1.96039603960396 66 21 98 0 1 198 377 442 CAM6003861.1 unnamed protein product [Sphagnum balticum] diamond 396 97.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
29221678 29221678 PRJNA283169_P_NODE_4669_length_196_cov_1.319728_g4606_i0 PRJNA283169 4669 196 1.319728 2.58666688 Heracleum sosnowskyi 360622 Plants Plants 86.3 1.09e-19   NR KAK1388366.1 360622 g4606 i0 66.2 2.98469387755102 65 15 88.8 1 23 196 35 99 KAK1388366.1 hypothetical protein POM88_016544 [Heracleum sosnowskyi] diamond 585 86.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Heracleum Heracleum sosnowskyi
29347849 29347849 PRJNA283169_P_NODE_1689_length_312_cov_1.730038_g1627_i0 PRJNA283169 1689 312 1.730038 5.39771856 Heracleum sosnowskyi 360622 Plants Plants 107 1.16e-25   NR KAK1365124.1 360622 g1627 i0 58.3 2.92307692307692 103 34 90.4 2 30 311 209 311 KAK1365124.1 hypothetical protein POM88_040685 [Heracleum sosnowskyi] diamond 912 107 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Heracleum Heracleum sosnowskyi
29965500 29965500 PRJNA283169_S_NODE_2451_length_183_cov_1.492537_g2437_i0 PRJNA283169 2451 183 1.492537 2.73134271 Eukaryota 2759 Plants Plants 97.1 5.02e-23   NR KAG9139817.1 34254 g2437 i0 85 131.491803278689 60 9 98.4 0 2 181 86 145 KAG9139817.1 hypothetical protein Leryth_020218 [Lithospermum erythrorhizon] diamond 24063 97.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Boraginales Boraginaceae Lithospermum Lithospermum erythrorhizon
30358976 30358976 PRJNA283169_P_NODE_2172_length_277_cov_1.771930_g2110_i0 PRJNA283169 2172 277 1.77193 4.9082461 Heracleum sosnowskyi 360622 Plants Plants 132 3.62e-35   NR KAK1362157.1 360622 g2110 i0 85.3 0.812274368231047 75 10 80.1 1 3 224 278 352 KAK1362157.1 RING-H2 finger protein ATL47 [Heracleum sosnowskyi] diamond 225 132 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Heracleum Heracleum sosnowskyi
32129103 32129103 PRJNA283169_P_NODE_1618_length_317_cov_2.261194_g1556_i0 PRJNA283169 1618 317 2.261194 7.16798498 Acorus calamus 4465 Plants Plants 45.1 0.0135   NR KAK1326072.1 4465 g1556 i0 33.3 0.766561514195584 81 51 73.8 2 70 303 615 695 KAK1326072.1 hypothetical protein QJS10_CPA01g01422 [Acorus calamus] diamond 243 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Acorales Acoraceae Acorus Acorus calamus
32209911 32209911 PRJNA283169_P_NODE_7858_length_163_cov_0.894737_g7795_i0 PRJNA283169 7858 163 0.894737 1.45842131 Magnoliopsida 3398 Plants Plants 45.4 0.00143   NR KAL0725132.1 52824 g7795 i0 57.1 19.3251533742331 35 15 64.4 0 162 58 637 671 KAL0725132.1 hypothetical protein Bca4012_039731 [Brassica carinata] diamond 3150 45.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica carinata
32477140 32477140 PRJNA283169_S_NODE_2679_length_176_cov_1.244094_g2665_i0 PRJNA283169 2679 176 1.244094 2.18960544 Sphagnum jensenii 128206 Plants Plants 114 5.799999999999999e-31   NR CAK9251138.1 128206 g2665 i0 91.4 0.988636363636364 58 5 98.9 0 2 175 11 68 CAK9251138.1 unnamed protein product [Sphagnum jensenii] diamond 174 114 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
32666250 32666250 PRJNA283169_P_NODE_1680_length_313_cov_1.155303_g1618_i0 PRJNA283169 1680 313 1.155303 3.61609839 Oryza sativa Japonica Group 39947 Plants Plants 43.9 0.0333   NR NP_001410491.1 39947 g1618 i0 37.3 1.43769968051118 75 46 70.9 1 245 24 703 777 NP_001410491.1 trafficking protein particle complex II-specific subunit 130 homolog [Oryza sativa Japonica Group] diamond 450 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza 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);;