contig_metadata
23 rows where bioproject = "PRJNA998413" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1273982 | 1273982 | PRJNA998413_S_NODE_5321_length_269_cov_1.951456_g5290_i0 | PRJNA998413 | 5321 | 269 | 1.951456 | 5.24941664 | Picea | 3328 | Plants | Plants | 333 | 7.8599999999999995e-87 | NTclustered | gi|270140160|gb|BT107112.1| | 3330 | g5290 | i0 | 96.078 | 10.8996282527881 | 204 | 8 | 76 | 0 | 66 | 269 | 912 | 709 | Picea glauca clone GQ03102_N19 mRNA sequence | blastn | 2932 | 333 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea glauca | |
| 2254351 | 2254351 | PRJNA998413_S_NODE_12622_length_211_cov_0.972973_g12591_i0 | PRJNA998413 | 12622 | 211 | 0.972973 | 2.05297303 | Morus nigra | 85232 | Plants | Plants | 385 | 1.61e-102 | NTclustered | gi|19919673|gb|AF479232.1| | 85232 | g12591 | i0 | 99.526 | 135.625592417062 | 211 | 1 | 100 | 0 | 1 | 211 | 45 | 255 | Morus nigra 26S ribosomal RNA gene, partial sequence | blastn | 28617 | 385 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Moraceae | Morus | Morus nigra | |
| 3529769 | 3529769 | PRJNA998413_S_NODE_15143_length_173_cov_5.018182_g15112_i0 | PRJNA998413 | 15143 | 173 | 5.018182 | 8.68145486 | Lolium rigidum | 89674 | Plants | Plants | 65.8 | 1.87e-6 | NTclustered | gi|2212524801|ref|XR_006987231.1| | 89674 | g15112 | i0 | 100 | 21.1445086705202 | 35 | 0 | 20 | 0 | 1 | 35 | 3096 | 3130 | PREDICTED: Lolium rigidum 28S ribosomal RNA (LOC124650820), rRNA | blastn | 3658 | 65.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium rigidum | |
| 3529822 | 3529822 | PRJNA998413_S_NODE_5523_length_266_cov_1.980296_g5492_i0 | PRJNA998413 | 5523 | 266 | 1.980296 | 5.26758736 | Picea glauca | 3330 | Plants | Plants | 117 | 8.5e-22 | NTclustered | gi|270136799|gb|BT103751.1| | 3330 | g5492 | i0 | 82.394 | 2.09774436090226 | 142 | 17 | 76 | 2 | 32 | 172 | 521 | 655 | Picea glauca clone GQ02801_J01 mRNA sequence | blastn | 558 | 117 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea glauca | |
| 3529880 | 3529880 | PRJNA998413_S_NODE_9783_length_223_cov_75.993750_g9752_i0 | PRJNA998413 | 9783 | 223 | 75.99375 | 169.4660625 | Picea abies | 3329 | Plants | Plants | 52.8 | 0.02 | NTclustered | gi|2835530393|dbj|LC777203.1| | 3329 | g9752 | i0 | 100 | 0.125560538116592 | 28 | 0 | 13 | 0 | 196 | 223 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 5102176 | 5102176 | PRJNA998413_S_NODE_5444_length_267_cov_3.284314_g5413_i0 | PRJNA998413 | 5444 | 267 | 3.284314 | 8.76911838 | Picea | 3328 | Plants | Plants | 486 | 5.6499999999999985e-133 | NTclustered | gi|1189438144|emb|LT727875.1| | 3333 | g5413 | i0 | 99.625 | 99.3220973782771 | 267 | 0 | 100 | 1 | 1 | 267 | 52667 | 52932 | Picea rubens genome assembly, organelle: plastid:chloroplast | blastn | 26519 | 486 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea rubens | |
| 6082425 | 6082425 | PRJNA998413_S_NODE_8925_length_230_cov_4.317365_g8894_i0 | PRJNA998413 | 8925 | 230 | 4.317365 | 9.9299395 | Phaseolus vulgaris | 3885 | Plants | Plants | 420 | 4.89e-113 | NTclustered | gi|33327293|gb|AF527446.1| | 3885 | g8894 | i0 | 99.567 | 1.00434782608696 | 231 | 0 | 100 | 1 | 1 | 230 | 415 | 185 | Phaseolus vulgaris clone PvDR-13 mRNA sequence | blastn | 231 | 420 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Phaseolus | Phaseolus vulgaris | |
| 7652035 | 7652035 | PRJNA998413_S_NODE_8606_length_233_cov_1.535294_g8575_i0 | PRJNA998413 | 8606 | 233 | 1.535294 | 3.57723502 | Musa | 4640 | Plants | Plants | 431 | 2.2899999999999996e-116 | NTclustered | gi|2046373213|dbj|LC610764.1| | 4641 | g8575 | i0 | 100 | 1150.10729613734 | 233 | 0 | 100 | 0 | 1 | 233 | 3181 | 2949 | Musa acuminata cv. Pei Chiao genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, complete sequence | blastn | 267975 | 431 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Musaceae | Musa | Musa acuminata | |
| 8632310 | 8632310 | PRJNA998413_S_NODE_7487_length_243_cov_2.188889_g7456_i0 | PRJNA998413 | 7487 | 243 | 2.188889 | 5.31900027 | Populus trichocarpa | 3694 | Plants | Plants | 333 | 6.989999999999999e-87 | NTclustered | gi|2396545017|ref|XM_024584499.2| | 3694 | g7456 | i0 | 92.308 | 8.7283950617284 | 234 | 18 | 96 | 0 | 1 | 234 | 2659 | 2426 | PREDICTED: Populus trichocarpa serine/threonine protein phosphatase 2A 59 kDa regulatory subunit B' gamma isoform (LOC18105339), mRNA | blastn | 2121 | 333 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus trichocarpa | |
| 9907412 | 9907412 | PRJNA998413_S_NODE_8868_length_231_cov_1.196429_g8837_i0 | PRJNA998413 | 8868 | 231 | 1.196429 | 2.76375099 | Triticum aestivum | 4565 | Plants | Plants | 58.4 | 4.44e-4 | NTclustered | gi|1963662117|emb|LR861820.1| | 4565 | g8837 | i0 | 94.737 | 0.406926406926407 | 38 | 0 | 16 | 2 | 1 | 37 | 6 | 42 | Triticum aestivum mRNA for NB-LRR protein (Pm1 gene), cultivar Axminster, allele Pm1a | blastn | 94 | 58.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 11182494 | 11182494 | PRJNA998413_S_NODE_5669_length_264_cov_1.666667_g5638_i0 | PRJNA998413 | 5669 | 264 | 1.666667 | 4.40000088 | Picea abies | 3329 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g5638 | i0 | 100 | 0.21969696969697 | 30 | 0 | 11 | 0 | 1 | 30 | 29 | 58 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 58 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 13732725 | 13732725 | PRJNA998413_S_NODE_8551_length_233_cov_4.435294_g8520_i0 | PRJNA998413 | 8551 | 233 | 4.435294 | 10.33423502 | Brassica oleracea | 3712 | Plants | Plants | 52.8 | 0.021 | NTclustered | gi|1516555473|emb|LR031873.1| | 3712 | g8520 | i0 | 100 | 0.120171673819742 | 28 | 0 | 12 | 0 | 110 | 137 | 33301957 | 33301984 | Brassica oleracea HDEM genome, scaffold: C4 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica oleracea | |
| 15007020 | 15007020 | PRJNA998413_S_NODE_2632_length_332_cov_3.394052_g2601_i0 | PRJNA998413 | 2632 | 332 | 3.394052 | 11.26825264 | Picea abies | 3329 | Plants | Plants | 52.8 | 0.031 | NTclustered | gi|2835530393|dbj|LC777203.1| | 3329 | g2601 | i0 | 100 | 0.0843373493975904 | 28 | 0 | 8 | 0 | 1 | 28 | 29 | 56 | Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 15007092 | 15007092 | PRJNA998413_S_NODE_7632_length_242_cov_1.122905_g7601_i0 | PRJNA998413 | 7632 | 242 | 1.122905 | 2.7174301 | Oryza sativa | 4530 | Plants | Plants | 52.8 | 0.022 | NTclustered | gi|2668294540|dbj|AP027395.1| | 1771142 | g7601 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 90 | 117 | 11083773 | 11083800 | Oryza sativa indica subgroup Inn Ma Yebaw DNA, chromosome: 11 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 16576583 | 16576583 | PRJNA998413_S_NODE_10913_length_217_cov_0.870130_g10882_i0 | PRJNA998413 | 10913 | 217 | 0.87013 | 1.8881821 | Arachis | 3817 | Plants | Plants | 185 | 1.81e-42 | NTclustered | gi|1669391398|ref|XM_025830286.2| | 3818 | g10882 | i0 | 82.11 | 66.6774193548387 | 218 | 37 | 100 | 2 | 1 | 217 | 420 | 204 | PREDICTED: Arachis hypogaea 60S ribosomal protein L44 (LOC112786905), mRNA | blastn | 14469 | 185 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Arachis | Arachis hypogaea | |
| 20105755 | 20105755 | PRJNA998413_S_NODE_7456_length_243_cov_24.155556_g7425_i0 | PRJNA998413 | 7456 | 243 | 24.155556 | 58.69800108 | Ziziphus jujuba | 326968 | Plants | Plants | 52.8 | 0.022 | NTclustered | gi|2739574740|gb|CP157414.1| | 326968 | g7425 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 39 | 66 | 17662983 | 17663010 | Ziziphus jujuba isolate TW-2024b chromosome 12 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rhamnaceae | Ziziphus | Ziziphus jujuba | |
| 21381250 | 21381250 | PRJNA998413_S_NODE_11637_length_214_cov_1.331126_g11606_i0 | PRJNA998413 | 11637 | 214 | 1.331126 | 2.84860964 | Cucumis melo | 3656 | Plants | Plants | 52.8 | 0.019 | NTclustered | gi|733598836|emb|LN681873.1| | 3656 | g11606 | i0 | 100 | 0.261682242990654 | 28 | 0 | 13 | 0 | 15 | 42 | 3732803 | 3732830 | Cucumis melo genomic scaffold, anchoredscaffold00027 | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis melo | |
| 21381254 | 21381254 | PRJNA998413_S_NODE_11737_length_214_cov_0.887417_g11706_i0 | PRJNA998413 | 11737 | 214 | 0.887417 | 1.89907238 | Malpighia emarginata | 151847 | Plants | Plants | 52.8 | 0.019 | NTclustered | gi|2783005953|dbj|AP035804.1| | 151847 | g11706 | i0 | 100 | 0.130841121495327 | 28 | 0 | 13 | 0 | 105 | 132 | 73739914 | 73739887 | Malpighia emarginata NRA309 DNA, chromosome 3, nearly complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Malpighiaceae | Malpighia | Malpighia emarginata | |
| 21381334 | 21381334 | PRJNA998413_S_NODE_4737_length_279_cov_0.930556_g4706_i0 | PRJNA998413 | 4737 | 279 | 0.930556 | 2.59625124 | Brassica oleracea | 3712 | Plants | Plants | 52.8 | 0.026 | NTclustered | gi|1516555473|emb|LR031873.1| | 3712 | g4706 | i0 | 100 | 0.100358422939068 | 28 | 0 | 10 | 0 | 244 | 271 | 29453941 | 29453914 | Brassica oleracea HDEM genome, scaffold: C4 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica oleracea | |
| 21381406 | 21381406 | PRJNA998413_S_NODE_9277_length_228_cov_1.127273_g9246_i0 | PRJNA998413 | 9277 | 228 | 1.127273 | 2.57018244 | Picea abies | 3329 | Plants | Plants | 52.8 | 0.02 | NTclustered | gi|2835530398|dbj|LC777204.1| | 3329 | g9246 | i0 | 100 | 0.245614035087719 | 28 | 0 | 12 | 0 | 201 | 228 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaPbp mRNA for penicillin-binding protein, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 22656150 | 22656150 | PRJNA998413_S_NODE_12038_length_213_cov_0.893333_g12007_i0 | PRJNA998413 | 12038 | 213 | 0.893333 | 1.90279929 | Camelina sativa | 90675 | Plants | Plants | 54.7 | 0.005 | NTclustered | gi|1109124791|ref|XM_010509663.2| | 90675 | g12007 | i0 | 100 | 0.267605633802817 | 29 | 0 | 14 | 0 | 140 | 168 | 1384 | 1412 | PREDICTED: Camelina sativa transcription factor bHLH70-like (LOC104784626), mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Camelina | Camelina sativa | |
| 22656188 | 22656188 | PRJNA998413_S_NODE_2998_length_320_cov_4.544747_g2967_i0 | PRJNA998413 | 2998 | 320 | 4.544747 | 14.5431904 | Picea abies | 3329 | Plants | Plants | 52.8 | 0.03 | NTclustered | gi|2835530393|dbj|LC777203.1| | 3329 | g2967 | i0 | 100 | 0.0875 | 28 | 0 | 9 | 0 | 293 | 320 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 29779667 | 29779667 | PRJNA998413_S_NODE_13731_length_204_cov_2.375887_g13700_i0 | PRJNA998413 | 13731 | 204 | 2.375887 | 4.84680948 | root | 1 | Root_unresolved | Root_unresolved | 42 | 0.0429 | NR | CAH2078562.1 | 13288 | g13700 | i0 | 39.1 | 3.08823529411765 | 46 | 28 | 67.6 | 0 | 34 | 171 | 105 | 150 | CAH2078562.1 unnamed protein product [Thlaspi arvense] | diamond | 630 | 42 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Thlaspi | Thlaspi arvense |
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);;