contig_metadata
25 rows where bioproject = "PRJNA512103" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 485956 | 485956 | PRJNA512103_P_NODE_24941_length_189_cov_0.892857_g24529_i0 | PRJNA512103 | 24941 | 189 | 0.892857 | 1.68749973 | Cucumis melo | 3656 | Plants | Plants | 52.8 | 0.016 | NTclustered | gi|733591487|emb|LN681811.1| | 3656 | g24529 | i0 | 100 | 0.296296296296296 | 28 | 0 | 15 | 0 | 103 | 130 | 125341 | 125368 | Cucumis melo genomic scaffold, anchoredscaffold00069 | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis melo | |
| 1110865 | 1110865 | PRJNA512103_P_NODE_17461_length_235_cov_2.586022_g17049_i0 | PRJNA512103 | 17461 | 235 | 2.586022 | 6.0771517 | Poaceae | 4479 | Plants | Plants | 398 | 2.349999999999999e-106 | NTclustered | gi|1995660796|pdb|4V3P|L1 | 4565 | g17049 | i0 | 99.541 | 2224.14893617021 | 218 | 1 | 93 | 0 | 10 | 227 | 1891 | 2108 | Chain L1, 26S ribosomal RNA | blastn | 522675 | 398 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 2386376 | 2386376 | PRJNA512103_P_NODE_29122_length_173_cov_1.467742_g28710_i0 | PRJNA512103 | 29122 | 173 | 1.467742 | 2.53919366 | Glycine | 3846 | Plants | Plants | 287 | 3.6600000000000005e-73 | NTclustered | gi|37495450|emb|AJ583799.1| | 3847 | g28710 | i0 | 100 | 21.4971098265896 | 155 | 0 | 90 | 0 | 10 | 164 | 628 | 474 | Glycine max lea-D-11 gene for dehydrin, cultivar Cuc Vang | blastn | 3719 | 287 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 3662123 | 3662123 | PRJNA512103_P_NODE_19723_length_216_cov_5.143713_g19311_i0 | PRJNA512103 | 19723 | 216 | 5.143713 | 11.11042008 | Glycine | 3846 | Plants | Plants | 381 | 2.139999999999999e-101 | NTclustered | gi|2027446350|ref|XR_005890558.1| | 3847 | g19311 | i0 | 100 | 95.4537037037037 | 206 | 0 | 95 | 0 | 10 | 215 | 3114 | 3319 | PREDICTED: Glycine max 28S ribosomal RNA (LOC121174465), rRNA | blastn | 20618 | 381 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 4312420 | 4312420 | PRJNA512103_P_NODE_13164_length_298_cov_1.180723_g12752_i0 | PRJNA512103 | 13164 | 298 | 1.180723 | 3.51855454 | Phalaenopsis equestris | 78828 | Plants | Plants | 52.8 | 0.028 | NTclustered | gi|1175831788|ref|XM_020737576.1| | 78828 | g12752 | i0 | 100 | 0.187919463087248 | 28 | 0 | 9 | 0 | 84 | 111 | 830 | 803 | PREDICTED: Phalaenopsis equestris uncharacterized LOC110033551 (LOC110033551), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Orchidaceae | Phalaenopsis | Phalaenopsis equestris | |
| 4939099 | 4939099 | PRJNA512103_P_NODE_18084_length_230_cov_1.176796_g17672_i0 | PRJNA512103 | 18084 | 230 | 1.176796 | 2.7066308 | Glycine | 3846 | Plants | Plants | 313 | 8.53e-81 | NTclustered | gi|2027472501|ref|XM_003526189.5| | 3847 | g17672 | i0 | 95.408 | 9.88695652173913 | 196 | 9 | 96 | 0 | 35 | 230 | 2194 | 1999 | PREDICTED: Glycine max seed biotin-containing protein SBP65 (LOC100780139), mRNA | blastn | 2274 | 313 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 7488935 | 7488935 | PRJNA512103_P_NODE_24486_length_190_cov_1.794326_g24074_i0 | PRJNA512103 | 24486 | 190 | 1.794326 | 3.4092194 | Poaceae | 4479 | Plants | Plants | 294 | 2.46e-75 | NTclustered | gi|2022331886|ref|XR_005813456.1| | 4533 | g24074 | i0 | 100 | 953.536842105263 | 159 | 0 | 84 | 0 | 23 | 181 | 1456 | 1298 | PREDICTED: Oryza brachyantha 28S ribosomal RNA (LOC121056681), rRNA | blastn | 181172 | 296 | 0.993243243243243 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza brachyantha | |
| 9414000 | 9414000 | PRJNA512103_P_NODE_20948_length_208_cov_2.025157_g20536_i0 | PRJNA512103 | 20948 | 208 | 2.025157 | 4.21232656 | Brassica rapa | 3711 | Plants | Plants | 56.5 | 0.001 | NTclustered | gi|1827929271|ref|XM_033279585.1| | 3711 | g20536 | i0 | 100 | 0.144230769230769 | 30 | 0 | 14 | 0 | 58 | 87 | 3072 | 3101 | PREDICTED: Brassica rapa uncharacterized LOC103838596 (LOC103838596), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica rapa | |
| 10039398 | 10039398 | PRJNA512103_P_NODE_7308_length_489_cov_2.065909_g6900_i0 | PRJNA512103 | 7308 | 489 | 2.065909 | 10.10229501 | Fabaceae | 3803 | Plants | Plants | 870 | 0 | NTclustered | gi|1418576273|ref|NC_037714.1| | 3832 | g6900 | i0 | 100 | 188.78527607362 | 471 | 0 | 96 | 0 | 10 | 480 | 103598 | 104068 | Cyamopsis tetragonoloba chloroplast, complete genome | blastn | 92316 | 870 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Cyamopsis | Cyamopsis tetragonoloba | |
| 10690026 | 10690026 | PRJNA512103_P_NODE_32629_length_165_cov_1.275862_g32217_i0 | PRJNA512103 | 32629 | 165 | 1.275862 | 2.1051723 | Olea europaea | 4146 | Plants | Plants | 54.7 | 0.004 | NTclustered | gi|1279006580|ref|XM_023007944.1| | 158386 | g32217 | i0 | 100 | 1.40606060606061 | 29 | 0 | 18 | 0 | 100 | 128 | 1141 | 1113 | PREDICTED: Olea europaea var. sylvestris DNA repair protein XRCC2 homolog (LOC111383790), transcript variant X2, mRNA | blastn | 232 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Olea | Olea europaea | |
| 11314036 | 11314036 | PRJNA512103_P_NODE_25949_length_185_cov_0.764706_g25537_i0 | PRJNA512103 | 25949 | 185 | 0.764706 | 1.4147061 | Glycine | 3846 | Plants | Plants | 305 | 1.1e-78 | NTclustered | gi|2027488443|ref|XM_003535208.4| | 3847 | g25537 | i0 | 99.405 | 8.02162162162162 | 168 | 1 | 91 | 0 | 10 | 177 | 457 | 624 | PREDICTED: Glycine max late embryogenesis abundant protein At3g53040 (LOC100786618), mRNA | blastn | 1484 | 305 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 14515132 | 14515132 | PRJNA512103_P_NODE_30232_length_170_cov_1.033058_g29820_i0 | PRJNA512103 | 30232 | 170 | 1.033058 | 1.7561986 | Ipomoea triloba | 35885 | Plants | Plants | 152 | 1.36e-32 | NTclustered | gi|1766764744|ref|XM_031234826.1| | 35885 | g29820 | i0 | 83.234 | 21.2235294117647 | 167 | 27 | 98 | 1 | 1 | 166 | 324 | 158 | PREDICTED: Ipomoea triloba histone H3.3 (LOC115995716), mRNA | blastn | 3608 | 152 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea triloba | |
| 14515150 | 14515150 | PRJNA512103_P_NODE_30772_length_169_cov_0.866667_g30360_i0 | PRJNA512103 | 30772 | 169 | 0.866667 | 1.46466723 | Glycine max | 3847 | Plants | Plants | 274 | 2.7699999999999997e-69 | NTclustered | gi|351724000|ref|NM_001251649.1| | 3847 | g30360 | i0 | 99.338 | 22.6804733727811 | 151 | 1 | 89 | 0 | 10 | 160 | 662 | 512 | Glycine max protein MAT1 (MAT1), mRNA | blastn | 3833 | 274 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 15789187 | 15789187 | PRJNA512103_P_NODE_7153_length_498_cov_1.910913_g6746_i0 | PRJNA512103 | 7153 | 498 | 1.910913 | 9.51634674 | Elaeis guineensis | 51953 | Plants | Plants | 52.8 | 0.049 | NTclustered | gi|1658213114|ref|XM_010928681.3| | 51953 | g6746 | i0 | 96.774 | 0.0622489959839357 | 31 | 1 | 6 | 0 | 200 | 230 | 212 | 242 | PREDICTED: Elaeis guineensis aspartyl protease AED3-like (LOC105049122), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Arecales | Arecaceae | Elaeis | Elaeis guineensis | |
| 17688726 | 17688726 | PRJNA512103_P_NODE_24314_length_191_cov_1.394366_g23902_i0 | PRJNA512103 | 24314 | 191 | 1.394366 | 2.66323906 | Solanum | 4107 | Plants | Plants | 320 | 4.08e-83 | NTclustered | gi|1883211983|gb|MT122986.1| | 4111 | g23902 | i0 | 100 | 96.1413612565445 | 173 | 0 | 91 | 0 | 10 | 182 | 295848 | 295676 | Solanum melongena isolate NN5 chromosome 1 mitochondrion, complete sequence | blastn | 18363 | 320 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum melongena | |
| 20888123 | 20888123 | PRJNA512103_P_NODE_26457_length_183_cov_0.910448_g26045_i0 | PRJNA512103 | 26457 | 183 | 0.910448 | 1.66611984 | Vigna mungo | 3915 | Plants | Plants | 294 | 2.35e-75 | NTclustered | gi|2688608576|gb|CP144701.1| | 3915 | g26045 | i0 | 98.795 | 190.726775956284 | 166 | 0 | 90 | 2 | 10 | 174 | 673590 | 673754 | Vigna mungo isolate Urdbean mitochondrion, partial sequence | blastn | 34903 | 294 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vigna | Vigna mungo | |
| 22787903 | 22787903 | PRJNA512103_P_NODE_33938_length_163_cov_0.912281_g33526_i0 | PRJNA512103 | 33938 | 163 | 0.912281 | 1.48701803 | Glycine | 3846 | Plants | Plants | 268 | 1.24e-67 | NTclustered | gi|2027469553|ref|XM_003527817.5| | 3847 | g33526 | i0 | 100 | 1.77914110429448 | 145 | 0 | 89 | 0 | 10 | 154 | 2369 | 2225 | PREDICTED: Glycine max purple acid phosphatase 2 (LOC100789918), mRNA | blastn | 290 | 268 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 23438551 | 23438551 | PRJNA512103_P_NODE_28339_length_176_cov_1.141732_g27927_i0 | PRJNA512103 | 28339 | 176 | 1.141732 | 2.00944832 | Ornithogalum saundersiae | 484171 | Plants | Plants | 130 | 6.670000000000001e-26 | NTclustered | gi|731910671|gb|KM510380.1| | 484171 | g27927 | i0 | 83.333 | 63.3295454545455 | 144 | 20 | 81 | 4 | 28 | 169 | 958 | 1099 | Galtonia saundersiae actin-2 (Actin2) mRNA, complete cds | blastn | 11146 | 130 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Hyacinthaceae | Ornithogalum | Ornithogalum saundersiae | |
| 24062781 | 24062781 | PRJNA512103_P_NODE_17659_length_233_cov_3.565217_g17247_i0 | PRJNA512103 | 17659 | 233 | 3.565217 | 8.30695561 | Magnoliopsida | 3398 | Plants | Plants | 398 | 2.32e-106 | NTclustered | gi|2164447791|gb|OL824850.1| | 3528 | g17247 | i0 | 100 | 92.274678111588 | 215 | 0 | 92 | 0 | 10 | 224 | 1472 | 1686 | Phytolacca acinosa voucher ENC851188 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 21500 | 398 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Phytolaccaceae | Phytolacca | Phytolacca acinosa | |
| 25337266 | 25337266 | PRJNA512103_P_NODE_20940_length_208_cov_2.383648_g20528_i0 | PRJNA512103 | 20940 | 208 | 2.383648 | 4.95798784 | Glycine | 3846 | Plants | Plants | 385 | 1.58e-102 | NTclustered | gi|2027472501|ref|XM_003526189.5| | 3847 | g20528 | i0 | 100 | 6.36538461538461 | 208 | 0 | 100 | 0 | 1 | 208 | 1702 | 1909 | PREDICTED: Glycine max seed biotin-containing protein SBP65 (LOC100780139), mRNA | blastn | 1324 | 385 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 25337267 | 25337267 | PRJNA512103_P_NODE_21960_length_202_cov_1.941176_g21548_i0 | PRJNA512103 | 21960 | 202 | 1.941176 | 3.92117552 | root | 1 | Root_unresolved | Root_unresolved | 342 | 9.319999999999999e-90 | NTclustered | gi|1418576273|ref|NC_037714.1| | 3832 | g21548 | i0 | 100 | 172.178217821782 | 185 | 0 | 92 | 0 | 9 | 193 | 99705 | 99889 | Cyamopsis tetragonoloba chloroplast, complete genome | blastn | 34780 | 342 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Cyamopsis | Cyamopsis tetragonoloba | |
| 28213909 | 28213909 | PRJNA512103_P_NODE_19566_length_218_cov_0.875740_g19154_i0 | PRJNA512103 | 19566 | 218 | 0.87574 | 1.9091132 | Actinidia rufa | 165716 | Plants | Plants | 43.9 | 0.0106 | NR | GFZ12955.1 | 165716 | g19154 | i0 | 37.2 | 0.591743119266055 | 43 | 27 | 59.2 | 0 | 17 | 145 | 99 | 141 | GFZ12955.1 formin homology5 [Actinidia rufa] | diamond | 129 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Actinidiaceae | Actinidia | Actinidia rufa | |
| 28498487 | 28498487 | PRJNA512103_P_NODE_30767_length_169_cov_0.866667_g30355_i0 | PRJNA512103 | 30767 | 169 | 0.866667 | 1.46466723 | Triticum aestivum | 4565 | Plants | Plants | 42 | 0.0254 | NR | SPT19547.1 | 4565 | g30355 | i0 | 40.5 | 0.656804733727811 | 37 | 22 | 65.7 | 0 | 18 | 128 | 837 | 873 | SPT19547.1 unnamed protein product [Triticum aestivum] | diamond | 111 | 42 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 30803837 | 30803837 | PRJNA512103_P_NODE_11194_length_342_cov_1.191126_g10782_i0 | PRJNA512103 | 11194 | 342 | 1.191126 | 4.07365092 | Humulus lupulus | 3486 | Plants | Plants | 74.3 | 8.29e-13 | NR | XP_062118465.1 | 3486 | g10782 | i0 | 35.5 | 0.815789473684211 | 93 | 51 | 81.6 | 1 | 62 | 340 | 4 | 87 | XP_062118465.1 uncharacterized mitochondrial protein AtMg00810-like [Humulus lupulus] | diamond | 279 | 74.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Humulus | Humulus lupulus | |
| 32005454 | 32005454 | PRJNA512103_P_NODE_23378_length_195_cov_1.815068_g22966_i0 | PRJNA512103 | 23378 | 195 | 1.815068 | 3.5393826 | Prunus armeniaca | 36596 | Plants | Plants | 42 | 0.038 | NR | CAL2237091.1 | 36596 | g22966 | i0 | 41.9 | 0.953846153846154 | 62 | 36 | 95.4 | 0 | 192 | 7 | 361 | 422 | CAL2237091.1 unnamed protein product [Prunus armeniaca] | diamond | 186 | 42 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Prunus | Prunus armeniaca |
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);;