contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA631119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | |
| 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 | |
| 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 |
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);;