contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA773625" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 749379 | 749379 | PRJNA773625_P_NODE_9721_length_164_cov_0.904348_g9706_i0 | PRJNA773625 | 9721 | 164 | 0.904348 | 1.48313072 | Phyllostachys edulis | 38705 | Plants | Plants | 147 | 6.109999999999999e-31 | NTclustered | gi|284434619|gb|GQ252858.1| | 38705 | g9706 | i0 | 83.051 | 1.89634146341463 | 177 | 15 | 100 | 8 | 1 | 164 | 3514 | 3340 | Phyllostachys edulis clone 03109 hypothetical protein and putative transposon protein genes, complete cds | blastn | 311 | 147 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Phyllostachys | Phyllostachys edulis | |
| 10953447 | 10953447 | PRJNA773625_P_NODE_8229_length_167_cov_0.881356_g8214_i0 | PRJNA773625 | 8229 | 167 | 0.881356 | 1.47186452 | Phyllostachys edulis | 38705 | Plants | Plants | 213 | 6.07e-51 | NTclustered | gi|440577350|emb|FO203441.1| | 38705 | g8214 | i0 | 89.535 | 3.91616766467066 | 172 | 12 | 100 | 5 | 1 | 167 | 92130 | 92300 | Phyllostachys heterocycla genomic DNA, BAC clone: PH01B035L11, complete sequence | blastn | 654 | 213 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Phyllostachys | Phyllostachys edulis | |
| 18601034 | 18601034 | PRJNA773625_P_NODE_3955_length_216_cov_0.952096_g3940_i0 | PRJNA773625 | 3955 | 216 | 0.952096 | 2.05652736 | Humulus japonicus | 3485 | Plants | Plants | 340 | 3.629999999999999e-89 | NTclustered | gi|1917169985|gb|MN971582.1| | 3485 | g3940 | i0 | 98.947 | 2.77314814814815 | 190 | 2 | 88 | 0 | 27 | 216 | 289 | 478 | Humulus japonicus pathogenesis-related 1 allergen mRNA, complete cds | blastn | 599 | 340 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Humulus | Humulus japonicus | |
| 21151940 | 21151940 | PRJNA773625_P_NODE_7877_length_168_cov_0.873950_g7862_i0 | PRJNA773625 | 7877 | 168 | 0.87395 | 1.468236 | Phyllostachys edulis | 38705 | Plants | Plants | 195 | 2.22e-45 | NTclustered | gi|440577297|emb|FO203437.1| | 38705 | g7862 | i0 | 87.574 | 3.67261904761905 | 169 | 19 | 100 | 2 | 1 | 168 | 132055 | 131888 | Phyllostachys heterocycla genomic DNA, BAC clone: PH01B001I13, complete sequence | blastn | 617 | 195 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Phyllostachys | Phyllostachys edulis | |
| 22426716 | 22426716 | PRJNA773625_P_NODE_8858_length_166_cov_0.888889_g8843_i0 | PRJNA773625 | 8858 | 166 | 0.888889 | 1.47555574 | Oryza sativa | 4530 | Plants | Plants | 137 | 3.73e-28 | NTclustered | gi|2668294532|dbj|AP027387.1| | 1771142 | g8843 | i0 | 82.39 | 12.0301204819277 | 159 | 26 | 95 | 1 | 8 | 164 | 10078076 | 10077918 | Oryza sativa indica subgroup Inn Ma Yebaw DNA, chromosome: 3 | blastn | 1997 | 137 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 23702331 | 23702331 | PRJNA773625_P_NODE_9379_length_165_cov_0.896552_g9364_i0 | PRJNA773625 | 9379 | 165 | 0.896552 | 1.4793108 | Phyllostachys edulis | 38705 | Plants | Plants | 178 | 2.18e-40 | NTclustered | gi|284434607|gb|GQ252852.1| | 38705 | g9364 | i0 | 86.42 | 3.16969696969697 | 162 | 22 | 98 | 0 | 3 | 164 | 771 | 932 | Phyllostachys edulis clone 03096 putative transposon protein gene, partial cds | blastn | 523 | 178 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Phyllostachys | Phyllostachys edulis |
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);;