contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA492406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4927320 | 4927320 | PRJNA492406_P_NODE_14904_length_324_cov_3.633466_g14605_i0 | PRJNA492406 | 14904 | 324 | 3.633466 | 11.77242984 | Eukaryota | 2759 | Plants | Plants | 577 | 4.0599999999999986e-160 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g14605 | i0 | 98.765 | 93.9938271604938 | 324 | 4 | 100 | 0 | 1 | 324 | 406 | 83 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 30454 | 582 | 0.991408934707904 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 6830141 | 6830141 | PRJNA492406_P_NODE_26906_length_250_cov_2.005650_g26607_i0 | PRJNA492406 | 26906 | 250 | 2.00565 | 5.014125 | Chlamydomonas moewusii | 3054 | Plants | Plants | 93.5 | 1.33e-14 | NTclustered | gi|397103|emb|X68913.1| | 3054 | g26607 | i0 | 75 | 2.772 | 224 | 44 | 88 | 10 | 29 | 248 | 927 | 712 | Chloroplast C.moewusii rrnL gene, exon 1 | blastn | 693 | 93.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas moewusii | |
| 9380096 | 9380096 | PRJNA492406_P_NODE_11548_length_365_cov_2.818493_g11249_i0 | PRJNA492406 | 11548 | 365 | 2.818493 | 10.28749945 | Trebouxia sp. Jameos_1 | 2007186 | Plants | Plants | 464 | 3.75e-126 | NTclustered | gi|1201080600|gb|MF192885.1| | 2007186 | g11249 | i0 | 99.222 | 90.7753424657534 | 257 | 2 | 70 | 0 | 109 | 365 | 803 | 547 | Trebouxia sp. Jameos_1 isolate ppJameos_1 large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 33133 | 464 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. Jameos_1 | |
| 10656362 | 10656362 | PRJNA492406_P_NODE_30089_length_244_cov_2.438596_g29790_i0 | PRJNA492406 | 30089 | 244 | 2.438596 | 5.95017424 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 91.6 | 4.66e-14 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g29790 | i0 | 88.312 | 2.38114754098361 | 77 | 8 | 31 | 1 | 137 | 212 | 86129 | 86205 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 581 | 91.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 11302497 | 11302497 | PRJNA492406_P_NODE_7049_length_455_cov_1.910995_g6750_i0 | PRJNA492406 | 7049 | 455 | 1.910995 | 8.69502725 | Trebouxia | 13786 | Plants | Plants | 736 | 0 | NTclustered | gi|162134340|gb|EU123979.1| | 160068 | g6750 | i0 | 95.824 | 125.621978021978 | 455 | 19 | 100 | 0 | 1 | 455 | 2051 | 2505 | Trebouxia aggregata strain SAG 219-1d large subunit ribosomal RNA (rrl) gene, complete sequence; and putative site-specific DNA endonuclease (orf210) and hypothetical protein (orf277) genes, complete cds; chloroplast | blastn | 57158 | 736 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 13206029 | 13206029 | PRJNA492406_P_NODE_14031_length_334_cov_3.601533_g13732_i0 | PRJNA492406 | 14031 | 334 | 3.601533 | 12.02912022 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 422 | 2.08e-113 | NTclustered | gi|167449|gb|M11448.1|CRETBA2A | 3055 | g13732 | i0 | 89.489 | 98.7994011976048 | 333 | 35 | 99 | 0 | 1 | 333 | 972 | 1304 | Chlamydomonas reinhardtii alpha-2 tubulin gene, complete cds | blastn | 32999 | 422 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 13852764 | 13852764 | PRJNA492406_P_NODE_10191_length_386_cov_1.476038_g9892_i0 | PRJNA492406 | 10191 | 386 | 1.476038 | 5.69750668 | Marvania | 97104 | Plants | Plants | 137 | 9.889999999999999e-28 | NTclustered | gi|2724824493|gb|PP746561.1| | 97105 | g9892 | i0 | 79.512 | 8.48186528497409 | 205 | 33 | 52 | 8 | 65 | 266 | 1484 | 1286 | Marvania geminata culture SAG:12.88 mitochondrion, complete genome | blastn | 3274 | 137 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Marvania | Marvania geminata | |
| 17029483 | 17029483 | PRJNA492406_P_NODE_11194_length_370_cov_3.683502_g10895_i0 | PRJNA492406 | 11194 | 370 | 3.683502 | 13.628957400000001 | Colemanosphaera angeleri | 1454018 | Plants | Plants | 148 | 4.36e-31 | NTclustered | gi|1861679643|gb|MN431475.1| | 1454018 | g10895 | i0 | 80.5 | 30.8432432432432 | 200 | 33 | 53 | 6 | 134 | 329 | 14771 | 14968 | Colemanosphaera angeleri strain FACHB-2363 mitochondrion, complete genome | blastn | 11412 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Colemanosphaera | Colemanosphaera angeleri | |
| 17029536 | 17029536 | PRJNA492406_P_NODE_13374_length_342_cov_7.985130_g13075_i0 | PRJNA492406 | 13374 | 342 | 7.98513 | 27.3091446 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 130 | 1.45e-25 | NTclustered | gi|760445578|ref|XM_011401556.1| | 3075 | g13075 | i0 | 88.679 | 2.41812865497076 | 106 | 12 | 31 | 0 | 185 | 290 | 105 | 210 | Auxenochlorella protothecoides 40S ribosomal protein S11 partial mRNA | blastn | 827 | 130 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 17029966 | 17029966 | PRJNA492406_P_NODE_31914_length_241_cov_0.916667_g31615_i0 | PRJNA492406 | 31914 | 241 | 0.916667 | 2.20916747 | Trebouxia lynnae | 1825957 | Plants | Plants | 385 | 1.88e-102 | NTclustered | gi|1812100161|ref|NC_045839.1| | 1825957 | g31615 | i0 | 95.436 | 84.3651452282158 | 241 | 11 | 100 | 0 | 1 | 241 | 179606 | 179366 | Trebouxia sp. TR9 chloroplast, partial genome | blastn | 20332 | 385 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 18304190 | 18304190 | PRJNA492406_P_NODE_26335_length_251_cov_2.438202_g26036_i0 | PRJNA492406 | 26335 | 251 | 2.438202 | 6.11988702 | Auxenochlorella pyrenoidosa | 3078 | Plants | Plants | 435 | 1.93e-117 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g26036 | i0 | 98.008 | 95.0796812749004 | 251 | 4 | 100 | 1 | 1 | 251 | 1446 | 1695 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 23865 | 435 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 19578196 | 19578196 | PRJNA492406_P_NODE_17016_length_303_cov_1.695652_g16717_i0 | PRJNA492406 | 17016 | 303 | 1.695652 | 5.13782556 | uncultured Trebouxia photobiont | 285713 | Plants | Plants | 87.9 | 7.74e-13 | NTclustered | gi|356700925|gb|JN847668.1| | 285713 | g16717 | i0 | 87.342 | 21.5544554455446 | 79 | 6 | 25 | 4 | 1 | 77 | 246 | 170 | Uncultured Trebouxia photobiont clone 530R.K5-1-2 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 6531 | 87.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 19578406 | 19578406 | PRJNA492406_P_NODE_26096_length_253_cov_1.311111_g25797_i0 | PRJNA492406 | 26096 | 253 | 1.311111 | 3.31711083 | Prototheca ciferrii | 1973153 | Plants | Plants | 148 | 2.8499999999999995e-31 | NTclustered | gi|1381389463|ref|NC_037449.1| | 1973153 | g25797 | i0 | 88.525 | 38.695652173913 | 122 | 14 | 48 | 0 | 63 | 184 | 25221 | 25342 | Prototheca zopfii strain SAG 2063 mitochondrion, complete genome | blastn | 9790 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca ciferrii | |
| 21501230 | 21501230 | PRJNA492406_P_NODE_9377_length_400_cov_10.143731_g9078_i0 | PRJNA492406 | 9377 | 400 | 10.143731 | 40.574924 | Eukaryota | 2759 | Plants | Plants | 706 | 0 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g9078 | i0 | 98.5 | 98.98 | 400 | 6 | 100 | 0 | 1 | 400 | 578 | 977 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 39592 | 712 | 0.991573033707865 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 23404946 | 23404946 | PRJNA492406_P_NODE_31079_length_243_cov_0.905882_g30780_i0 | PRJNA492406 | 31079 | 243 | 0.905882 | 2.20129326 | Monoraphidium neglectum | 145388 | Plants | Plants | 193 | 1.24e-44 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g30780 | i0 | 83.178 | 25.6543209876543 | 214 | 32 | 87 | 3 | 24 | 235 | 70 | 281 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 6234 | 193 | 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);;