contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJEB12237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1294943 | 1294943 | PRJEB12237_P_NODE_9942_length_169_cov_1.492537_g9746_i0 | PRJEB12237 | 9942 | 169 | 1.492537 | 2.52238753 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 126 | 8.2e-25 | NTclustered | gi|760448344|ref|XM_011402939.1| | 3075 | g9746 | i0 | 85.714 | 49.6213017751479 | 119 | 17 | 70 | 0 | 44 | 162 | 119 | 1 | Auxenochlorella protothecoides 60S ribosomal protein L15 partial mRNA | blastn | 8386 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 2570565 | 2570565 | PRJEB12237_P_NODE_2083_length_494_cov_7.385621_g1895_i0 | PRJEB12237 | 2083 | 494 | 7.385621 | 36.48496774 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 106 | 3.65e-18 | NTclustered | gi|2082260798|ref|XM_001697008.2| | 3055 | g1895 | i0 | 92 | 1.12348178137652 | 75 | 6 | 15 | 0 | 281 | 355 | 957 | 1031 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g520500v5), mRNA | blastn | 555 | 106 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 3846908 | 3846908 | PRJEB12237_P_NODE_5024_length_274_cov_2.025105_g4828_i0 | PRJEB12237 | 5024 | 274 | 2.025105 | 5.5487877 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 496 | 9.67e-136 | NTclustered | gi|1360638125|gb|AC277041.1| | 574566 | g4828 | i0 | 99.27 | 16.6532846715328 | 274 | 2 | 100 | 0 | 1 | 274 | 39822 | 39549 | Coccomyxa subellipsoidea C-169 clone FAHX05-A01, complete sequence | blastn | 4563 | 496 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 5123107 | 5123107 | PRJEB12237_P_NODE_9665_length_172_cov_1.781022_g9469_i0 | PRJEB12237 | 9665 | 172 | 1.781022 | 3.06335784 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 318 | 1.2899999999999999e-82 | NTclustered | gi|1360638129|gb|AC277064.1| | 574566 | g9469 | i0 | 100 | 99.5116279069767 | 172 | 0 | 100 | 0 | 1 | 172 | 2595 | 2766 | Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence | blastn | 17116 | 318 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 7363271 | 7363271 | PRJEB12237_P_NODE_1146_length_680_cov_4.031008_g987_i0 | PRJEB12237 | 1146 | 680 | 4.031008 | 27.4108544 | Eukaryota | 2759 | Plants | Plants | 324 | 1.3e-83 | NTclustered | gi|552825417|ref|XM_005846759.1| | 554065 | g987 | i0 | 81.818 | 29.7205882352941 | 385 | 70 | 57 | 0 | 132 | 516 | 13 | 397 | Chlorella variabilis 40S ribosomal protein S14 (CHLNCDRAFT_135401) mRNA, complete cds | blastn | 20210 | 327 | 0.990825688073395 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 7672893 | 7672893 | PRJEB12237_P_NODE_4407_length_303_cov_1.791045_g4211_i0 | PRJEB12237 | 4407 | 303 | 1.791045 | 5.42686635 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 134 | 9.8e-27 | NTclustered | gi|402244316|emb|FR686759.1| | 37502 | g4211 | i0 | 80.702 | 0.564356435643564 | 171 | 33 | 56 | 0 | 2 | 172 | 989 | 1159 | Polytomella sp. Pringsheim 198.80 mRNA for 40S ribosomal protein L3 (rpl3 gene) | blastn | 171 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 7672906 | 7672906 | PRJEB12237_P_NODE_6487_length_226_cov_1.675393_g6291_i0 | PRJEB12237 | 6487 | 226 | 1.675393 | 3.78638818 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 405 | 1.34e-108 | NTclustered | gi|1360638129|gb|AC277064.1| | 574566 | g6291 | i0 | 99.111 | 99.4159292035398 | 225 | 2 | 99 | 0 | 1 | 225 | 1715 | 1491 | Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence | blastn | 22468 | 405 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 8947654 | 8947654 | PRJEB12237_P_NODE_1768_length_541_cov_1.818182_g1585_i0 | PRJEB12237 | 1768 | 541 | 1.818182 | 9.83636462 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 307 | 1.03e-78 | NTclustered | gi|635557420|emb|FN984965.1| | 37502 | g1585 | i0 | 79.545 | 32.9611829944547 | 440 | 82 | 81 | 8 | 50 | 485 | 1019 | 1454 | Polytomella sp. Pringsheim 198.80 mRNA for S-Adenosyl homocysteine hydrolase (sah1 gene) | blastn | 17832 | 307 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 8947655 | 8947655 | PRJEB12237_P_NODE_2108_length_490_cov_3.015385_g1920_i0 | PRJEB12237 | 2108 | 490 | 3.015385 | 14.7753865 | Monoraphidium neglectum | 145388 | Plants | Plants | 231 | 5.719999999999999e-56 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g1920 | i0 | 80.192 | 31.7387755102041 | 313 | 58 | 63 | 4 | 109 | 419 | 365 | 55 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 15552 | 231 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 10223403 | 10223403 | PRJEB12237_P_NODE_10809_length_161_cov_1.166667_g10613_i0 | PRJEB12237 | 10809 | 161 | 1.166667 | 1.87833387 | Pedinomonas sp. M2079/1 | 1108796 | Plants | Plants | 165 | 1.65e-36 | NTclustered | gi|371782103|emb|HE610135.1| | 1108796 | g10613 | i0 | 85.897 | 4.47204968944099 | 156 | 20 | 96 | 2 | 1 | 155 | 4008 | 4162 | Pedinomonas sp. M2079/1 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M2079/1 | blastn | 720 | 165 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinomonadales | Pedinomonadaceae | Pedinomonas | Pedinomonas sp. M2079/1 | |
| 10223434 | 10223434 | PRJEB12237_P_NODE_2929_length_403_cov_2.880435_g2733_i0 | PRJEB12237 | 2929 | 403 | 2.880435 | 11.60815305 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 141 | 8.02e-29 | NTclustered | gi|2082244743|ref|XM_001698671.2| | 3055 | g2733 | i0 | 79.397 | 1.84863523573201 | 199 | 41 | 49 | 0 | 1 | 199 | 556 | 754 | Chlamydomonas reinhardtii ribosomal protein L23 (CHLRE_04g211800v5), mRNA | blastn | 745 | 141 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 12464755 | 12464755 | PRJEB12237_P_NODE_8350_length_189_cov_3.623377_g8154_i0 | PRJEB12237 | 8350 | 189 | 3.623377 | 6.84818253 | Coccomyxa | 41891 | Plants | Plants | 350 | 5.14e-92 | NTclustered | gi|2916178960|gb|PV156797.1| | 248742 | g8154 | i0 | 100 | 99.984126984127 | 189 | 0 | 100 | 0 | 1 | 189 | 862 | 674 | Coccomyxa subellipsoidea small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 18897 | 350 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 17563479 | 17563479 | PRJEB12237_P_NODE_9134_length_179_cov_1.111111_g8938_i0 | PRJEB12237 | 9134 | 179 | 1.111111 | 1.98888869 | Chlorophyta | 3041 | Plants | Plants | 158 | 3.12e-34 | NTclustered | gi|2082236323|ref|XM_001689445.2| | 3055 | g8938 | i0 | 85.897 | 14.4692737430168 | 156 | 13 | 87 | 6 | 13 | 168 | 656 | 802 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g019250v5), mRNA | blastn | 2590 | 159 | 0.993710691823899 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20112168 | 20112168 | PRJEB12237_P_NODE_3436_length_359_cov_1.413580_g3240_i0 | PRJEB12237 | 3436 | 359 | 1.41358 | 5.0747522 | Eukaryota | 2759 | Plants | Plants | 111 | 5.53e-20 | NTclustered | gi|760450068|ref|XM_011403801.1| | 3075 | g3240 | i0 | 90.476 | 24.1281337047354 | 84 | 8 | 23 | 0 | 276 | 359 | 404 | 321 | Auxenochlorella protothecoides Peptidyl-prolyl cis-trans isomerase CYP18-4 partial mRNA | blastn | 8662 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 22972688 | 22972688 | PRJEB12237_P_NODE_8059_length_194_cov_2.012579_g7863_i0 | PRJEB12237 | 8059 | 194 | 2.012579 | 3.90440326 | Monoraphidium neglectum | 145388 | Plants | Plants | 159 | 9.589999999999999e-35 | NTclustered | gi|926781159|ref|XM_014043600.1| | 145388 | g7863 | i0 | 86.806 | 24.5154639175258 | 144 | 17 | 74 | 2 | 3 | 145 | 2660 | 2802 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 4756 | 159 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum |
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);;