contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA631119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 603180 | 603180 | PRJNA631119_P_NODE_23161_length_281_cov_2.139423_g23043_i0 | PRJNA631119 | 23161 | 281 | 2.139423 | 6.01177863 | Mantoniella tinhauana | 3097027 | Plants | Plants | 233 | 8.62e-57 | NTclustered | gi|2735153279|gb|CP140064.1| | 3097027 | g23043 | i0 | 89.305 | 65.9466192170818 | 187 | 18 | 66 | 2 | 90 | 275 | 1560424 | 1560239 | Mantoniella tinhauana isolate LFS chromosome 3 | blastn | 18531 | 233 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 1879356 | 1879356 | PRJNA631119_P_NODE_20362_length_295_cov_1.337838_g20244_i0 | PRJNA631119 | 20362 | 295 | 1.337838 | 3.9466221 | Micromonas commoda | 296587 | Plants | Plants | 270 | 6.9399999999999985e-68 | NTclustered | gi|255077164|ref|XM_002502186.1| | 296587 | g20244 | i0 | 90.64 | 74.2271186440678 | 203 | 19 | 69 | 0 | 4 | 206 | 203 | 1 | Micromonas commoda predicted protein partial mRNA | blastn | 21897 | 270 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 4430929 | 4430929 | PRJNA631119_P_NODE_25164_length_272_cov_2.904523_g25046_i0 | PRJNA631119 | 25164 | 272 | 2.904523 | 7.90030256 | Ostreococcus tauri | 70448 | Plants | Plants | 187 | 6.559999999999998e-43 | NTclustered | gi|1275575703|ref|XM_003082661.2| | 70448 | g25046 | i0 | 81.545 | 10.6948529411765 | 233 | 38 | 85 | 5 | 8 | 238 | 245 | 16 | Ostreococcus tauri Translation elongation/initiation factor/Ribosomal, beta-barrel (OT_ostta13g02260), partial mRNA | blastn | 2909 | 187 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus tauri | ||
| 4430958 | 4430958 | PRJNA631119_P_NODE_30624_length_251_cov_2.561798_g30506_i0 | PRJNA631119 | 30624 | 251 | 2.561798 | 6.43011298 | Chlorella variabilis | 554065 | Plants | Plants | 196 | 9.93e-46 | NTclustered | gi|552813385|ref|XM_005843877.1| | 554065 | g30506 | i0 | 82.128 | 12.2470119521912 | 235 | 36 | 92 | 6 | 20 | 251 | 1107 | 1338 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_59785) mRNA, complete cds | blastn | 3074 | 196 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 5706790 | 5706790 | PRJNA631119_P_NODE_19845_length_298_cov_1.142222_g19727_i0 | PRJNA631119 | 19845 | 298 | 1.142222 | 3.40382156 | Chlorella variabilis | 554065 | Plants | Plants | 198 | 3.3599999999999993e-46 | NTclustered | gi|552841436|ref|XM_005850245.1| | 554065 | g19727 | i0 | 81.008 | 52.1107382550336 | 258 | 42 | 86 | 7 | 31 | 286 | 291 | 39 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_30036) mRNA, complete cds | blastn | 15529 | 198 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 5706899 | 5706899 | PRJNA631119_P_NODE_38145_length_242_cov_1.177515_g38027_i0 | PRJNA631119 | 38145 | 242 | 1.177515 | 2.8495863 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 219 | 2.0299999999999993e-52 | NTclustered | gi|760449020|ref|XM_011403277.1| | 3075 | g38027 | i0 | 84.305 | 20.8801652892562 | 223 | 35 | 92 | 0 | 20 | 242 | 745 | 523 | Auxenochlorella protothecoides putative histone H2A variant 3 partial mRNA | blastn | 5053 | 219 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 8256355 | 8256355 | PRJNA631119_P_NODE_23027_length_282_cov_1.468900_g22909_i0 | PRJNA631119 | 23027 | 282 | 1.4689 | 4.142298 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 198 | 3.1599999999999997e-46 | NTclustered | gi|2082256323|ref|XM_043066580.1| | 3055 | g22909 | i0 | 80 | 82.6843971631206 | 275 | 49 | 96 | 6 | 9 | 280 | 1095 | 1366 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_10g427700v5), mRNA | blastn | 23317 | 198 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 8804871 | 8804871 | PRJNA631119_P_NODE_34427_length_247_cov_0.885057_g34309_i0 | PRJNA631119 | 34427 | 247 | 0.885057 | 2.18609079 | Chlorophyta | 3041 | Plants | Plants | 315 | 2.58e-81 | NTclustered | gi|1861356407|gb|MT377431.1| | 51329 | g34309 | i0 | 89.796 | 98.2145748987854 | 245 | 25 | 99 | 0 | 3 | 247 | 641 | 397 | Polytomella parva clone 0016300141 tubulin alpha chain (TBA) mRNA, complete cds; plastid | blastn | 24259 | 315 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 10807329 | 10807329 | PRJNA631119_P_NODE_11209_length_367_cov_1.044218_g11091_i0 | PRJNA631119 | 11209 | 367 | 1.044218 | 3.83228006 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 220 | 9.029999999999999e-53 | NTclustered | gi|545362991|ref|XM_005646636.1| | 574566 | g11091 | i0 | 78.947 | 7.91825613079019 | 323 | 68 | 88 | 0 | 1 | 323 | 160 | 482 | Coccomyxa subellipsoidea C-169 mitogen-activated protein kinase 5 partial mRNA | blastn | 2906 | 220 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 10807379 | 10807379 | PRJNA631119_P_NODE_20089_length_296_cov_2.017937_g19971_i0 | PRJNA631119 | 20089 | 296 | 2.017937 | 5.97309352 | Mantoniella tinhauana | 3097027 | Plants | Plants | 106 | 2.08e-18 | NTclustered | gi|2735153281|gb|CP140066.1| | 3097027 | g19971 | i0 | 83.333 | 0.547297297297297 | 114 | 19 | 39 | 0 | 52 | 165 | 1029462 | 1029575 | Mantoniella tinhauana isolate LFS chromosome 5 | blastn | 162 | 106 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 10807399 | 10807399 | PRJNA631119_P_NODE_23749_length_279_cov_1.398058_g23631_i0 | PRJNA631119 | 23749 | 279 | 1.398058 | 3.90058182 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 204 | 6.7e-48 | NTclustered | gi|545363001|ref|XM_005646641.1| | 574566 | g23631 | i0 | 79.856 | 71.2293906810036 | 278 | 56 | 99 | 0 | 2 | 279 | 5919 | 5642 | Coccomyxa subellipsoidea C-169 Not1-domain-containing protein partial mRNA | blastn | 19873 | 204 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 11355378 | 11355378 | PRJNA631119_P_NODE_8269_length_413_cov_1.385294_g8151_i0 | PRJNA631119 | 8269 | 413 | 1.385294 | 5.72126422 | Eukaryota | 2759 | Plants | Plants | 520 | 9.05e-143 | NTclustered | gi|969822364|gb|KT950949.1| | 3130 | g8151 | i0 | 90.38 | 97.0532687651332 | 395 | 38 | 96 | 0 | 4 | 398 | 397 | 3 | Bryopsis plumosa actin mRNA, partial cds | blastn | 40083 | 525 | 0.990476190476191 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis plumosa | |
| 13905852 | 13905852 | PRJNA631119_P_NODE_37091_length_243_cov_2.264706_g36973_i0 | PRJNA631119 | 37091 | 243 | 2.264706 | 5.50323558 | Chlorophyta | 3041 | Plants | Plants | 150 | 7.55e-32 | NTclustered | gi|255078525|ref|XM_002502797.1| | 296587 | g36973 | i0 | 79.812 | 32.0123456790123 | 213 | 37 | 86 | 6 | 22 | 231 | 467 | 258 | Micromonas commoda translation elongation factor EF-1alpha/Tu (TEF1.1), mRNA | blastn | 7779 | 150 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 14632101 | 14632101 | PRJNA631119_P_NODE_16592_length_318_cov_1.179592_g16474_i0 | PRJNA631119 | 16592 | 318 | 1.179592 | 3.75110256 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 178 | 4.71e-40 | NTclustered | gi|2082237330|ref|XM_001689650.2| | 3055 | g16474 | i0 | 81.364 | 49.1666666666667 | 220 | 39 | 69 | 2 | 68 | 286 | 2299 | 2081 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g042750v5), mRNA | blastn | 15635 | 178 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17181259 | 17181259 | PRJNA631119_P_NODE_35094_length_246_cov_0.890173_g34976_i0 | PRJNA631119 | 35094 | 246 | 0.890173 | 2.18982558 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 217 | 7.449999999999999e-52 | NTclustered | gi|14970741|emb|AJ304836.1| | 3055 | g34976 | i0 | 84.234 | 44.4512195121951 | 222 | 35 | 90 | 0 | 24 | 245 | 1689 | 1468 | Chlamydomonas reinhardtii mRNA for proton-translocating inorganic pyrophosphatase (vppa gene) | blastn | 10935 | 217 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19729779 | 19729779 | PRJNA631119_P_NODE_16396_length_319_cov_1.378049_g16278_i0 | PRJNA631119 | 16396 | 319 | 1.378049 | 4.39597631 | Mantoniella tinhauana | 3097027 | Plants | Plants | 318 | 2.67e-82 | NTclustered | gi|2735153287|gb|CP140072.1| | 3097027 | g16278 | i0 | 85.906 | 89.2978056426332 | 298 | 42 | 93 | 0 | 22 | 319 | 501458 | 501161 | Mantoniella tinhauana isolate LFS chromosome 11 | blastn | 28486 | 318 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 21005608 | 21005608 | PRJNA631119_P_NODE_22057_length_286_cov_3.586854_g21939_i0 | PRJNA631119 | 22057 | 286 | 3.586854 | 10.25840244 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 183 | 8.98e-42 | NTclustered | gi|2082263712|ref|XM_043069564.1| | 3055 | g21939 | i0 | 82.407 | 3.48251748251748 | 216 | 32 | 74 | 6 | 34 | 246 | 1027 | 815 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_13g580900v5), mRNA | blastn | 996 | 183 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 21005615 | 21005615 | PRJNA631119_P_NODE_23617_length_279_cov_2.373786_g23499_i0 | PRJNA631119 | 23617 | 279 | 2.373786 | 6.62286294 | Chlamydomonas incerta | 51695 | Plants | Plants | 165 | 3.16e-36 | NTclustered | gi|74272606|gb|DQ122868.1| | 51695 | g23499 | i0 | 77.695 | 3.67025089605735 | 269 | 60 | 96 | 0 | 3 | 271 | 602 | 334 | Chlamydomonas incerta 40S ribosomal protein S3 mRNA, complete cds | blastn | 1024 | 165 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 22280416 | 22280416 | PRJNA631119_P_NODE_7798_length_422_cov_2.381089_g7680_i0 | PRJNA631119 | 7798 | 422 | 2.381089 | 10.04819558 | Chlamydomonas sp. ICE-L | 309537 | Plants | Plants | 198 | 4.929999999999999e-46 | NTclustered | gi|1433048021|gb|MF780877.1| | 309537 | g7680 | i0 | 79.514 | 48.0568720379147 | 288 | 51 | 67 | 7 | 2 | 285 | 1402 | 1685 | Chlamydomonas sp. ICE-L heat shock protein 70A (HSP70A) mRNA, partial cds | blastn | 20280 | 198 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. ICE-L | |
| 23555869 | 23555869 | PRJNA631119_P_NODE_40799_length_226_cov_4.549020_g40681_i0 | PRJNA631119 | 40799 | 226 | 4.54902 | 10.2807852 | Micromonas pusilla | 38833 | Plants | Plants | 128 | 3.25e-25 | NTclustered | gi|303271766|ref|XM_003055199.1| | 564608 | g40681 | i0 | 82.237 | 3.7787610619469 | 152 | 23 | 66 | 4 | 51 | 200 | 184 | 35 | Micromonas pusilla CCMP1545 uncharacterized protein (MICPUCDRAFT_37283), mRNA | blastn | 854 | 128 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla |
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);;