contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA493828" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 474975 | 474975 | PRJNA493828_P_NODE_44121_length_226_cov_2.830065_g43702_i0 | PRJNA493828 | 44121 | 226 | 2.830065 | 6.3959469 | Chlorosarcinopsis eremi | 332213 | Plants | Plants | 416 | 6.189999999999998e-112 | NTclustered | gi|1642525901|ref|NC_042250.1| | 332213 | g43702 | i0 | 100 | 134.561946902655 | 225 | 0 | 99 | 0 | 1 | 225 | 131358 | 131134 | Chlorosarcinopsis eremi culture UTEX:1186 chloroplast, complete genome | blastn | 30411 | 416 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis eremi | |
| 1106655 | 1106655 | PRJNA493828_P_NODE_7601_length_406_cov_12.834835_g7186_i0 | PRJNA493828 | 7601 | 406 | 12.834835 | 52.1094301 | Eukaryota | 2759 | Plants | Plants | 747 | 0 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g7186 | i0 | 100 | 100.036945812808 | 404 | 0 | 99 | 0 | 3 | 406 | 50 | 453 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 40615 | 747 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 3657588 | 3657588 | PRJNA493828_P_NODE_19683_length_288_cov_14.055814_g19264_i0 | PRJNA493828 | 19683 | 288 | 14.055814 | 40.48074432 | Eukaryota | 2759 | Plants | Plants | 527 | 3.63e-145 | NTclustered | gi|1201359270|gb|MF040792.1| | 3078 | g19264 | i0 | 99.653 | 100 | 288 | 1 | 100 | 0 | 1 | 288 | 79 | 366 | Auxenochlorella pyrenoidosa isolate HIT9 18S ribosomal RNA gene, partial sequence | blastn | 28800 | 532 | 0.990601503759398 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 4301809 | 4301809 | PRJNA493828_P_NODE_44624_length_222_cov_5.557047_g44205_i0 | PRJNA493828 | 44624 | 222 | 5.557047 | 12.33664434 | Chlamydomonas noctigama | 28456 | Plants | Plants | 329 | 8.12e-86 | NTclustered | gi|17028277|gb|L43353.1|CRECPRRNLD | 28456 | g44205 | i0 | 93.665 | 129.662162162162 | 221 | 12 | 99 | 1 | 1 | 221 | 1691 | 1473 | Chlamydomonas geitleri chloroplast large subunit ribosomal RNA (rrnL) gene | blastn | 28785 | 329 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas noctigama | |
| 5578544 | 5578544 | PRJNA493828_P_NODE_48265_length_198_cov_5.568000_g47846_i0 | PRJNA493828 | 48265 | 198 | 5.568 | 11.02464 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 191 | 3.49e-44 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g47846 | i0 | 93.701 | 29.7323232323232 | 127 | 8 | 64 | 0 | 4 | 130 | 3793 | 3667 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 5887 | 191 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 6210011 | 6210011 | PRJNA493828_P_NODE_34885_length_247_cov_1.545977_g34466_i0 | PRJNA493828 | 34885 | 247 | 1.545977 | 3.81856319 | Trebouxiophyceae | 75966 | Plants | Plants | 305 | 1.55e-78 | NTclustered | gi|725650801|ref|NC_025532.1| | 3102 | g34466 | i0 | 90.476 | 526.676113360324 | 231 | 22 | 94 | 0 | 15 | 245 | 122091 | 121861 | Ettlia pseudoalveolaris culture-collection UTEX:975 chloroplast, complete genome | blastn | 130089 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Parietochloris | Parietochloris pseudoalveolaris | |
| 6210219 | 6210219 | PRJNA493828_P_NODE_9685_length_365_cov_10.565068_g9267_i0 | PRJNA493828 | 9685 | 365 | 10.565068 | 38.5624982 | Eukaryota | 2759 | Plants | Plants | 647 | 0 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g9267 | i0 | 98.634 | 91.6602739726027 | 366 | 3 | 100 | 2 | 1 | 365 | 1083 | 719 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 33456 | 652 | 0.992331288343558 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 11309907 | 11309907 | PRJNA493828_P_NODE_7069_length_420_cov_1.443804_g6658_i0 | PRJNA493828 | 7069 | 420 | 1.443804 | 6.0639768 | Trebouxiophyceae | 75966 | Plants | Plants | 63.9 | 1.87e-5 | NTclustered | gi|371782132|emb|HE610164.1| | 33092 | g6658 | i0 | 95 | 15.5452380952381 | 40 | 2 | 10 | 0 | 16 | 55 | 76 | 37 | Koliella longiseta plastid partial 23S rRNA gene, strain SAG 470-1 | blastn | 6529 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 20232973 | 20232973 | PRJNA493828_P_NODE_30976_length_253_cov_3.055556_g30557_i0 | PRJNA493828 | 30976 | 253 | 3.055556 | 7.73055668 | Chlamydomonadales | 3042 | Plants | Plants | 324 | 4.41e-84 | NTclustered | gi|66864302|gb|DQ015757.1| | 158507 | g30557 | i0 | 89.804 | 74.1660079051383 | 255 | 22 | 100 | 4 | 1 | 253 | 3204 | 2952 | Oogamochlamys gigantea strain SAG 44.91 26S ribosomal RNA gene, partial sequence | blastn | 18764 | 324 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Oogamochlamys | Oogamochlamys gigantea | |
| 20876574 | 20876574 | PRJNA493828_P_NODE_37397_length_244_cov_0.900585_g36978_i0 | PRJNA493828 | 37397 | 244 | 0.900585 | 2.1974274 | Chlorella variabilis | 554065 | Plants | Plants | 174 | 4.5e-39 | NTclustered | gi|552825898|ref|XM_005846851.1| | 554065 | g36978 | i0 | 85.714 | 16.0450819672131 | 168 | 20 | 68 | 4 | 1 | 166 | 1266 | 1431 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_31463) mRNA, complete cds | blastn | 3915 | 174 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 22151544 | 22151544 | PRJNA493828_P_NODE_47818_length_200_cov_7.007874_g47399_i0 | PRJNA493828 | 47818 | 200 | 7.007874 | 14.015748 | Haematococcus lacustris | 44745 | Plants | Plants | 220 | 4.5e-53 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g47399 | i0 | 86.567 | 139.665 | 201 | 25 | 99 | 2 | 1 | 199 | 3475 | 3675 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 27933 | 220 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris |
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);;