contig_metadata
11 rows where bioproject = "PRJNA885753" and tax_phylum = "Streptophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2516923 | 2516923 | PRJNA885753_S_NODE_2742_length_281_cov_2.399038_g2724_i0 | PRJNA885753 | 2742 | 281 | 2.399038 | 6.74129678 | Oryza | 4527 | Plants | Plants | 520 | 5.909999999999999e-143 | NTclustered | gi|815859367|gb|KM036293.1| | 4528 | g2724 | i0 | 100 | 109.259786476868 | 281 | 0 | 100 | 0 | 1 | 281 | 2684 | 2404 | Oryza longistaminata 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 30702 | 520 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza longistaminata | |
| 3793273 | 3793273 | PRJNA885753_S_NODE_1143_length_399_cov_6.061350_g1125_i0 | PRJNA885753 | 1143 | 399 | 6.06135 | 24.1847865 | Streptophyta | 35493 | Plants | Plants | 726 | 0 | NTclustered | gi|30527338|gb|AY095475.1| | 3311 | g1125 | i0 | 99.5 | 100.250626566416 | 400 | 0 | 99 | 1 | 1 | 398 | 1436 | 1835 | Ginkgo biloba 26S ribosomal RNA gene, partial sequence | blastn | 40000 | 726 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Ginkgoopsida | Ginkgoales | Ginkgoaceae | Ginkgo | Ginkgo biloba | |
| 3793280 | 3793280 | PRJNA885753_S_NODE_3563_length_254_cov_2.027624_g3545_i0 | PRJNA885753 | 3563 | 254 | 2.027624 | 5.15016496 | Sphagnum balticum | 128184 | Plants | Plants | 149 | 2.29e-44 | NR | CAM6001409.1 | 128184 | g3545 | i0 | 82.1 | 0.992125984251969 | 84 | 15 | 99.2 | 0 | 252 | 1 | 46 | 129 | CAM6001409.1 unnamed protein product [Sphagnum balticum] | diamond | 252 | 149 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 8514609 | 8514609 | PRJNA885753_S_NODE_2207_length_306_cov_1.000000_g2189_i0 | PRJNA885753 | 2207 | 306 | 1 | 3.06 | Hordeum vulgare | 4513 | Plants | Plants | 566 | 8.239999999999998e-157 | NTclustered | gi|326497356|dbj|AK371065.1| | 112509 | g2189 | i0 | 100 | 1.94117647058824 | 306 | 0 | 100 | 0 | 1 | 306 | 349 | 654 | Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2123O06 | blastn | 594 | 566 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 12340859 | 12340859 | PRJNA885753_S_NODE_2650_length_285_cov_1.929245_g2632_i0 | PRJNA885753 | 2650 | 285 | 1.929245 | 5.49834825 | Cryptomeria japonica | 3369 | Plants | Plants | 516 | 7.77e-142 | NTclustered | gi|2571297752|ref|XR_009362071.1| | 3369 | g2632 | i0 | 99.298 | 100 | 285 | 2 | 100 | 0 | 1 | 285 | 299 | 15 | PREDICTED: Cryptomeria japonica 28S ribosomal RNA (LOC131863136), rRNA | blastn | 28500 | 516 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 17439919 | 17439919 | PRJNA885753_S_NODE_3994_length_248_cov_1.782857_g3976_i0 | PRJNA885753 | 3994 | 248 | 1.782857 | 4.42148536 | Calluna vulgaris | 13385 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2917566876|emb|OZ228610.1| | 13385 | g3976 | i0 | 97.059 | 0.814516129032258 | 34 | 0 | 13 | 1 | 125 | 157 | 49713335 | 49713368 | Calluna vulgaris genome assembly, chromosome: 7 | blastn | 202 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Calluna | Calluna vulgaris | |
| 20367714 | 20367714 | PRJNA885753_S_NODE_2296_length_302_cov_0.908297_g2278_i0 | PRJNA885753 | 2296 | 302 | 0.908297 | 2.7430569400000002 | Eukaryota | 2759 | Plants | Plants | 553 | 6.32e-153 | NTclustered | gi|194703603|gb|BT040881.1| | 4577 | g2278 | i0 | 99.669 | 77.3443708609272 | 302 | 1 | 100 | 0 | 1 | 302 | 791 | 1092 | Zea mays full-length cDNA clone ZM_BFc0144J03 mRNA, complete cds | blastn | 23358 | 558 | 0.991039426523297 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 20367715 | 20367715 | PRJNA885753_S_NODE_2656_length_285_cov_1.650943_g2638_i0 | PRJNA885753 | 2656 | 285 | 1.650943 | 4.70518755 | Oryza | 4527 | Plants | Plants | 527 | 3.59e-145 | NTclustered | gi|780981400|gb|KM117266.1| | 4529 | g2638 | i0 | 100 | 108.99298245614 | 285 | 0 | 100 | 0 | 1 | 285 | 952 | 668 | Oryza rufipogon 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 31063 | 527 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza rufipogon | |
| 21263700 | 21263700 | PRJNA885753_S_NODE_3257_length_263_cov_1.078947_g3239_i0 | PRJNA885753 | 3257 | 263 | 1.078947 | 2.83763061 | Tripterygium wilfordii | 458696 | Plants | Plants | 75 | 5.12e-9 | NTclustered | gi|1954764206|ref|XM_038831111.1| | 458696 | g3239 | i0 | 89.655 | 3.77186311787072 | 58 | 6 | 22 | 0 | 164 | 221 | 629 | 572 | PREDICTED: Tripterygium wilfordii 60S ribosomal protein L9-like (LOC119986525), mRNA | blastn | 992 | 75 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Celastrales | Celastraceae | Tripterygium | Tripterygium wilfordii | |
| 25468011 | 25468011 | PRJNA885753_S_NODE_2700_length_283_cov_2.100000_g2682_i0 | PRJNA885753 | 2700 | 283 | 2.1 | 5.943 | Streptophyta | 35493 | Plants | Plants | 472 | 1.6899999999999998e-128 | NTclustered | gi|374347430|dbj|AB107898.1| | 3371 | g2682 | i0 | 100 | 90.1060070671378 | 255 | 0 | 90 | 0 | 29 | 283 | 20 | 274 | Metasequoia glyptostroboides gene for 18S ribosomal RNA, complete cds | blastn | 25500 | 472 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Metasequoia | Metasequoia glyptostroboides | |
| 25468019 | 25468019 | PRJNA885753_S_NODE_4340_length_244_cov_2.005848_g4322_i0 | PRJNA885753 | 4340 | 244 | 2.005848 | 4.89426912 | Streptophyta | 35493 | Plants | Plants | 446 | 8.639999999999999e-121 | NTclustered | gi|125662660|gb|EF053174.1| | 3371 | g4322 | i0 | 99.59 | 100 | 244 | 1 | 100 | 0 | 1 | 244 | 598 | 841 | Metasequoia glyptostroboides isolate 110 18S ribosomal RNA gene, partial sequence | blastn | 24400 | 446 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Metasequoia | Metasequoia glyptostroboides |
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);;