contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA915212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4723654 | 4723654 | PRJNA915212_P_NODE_1364_length_574_cov_3.072381_g1332_i0 | PRJNA915212 | 1364 | 574 | 3.072381 | 17.63546694 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 267 | 1.86e-66 | NTclustered | gi|2082260161|ref|XM_001690941.2| | 3055 | g1332 | i0 | 83.566 | 42.4982578397213 | 286 | 45 | 50 | 2 | 161 | 445 | 265 | 549 | Chlamydomonas reinhardtii ribosomal protein S23 (CHLRE_12g504200v5), mRNA | blastn | 24394 | 267 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 5998367 | 5998367 | PRJNA915212_P_NODE_2185_length_445_cov_2.585859_g2149_i0 | PRJNA915212 | 2185 | 445 | 2.585859 | 11.50707255 | Chlorella variabilis | 554065 | Plants | Plants | 252 | 3.96e-62 | NTclustered | gi|552830805|ref|XM_005847928.1| | 554065 | g2149 | i0 | 84.585 | 59.761797752809 | 253 | 39 | 57 | 0 | 193 | 445 | 174 | 426 | Chlorella variabilis hypothetical protein (RACK1) mRNA, complete cds | blastn | 26594 | 252 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 8548122 | 8548122 | PRJNA915212_P_NODE_7027_length_221_cov_0.796512_g6989_i0 | PRJNA915212 | 7027 | 221 | 0.796512 | 1.76029152 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 119 | 1.9e-22 | NTclustered | gi|2082260551|ref|XM_001702928.2| | 3055 | g6989 | i0 | 80.38 | 1.73755656108597 | 158 | 29 | 71 | 2 | 1 | 157 | 315 | 159 | Chlamydomonas reinhardtii ribosomal protein S11 (CHLRE_12g514500v5), mRNA | blastn | 384 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 9823022 | 9823022 | PRJNA915212_P_NODE_2468_length_416_cov_1.482289_g2432_i0 | PRJNA915212 | 2468 | 416 | 1.482289 | 6.16632224 | Chlorella variabilis | 554065 | Plants | Plants | 361 | 5.8499999999999996e-95 | NTclustered | gi|552844675|ref|XM_005851082.1| | 554065 | g2432 | i0 | 84.573 | 83.2860576923077 | 363 | 56 | 87 | 0 | 1 | 363 | 448 | 86 | Chlorella variabilis alpha-tubulin (CHLNCDRAFT_33793) mRNA, complete cds | blastn | 34647 | 361 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 12374265 | 12374265 | PRJNA915212_P_NODE_1570_length_530_cov_1.985447_g1535_i0 | PRJNA915212 | 1570 | 530 | 1.985447 | 10.5228691 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 244 | 8.000000000000002e-60 | NTclustered | gi|760441128|ref|XM_011399331.1| | 3075 | g1535 | i0 | 78.358 | 11.8245283018868 | 402 | 69 | 75 | 10 | 100 | 495 | 55 | 444 | Auxenochlorella protothecoides 40S ribosomal protein S3-3 partial mRNA | blastn | 6267 | 244 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 14923049 | 14923049 | PRJNA915212_P_NODE_10872_length_174_cov_1.320000_g10834_i0 | PRJNA915212 | 10872 | 174 | 1.32 | 2.2968 | Volvox carteri | 3067 | Plants | Plants | 58.4 | 3.15e-4 | NTclustered | gi|302845532|ref|XM_002954259.1| | 3068 | g10834 | i0 | 100 | 0.17816091954023 | 31 | 0 | 18 | 0 | 19 | 49 | 911 | 881 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_106323), partial mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 14923127 | 14923127 | PRJNA915212_P_NODE_612_length_847_cov_2.330827_g588_i0 | PRJNA915212 | 612 | 847 | 2.330827 | 19.74210469 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 885 | 0 | NTclustered | gi|2082244282|ref|XM_001703058.2| | 3055 | g588 | i0 | 87.039 | 93.1770956316411 | 787 | 99 | 93 | 3 | 1 | 785 | 1346 | 561 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_04g216850v5), mRNA | blastn | 78921 | 885 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 15278991 | 15278991 | PRJNA915212_P_NODE_14012_length_163_cov_0.894737_g13974_i0 | PRJNA915212 | 14012 | 163 | 0.894737 | 1.45842131 | root | 1 | Root_unresolved | Root_unresolved | 302 | 1.22e-77 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g13974 | i0 | 100 | 100.233128834356 | 163 | 0 | 100 | 0 | 1 | 163 | 842 | 680 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 16338 | 302 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 17828562 | 17828562 | PRJNA915212_P_NODE_4934_length_269_cov_1.954545_g4896_i0 | PRJNA915212 | 4934 | 269 | 1.954545 | 5.25772605 | Chlorophyceae | 3166 | Plants | Plants | 231 | 2.95e-56 | NTclustered | gi|2082260161|ref|XM_001690941.2| | 3055 | g4896 | i0 | 82.759 | 60.4609665427509 | 261 | 43 | 97 | 2 | 1 | 260 | 395 | 136 | Chlamydomonas reinhardtii ribosomal protein S23 (CHLRE_12g504200v5), mRNA | blastn | 16264 | 231 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20021826 | 20021826 | PRJNA915212_P_NODE_3676_length_324_cov_3.400000_g3638_i0 | PRJNA915212 | 3676 | 324 | 3.4 | 11.016 | Chlorella variabilis | 554065 | Plants | Plants | 152 | 2.9199999999999996e-32 | NTclustered | gi|552847345|ref|XM_005851779.1| | 554065 | g3638 | i0 | 78.279 | 4.6882716049382704 | 244 | 47 | 74 | 6 | 47 | 287 | 525 | 285 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_133342) mRNA, complete cds | blastn | 1519 | 152 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 22928705 | 22928705 | PRJNA915212_P_NODE_3898_length_311_cov_1.675573_g3860_i0 | PRJNA915212 | 3898 | 311 | 1.675573 | 5.21103203 | Eukaryota | 2759 | Plants | Plants | 239 | 2.08e-58 | NTclustered | gi|552833068|ref|XM_005848413.1| | 554065 | g3860 | i0 | 85.59 | 81.0932475884244 | 229 | 31 | 73 | 2 | 66 | 293 | 544 | 771 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_35106) mRNA, complete cds | blastn | 25220 | 241 | 0.991701244813278 | 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);;