contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA397065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 411922 | 411922 | PRJNA397065_S_NODE_11761_length_227_cov_140.500000_g11511_i0 | PRJNA397065 | 11761 | 227 | 140.5 | 318.935 | Koliella longiseta | 33092 | Plants | Plants | 303 | 5.06e-78 | NTclustered | gi|371782094|emb|HE610126.1| | 33092 | g11511 | i0 | 90.789 | 101.709251101322 | 228 | 19 | 100 | 2 | 1 | 227 | 5445 | 5219 | Koliella longiseta 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 470-1 | blastn | 23088 | 303 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 411964 | 411964 | PRJNA397065_S_NODE_16161_length_176_cov_24.190476_g15911_i0 | PRJNA397065 | 16161 | 176 | 24.190476 | 42.57523776 | Picochlorum sp. | 2812594 | Plants | Plants | 289 | 1.04e-73 | NTclustered | gi|2632235342|gb|OR922724.1| | 2812594 | g15911 | i0 | 97.076 | 97.4715909090909 | 171 | 5 | 97 | 0 | 1 | 171 | 3463 | 3293 | Picochlorum sp. strain AGSB0210 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 | 17155 | 289 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. | |||
| 412041 | 412041 | PRJNA397065_S_NODE_4241_length_507_cov_11.476987_g4000_i0 | PRJNA397065 | 4241 | 507 | 11.476987 | 58.18832409 | Pseudochlorella signiensis | 173497 | Plants | Plants | 763 | 0 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g4000 | i0 | 93.75 | 172.560157790927 | 512 | 27 | 100 | 3 | 1 | 507 | 151334 | 150823 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 87488 | 763 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 2355256 | 2355256 | PRJNA397065_S_NODE_8702_length_288_cov_16.436293_g8452_i0 | PRJNA397065 | 8702 | 288 | 16.436293 | 47.33652384 | Chlorophyta | 3041 | Plants | Plants | 329 | 1.1e-85 | NTclustered | gi|371782092|emb|HE610124.1| | 55999 | g8452 | i0 | 87.415 | 103.090277777778 | 294 | 27 | 100 | 8 | 1 | 288 | 2449 | 2738 | Stigeoclonium helveticum 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 477-2 | blastn | 29690 | 329 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetophorales | Chaetophoraceae | Stigeoclonium | Stigeoclonium helveticum | |
| 6182404 | 6182404 | PRJNA397065_S_NODE_13825_length_199_cov_13250.564706_g13575_i0 | PRJNA397065 | 13825 | 199 | 13250.564706 | 26368.62376494 | Sphaeropleales | 35491 | Plants | Plants | 250 | 5.71e-62 | NTclustered | gi|2727922309|gb|PP766946.1| | 81818 | g13575 | i0 | 98.582 | 70.8542713567839 | 141 | 2 | 71 | 0 | 59 | 199 | 3176 | 3036 | Monoraphidium dybowskii strain Ga012 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 | 14100 | 250 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium dybowskii | |
| 8065328 | 8065328 | PRJNA397065_S_NODE_15727_length_180_cov_8.682119_g15477_i0 | PRJNA397065 | 15727 | 180 | 8.682119 | 15.6278142 | Hormotilopsis gelatinosa | 56008 | Plants | Plants | 287 | 3.85e-73 | NTclustered | gi|586587046|gb|KC817003.1| | 56008 | g15477 | i0 | 95.58 | 100.683333333333 | 181 | 5 | 100 | 3 | 1 | 180 | 1770 | 1592 | Hormotilopsis gelatinosa strain UTEX B104 28S ribosomal RNA gene, partial sequence | blastn | 18123 | 287 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetopeltidales | Chaetopeltidaceae | Hormotilopsis | Hormotilopsis gelatinosa | |
| 14440843 | 14440843 | PRJNA397065_S_NODE_10132_length_256_cov_7.096916_g9882_i0 | PRJNA397065 | 10132 | 256 | 7.096916 | 18.16810496 | Pseudochlorella signiensis | 173497 | Plants | Plants | 368 | 2.03e-97 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g9882 | i0 | 92.913 | 127.6484375 | 254 | 17 | 99 | 1 | 3 | 256 | 150297 | 150045 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 32678 | 368 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 17657042 | 17657042 | PRJNA397065_S_NODE_16674_length_172_cov_8.265734_g16424_i0 | PRJNA397065 | 16674 | 172 | 8.265734 | 14.21706248 | Chlorellaceae | 35461 | Plants | Plants | 209 | 8.09e-50 | NTclustered | gi|698349064|gb|KM462875.1| | 163096 | g16424 | i0 | 88.506 | 136.941860465116 | 174 | 18 | 100 | 1 | 1 | 172 | 56171 | 56344 | Chlorosarcina brevispinosa culture-collection UTEX:1176 chloroplast, partial genome | blastn | 23554 | 209 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Pleurastrosarcina | Pleurastrosarcina brevispinosa | |||
| 17657098 | 17657098 | PRJNA397065_S_NODE_17954_length_162_cov_6.609023_g17704_i0 | PRJNA397065 | 17954 | 162 | 6.609023 | 10.70661726 | Chlorellaceae | 35461 | Plants | Plants | 291 | 2.62e-74 | NTclustered | gi|300713443|gb|GQ487247.1| | 797667 | g17704 | i0 | 99.375 | 98.9506172839506 | 160 | 1 | 99 | 0 | 2 | 161 | 599 | 758 | Dictyosphaerium sp. CCALA 333 18S ribosomal RNA gene, partial sequence | blastn | 16030 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dictyosphaerium | Dictyosphaerium sp. CCALA 333 | |
| 20205927 | 20205927 | PRJNA397065_S_NODE_6056_length_386_cov_6318.137255_g5807_i0 | PRJNA397065 | 6056 | 386 | 6318.137255 | 24388.0098043 | Trebouxiophyceae | 75966 | Plants | Plants | 433 | 1.13e-116 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g5807 | i0 | 90.549 | 31.7564766839378 | 328 | 30 | 85 | 1 | 59 | 386 | 5779 | 5453 | 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 | 12258 | 433 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum |
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);;