contig_metadata
16 rows where bioproject = "PRJNA745923" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1198943 | 1198943 | PRJNA745923_S_NODE_41_length_11369_cov_57.353346_g24_i1 | PRJNA745923 | 41 | 11369 | 57.353346 | 6520.50190674 | Tanacetum cinerariifolium | 118510 | Plants | Plants | 1025 | 0 | NR | GEZ83759.1 | 118510 | g24 | i1 | 52.3 | 0.433019614741842 | 1029 | 430 | 26.5 | 13 | 6972 | 9983 | 52 | 1044 | GEZ83759.1 hypothetical protein [Tanacetum cinerariifolium] | diamond | 4923 | 1025 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 6302876 | 6302876 | PRJNA745923_S_NODE_25285_length_192_cov_1.543624_g24953_i0 | PRJNA745923 | 25285 | 192 | 1.543624 | 2.96375808 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.017 | NTclustered | gi|2835530370|dbj|LC777197.1| | 3329 | g24953 | i0 | 100 | 0.729166666666667 | 28 | 0 | 15 | 0 | 165 | 192 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurD mRNA for UDP-MurNAc-L-alanyl-D-glutamate synthetase, complete cds | blastn | 140 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 10928975 | 10928975 | PRJNA745923_S_NODE_8069_length_370_cov_7.810398_g7737_i0 | PRJNA745923 | 8069 | 370 | 7.810398 | 28.8984726 | Picea abies | 3329 | Plants | Plants | 52.8 | 0.035 | NTclustered | gi|2835530398|dbj|LC777204.1| | 3329 | g7737 | i0 | 100 | 0.151351351351351 | 28 | 0 | 8 | 0 | 343 | 370 | 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 | |
| 12204247 | 12204247 | PRJNA745923_S_NODE_27690_length_182_cov_1.575540_g27358_i0 | PRJNA745923 | 27690 | 182 | 1.57554 | 2.8674828 | Picea abies | 3329 | Plants | Plants | 52.8 | 0.015 | NTclustered | gi|2835530398|dbj|LC777204.1| | 3329 | g27358 | i0 | 100 | 0.307692307692308 | 28 | 0 | 15 | 0 | 1 | 28 | 29 | 56 | 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 | |
| 13478684 | 13478684 | PRJNA745923_S_NODE_33591_length_163_cov_3.600000_g33259_i0 | PRJNA745923 | 33591 | 163 | 3.6 | 5.868 | Ziziphus jujuba | 326968 | Plants | Plants | 52.8 | 0.014 | NTclustered | gi|2739574731|gb|CP157405.1| | 326968 | g33259 | i0 | 100 | 0.171779141104294 | 28 | 0 | 17 | 0 | 33 | 60 | 10977992 | 10977965 | Ziziphus jujuba isolate TW-2024b chromosome 03 | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rhamnaceae | Ziziphus | Ziziphus jujuba | |
| 16027225 | 16027225 | PRJNA745923_S_NODE_17033_length_241_cov_5.449495_g16701_i0 | PRJNA745923 | 17033 | 241 | 5.449495 | 13.13328295 | Picea abies | 3329 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|2835530398|dbj|LC777204.1| | 3329 | g16701 | i0 | 100 | 0.236514522821577 | 29 | 0 | 12 | 0 | 1 | 29 | 29 | 57 | Picea abies Pa-Kumamoto-2022 PaPbp mRNA for penicillin-binding protein, complete cds | blastn | 57 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 16027558 | 16027558 | PRJNA745923_S_NODE_38013_length_153_cov_0.872727_g37681_i0 | PRJNA745923 | 38013 | 153 | 0.872727 | 1.33527231 | Triticum aestivum | 4565 | Plants | Plants | 211 | 1.95e-50 | NTclustered | gi|300681419|emb|FN564427.1| | 4565 | g37681 | i0 | 91.503 | 21.8954248366013 | 153 | 13 | 100 | 0 | 1 | 153 | 549775 | 549623 | Triticum aestivum chromosome 3B-specific BAC library, contig ctg0079b | blastn | 3350 | 211 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 16502006 | 16502006 | PRJNA745923_S_NODE_9473_length_338_cov_4.433898_g9141_i0 | PRJNA745923 | 9473 | 338 | 4.433898 | 14.98657524 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.032 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g9141 | i0 | 100 | 0.165680473372781 | 28 | 0 | 8 | 0 | 1 | 28 | 29 | 56 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 17302883 | 17302883 | PRJNA745923_S_NODE_29294_length_176_cov_2.165414_g28962_i0 | PRJNA745923 | 29294 | 176 | 2.165414 | 3.81112864 | Papaver somniferum | 3469 | Plants | Plants | 52.8 | 0.015 | NTclustered | gi|1484774789|ref|XR_003324792.1| | 3469 | g28962 | i0 | 100 | 0.159090909090909 | 28 | 0 | 16 | 0 | 135 | 162 | 1730 | 1703 | PREDICTED: Papaver somniferum uncharacterized LOC113277222 (LOC113277222), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver somniferum | |
| 19050690 | 19050690 | PRJNA745923_S_NODE_31775_length_168_cov_5.872000_g31443_i0 | PRJNA745923 | 31775 | 168 | 5.872 | 9.86496 | Glycine | 3846 | Plants | Plants | 52.8 | 0.014 | NTclustered | gi|2027490559|ref|XM_003535662.5| | 3847 | g31443 | i0 | 100 | 0.333333333333333 | 28 | 0 | 17 | 0 | 131 | 158 | 1702 | 1675 | PREDICTED: Glycine max palmitoyl-acyl carrier protein thioesterase, chloroplastic (LOC100818183), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 19050708 | 19050708 | PRJNA745923_S_NODE_35_length_12554_cov_75.931260_g24_i0 | PRJNA745923 | 35 | 12554 | 75.93126 | 9532.4103804 | Tanacetum cinerariifolium | 118510 | Plants | Plants | 1025 | 0 | NR | GEZ83759.1 | 118510 | g24 | i0 | 52.3 | 0.392145929584196 | 1029 | 430 | 24 | 13 | 7623 | 10634 | 52 | 1044 | GEZ83759.1 hypothetical protein [Tanacetum cinerariifolium] | diamond | 4923 | 1025 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 21601030 | 21601030 | PRJNA745923_S_NODE_21637_length_209_cov_4.192771_g21305_i0 | PRJNA745923 | 21637 | 209 | 4.192771 | 8.76289139 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.018 | NTclustered | gi|2835530381|dbj|LC777201.1| | 3329 | g21305 | i0 | 100 | 0.669856459330144 | 28 | 0 | 13 | 0 | 1 | 28 | 29 | 56 | Picea abies Pa-Kumamoto-2022 PaMraY mRNA for UDP-MurNAc-pentapeptide phosphotransferase, complete cds | blastn | 140 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 22402109 | 22402109 | PRJNA745923_S_NODE_20998_length_213_cov_2.211765_g20666_i0 | PRJNA745923 | 20998 | 213 | 2.211765 | 4.71105945 | Picea abies | 3329 | Plants | Plants | 52.8 | 0.019 | NTclustered | gi|2835530398|dbj|LC777204.1| | 3329 | g20666 | i0 | 100 | 0.262910798122066 | 28 | 0 | 13 | 0 | 186 | 213 | 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 | |
| 25425373 | 25425373 | PRJNA745923_S_NODE_11140_length_308_cov_20.132075_g10808_i0 | PRJNA745923 | 11140 | 308 | 20.132075 | 62.006791 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.029 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g10808 | i0 | 100 | 0.181818181818182 | 28 | 0 | 9 | 0 | 281 | 308 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 25425377 | 25425377 | PRJNA745923_S_NODE_11220_length_307_cov_4.189394_g10888_i0 | PRJNA745923 | 11220 | 307 | 4.189394 | 12.86143958 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.029 | NTclustered | gi|2835530364|dbj|LC777194.1| | 3329 | g10888 | i0 | 100 | 0.182410423452769 | 28 | 0 | 9 | 0 | 280 | 307 | 56 | 29 | Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds | blastn | 56 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 29799954 | 29799954 | PRJNA745923_S_NODE_27151_length_184_cov_1.702128_g26819_i0 | PRJNA745923 | 27151 | 184 | 1.702128 | 3.13191552 | Liquidambar formosana | 63359 | Plants | Plants | 74.7 | 6.58e-16 | NR | KAK9269863.1 | 63359 | g26819 | i0 | 97.1 | 0.554347826086957 | 34 | 1 | 55.4 | 0 | 3 | 104 | 43 | 76 | KAK9269863.1 hypothetical protein L1049_025436 [Liquidambar formosana] | diamond | 102 | 74.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Saxifragales | Altingiaceae | Liquidambar | Liquidambar formosana |
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);;