contig_metadata
11 rows where bioproject = "PRJEB11523" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2257746 | 2257746 | PRJEB11523_P_NODE_4482_length_224_cov_1.051429_g4404_i0 | PRJEB11523 | 4482 | 224 | 1.051429 | 2.35520096 | Coccomyxa | 41891 | Plants | Plants | 337 | 4.909999999999999e-88 | NTclustered | gi|1601875646|gb|MK694759.1| | 2315456 | g4404 | i0 | 93.75 | 100.133928571429 | 224 | 14 | 100 | 0 | 1 | 224 | 4299 | 4076 | Coccomyxa sp. Obi small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 22430 | 337 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 9910690 | 9910690 | PRJEB11523_P_NODE_4088_length_237_cov_1.627660_g4010_i0 | PRJEB11523 | 4088 | 237 | 1.62766 | 3.8575542 | Apatococcus lobatus | 904363 | Plants | Plants | 108 | 1.18e-25 | NR | KAK9817341.1 | 904363 | g4010 | i0 | 90.9 | 0.69620253164557 | 55 | 5 | 69.6 | 0 | 9 | 173 | 374 | 428 | KAK9817341.1 hypothetical protein WJX74_003121 [Apatococcus lobatus] | diamond | 165 | 108 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Apatococcus | Apatococcus lobatus | |
| 11491741 | 11491741 | PRJEB11523_P_NODE_6450_length_181_cov_2.840909_g6372_i0 | PRJEB11523 | 6450 | 181 | 2.840909 | 5.14204529 | Chlorogonium euchlorum | 52028 | Plants | Plants | 281 | 1.8e-71 | NTclustered | gi|2324954163|gb|OP597711.1| | 52028 | g6372 | i0 | 97.576 | 3.19337016574586 | 165 | 2 | 91 | 2 | 18 | 181 | 3675 | 3838 | Chlorogonium euchlorum chloroplast, partial genome | blastn | 578 | 281 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Chlorogonium | Chlorogonium euchlorum | |
| 15315964 | 15315964 | PRJEB11523_P_NODE_3153_length_281_cov_16.797414_g3075_i0 | PRJEB11523 | 3153 | 281 | 16.797414 | 47.20073334 | Pithophora roettleri | 926344 | Plants | Plants | 111 | 4.21e-20 | NTclustered | gi|1678088264|gb|MN017042.1| | 926344 | g3075 | i0 | 85.714 | 10.2491103202847 | 105 | 15 | 37 | 0 | 23 | 127 | 3922 | 4026 | Pithophora roettleri isolate Ogeechee small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 2880 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Pithophoraceae | Pithophora | Pithophora roettleri | |
| 15315994 | 15315994 | PRJEB11523_P_NODE_693_length_728_cov_1.988218_g629_i0 | PRJEB11523 | 693 | 728 | 1.988218 | 14.47422704 | Trebouxiales | 2507901 | Plants | Plants | 308 | 6.04e-104 | NR | KAK9814797.1 | 41462 | g629 | i0 | 84.9 | 5.65796703296703 | 172 | 26 | 70.9 | 0 | 26 | 541 | 1 | 172 | KAK9814797.1 hypothetical protein WJX72_011617 [[Myrmecia] bisecta] | diamond | 4119 | 310 | 0.993548387096774 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 19139233 | 19139233 | PRJEB11523_P_NODE_2116_length_371_cov_34.149068_g2038_i0 | PRJEB11523 | 2116 | 371 | 34.149068 | 126.69304228 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 569 | 7.88e-158 | NTclustered | gi|2917929623|emb|OZ234911.1| | 3350044 | g2038 | i0 | 100 | 0.830188679245283 | 308 | 0 | 83 | 0 | 41 | 348 | 1745611 | 1745918 | Trebouxia sp. SL0000003 genome assembly, chromosome: 6 | blastn | 308 | 569 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 24239651 | 24239651 | PRJEB11523_P_NODE_4140_length_235_cov_2.010753_g4062_i0 | PRJEB11523 | 4140 | 235 | 2.010753 | 4.72526955 | uncultured Apatococcus | 1229086 | Plants | Plants | 429 | 8.33e-116 | NTclustered | gi|1031961068|gb|KX025109.1| | 1229086 | g4062 | i0 | 99.574 | 99.9574468085106 | 235 | 1 | 100 | 0 | 1 | 235 | 1485 | 1251 | Uncultured Apatococcus clone GOGs_K08 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 23490 | 429 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Apatococcus | ||||
| 24239656 | 24239656 | PRJEB11523_P_NODE_4820_length_214_cov_14.521212_g4742_i0 | PRJEB11523 | 4820 | 214 | 14.521212 | 31.07539368 | Hazenia capsulata | 2202518 | Plants | Plants | 213 | 8.17e-51 | NTclustered | gi|17028245|gb|L42837.1|CMKCPRGOL | 2202518 | g4742 | i0 | 92.568 | 129.981308411215 | 148 | 11 | 69 | 0 | 24 | 171 | 1337 | 1484 | Hazenia capsulata large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 27816 | 213 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Hazeniaceae | Hazenia | Hazenia capsulata | |
| 25208594 | 25208594 | PRJEB11523_P_NODE_8340_length_162_cov_4.530973_g8262_i0 | PRJEB11523 | 8340 | 162 | 4.530973 | 7.34017626 | Selenastraceae | 35466 | Plants | Plants | 272 | 9.51e-69 | NTclustered | gi|523583551|gb|KC145448.1| | 52960 | g8262 | i0 | 98.693 | 94.6172839506173 | 153 | 2 | 94 | 0 | 10 | 162 | 138 | 290 | Ankistrodesmus falcatus strain UTEX 101 28S ribosomal RNA gene, partial sequence | blastn | 15328 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Ankistrodesmus | Ankistrodesmus falcatus | |
| 27759654 | 27759654 | PRJEB11523_P_NODE_5484_length_198_cov_13.704698_g5406_i0 | PRJEB11523 | 5484 | 198 | 13.704698 | 27.13530204 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 84 | 6.03e-17 | NR | GAX79711.1 | 1157962 | g5406 | i0 | 62.3 | 0.803030303030303 | 53 | 20 | 80.3 | 0 | 14 | 172 | 516 | 568 | GAX79711.1 hypothetical protein CEUSTIGMA_g7152.t1 [Chlamydomonas eustigma] | diamond | 159 | 84 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 32656237 | 32656237 | PRJEB11523_P_NODE_800_length_672_cov_30.089888_g731_i0 | PRJEB11523 | 800 | 672 | 30.089888 | 202.20404736 | Trebouxia sp. C | 2796353 | Plants | Plants | 61.6 | 4.68e-7 | NR | KAL0020025.1 | 2905653 | g731 | i0 | 45.9 | 0.486607142857143 | 109 | 51 | 46 | 2 | 624 | 316 | 389 | 495 | KAL0020025.1 hypothetical protein WJX77_004769 [Trebouxia sp. C0004] | diamond | 327 | 61.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 |
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);;