contig_metadata
27 rows where bioproject = "PRJNA938397" and tax_clade = "Embryophyta"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3808018 | 3808018 | PRJNA938397_S_NODE_40743_length_172_cov_3.111111_g40502_i0 | PRJNA938397 | 40743 | 172 | 3.111111 | 5.35111092 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.014 | NTclustered | gi|2583740234|ref|XM_059784070.1| | 4283 | g40502 | i0 | 100 | 0.488372093023256 | 28 | 0 | 16 | 0 | 82 | 109 | 1173 | 1200 | PREDICTED: Cornus florida nucleosome assembly protein 1;4-like (LOC132282399), mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cornales | Cornaceae | Cornus | Cornus florida | |
| 4741081 | 4741081 | PRJNA938397_S_NODE_21764_length_236_cov_113.718593_g21523_i0 | PRJNA938397 | 21764 | 236 | 113.718593 | 268.37587948 | Quercus lobata | 97700 | Plants | Plants | 58.4 | 4.55e-4 | NTclustered | gi|1757525123|ref|XM_031086011.1| | 97700 | g21523 | i0 | 100 | 0.13135593220339 | 31 | 0 | 13 | 0 | 88 | 118 | 473 | 503 | PREDICTED: Quercus lobata uncharacterized LOC115966867 (LOC115966867), mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus lobata | |
| 6016163 | 6016163 | PRJNA938397_S_NODE_26845_length_213_cov_3.732955_g26604_i0 | PRJNA938397 | 26845 | 213 | 3.732955 | 7.95119415 | Taxillus matsudae | 2805424 | Plants | Plants | 126 | 1.09e-24 | NTclustered | gi|1970150767|gb|MW555625.1| | 2805424 | g26604 | i0 | 84.375 | 9.64788732394366 | 128 | 20 | 60 | 0 | 63 | 190 | 3022 | 2895 | Taxillus matsudae voucher Su138 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 2055 | 126 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Santalales | Loranthaceae | Taxillus | Taxillus matsudae | |
| 7292121 | 7292121 | PRJNA938397_S_NODE_52766_length_151_cov_0.982456_g52525_i0 | PRJNA938397 | 52766 | 151 | 0.982456 | 1.48350856 | Mesembryanthemum crystallinum | 3544 | Plants | Plants | 176 | 7.009999999999999e-40 | NTclustered | gi|167269|gb|M38316.1|CIPRBCS2 | 3544 | g52525 | i0 | 88.811 | 40.9933774834437 | 143 | 16 | 95 | 0 | 6 | 148 | 416 | 558 | Mesembryanthemum crystallinum ribulose-1,5- bisphosphate carboxylase/oxygenase small subunit (rbcS-2) mRNA, complete cds | blastn | 6190 | 176 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Aizoaceae | Mesembryanthemum | Mesembryanthemum crystallinum | |
| 7634156 | 7634156 | PRJNA938397_S_NODE_53166_length_150_cov_3.398230_g52925_i0 | PRJNA938397 | 53166 | 150 | 3.39823 | 5.097345 | Magnoliopsida | 3398 | Plants | Plants | 272 | 8.609999999999998e-69 | NTclustered | gi|910750164|gb|KR336549.1| | 4615 | g52925 | i0 | 99.333 | 198 | 150 | 1 | 100 | 0 | 1 | 150 | 109178 | 109029 | Ananas comosus cultivar MD-2 chloroplast, complete genome | blastn | 29700 | 272 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Bromeliaceae | Ananas | Ananas comosus | |
| 9840915 | 9840915 | PRJNA938397_S_NODE_25988_length_216_cov_13.474860_g25747_i0 | PRJNA938397 | 25988 | 216 | 13.47486 | 29.1056976 | Phragmites australis | 29695 | Plants | Plants | 63.9 | 8.81e-6 | NTclustered | gi|2649485551|ref|XM_062339634.1| | 29695 | g25747 | i0 | 95 | 0.574074074074074 | 40 | 2 | 19 | 0 | 161 | 200 | 440 | 401 | PREDICTED: Phragmites australis metallothionein-like protein 3A (LOC133898847), mRNA | blastn | 124 | 63.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Phragmites | Phragmites australis | |
| 11117109 | 11117109 | PRJNA938397_S_NODE_39249_length_175_cov_8.514493_g39008_i0 | PRJNA938397 | 39249 | 175 | 8.514493 | 14.90036275 | Solanum lycopersicum | 4081 | Plants | Plants | 52.8 | 0.015 | NTclustered | gi|452682627|gb|AC254170.3| | 4081 | g39008 | i0 | 100 | 0.32 | 28 | 0 | 16 | 0 | 90 | 117 | 96951 | 96924 | Solanum lycopersicum strain Heinz 1706 chromosome 9 clone sle-19b10 map 9, complete sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 16216466 | 16216466 | PRJNA938397_S_NODE_40313_length_173_cov_2.676471_g40072_i0 | PRJNA938397 | 40313 | 173 | 2.676471 | 4.63029483 | Cannabis sativa | 3483 | Plants | Plants | 54.7 | 0.004 | NTclustered | gi|2748541970|gb|CP158650.1| | 3483 | g40072 | i0 | 100 | 0.335260115606936 | 29 | 0 | 17 | 0 | 135 | 163 | 46059358 | 46059330 | Cannabis sativa cultivar ERBxHO40_23 chromosome 9 | blastn | 58 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 16558509 | 16558509 | PRJNA938397_S_NODE_43493_length_166_cov_5.271318_g43252_i0 | PRJNA938397 | 43493 | 166 | 5.271318 | 8.75038788 | Eukaryota | 2759 | Plants | Plants | 265 | 1.64e-66 | NTclustered | gi|1484650212|ref|XR_003349481.1| | 3469 | g43252 | i0 | 99.315 | 87.9698795180723 | 146 | 1 | 88 | 0 | 5 | 150 | 987 | 1132 | PREDICTED: Papaver somniferum 18S ribosomal RNA (LOC113328623), rRNA | blastn | 14603 | 265 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver somniferum | |
| 17491113 | 17491113 | PRJNA938397_S_NODE_24434_length_223_cov_9.983871_g24193_i0 | PRJNA938397 | 24434 | 223 | 9.983871 | 22.26403233 | Brassica rapa | 3711 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|1516499363|emb|LR031568.1| | 3711 | g24193 | i0 | 100 | 0.130044843049327 | 29 | 0 | 13 | 0 | 38 | 66 | 42526557 | 42526529 | Brassica rapa genome, scaffold: A09 | blastn | 29 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica rapa | |
| 17491795 | 17491795 | PRJNA938397_S_NODE_40954_length_171_cov_11.022388_g40713_i0 | PRJNA938397 | 40954 | 171 | 11.022388 | 18.84828348 | Solanum verrucosum | 315347 | Plants | Plants | 54.7 | 0.004 | NTclustered | gi|2276298343|ref|XM_049510000.1| | 315347 | g40713 | i0 | 96.875 | 0.187134502923977 | 32 | 1 | 19 | 0 | 16 | 47 | 430 | 461 | PREDICTED: Solanum verrucosum protein HOTHEAD-like (LOC125830822), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum verrucosum | |
| 18765818 | 18765818 | PRJNA938397_S_NODE_7975_length_365_cov_8.521341_g7734_i0 | PRJNA938397 | 7975 | 365 | 8.521341 | 31.10289465 | Cannabis sativa | 3483 | Plants | Plants | 54.7 | 0.01 | NTclustered | gi|2748540810|gb|CP158644.1| | 3483 | g7734 | i0 | 92.105 | 0.208219178082192 | 38 | 3 | 10 | 0 | 302 | 339 | 53988832 | 53988795 | Cannabis sativa cultivar ERBxHO40_23 chromosome 5 | blastn | 76 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 21314806 | 21314806 | PRJNA938397_S_NODE_21637_length_237_cov_11.950000_g21396_i0 | PRJNA938397 | 21637 | 237 | 11.95 | 28.3215 | Chenopodium quinoa | 63459 | Plants | Plants | 52.8 | 0.021 | NTclustered | gi|1219161595|ref|XR_002509158.1| | 63459 | g21396 | i0 | 96.774 | 0.392405063291139 | 31 | 1 | 13 | 0 | 99 | 129 | 3049 | 3019 | PREDICTED: Chenopodium quinoa uncharacterized LOC110710381 (LOC110710381), transcript variant X1, misc_RNA | blastn | 93 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Chenopodium | Chenopodium quinoa | |
| 22590289 | 22590289 | PRJNA938397_S_NODE_34578_length_187_cov_8.793333_g34337_i0 | PRJNA938397 | 34578 | 187 | 8.793333 | 16.44353271 | Brassica rapa | 3711 | Plants | Plants | 52.8 | 0.016 | NTclustered | gi|1516499363|emb|LR031568.1| | 3711 | g34337 | i0 | 96.875 | 0.171122994652406 | 32 | 0 | 17 | 1 | 138 | 168 | 36933071 | 36933040 | Brassica rapa genome, scaffold: A09 | blastn | 32 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica rapa | |
| 25138940 | 25138940 | PRJNA938397_S_NODE_23100_length_230_cov_3.248705_g22859_i0 | PRJNA938397 | 23100 | 230 | 3.248705 | 7.4720215 | Maltebrunia leersioides | 2057683 | Plants | Plants | 425 | 1.05e-114 | NTclustered | gi|2879580938|emb|OZ217168.1| | 2057683 | g22859 | i0 | 100 | 191 | 230 | 0 | 100 | 0 | 1 | 230 | 80539 | 80768 | Maltebrunia leersioides genome assembly, organelle: plastid:chloroplast | blastn | 43930 | 425 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Maltebrunia | Maltebrunia leersioides | |
| 25482530 | 25482530 | PRJNA938397_S_NODE_34800_length_187_cov_2.946667_g34559_i0 | PRJNA938397 | 34800 | 187 | 2.946667 | 5.51026729 | Glycine | 3846 | Plants | Plants | 52.8 | 0.016 | NTclustered | gi|2027512976|ref|XM_003547482.5| | 3847 | g34559 | i0 | 100 | 0.299465240641711 | 28 | 0 | 15 | 0 | 93 | 120 | 2349 | 2322 | PREDICTED: Glycine max probable receptor-like protein kinase At1g11050 (LOC100806560), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 25482552 | 25482552 | PRJNA938397_S_NODE_51260_length_153_cov_2.258621_g51019_i0 | PRJNA938397 | 51260 | 153 | 2.258621 | 3.45569013 | Caryophyllales | 3524 | Plants | Plants | 267 | 4.1099999999999994e-67 | NTclustered | gi|19919534|gb|AF479093.1| | 3583 | g51019 | i0 | 98.039 | 100.21568627451 | 153 | 3 | 100 | 0 | 1 | 153 | 1673 | 1521 | Portulaca grandiflora 26S ribosomal RNA gene, complete sequence | blastn | 15333 | 267 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Portulacaceae | Portulaca | Portulaca grandiflora | |
| 26676463 | 26676463 | PRJNA938397_S_NODE_6261_length_395_cov_22.787709_g6025_i0 | PRJNA938397 | 6261 | 395 | 22.787709 | 90.01145055 | Vicia faba | 3906 | Plants | Plants | 54.7 | 1.86e-6 | NR | KAL5061354.1 | 3906 | g6025 | i0 | 58.8 | 1.54936708860759 | 102 | 37 | 75.2 | 2 | 32 | 328 | 31 | 130 | KAL5061354.1 hypothetical protein RYX36_032958, partial [Vicia faba] | diamond | 612 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vicia | Vicia faba | |
| 26739658 | 26739658 | PRJNA938397_S_NODE_48041_length_158_cov_3.206612_g47800_i0 | PRJNA938397 | 48041 | 158 | 3.206612 | 5.06644696 | Perilla frutescens var. hirtella | 608512 | Plants | Plants | 65.5 | 3.8e-11 | NR | KAH6829129.1 | 608512 | g47800 | i0 | 63.8 | 2.6012658227848098 | 47 | 17 | 89.2 | 0 | 156 | 16 | 166 | 212 | KAH6829129.1 deacylase family protein [Perilla frutescens var. hirtella] | diamond | 411 | 65.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Lamiaceae | Perilla | Perilla frutescens | |
| 27474426 | 27474426 | PRJNA938397_S_NODE_12523_length_306_cov_18.717472_g12282_i0 | PRJNA938397 | 12523 | 306 | 18.717472 | 57.27546432 | Eukaryota | 2759 | Plants | Plants | 102 | 1.5199999999999995e-23 | NR | ABK26437.1 | 3332 | g12282 | i0 | 60.8 | 14.1862745098039 | 74 | 29 | 72.5 | 0 | 8 | 229 | 264 | 337 | ABK26437.1 unknown [Picea sitchensis] | diamond | 4341 | 103 | 0.990291262135922 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea sitchensis | |
| 27600920 | 27600920 | PRJNA938397_S_NODE_48544_length_157_cov_4.091667_g48303_i0 | PRJNA938397 | 48544 | 157 | 4.091667 | 6.42391719 | Viridiplantae | 33090 | Plants | Plants | 45.1 | 0.0017 | NR | KAG5019451.1 | 3848 | g48303 | i0 | 50 | 2.36942675159236 | 30 | 15 | 57.3 | 0 | 9 | 98 | 312 | 341 | KAG5019451.1 hypothetical protein JHK87_015306 [Glycine soja] | diamond | 372 | 45.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine soja | |
| 28295256 | 28295256 | PRJNA938397_S_NODE_27906_length_209_cov_2.784884_g27665_i0 | PRJNA938397 | 27906 | 209 | 2.784884 | 5.82040756 | Eukaryota | 2759 | Plants | Plants | 53.5 | 3.64e-6 | NR | KAG9448538.1 | 158543 | g27665 | i0 | 60 | 3.80382775119617 | 40 | 16 | 57.4 | 0 | 208 | 89 | 391 | 430 | KAG9448538.1 hypothetical protein H6P81_008503 [Aristolochia fimbriata] | diamond | 795 | 53.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Piperales | Aristolochiaceae | Aristolochia | Aristolochia fimbriata | |
| 28895138 | 28895138 | PRJNA938397_S_NODE_37248_length_180_cov_7.062937_g37007_i0 | PRJNA938397 | 37248 | 180 | 7.062937 | 12.7132866 | Magnoliopsida | 3398 | Plants | Plants | 59.7 | 1.62e-8 | NR | KAK1271782.1 | 55184 | g37007 | i0 | 44.9 | 6.58333333333333 | 49 | 27 | 81.7 | 0 | 5 | 151 | 414 | 462 | KAK1271782.1 E3 ubiquitin-protein ligase RGLG2 [Acorus gramineus] | diamond | 1185 | 60.1 | 0.993344425956739 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Acorales | Acoraceae | Acorus | Acorus gramineus | |
| 29803789 | 29803789 | PRJNA938397_S_NODE_30411_length_200_cov_4.380368_g30170_i0 | PRJNA938397 | 30411 | 200 | 4.380368 | 8.760736 | Iris pallida | 29817 | Plants | Plants | 55.1 | 9.28e-7 | NR | KAJ6830814.1 | 29817 | g30170 | i0 | 43.6 | 8.385 | 55 | 29 | 79.5 | 1 | 5 | 163 | 416 | 470 | KAJ6830814.1 ultraviolet-B receptor UVR8-like [Iris pallida] | diamond | 1677 | 55.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Iridaceae | Iris | Iris pallida | |
| 30151119 | 30151119 | PRJNA938397_S_NODE_37312_length_180_cov_4.867133_g37071_i0 | PRJNA938397 | 37312 | 180 | 4.867133 | 8.7608394 | Prosopis alba | 207710 | Plants | Plants | 51.6 | 1.17e-5 | NR | XP_028799659.1 | 207710 | g37071 | i0 | 51.2 | 1.43333333333333 | 43 | 21 | 71.7 | 0 | 2 | 130 | 532 | 574 | XP_028799659.1 uncharacterized protein LOC114754967 isoform X2 [Prosopis alba] | diamond | 258 | 51.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Neltuma | Neltuma alba | |
| 30467664 | 30467664 | PRJNA938397_S_NODE_33393_length_191_cov_1.519481_g33152_i0 | PRJNA938397 | 33393 | 191 | 1.519481 | 2.90220871 | Genlisea aurea | 192259 | Plants | Plants | 64.7 | 6.42e-11 | NR | EPS59092.1 | 192259 | g33152 | i0 | 56.7 | 1.8848167539267 | 60 | 25 | 92.7 | 1 | 189 | 13 | 9 | 68 | EPS59092.1 hypothetical protein M569_15720, partial [Genlisea aurea] | diamond | 360 | 64.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Lentibulariaceae | Genlisea | Genlisea aurea | |
| 32774698 | 32774698 | PRJNA938397_S_NODE_47660_length_159_cov_1.221311_g47419_i0 | PRJNA938397 | 47660 | 159 | 1.221311 | 1.94188449 | Lithospermum erythrorhizon | 34254 | Plants | Plants | 61.2 | 2.14e-10 | NR | GAA0142781.1 | 34254 | g47419 | i0 | 56 | 2.83018867924528 | 50 | 22 | 94.3 | 0 | 2 | 151 | 32 | 81 | GAA0142781.1 ribosomal protein [Lithospermum erythrorhizon] | diamond | 450 | 61.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Boraginales | Boraginaceae | Lithospermum | Lithospermum erythrorhizon |
Advanced export
JSON shape: default, array, newline-delimited
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);;