contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA908278" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2524708 | 2524708 | PRJNA908278_P_NODE_27742_length_250_cov_0.870056_g27639_i0 | PRJNA908278 | 27742 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.006 | NTclustered | gi|2082264889|ref|XM_043070076.1| | 3055 | g27639 | i0 | 100 | 0.232 | 29 | 0 | 12 | 0 | 112 | 140 | 2318 | 2290 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_14g615450v5), mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 3441109 | 3441109 | PRJNA908278_P_NODE_28823_length_249_cov_0.801136_g28720_i0 | PRJNA908278 | 28823 | 249 | 0.801136 | 1.99482864 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 104 | 6.13e-18 | NTclustered | gi|2082244743|ref|XM_001698671.2| | 3055 | g28720 | i0 | 85.149 | 2.04016064257028 | 101 | 15 | 41 | 0 | 149 | 249 | 754 | 654 | Chlamydomonas reinhardtii ribosomal protein L23 (CHLRE_04g211800v5), mRNA | blastn | 508 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 4718745 | 4718745 | PRJNA908278_P_NODE_19264_length_292_cov_1.054795_g19161_i0 | PRJNA908278 | 19264 | 292 | 1.054795 | 3.0800014 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 193 | 1.53e-44 | NTclustered | gi|2082265902|ref|XM_043070515.1| | 3055 | g19161 | i0 | 85.638 | 7.31849315068493 | 188 | 21 | 63 | 5 | 10 | 194 | 373 | 189 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_15g635600v5), mRNA | blastn | 2137 | 193 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 5993538 | 5993538 | PRJNA908278_P_NODE_27625_length_250_cov_0.870056_g27522_i0 | PRJNA908278 | 27625 | 250 | 0.870056 | 2.17514 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 446 | 8.89e-121 | NTclustered | gi|760437442|ref|XM_011397488.1| | 3075 | g27522 | i0 | 98.8 | 1 | 250 | 3 | 100 | 0 | 1 | 250 | 1176 | 927 | Auxenochlorella protothecoides hypothetical protein partial mRNA | blastn | 250 | 446 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 8543047 | 8543047 | PRJNA908278_P_NODE_10467_length_375_cov_2.801325_g10364_i0 | PRJNA908278 | 10467 | 375 | 2.801325 | 10.50496875 | Volvox carteri | 3067 | Plants | Plants | 54.7 | 0.01 | NTclustered | gi|349584|gb|L07946.1|VVCH1IA | 3068 | g10364 | i0 | 100 | 0.154666666666667 | 29 | 0 | 8 | 0 | 258 | 286 | 1537 | 1509 | Volvox carteri nagariensis histone (H1-I) gene, complete cds | blastn | 58 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 11093827 | 11093827 | PRJNA908278_P_NODE_20709_length_284_cov_1.094787_g20606_i0 | PRJNA908278 | 20709 | 284 | 1.094787 | 3.10919508 | Monoraphidium neglectum | 145388 | Plants | Plants | 200 | 8.85e-47 | NTclustered | gi|926781757|ref|XM_014043899.1| | 145388 | g20606 | i0 | 82.883 | 11.9894366197183 | 222 | 38 | 78 | 0 | 63 | 284 | 399 | 178 | Monoraphidium neglectum 60S ribosomal protein mRNA | blastn | 3405 | 200 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 16192997 | 16192997 | PRJNA908278_P_NODE_15653_length_319_cov_2.304878_g15550_i0 | PRJNA908278 | 15653 | 319 | 2.304878 | 7.35256082 | Chlorella variabilis | 554065 | Plants | Plants | 156 | 2.22e-33 | NTclustered | gi|552847345|ref|XM_005851779.1| | 554065 | g15550 | i0 | 80 | 0.836990595611285 | 215 | 39 | 67 | 4 | 65 | 277 | 509 | 297 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_133342) mRNA, complete cds | blastn | 267 | 156 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 18741734 | 18741734 | PRJNA908278_P_NODE_15875_length_318_cov_0.804082_g15772_i0 | PRJNA908278 | 15875 | 318 | 0.804082 | 2.55698076 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 102 | 2.92e-17 | NTclustered | gi|2082263148|ref|XM_001693658.2| | 3055 | g15772 | i0 | 83.486 | 25.877358490566 | 109 | 18 | 34 | 0 | 16 | 124 | 610 | 718 | Chlamydomonas reinhardtii ribosomal protein S3a (CHLRE_13g568650v5), mRNA | blastn | 8229 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18741846 | 18741846 | PRJNA908278_P_NODE_26855_length_251_cov_0.865169_g26752_i0 | PRJNA908278 | 26855 | 251 | 0.865169 | 2.17157419 | Chlamydomonas schloesseri | 2026947 | Plants | Plants | 95.3 | 3.73e-15 | NTclustered | gi|2089721549|gb|MZ445444.1| | 2026947 | g26752 | i0 | 85.556 | 7.72509960159363 | 90 | 13 | 36 | 0 | 142 | 231 | 540 | 451 | Chlamydomonas schloesseri strain SAG 2486 small nucleolar ribonucleoprotein U3 component mRNA, partial cds | blastn | 1939 | 95.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas schloesseri | |
| 21292284 | 21292284 | PRJNA908278_P_NODE_32237_length_245_cov_0.895349_g32134_i0 | PRJNA908278 | 32237 | 245 | 0.895349 | 2.19360505 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 172 | 1.63e-38 | NTclustered | gi|760441254|ref|XM_011399394.1| | 3075 | g32134 | i0 | 92.5 | 0.489795918367347 | 120 | 9 | 49 | 0 | 1 | 120 | 445 | 564 | Auxenochlorella protothecoides hypothetical protein partial mRNA | blastn | 120 | 172 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 23842445 | 23842445 | PRJNA908278_P_NODE_20259_length_286_cov_1.446009_g20156_i0 | PRJNA908278 | 20259 | 286 | 1.446009 | 4.13558574 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2082250453|ref|XM_001690409.2| | 3055 | g20156 | i0 | 100 | 0.104895104895105 | 30 | 0 | 10 | 0 | 61 | 90 | 177 | 206 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_07g328350v5), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii |
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);;