contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA993416" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 976046 | 976046 | PRJNA993416_P_NODE_9841_length_276_cov_1.137931_g9736_i0 | PRJNA993416 | 9841 | 276 | 1.137931 | 3.14068956 | Paradoxia multiseta | 249350 | Plants | Plants | 436 | 5.999999999999999e-118 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g9736 | i0 | 98.776 | 2.32971014492754 | 245 | 3 | 99 | 0 | 1 | 245 | 88620 | 88864 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 643 | 436 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 4803922 | 4803922 | PRJNA993416_P_NODE_7744_length_296_cov_3.076233_g7639_i0 | PRJNA993416 | 7744 | 296 | 3.076233 | 9.10564968 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 124 | 5.74e-24 | NTclustered | gi|545363291|ref|XM_005646727.1| | 574566 | g7639 | i0 | 88.462 | 1.68918918918919 | 104 | 10 | 35 | 2 | 145 | 247 | 832 | 730 | Coccomyxa subellipsoidea C-169 ENTH-domain-containing protein partial mRNA | blastn | 500 | 124 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 6079265 | 6079265 | PRJNA993416_P_NODE_9645_length_277_cov_1.509804_g9540_i0 | PRJNA993416 | 9645 | 277 | 1.509804 | 4.18215708 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 292 | 1.38e-74 | NTclustered | gi|545370123|ref|XM_005649674.1| | 574566 | g9540 | i0 | 88.983 | 0.851985559566787 | 236 | 26 | 85 | 0 | 8 | 243 | 1300 | 1065 | Coccomyxa subellipsoidea C-169 hypothetical protein mRNA | blastn | 236 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 7353530 | 7353530 | PRJNA993416_P_NODE_11566_length_259_cov_1.596774_g11461_i0 | PRJNA993416 | 11566 | 259 | 1.596774 | 4.13564466 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 86.1 | 2.33e-12 | NTclustered | gi|545365777|ref|XM_005647776.1| | 574566 | g11461 | i0 | 79.528 | 0.49034749034749 | 127 | 20 | 48 | 4 | 107 | 230 | 4703 | 4826 | Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA | blastn | 127 | 86.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 9903974 | 9903974 | PRJNA993416_P_NODE_12768_length_250_cov_0.870056_g12663_i0 | PRJNA993416 | 12768 | 250 | 0.870056 | 2.17514 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 303 | 5.66e-78 | NTclustered | gi|2106301938|dbj|AP025008.1| | 2315456 | g12663 | i0 | 94.444 | 39.104 | 198 | 10 | 79 | 1 | 29 | 225 | 77533 | 77336 | Coccomyxa sp. Obi chloroplast DNA, complete genome | blastn | 9776 | 303 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 10201547 | 10201547 | PRJNA993416_P_NODE_10508_length_269_cov_1.571429_g10403_i0 | PRJNA993416 | 10508 | 269 | 1.571429 | 4.22714401 | Chlorophyceae | 3166 | Plants | Plants | 163 | 1.09e-35 | NTclustered | gi|2082244575|ref|XM_043061686.1| | 3055 | g10403 | i0 | 81.068 | 2.58736059479554 | 206 | 37 | 76 | 2 | 65 | 269 | 806 | 1010 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_04g215400v5), mRNA | blastn | 696 | 163 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 11179365 | 11179365 | PRJNA993416_P_NODE_8449_length_287_cov_1.443925_g8344_i0 | PRJNA993416 | 8449 | 287 | 1.443925 | 4.14406475 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 178 | 4.2e-40 | NTclustered | gi|545359931|ref|XM_005645330.1| | 574566 | g8344 | i0 | 89.928 | 0.937282229965157 | 139 | 12 | 48 | 2 | 21 | 158 | 790 | 927 | Coccomyxa subellipsoidea C-169 coatomer protein complex, beta prime partial mRNA | blastn | 269 | 178 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 12454959 | 12454959 | PRJNA993416_P_NODE_13250_length_249_cov_0.875000_g13145_i0 | PRJNA993416 | 13250 | 249 | 0.875 | 2.17875 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 193 | 1.27e-44 | NTclustered | gi|545359095|ref|XM_005644987.1| | 574566 | g13145 | i0 | 88.199 | 0.646586345381526 | 161 | 19 | 65 | 0 | 25 | 185 | 2018 | 1858 | Coccomyxa subellipsoidea C-169 P-loop containing nucleoside triphosphate hydrolase protein mRNA | blastn | 161 | 193 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 12455089 | 12455089 | PRJNA993416_P_NODE_4170_length_412_cov_1.749263_g4065_i0 | PRJNA993416 | 4170 | 412 | 1.749263 | 7.20696356 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 187 | 1.0399999999999997e-42 | NTclustered | gi|545354972|ref|XM_005643250.1| | 574566 | g4065 | i0 | 88.816 | 0.368932038834951 | 152 | 17 | 37 | 0 | 88 | 239 | 707 | 556 | Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA | blastn | 152 | 187 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 17553727 | 17553727 | PRJNA993416_P_NODE_15894_length_242_cov_0.911243_g15789_i0 | PRJNA993416 | 15894 | 242 | 0.911243 | 2.20520806 | Paradoxia multiseta | 249350 | Plants | Plants | 270 | 5.53e-68 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g15789 | i0 | 86.777 | 84.7272727272727 | 242 | 32 | 100 | 0 | 1 | 242 | 171551 | 171792 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 20504 | 270 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 18827516 | 18827516 | PRJNA993416_P_NODE_10915_length_265_cov_2.395833_g10810_i0 | PRJNA993416 | 10915 | 265 | 2.395833 | 6.34895745 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 121 | 6.55e-23 | NTclustered | gi|545368768|ref|XM_005649103.1| | 574566 | g10810 | i0 | 82.069 | 0.547169811320755 | 145 | 22 | 54 | 3 | 81 | 223 | 1763 | 1621 | Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA | blastn | 145 | 121 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 22652865 | 22652865 | PRJNA993416_P_NODE_13718_length_247_cov_1.873563_g13613_i0 | PRJNA993416 | 13718 | 247 | 1.873563 | 4.62770061 | Paradoxia multiseta | 249350 | Plants | Plants | 278 | 3.3800000000000004e-70 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g13613 | i0 | 90.521 | 13.6072874493927 | 211 | 18 | 85 | 2 | 37 | 247 | 15127 | 15335 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 3361 | 278 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 23928287 | 23928287 | PRJNA993416_P_NODE_11159_length_263_cov_1.600000_g11054_i0 | PRJNA993416 | 11159 | 263 | 1.6 | 4.208 | Paradoxia multiseta | 249350 | Plants | Plants | 481 | 2.58e-131 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g11054 | i0 | 99.62 | 3 | 263 | 1 | 100 | 0 | 1 | 263 | 66046 | 66308 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 789 | 481 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 23928559 | 23928559 | PRJNA993416_P_NODE_8939_length_283_cov_1.685714_g8834_i0 | PRJNA993416 | 8939 | 283 | 1.685714 | 4.77057062 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 254 | 6.67e-63 | NTclustered | gi|545370403|ref|XM_005649787.1| | 574566 | g8834 | i0 | 93.529 | 0.600706713780919 | 170 | 11 | 60 | 0 | 16 | 185 | 1520 | 1351 | Coccomyxa subellipsoidea C-169 TBC-domain-containing protein partial mRNA | blastn | 170 | 254 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 25202177 | 25202177 | PRJNA993416_P_NODE_9900_length_275_cov_1.480198_g9795_i0 | PRJNA993416 | 9900 | 275 | 1.480198 | 4.0705445 | Chlorella variabilis | 554065 | Plants | Plants | 76.8 | 1.5e-9 | NTclustered | gi|552843909|ref|XM_005850898.1| | 554065 | g9795 | i0 | 84.615 | 0.283636363636364 | 78 | 11 | 28 | 1 | 199 | 275 | 793 | 870 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_19459) mRNA, complete cds | blastn | 78 | 76.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis |
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);;