contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJEB10320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13592 | 13592 | PRJEB10320_P_NODE_9621_length_317_cov_5.939716_g9363_i0 | PRJEB10320 | 9621 | 317 | 5.939716 | 18.82889972 | Stichococcus bacillaris | 37433 | Plants | Plants | 311 | 4.44e-80 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g9363 | i0 | 96.774 | 12.8422712933754 | 186 | 6 | 59 | 0 | 132 | 317 | 7182 | 6997 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 4071 | 311 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 982428 | 982428 | PRJEB10320_P_NODE_21561_length_182_cov_4.897959_g21303_i0 | PRJEB10320 | 21561 | 182 | 4.897959 | 8.91428538 | Trebouxiophyceae | 75966 | Plants | Plants | 267 | 5.08e-67 | NTclustered | gi|2088219092|gb|MZ969861.1| | 29647 | g21303 | i0 | 100 | 100 | 144 | 0 | 100 | 0 | 1 | 144 | 302 | 445 | Stichococcus sp. isolate HP-41P 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 | 18200 | 267 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus sp. | |
| 2563371 | 2563371 | PRJEB10320_P_NODE_10643_length_297_cov_6.458015_g10385_i0 | PRJEB10320 | 10643 | 297 | 6.458015 | 19.18030455 | uncultured Diplosphaera | 1266964 | Plants | Plants | 544 | 3.7299999999999996e-150 | NTclustered | gi|2515376756|gb|OR101613.1| | 1266964 | g10385 | i0 | 99.663 | 99.8686868686869 | 297 | 1 | 100 | 0 | 1 | 297 | 875 | 579 | Uncultured Diplosphaera clone mgcl54_AS20 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 29661 | 544 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetophorales | Chaetophoraceae | uncultured Diplosphaera | ||
| 2563389 | 2563389 | PRJEB10320_P_NODE_15483_length_230_cov_2.092308_g15225_i0 | PRJEB10320 | 15483 | 230 | 2.092308 | 4.8123084 | Nannochloris normandinae | 926285 | Plants | Plants | 425 | 1.05e-114 | NTclustered | gi|922575245|gb|JQ921007.1| | 926285 | g15225 | i0 | 100 | 124.030434782609 | 230 | 0 | 100 | 0 | 1 | 230 | 1135 | 906 | Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 28527 | 425 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris normandinae | |
| 5115921 | 5115921 | PRJEB10320_P_NODE_22525_length_177_cov_1.119718_g22267_i0 | PRJEB10320 | 22525 | 177 | 1.119718 | 1.98190086 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 115 | 1.88e-21 | NTclustered | gi|2082260551|ref|XM_001702928.2| | 3055 | g22267 | i0 | 87.129 | 15.2429378531073 | 101 | 13 | 57 | 0 | 1 | 101 | 244 | 144 | Chlamydomonas reinhardtii ribosomal protein S11 (CHLRE_12g514500v5), mRNA | blastn | 2698 | 115 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 7665793 | 7665793 | PRJEB10320_P_NODE_27487_length_154_cov_1.008403_g27229_i0 | PRJEB10320 | 27487 | 154 | 1.008403 | 1.55294062 | uncultured Symbiochloris | 2562465 | Plants | Plants | 213 | 5.48e-51 | NTclustered | gi|2509725906|gb|OR042192.1| | 2562465 | g27229 | i0 | 91.613 | 15.1038961038961 | 155 | 11 | 100 | 2 | 1 | 154 | 1055 | 1208 | Uncultured Symbiochloris clone BW01 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 | 2326 | 213 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Symbiochloris | ||||
| 8635554 | 8635554 | PRJEB10320_P_NODE_10887_length_293_cov_3.321705_g10629_i0 | PRJEB10320 | 10887 | 293 | 3.321705 | 9.73259565 | Chlorophyta | 3041 | Plants | Plants | 542 | 1.32e-149 | NTclustered | gi|1523765370|gb|MK231279.1| | 29647 | g10629 | i0 | 100 | 100.01023890785 | 293 | 0 | 100 | 0 | 1 | 293 | 591 | 883 | Stichococcus sp. strain KZ-5-1-1 small subunit ribosomal RNA gene, partial sequence | blastn | 29303 | 542 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus sp. | |
| 13735930 | 13735930 | PRJEB10320_P_NODE_22211_length_178_cov_4.090909_g21953_i0 | PRJEB10320 | 22211 | 178 | 4.090909 | 7.28181802 | Trebouxiophyceae | 75966 | Plants | Plants | 291 | 2.93e-74 | NTclustered | gi|1799637080|gb|MN968346.1| | 29647 | g21953 | i0 | 96.067 | 100 | 178 | 7 | 100 | 0 | 1 | 178 | 1577 | 1400 | Stichococcus sp. strain USMFM_Antarctica 2 small subunit ribosomal RNA gene, partial sequence | blastn | 17800 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus sp. | |
| 15010295 | 15010295 | PRJEB10320_P_NODE_10072_length_308_cov_4.831502_g9814_i0 | PRJEB10320 | 10072 | 308 | 4.831502 | 14.88102616 | Trebouxiophyceae | 75966 | Plants | Plants | 342 | 1.5199999999999999e-89 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g9814 | i0 | 86.688 | 95.8051948051948 | 308 | 41 | 100 | 0 | 1 | 308 | 3513 | 3206 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 29508 | 342 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 15315779 | 15315779 | PRJEB10320_P_NODE_26653_length_157_cov_1.295082_g26395_i0 | PRJEB10320 | 26653 | 157 | 1.295082 | 2.03327874 | Chlamydomonas incerta | 51695 | Plants | Plants | 171 | 3.43e-38 | NTclustered | gi|74272606|gb|DQ122868.1| | 51695 | g26395 | i0 | 86.452 | 42.2802547770701 | 155 | 21 | 99 | 0 | 1 | 155 | 215 | 61 | Chlamydomonas incerta 40S ribosomal protein S3 mRNA, complete cds | blastn | 6638 | 171 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 16285052 | 16285052 | PRJEB10320_P_NODE_10693_length_296_cov_7.747126_g10435_i0 | PRJEB10320 | 10693 | 296 | 7.747126 | 22.93149296 | Chlorophyta | 3041 | Plants | Plants | 503 | 6.309999999999998e-138 | NTclustered | gi|1799637008|gb|MN968057.1| | 29647 | g10435 | i0 | 97.306 | 100.375 | 297 | 7 | 100 | 1 | 1 | 296 | 12 | 308 | Stichococcus sp. strain USMFM_Antarctica 1 small subunit ribosomal RNA gene, partial sequence | blastn | 29711 | 508 | 0.990157480314961 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus sp. | |
| 19139056 | 19139056 | PRJEB10320_P_NODE_27016_length_155_cov_2.650000_g26758_i0 | PRJEB10320 | 27016 | 155 | 2.65 | 4.1075 | Trochiscia hystrix | 132247 | Plants | Plants | 161 | 2.03e-35 | NTclustered | gi|9438174|gb|AF277658.1| | 132247 | g26758 | i0 | 86.184 | 85.258064516129 | 152 | 17 | 96 | 4 | 1 | 149 | 1775 | 1625 | Trochiscia hystrix strain UTEX LB 606 28S ribosomal RNA gene, partial sequence | blastn | 13215 | 161 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Trochiscia | Trochiscia hystrix | |||
| 20414127 | 20414127 | PRJEB10320_P_NODE_15017_length_235_cov_2.285000_g14759_i0 | PRJEB10320 | 15017 | 235 | 2.285 | 5.36975 | Monoraphidium neglectum | 145388 | Plants | Plants | 104 | 5.73e-18 | NTclustered | gi|926764667|ref|XM_014035932.1| | 145388 | g14759 | i0 | 79.355 | 5.44255319148936 | 155 | 26 | 65 | 6 | 1 | 152 | 251 | 402 | Monoraphidium neglectum 40S ribosomal protein S27a mRNA | blastn | 1279 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 21690135 | 21690135 | PRJEB10320_P_NODE_12558_length_266_cov_3.926407_g12300_i0 | PRJEB10320 | 12558 | 266 | 3.926407 | 10.44424262 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 311 | 3.63e-80 | NTclustered | gi|2082258180|ref|XM_043067316.1| | 3055 | g12300 | i0 | 87.97 | 277.447368421053 | 266 | 29 | 100 | 1 | 1 | 266 | 1621 | 1883 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_11g467567v5), mRNA | blastn | 73801 | 311 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22965410 | 22965410 | PRJEB10320_P_NODE_23739_length_170_cov_1.474074_g23481_i0 | PRJEB10320 | 23739 | 170 | 1.474074 | 2.5059258 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 126 | 8.26e-25 | NTclustered | gi|760448344|ref|XM_011402939.1| | 3075 | g23481 | i0 | 85.714 | 47.9647058823529 | 119 | 17 | 70 | 0 | 37 | 155 | 119 | 1 | Auxenochlorella protothecoides 60S ribosomal protein L15 partial mRNA | blastn | 8154 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides |
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);;