contig_metadata
8 rows where bioproject = "PRJNA207719" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4884002 | 4884002 | PRJNA207719_P_NODE_964_length_193_cov_7.579268_g944_i0 | PRJNA207719 | 964 | 193 | 7.579268 | 14.62798724 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.005 | NTclustered | gi|1241299067|gb|KY965816.2| | 149440 | g944 | i0 | 100 | 0.735751295336788 | 29 | 0 | 15 | 0 | 1 | 29 | 106092 | 106064 | Lasthenia californica chloroplast | blastn | 142 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Lasthenia | Lasthenia californica | |
| 5470426 | 5470426 | PRJNA207719_P_NODE_1085_length_178_cov_14.476510_g1065_i0 | PRJNA207719 | 1085 | 178 | 14.47651 | 25.7681878 | Hordeum vulgare | 4513 | Plants | Plants | 329 | 6.21e-86 | NTclustered | gi|2133473874|ref|XR_006616617.1| | 112509 | g1065 | i0 | 100 | 1119.78651685393 | 178 | 0 | 100 | 0 | 1 | 178 | 1450 | 1273 | PREDICTED: Hordeum vulgare subsp. vulgare 28S ribosomal RNA (LOC123417155), rRNA | blastn | 199322 | 329 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 15669874 | 15669874 | PRJNA207719_P_NODE_713_length_235_cov_9.077670_g693_i0 | PRJNA207719 | 713 | 235 | 9.07767 | 21.3325245 | Justicia demissa | 1685546 | Plants | Plants | 435 | 1.79e-117 | NTclustered | gi|2482680364|gb|OQ785890.1| | 1685546 | g693 | i0 | 100 | 105.676595744681 | 235 | 0 | 100 | 0 | 1 | 235 | 5073 | 4839 | Justicia demissa small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 24834 | 435 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Acanthaceae | Justicia | Justicia demissa | |
| 18907492 | 18907492 | PRJNA207719_P_NODE_215_length_467_cov_6.915525_g195_i0 | PRJNA207719 | 215 | 467 | 6.915525 | 32.29550175 | Eukaryota | 2759 | Plants | Plants | 521 | 2.879999999999999e-143 | NTclustered | gi|6273812|gb|AF168852.1| | 4517 | g195 | i0 | 100 | 2212.6852248394 | 282 | 0 | 93 | 0 | 186 | 467 | 290 | 9 | Hordeum jubatum 18S small subunit ribosomal RNA gene, partial sequence | blastn | 1033324 | 521 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum jubatum | |
| 22732810 | 22732810 | PRJNA207719_P_NODE_1158_length_171_cov_2.690141_g1138_i0 | PRJNA207719 | 1158 | 171 | 2.690141 | 4.60014111 | Ananas | 4614 | Plants | Plants | 126 | 8.32e-25 | NTclustered | gi|1147599615|ref|XM_020248139.1| | 4615 | g1138 | i0 | 83.704 | 42.2222222222222 | 135 | 20 | 78 | 2 | 31 | 164 | 425 | 292 | PREDICTED: Ananas comosus 60S ribosomal protein L10-like (LOC109720811), mRNA | blastn | 7220 | 126 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Bromeliaceae | Ananas | Ananas comosus | |
| 29126878 | 29126878 | PRJNA207719_P_NODE_1349_length_150_cov_2.181818_g1329_i0 | PRJNA207719 | 1349 | 150 | 2.181818 | 3.272727 | Daucus carota subsp. sativus | 79200 | Plants | Plants | 59.7 | 4.55e-9 | NR | XP_017243200.1 | 79200 | g1329 | i0 | 61.7 | 3.7 | 47 | 18 | 94 | 0 | 150 | 10 | 160 | 206 | XP_017243200.1 nascent polypeptide-associated complex subunit alpha-like protein 2 [Daucus carota subsp. sativus] | diamond | 555 | 59.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Apiales | Apiaceae | Daucus | Daucus carota | |
| 31228968 | 31228968 | PRJNA207719_P_NODE_1155_length_172_cov_1.797203_g1135_i0 | PRJNA207719 | 1155 | 172 | 1.797203 | 3.09118916 | Eukaryota | 2759 | Plants | Plants | 67 | 4.42e-12 | NR | KAI9191846.1 | 4023 | g1135 | i0 | 56.1 | 11.9476744186047 | 57 | 25 | 99.4 | 0 | 2 | 172 | 11 | 67 | KAI9191846.1 hypothetical protein LWI28_014423 [Acer negundo] | diamond | 2055 | 67.4 | 0.99406528189911 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer negundo | |
| 31703627 | 31703627 | PRJNA207719_P_NODE_617_length_256_cov_2.713656_g597_i0 | PRJNA207719 | 617 | 256 | 2.713656 | 6.94695936 | Ericales | 41945 | Plants | Plants | 47.4 | 5.03e-4 | NR | XP_057502784.1 | 165200 | g597 | i0 | 39.4 | 5.49609375 | 66 | 39 | 77.3 | 1 | 15 | 212 | 42 | 106 | XP_057502784.1 calmodulin-like protein 30 [Actinidia eriantha] | diamond | 1407 | 47.8 | 0.99163179916318 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Actinidiaceae | Actinidia | Actinidia eriantha |
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);;