contig_metadata
19 rows where bioproject = "PRJNA193544" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4193008 | 4193008 | PRJNA193544_S_NODE_804_length_272_cov_14430.037037_g789_i0 | PRJNA193544 | 804 | 272 | 14430.037037 | 39249.70074064 | Arachis stenosperma | 217475 | Plants | Plants | 89.8 | 1.9e-13 | NTclustered | gi|2531356839|ref|XR_009076377.1| | 217475 | g789 | i0 | 92.063 | 12.6470588235294 | 63 | 5 | 23 | 0 | 210 | 272 | 97 | 35 | PREDICTED: Arachis stenosperma 28S ribosomal RNA (LOC130954646), rRNA | blastn | 3440 | 89.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Arachis | Arachis stenosperma | |
| 4883196 | 4883196 | PRJNA193544_S_NODE_1444_length_216_cov_34.609626_g1429_i0 | PRJNA193544 | 1444 | 216 | 34.609626 | 74.75679216 | Glycine | 3846 | Plants | Plants | 390 | 3.559999999999999e-104 | NTclustered | gi|2027446350|ref|XR_005890558.1| | 3847 | g1429 | i0 | 99.533 | 99.0740740740741 | 214 | 1 | 99 | 0 | 3 | 216 | 1917 | 2130 | PREDICTED: Glycine max 28S ribosomal RNA (LOC121174465), rRNA | blastn | 21400 | 390 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 5469220 | 5469220 | PRJNA193544_S_NODE_2025_length_190_cov_371.956522_g2010_i0 | PRJNA193544 | 2025 | 190 | 371.956522 | 706.7173918 | Glycine max | 3847 | Plants | Plants | 283 | 5.319999999999999e-72 | NTclustered | gi|1448291615|ref|XR_003264244.1| | 3847 | g2010 | i0 | 98.16 | 86.3105263157895 | 163 | 2 | 85 | 1 | 1 | 162 | 1611 | 1773 | PREDICTED: Glycine max 18S ribosomal RNA (LOC112999065), rRNA | blastn | 16399 | 283 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 6743534 | 6743534 | PRJNA193544_S_NODE_1086_length_244_cov_11.790698_g1071_i0 | PRJNA193544 | 1086 | 244 | 11.790698 | 28.76930312 | Juglans microcarpa x Juglans regia | 2249226 | Plants | Plants | 69.4 | 2.19e-7 | NTclustered | gi|2031631824|ref|XR_005936574.1| | 2249226 | g1071 | i0 | 79.63 | 11.2827868852459 | 108 | 12 | 43 | 6 | 126 | 230 | 3287 | 3387 | PREDICTED: Juglans microcarpa x Juglans regia 28S ribosomal RNA (LOC121245168), rRNA | blastn | 2753 | 69.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Juglandaceae | Juglans | Juglans microcarpa x Juglans regia | |
| 7433119 | 7433119 | PRJNA193544_S_NODE_166_length_417_cov_15.445876_g151_i0 | PRJNA193544 | 166 | 417 | 15.445876 | 64.40930292 | Glycine | 3846 | Plants | Plants | 579 | 1.4899999999999995e-160 | NTclustered | gi|1448291768|ref|XR_003264397.1| | 3847 | g151 | i0 | 93.573 | 93.2470023980815 | 389 | 23 | 93 | 2 | 16 | 403 | 261 | 648 | PREDICTED: Glycine max 28S ribosomal RNA (LOC112999219), rRNA | blastn | 38884 | 579 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 8019241 | 8019241 | PRJNA193544_S_NODE_1347_length_222_cov_9.419689_g1332_i0 | PRJNA193544 | 1347 | 222 | 9.419689 | 20.91170958 | Malania oleifera | 397392 | Plants | Plants | 113 | 8.910000000000001e-21 | NTclustered | gi|2532207879|ref|XR_009138347.1| | 397392 | g1332 | i0 | 84.483 | 19.3738738738739 | 116 | 16 | 52 | 2 | 35 | 149 | 419 | 305 | PREDICTED: Malania oleifera 28S ribosomal RNA (LOC131161192), rRNA | blastn | 4301 | 113 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Santalales | Ximeniaceae | Malania | Malania oleifera | |
| 8019270 | 8019270 | PRJNA193544_S_NODE_2667_length_169_cov_14.485714_g2652_i0 | PRJNA193544 | 2667 | 169 | 14.485714 | 24.48085666 | Pinus pinea | 3346 | Plants | Plants | 279 | 5.95e-71 | NTclustered | gi|1150534|emb|X87936.1| | 3346 | g2652 | i0 | 98.137 | 95.5562130177515 | 161 | 2 | 95 | 1 | 4 | 164 | 2662 | 2821 | P.pinea internal transcribed spacers 1 & 2 of ribosomal DNA | blastn | 16149 | 279 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Pinus | Pinus pinea | |
| 9293975 | 9293975 | PRJNA193544_S_NODE_2048_length_189_cov_21930.575000_g2033_i0 | PRJNA193544 | 2048 | 189 | 21930.575 | 41448.78675 | Dendromyza ledermannii | 450010 | Plants | Plants | 134 | 5.630000000000001e-27 | NTclustered | gi|1570104161|gb|MH390567.1| | 450010 | g2033 | i0 | 91.667 | 43.8518518518519 | 96 | 8 | 51 | 0 | 61 | 156 | 3013 | 3108 | Dendromyza ledermannii voucher D. Nickrent 4466 26S ribosomal RNA gene, partial sequence | blastn | 8288 | 134 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Santalales | Amphorogynaceae | Dendromyza | Dendromyza ledermannii | |
| 9983294 | 9983294 | PRJNA193544_S_NODE_3328_length_153_cov_41.758065_g3313_i0 | PRJNA193544 | 3328 | 153 | 41.758065 | 63.88983945 | Magnoliopsida | 3398 | Plants | Plants | 272 | 8.84e-69 | NTclustered | gi|2645384110|ref|XR_009840671.1| | 3691 | g3313 | i0 | 98.693 | 1376.76470588235 | 153 | 2 | 100 | 0 | 1 | 153 | 2770 | 2618 | PREDICTED: Populus nigra 28S ribosomal RNA (LOC133687332), rRNA | blastn | 210645 | 272 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus nigra | |
| 14394986 | 14394986 | PRJNA193544_S_NODE_2832_length_164_cov_31.718519_g2817_i0 | PRJNA193544 | 2832 | 164 | 31.718519 | 52.01837116 | Brassica napus | 3708 | Plants | Plants | 52.8 | 0.014 | NTclustered | gi|2258135794|ref|XR_007334357.1| | 3708 | g2817 | i0 | 96.875 | 0.195121951219512 | 32 | 0 | 19 | 1 | 134 | 164 | 2995 | 2964 | PREDICTED: Brassica napus 28S ribosomal RNA (LOC125601643), rRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 17632881 | 17632881 | PRJNA193544_S_NODE_494_length_317_cov_13366.173611_g479_i0 | PRJNA193544 | 494 | 317 | 13366.173611 | 42370.77034687 | Magnoliopsida | 3398 | Plants | Plants | 115 | 3.7300000000000006e-21 | NTclustered | gi|2645383891|ref|XR_009840450.1| | 3691 | g479 | i0 | 86.239 | 22.9842271293375 | 109 | 12 | 34 | 2 | 34 | 141 | 2216 | 2110 | PREDICTED: Populus nigra 28S ribosomal RNA (LOC133687102), rRNA | blastn | 7286 | 115 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus nigra | |
| 19491886 | 19491886 | PRJNA193544_S_NODE_236_length_380_cov_9976.273504_g221_i0 | PRJNA193544 | 236 | 380 | 9976.273504 | 37909.8393152 | Brassica napus | 3708 | Plants | Plants | 52.8 | 0.036 | NTclustered | gi|2258135794|ref|XR_007334357.1| | 3708 | g221 | i0 | 96.875 | 0.0842105263157895 | 32 | 0 | 8 | 1 | 350 | 380 | 2995 | 2964 | PREDICTED: Brassica napus 28S ribosomal RNA (LOC125601643), rRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 21457022 | 21457022 | PRJNA193544_S_NODE_777_length_276_cov_8.979757_g762_i0 | PRJNA193544 | 777 | 276 | 8.979757 | 24.78412932 | Magnoliopsida | 3398 | Plants | Plants | 54.7 | 0.007 | NTclustered | gi|1939055476|gb|MW172410.1| | 3702 | g762 | i0 | 94.444 | 1.10144927536232 | 36 | 1 | 13 | 1 | 242 | 276 | 60871 | 60836 | Arabidopsis thaliana NOR2 telomere junction genomic sequence | blastn | 304 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis thaliana | |
| 24007229 | 24007229 | PRJNA193544_S_NODE_599_length_301_cov_6.227941_g584_i0 | PRJNA193544 | 599 | 301 | 6.227941 | 18.74610241 | Glycine | 3846 | Plants | Plants | 529 | 1.0599999999999996e-145 | NTclustered | gi|2027446350|ref|XR_005890558.1| | 3847 | g584 | i0 | 99.315 | 97.063122923588 | 292 | 2 | 97 | 0 | 1 | 292 | 1493 | 1784 | PREDICTED: Glycine max 28S ribosomal RNA (LOC121174465), rRNA | blastn | 29216 | 529 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 24007232 | 24007232 | PRJNA193544_S_NODE_739_length_281_cov_2762.623016_g724_i0 | PRJNA193544 | 739 | 281 | 2762.623016 | 7762.97067496 | Magnoliopsida | 3398 | Plants | Plants | 281 | 3.04e-71 | NTclustered | gi|1484650211|ref|XR_003349480.1| | 3469 | g724 | i0 | 93.264 | 68.3772241992882 | 193 | 10 | 68 | 3 | 1 | 192 | 46 | 236 | PREDICTED: Papaver somniferum 18S ribosomal RNA (LOC113328622), rRNA | blastn | 19214 | 281 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver somniferum | |
| 28968801 | 28968801 | PRJNA193544_S_NODE_968_length_254_cov_5.355556_g953_i0 | PRJNA193544 | 968 | 254 | 5.355556 | 13.60311224 | Arachis hypogaea | 3818 | Plants | Plants | 54.3 | 1.39e-6 | NR | ABH09321.1 | 3818 | g953 | i0 | 62.8 | 0.507874015748031 | 43 | 16 | 50.8 | 0 | 68 | 196 | 86 | 128 | ABH09321.1 leucine rich protein [Arachis hypogaea] | diamond | 129 | 54.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Arachis | Arachis hypogaea | |
| 29347678 | 29347678 | PRJNA193544_S_NODE_1949_length_193_cov_23599.609756_g1934_i0 | PRJNA193544 | 1949 | 193 | 23599.609756 | 45547.24682908 | Brassica napus | 3708 | Plants | Plants | 43.9 | 8.19e-4 | NR | WZZ15440.1 | 3708 | g1934 | i0 | 48 | 0.77720207253886 | 50 | 24 | 74.6 | 1 | 17 | 160 | 1 | 50 | WZZ15440.1 hypothetical protein YC2023_108529 [Brassica napus] | diamond | 150 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 29744019 | 29744019 | PRJNA193544_S_NODE_1810_length_199_cov_20693.070588_g1795_i0 | PRJNA193544 | 1810 | 199 | 20693.070588 | 41179.21047012 | Streptophyta | 35493 | Plants | Plants | 52 | 4.93e-6 | NR | KAH8936970.1 | 53036 | g1795 | i0 | 68.6 | 5.89447236180905 | 35 | 11 | 52.8 | 0 | 75 | 179 | 8 | 42 | KAH8936970.1 hypothetical protein BDL97_16G000300 [Sphagnum fallax] | diamond | 1173 | 52 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum fallax | |
| 31306195 | 31306195 | PRJNA193544_S_NODE_1375_length_220_cov_130.382199_g1360_i0 | PRJNA193544 | 1375 | 220 | 130.38219900000001 | 286.8408378 | Rubroshorea leprosula | 152421 | Plants | Plants | 52 | 1.58e-6 | NR | GKV53456.1 | 152421 | g1360 | i0 | 66.7 | 0.531818181818182 | 39 | 9 | 47.7 | 1 | 105 | 1 | 8 | 46 | GKV53456.1 hypothetical protein SLEP1_g59978 [Rubroshorea leprosula] | diamond | 117 | 52 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Dipterocarpaceae | Rubroshorea | Rubroshorea leprosula |
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);;