contig_metadata
7 rows where bioproject = "PRJNA1136957" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2835264 | 2835264 | PRJNA1136957_S_NODE_21463_length_187_cov_3.570312_g21366_i0 | PRJNA1136957 | 21463 | 187 | 3.570312 | 6.67648344 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 224 | 3.21e-54 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g21366 | i0 | 88.235 | 99.8395721925134 | 187 | 22 | 100 | 0 | 1 | 187 | 2338 | 2524 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 18670 | 224 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 4860068 | 4860068 | PRJNA1136957_S_NODE_14004_length_231_cov_1.284884_g13907_i0 | PRJNA1136957 | 14004 | 231 | 1.284884 | 2.96808204 | Ostreobium | 121087 | Plants | Plants | 58.4 | 4.44e-4 | NTclustered | gi|1075059554|ref|NC_030629.1| | 121088 | g13907 | i0 | 97.143 | 0.303030303030303 | 35 | 0 | 15 | 1 | 94 | 128 | 61550 | 61583 | Ostreobium quekettii genome assembly, organelle: plastid | blastn | 70 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 20685965 | 20685965 | PRJNA1136957_S_NODE_13617_length_234_cov_1.531429_g13520_i0 | PRJNA1136957 | 13617 | 234 | 1.531429 | 3.58354386 | Diplosphaera sundellii | 3135960 | Plants | Plants | 202 | 1.9699999999999998e-47 | NTclustered | gi|2878821371|gb|PQ563290.1| | 3135960 | g13520 | i0 | 89.873 | 44.042735042735 | 158 | 15 | 97 | 1 | 1 | 157 | 9287 | 9130 | Diplosphaera sundellii mitochondrion, complete genome | blastn | 10306 | 202 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Diplosphaera | Diplosphaera sundellii | |
| 27659848 | 27659848 | PRJNA1136957_S_NODE_12744_length_241_cov_2.010989_g12647_i0 | PRJNA1136957 | 12744 | 241 | 2.010989 | 4.84648349 | Eukaryota | 2759 | Plants | Plants | 48.9 | 1.53e-4 | NR | KAG2483284.1 | 47281 | g12647 | i0 | 50.9 | 1.3195020746888 | 53 | 25 | 64.7 | 1 | 241 | 86 | 149 | 201 | KAG2483284.1 hypothetical protein HYH03_017831 [Edaphochlamys debaryana] | diamond | 318 | 48.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 28870353 | 28870353 | PRJNA1136957_S_NODE_828_length_602_cov_25.974217_g750_i0 | PRJNA1136957 | 828 | 602 | 25.974217 | 156.36478634 | [Myrmecia] bisecta | 41462 | Plants | Plants | 171 | 2.99e-51 | NR | KAK9808902.1 | 41462 | g750 | i0 | 81.3 | 1.43521594684385 | 96 | 18 | 47.8 | 0 | 602 | 315 | 13 | 108 | KAK9808902.1 hypothetical protein WJX72_006080 [[Myrmecia] bisecta] | diamond | 864 | 171 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 32505039 | 32505039 | PRJNA1136957_S_NODE_19779_length_197_cov_1.326087_g19682_i0 | PRJNA1136957 | 19779 | 197 | 1.326087 | 2.61239139 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 70.5 | 8.4e-13 | NR | KAG7673070.1 | 1650286 | g19682 | i0 | 86.8 | 0.578680203045685 | 38 | 5 | 57.9 | 0 | 197 | 84 | 184 | 221 | KAG7673070.1 hypothetical protein KSW81_006286 [Chlorella desiccata (nom. nud.)] | diamond | 114 | 70.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 32757041 | 32757041 | PRJNA1136957_S_NODE_11860_length_249_cov_1.926316_g11763_i0 | PRJNA1136957 | 11860 | 249 | 1.926316 | 4.79652684 | Chlamydomonas incerta | 51695 | Plants | Plants | 55.1 | 1.91e-6 | NR | KAG2425500.1 | 51695 | g11763 | i0 | 42.3 | 1.55421686746988 | 78 | 40 | 94 | 2 | 234 | 1 | 1727 | 1799 | KAG2425500.1 hypothetical protein HXX76_013709 [Chlamydomonas incerta] | diamond | 387 | 55.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta |
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);;