RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1012699" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1012699 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
9085613 9085613 PRJNA1012699_P_NODE_4028_length_242_cov_0.917160_g3996_i0 PRJNA1012699 4028 242 0.91716 2.2195272 Eukaryota 2759 Plants Plants 105 1.11e-25   NR ABR16850.1 3332 g3996 i0 67.6 8.14462809917355 74 23 90.5 1 241 23 172 245 ABR16850.1 unknown [Picea sitchensis] diamond 1971 106 0.990566037735849 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
9085616 9085616 PRJNA1012699_P_NODE_448_length_509_cov_1.745413_g416_i0 PRJNA1012699 448 509 1.745413 8.88415217 Magnoliopsida 3398 Plants Plants 208 7.27e-66   NR KAH9604985.1 39905 g416 i0 64.3 8.3811394891945 157 54 92.5 1 503 33 1 155 KAH9604985.1 hypothetical protein KSS87_007240 [Heliosperma pusillum] diamond 4266 208 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Caryophyllaceae Heliosperma Heliosperma pusillum
10361292 10361292 PRJNA1012699_P_NODE_769_length_407_cov_3.637725_g737_i0 PRJNA1012699 769 407 3.637725 14.80554075 Drosera rotundifolia 173423 Plants Plants 198 1.66e-62   NR GAB2232939.1 173423 g737 i0 77.7 6.68550368550369 130 29 95.8 0 391 2 1 130 GAB2232939.1 hypothetical protein Drorol1_Dr00012008 [Drosera rotundifolia] diamond 2721 198 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Droseraceae Drosera Drosera rotundifolia
11205709 11205709 PRJNA1012699_P_NODE_869_length_387_cov_5.394904_g837_i0 PRJNA1012699 869 387 5.394904 20.87827848 Eukaryota 2759 Plants Plants 211 9.240000000000001e-66   NR BAK03012.1 112509 g837 i0 83.6 11.3488372093023 122 20 94.6 0 2 367 192 313 BAK03012.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 4392 211 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
17580285 17580285 PRJNA1012699_P_NODE_994_length_365_cov_3.054795_g962_i0 PRJNA1012699 994 365 3.054795 11.15000175 Eukaryota 2759 Plants Plants 188 1.05e-58   NR KAF3336673.1 544730 g962 i0 76 17.6383561643836 121 29 99.5 0 2 364 28 148 KAF3336673.1 hypothetical protein FCM35_KLT19259 [Carex littledalei] diamond 6438 188 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Cyperaceae Carex Carex littledalei
20559202 20559202 PRJNA1012699_P_NODE_2837_length_251_cov_2.348315_g2805_i0 PRJNA1012699 2837 251 2.348315 5.89427065 Hordeum vulgare subsp. vulgare 112509 Plants Plants 140 1.73e-36   NR BAJ93702.1 112509 g2805 i0 78 1.9601593625498 82 18 98 0 248 3 672 753 BAJ93702.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 492 140 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
26646980 26646980 PRJNA1012699_P_NODE_3541_length_245_cov_1.773256_g3509_i0 PRJNA1012699 3541 245 1.773256 4.3444772 Magnoliopsida 3398 Plants Plants 105 7.37e-26   NR CAA0829683.1 68872 g3509 i0 63.1 9.23265306122449 84 28 99.2 1 244 2 154 237 CAA0829683.1 Aldolase superfamily protein [Striga hermonthica] diamond 2262 106 0.990566037735849 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Striga Striga hermonthica
26749562 26749562 PRJNA1012699_P_NODE_3321_length_247_cov_0.896552_g3289_i0 PRJNA1012699 3321 247 0.896552 2.21448344 Hordeum vulgare subsp. vulgare 112509 Plants Plants 126 9.77e-32   NR BAK00478.1 112509 g3289 i0 82.9 0.995951417004049 82 14 99.6 0 2 247 287 368 BAK00478.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 246 126 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27256076 27256076 PRJNA1012699_P_NODE_1943_length_282_cov_2.956938_g1911_i0 PRJNA1012699 1943 282 2.956938 8.33856516 Lithospermum erythrorhizon 34254 Plants Plants 120 4.94e-33   NR KAG9143975.1 34254 g1911 i0 67.9 1.72340425531915 81 26 86.2 0 38 280 3 83 KAG9143975.1 hypothetical protein Leryth_025055 [Lithospermum erythrorhizon] diamond 486 120 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Boraginales Boraginaceae Lithospermum Lithospermum erythrorhizon
27627535 27627535 PRJNA1012699_P_NODE_924_length_377_cov_1.430921_g892_i0 PRJNA1012699 924 377 1.430921 5.39457217 Viridiplantae 33090 Plants Plants 154 2.29e-45   NR KAI5060525.1 13818 g892 i0 64.3 4.57559681697613 115 41 91.5 0 346 2 1 115 KAI5060525.1 hypothetical protein GOP47_0024945 [Adiantum capillus-veneris] diamond 1725 154 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Adiantum Adiantum capillus-veneris
27635260 27635260 PRJNA1012699_P_NODE_3904_length_243_cov_0.911765_g3872_i0 PRJNA1012699 3904 243 0.911765 2.21558895 Hordeum vulgare subsp. vulgare 112509 Plants Plants 56.2 6.67e-7   NR BAJ93895.1 112509 g3872 i0 37.2 0.962962962962963 78 46 92.6 2 225 1 108 185 BAJ93895.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 234 56.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
28290295 28290295 PRJNA1012699_P_NODE_266_length_639_cov_2.519435_g237_i0 PRJNA1012699 266 639 2.519435 16.09918965 Eukaryota 2759 Plants Plants 245 5.1700000000000007e-79   NR KAG0581586.1 3225 g237 i0 68.2 24.7323943661972 201 56 91.1 3 2 583 10 209 KAG0581586.1 hypothetical protein KC19_4G263300 [Ceratodon purpureus] diamond 15804 247 0.991902834008097 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pseudoditrichales Ditrichaceae Ceratodon Ceratodon purpureus
28645625 28645625 PRJNA1012699_P_NODE_2047_length_278_cov_1.463415_g2015_i0 PRJNA1012699 2047 278 1.463415 4.0682937 Zea mays 4577 Plants Plants 44.7 0.0116   NR ONM14325.1 4577 g2015 i0 40.8 0.820143884892086 76 40 79.9 3 227 6 52 124 ONM14325.1 Wall-associated receptor kinase 2 [Zea mays] diamond 228 44.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
28763955 28763955 PRJNA1012699_P_NODE_2387_length_262_cov_1.645503_g2355_i0 PRJNA1012699 2387 262 1.645503 4.31121786 Eukaryota 2759 Plants Plants 51.2 4.78e-5   NR XP_019191924.1 35883 g2355 i0 39.3 7.08778625954198 61 37 69.8 0 19 201 75 135 XP_019191924.1 PREDICTED: protein CfxQ homolog [Ipomoea nil] diamond 1857 51.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Ipomoea Ipomoea nil
29340249 29340249 PRJNA1012699_P_NODE_3249_length_248_cov_0.891429_g3217_i0 PRJNA1012699 3249 248 0.891429 2.21074392 Eragrostis curvula 38414 Plants Plants 50.8 4.9e-5   NR TVU42020.1 38414 g3217 i0 35.5 0.75 62 40 75 0 19 204 193 254 TVU42020.1 hypothetical protein EJB05_08402, partial [Eragrostis curvula] diamond 186 50.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Eragrostis Eragrostis curvula
29529665 29529665 PRJNA1012699_P_NODE_1450_length_314_cov_0.908714_g1418_i0 PRJNA1012699 1450 314 0.908714 2.85336196 Gossypium anomalum 47600 Plants Plants 47.8 0.00138   NR KAG8500857.1 47600 g1418 i0 40.4 0.544585987261146 57 33 53.5 1 169 2 250 306 KAG8500857.1 hypothetical protein CXB51_002877 [Gossypium anomalum] diamond 171 47.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium anomalum
30698308 30698308 PRJNA1012699_P_NODE_1774_length_291_cov_2.128440_g1742_i0 PRJNA1012699 1774 291 2.12844 6.1937604 Hordeum vulgare subsp. vulgare 112509 Plants Plants 187 2.18e-59   NR BAJ99430.1 112509 g1742 i0 94.8 0.989690721649485 96 5 99 0 4 291 21 116 BAJ99430.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 288 187 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
31449261 31449261 PRJNA1012699_P_NODE_2296_length_266_cov_2.010363_g2264_i0 PRJNA1012699 2296 266 2.010363 5.34756558 Streptophyta 35493 Plants Plants 106 5.2e-27   NR CBI31460.3 29760 g2264 i0 61.8 38.2330827067669 76 29 85.7 0 265 38 87 162 CBI31460.3 unnamed protein product, partial [Vitis vinifera] diamond 10170 107 0.990654205607477 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Vitales Vitaceae Vitis Vitis vinifera
31702186 31702186 PRJNA1012699_P_NODE_1077_length_355_cov_1.656028_g1045_i0 PRJNA1012699 1077 355 1.656028 5.8788994 Streptophyta 35493 Plants Plants 126 1.96e-31   NR AAT85663.1 3197 g1045 i0 50.4 4.83380281690141 115 51 92.1 1 352 26 361 475 AAT85663.1 polyunsaturated fatty acid delta-5-desaturase [Marchantia polymorpha] diamond 1716 127 0.992125984251969 Eukaryota Embryophyta Viridiplantae Streptophyta Marchantiopsida Marchantiales Marchantiaceae Marchantia Marchantia polymorpha
32311410 32311410 PRJNA1012699_P_NODE_3779_length_244_cov_0.883041_g3747_i0 PRJNA1012699 3779 244 0.883041 2.15462004 Cryptomeria japonica 3369 Plants Plants 57.8 1.89e-7   NR XP_057863274.2 3369 g3747 i0 43.2 6.44262295081967 74 41 91 1 4 225 248 320 XP_057863274.2 uncharacterized protein LOC131071452 [Cryptomeria japonica] diamond 1572 57.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica

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