contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA438572" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1091108 | 1091108 | PRJNA438572_P_NODE_8521_length_349_cov_1.307971_g8402_i0 | PRJNA438572 | 8521 | 349 | 1.307971 | 4.56481879 | Desmochloris | 138596 | Plants | Plants | 628 | 1.1999999999999999e-175 | NTclustered | gi|313476263|emb|FM882216.1| | 138176 | g8402 | i0 | 99.14 | 100.002865329513 | 349 | 3 | 100 | 0 | 1 | 349 | 954 | 606 | Desmochloris halophila partial 18S rRNA gene, ITS1, 5.8S rRNA and ITS2, strain CCAP 6006/1 | blastn | 34901 | 634 | 0.990536277602524 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 2985540 | 2985540 | PRJNA438572_P_NODE_11623_length_302_cov_0.847162_g11504_i0 | PRJNA438572 | 11623 | 302 | 0.847162 | 2.55842924 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 254 | 7.18e-63 | NTclustered | gi|760446452|ref|XM_011401993.1| | 3075 | g11504 | i0 | 84.436 | 82.3741721854305 | 257 | 40 | 85 | 0 | 46 | 302 | 533 | 277 | Auxenochlorella protothecoides Isocitrate dehydrogenase [NADP], chloroplastic partial mRNA | blastn | 24877 | 254 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 2985718 | 2985718 | PRJNA438572_P_NODE_22623_length_244_cov_1.649123_g22504_i0 | PRJNA438572 | 22623 | 244 | 1.649123 | 4.02386012 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 259 | 1.21e-64 | NTclustered | gi|1360638125|gb|AC277041.1| | 574566 | g22504 | i0 | 86.864 | 64.8155737704918 | 236 | 25 | 95 | 4 | 13 | 244 | 39814 | 39581 | Coccomyxa subellipsoidea C-169 clone FAHX05-A01, complete sequence | blastn | 15815 | 259 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 8088293 | 8088293 | PRJNA438572_P_NODE_2927_length_573_cov_1.780000_g2810_i0 | PRJNA438572 | 2927 | 573 | 1.78 | 10.1994 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 593 | 7.489999999999998e-165 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g2810 | i0 | 86.067 | 91.8219895287958 | 567 | 62 | 98 | 10 | 9 | 572 | 3993 | 4545 | Chloroidium ellipsoideum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 52614 | 593 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 10639078 | 10639078 | PRJNA438572_P_NODE_7149_length_377_cov_2.335526_g7030_i0 | PRJNA438572 | 7149 | 377 | 2.335526 | 8.80493302 | uncultured Scenedesmus | 223195 | Plants | Plants | 693 | 0 | NTclustered | gi|430000717|gb|JX877643.1| | 223195 | g7030 | i0 | 100 | 95.5915119363395 | 375 | 0 | 99 | 0 | 3 | 377 | 380 | 6 | Uncultured Scenedesmus clone HP04 23S ribosomal RNA gene, partial sequence | blastn | 36038 | 693 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | uncultured Scenedesmus | ||
| 11294258 | 11294258 | PRJNA438572_P_NODE_9749_length_328_cov_1.015686_g9630_i0 | PRJNA438572 | 9749 | 328 | 1.015686 | 3.33145008 | Apatococcus | 904362 | Plants | Plants | 601 | 2.4399999999999998e-167 | NTclustered | gi|1561005742|gb|MG493358.1| | 167235 | g9630 | i0 | 99.695 | 100.198170731707 | 328 | 1 | 100 | 0 | 1 | 328 | 619 | 946 | Uncultured Trebouxiophyceae clone LSY2041 18S ribosomal RNA gene, partial sequence | blastn | 32865 | 606 | 0.991749174917492 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Trebouxiophyceae | ||||
| 17012543 | 17012543 | PRJNA438572_P_NODE_8594_length_347_cov_2.470803_g8475_i0 | PRJNA438572 | 8594 | 347 | 2.470803 | 8.57368641 | Monoraphidium neglectum | 145388 | Plants | Plants | 132 | 4.1e-26 | NTclustered | gi|926770371|ref|XM_014038206.1| | 145388 | g8475 | i0 | 77.056 | 19.6512968299712 | 231 | 51 | 66 | 2 | 118 | 347 | 46 | 275 | Monoraphidium neglectum solute carrier family 25 partial mRNA | blastn | 6819 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 19560897 | 19560897 | PRJNA438572_P_NODE_16916_length_253_cov_0.866667_g16797_i0 | PRJNA438572 | 16916 | 253 | 0.866667 | 2.19266751 | Monoraphidium neglectum | 145388 | Plants | Plants | 202 | 2.15e-47 | NTclustered | gi|926773481|ref|XM_014039761.1| | 145388 | g16797 | i0 | 82.533 | 7.39130434782609 | 229 | 40 | 91 | 0 | 25 | 253 | 1047 | 819 | Monoraphidium neglectum glycine hydroxymethyltransferase partial mRNA | blastn | 1870 | 202 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 19560960 | 19560960 | PRJNA438572_P_NODE_21476_length_246_cov_0.901734_g21357_i0 | PRJNA438572 | 21476 | 246 | 0.901734 | 2.21826564 | Desmochloris halophila | 138176 | Plants | Plants | 388 | 1.49e-103 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g21357 | i0 | 95.142 | 72.7560975609756 | 247 | 11 | 100 | 1 | 1 | 246 | 3708 | 3954 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 17898 | 388 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 19561087 | 19561087 | PRJNA438572_P_NODE_6316_length_399_cov_1.674847_g6197_i0 | PRJNA438572 | 6316 | 399 | 1.674847 | 6.68263953 | Koliella corcontica | 155904 | Plants | Plants | 562 | 1.43e-155 | NTclustered | gi|723456950|ref|NC_025536.1| | 155904 | g6197 | i0 | 92.802 | 126 | 389 | 26 | 99 | 2 | 3 | 390 | 82764 | 83151 | Koliella corcontica culture-collection SAG:24.84 chloroplast, complete genome | blastn | 50274 | 562 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella corcontica | |
| 22111662 | 22111662 | PRJNA438572_P_NODE_21138_length_247_cov_0.896552_g21019_i0 | PRJNA438572 | 21138 | 247 | 0.896552 | 2.21448344 | Ulva intestinalis | 3116 | Plants | Plants | 265 | 2.63e-66 | NTclustered | gi|2127885487|ref|NC_058886.1| | 3116 | g21019 | i0 | 86.992 | 42.6315789473684 | 246 | 19 | 97 | 9 | 9 | 247 | 30317 | 30556 | Ulva intestinalis isolate CNS000531 mitochondrion, complete genome | blastn | 10530 | 265 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva intestinalis | |
| 22111673 | 22111673 | PRJNA438572_P_NODE_21898_length_245_cov_1.918605_g21779_i0 | PRJNA438572 | 21898 | 245 | 1.918605 | 4.70058225 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 307 | 4.2700000000000006e-79 | NTclustered | gi|1360638125|gb|AC277041.1| | 574566 | g21779 | i0 | 91.518 | 16.2775510204082 | 224 | 17 | 91 | 2 | 1 | 223 | 39547 | 39769 | Coccomyxa subellipsoidea C-169 clone FAHX05-A01, complete sequence | blastn | 3988 | 307 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea |
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);;