contig_metadata
7 rows where bioproject = "PRJNA1233317" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 335702 | 335702 | PRJNA1233317_S_NODE_8621_length_263_cov_3.186275_g8585_i0 | PRJNA1233317 | 8621 | 263 | 3.186275 | 8.37990325 | Viridiplantae | 33090 | Plants | Plants | 57 | 1.94e-7 | NR | KDD75683.1 | 1291522 | g8585 | i0 | 100 | 2.36121673003802 | 26 | 0 | 29.7 | 0 | 1 | 78 | 165 | 190 | KDD75683.1 hypothetical protein H632_c551p0 [Helicosporidium sp. ATCC 50920] | diamond | 621 | 57 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ATCC 50920 | |
| 7989113 | 7989113 | PRJNA1233317_S_NODE_8867_length_260_cov_2.731343_g8831_i0 | PRJNA1233317 | 8867 | 260 | 2.731343 | 7.1014918 | Diplosphaera sundellii | 3135960 | Plants | Plants | 388 | 1.59e-103 | NTclustered | gi|2878821371|gb|PQ563290.1| | 3135960 | g8831 | i0 | 93.846 | 1.29615384615385 | 260 | 13 | 100 | 1 | 1 | 260 | 7087 | 6831 | Diplosphaera sundellii mitochondrion, complete genome | blastn | 337 | 388 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Diplosphaera | Diplosphaera sundellii | |
| 19461653 | 19461653 | PRJNA1233317_S_NODE_4076_length_336_cov_3.696751_g4040_i0 | PRJNA1233317 | 4076 | 336 | 3.696751 | 12.42108336 | Edaphochlorella mirabilis | 3083 | Plants | Plants | 217 | 1.06e-51 | NTclustered | gi|725675941|ref|NC_025528.1| | 3083 | g4040 | i0 | 84.513 | 56.7380952380952 | 226 | 27 | 65 | 5 | 118 | 336 | 113401 | 113625 | 'Chlorella' mirabilis culture-collection SAG:38.88 chloroplast, complete genome | blastn | 19064 | 217 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Prasiolaceae | Edaphochlorella | Edaphochlorella mirabilis | |
| 27389026 | 27389026 | PRJNA1233317_S_NODE_2083_length_389_cov_2.469697_g2047_i0 | PRJNA1233317 | 2083 | 389 | 2.469697 | 9.60712133 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 52 | 9.6e-5 | NR | GAX76654.1 | 1157962 | g2047 | i0 | 46.7 | 0.694087403598972 | 90 | 41 | 68.6 | 3 | 121 | 387 | 124 | 207 | GAX76654.1 hypothetical protein CEUSTIGMA_g4100.t1 [Chlamydomonas eustigma] | diamond | 270 | 52 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 28575759 | 28575759 | PRJNA1233317_S_NODE_3047_length_359_cov_9.760000_g3011_i0 | PRJNA1233317 | 3047 | 359 | 9.76 | 35.0384 | Trebouxia | 13786 | Plants | Plants | 65.9 | 9.91e-10 | NR | KAL0029491.1 | 2905653 | g3011 | i0 | 57.1 | 1.22841225626741 | 49 | 21 | 40.9 | 0 | 2 | 148 | 350 | 398 | KAL0029491.1 hypothetical protein WJX77_011613 [Trebouxia sp. C0004] | diamond | 441 | 65.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 30326067 | 30326067 | PRJNA1233317_S_NODE_13632_length_209_cov_1.626667_g13596_i0 | PRJNA1233317 | 13632 | 209 | 1.626667 | 3.39973403 | Micractinium conductrix | 554055 | Plants | Plants | 58.5 | 6.42e-8 | NR | PSC69493.1 | 554055 | g13596 | i0 | 49.2 | 0.933014354066986 | 65 | 33 | 93.3 | 0 | 13 | 207 | 809 | 873 | PSC69493.1 Acyl-coenzyme A thioesterase mitochondrial [Micractinium conductrix] | diamond | 195 | 58.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 30641326 | 30641326 | PRJNA1233317_S_NODE_9113_length_257_cov_2.646465_g9077_i0 | PRJNA1233317 | 9113 | 257 | 2.646465 | 6.80141505 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 93.2 | 2.38e-22 | NR | XP_005649206.1 | 574566 | g9077 | i0 | 79.2 | 1.23735408560311 | 53 | 11 | 61.9 | 0 | 255 | 97 | 13 | 65 | XP_005649206.1 ribosomal protein 60S [Coccomyxa subellipsoidea C-169] | diamond | 318 | 93.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea |
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);;