contig_metadata
14 rows where bioproject = "PRJEB48218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4818148 | 4818148 | PRJEB48218_S_NODE_12764_length_249_cov_1320.263636_g11802_i0 | PRJEB48218 | 12764 | 249 | 1320.263636 | 3287.45645364 | Trebouxia | 13786 | Plants | Plants | 255 | 1.6e-63 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g11802 | i0 | 96.178 | 324.204819277108 | 157 | 5 | 63 | 1 | 1 | 157 | 6661 | 6816 | Uncultured Trebouxia photobiont voucher Lendemer 46119 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 | 80727 | 255 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 7714739 | 7714739 | PRJEB48218_S_NODE_12127_length_256_cov_1246.224670_g11165_i0 | PRJEB48218 | 12127 | 256 | 1246.22467 | 3190.3351552 | Micractinium reisseri | 532145 | Plants | Plants | 268 | 2.1199999999999998e-67 | NTclustered | gi|297501471|dbj|AB506071.1| | 532145 | g11165 | i0 | 96.875 | 295.25390625 | 160 | 5 | 63 | 0 | 1 | 160 | 4716 | 4875 | Micractinium reisseri genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, clone: 2 | blastn | 75585 | 268 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium reisseri | |
| 7714757 | 7714757 | PRJEB48218_S_NODE_13227_length_245_cov_15.296296_g12265_i0 | PRJEB48218 | 13227 | 245 | 15.296296 | 37.4759252 | Scherffelia dubia | 3190 | Plants | Plants | 185 | 2.09e-42 | NTclustered | gi|371782096|emb|HE610128.1| | 3190 | g12265 | i0 | 80.992 | 83.2204081632653 | 242 | 39 | 98 | 7 | 7 | 245 | 2805 | 2568 | Scherffelia dubia 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 17.86 | blastn | 20389 | 185 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Scherffelia | Scherffelia dubia | |
| 8989587 | 8989587 | PRJEB48218_S_NODE_19568_length_212_cov_39.972678_g18606_i0 | PRJEB48218 | 19568 | 212 | 39.972678 | 84.74207736 | Koliella longiseta | 33092 | Plants | Plants | 346 | 7.64e-91 | NTclustered | gi|371782094|emb|HE610126.1| | 33092 | g18606 | i0 | 98.469 | 93.0047169811321 | 196 | 3 | 92 | 0 | 1 | 196 | 4494 | 4689 | Koliella longiseta 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 470-1 | blastn | 19717 | 346 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 8989880 | 8989880 | PRJEB48218_S_NODE_5848_length_425_cov_9961.962121_g4892_i0 | PRJEB48218 | 5848 | 425 | 9961.962121 | 42338.33901425 | Diplosphaera sp. (in: green algae) | 2911680 | Plants | Plants | 368 | 3.58e-97 | NTclustered | gi|2644500050|gb|PP079688.1| | 2911680 | g4892 | i0 | 98.104 | 49.7058823529412 | 211 | 4 | 50 | 0 | 119 | 329 | 1518 | 1728 | Diplosphaera sp. (in: green algae) isolate C3 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 | 21125 | 368 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Diplosphaera | Diplosphaera sp. (in: green algae) | |
| 9918445 | 9918445 | PRJEB48218_S_NODE_13088_length_246_cov_21.147465_g12126_i0 | PRJEB48218 | 13088 | 246 | 21.147465 | 52.0227639 | Trebouxiophyceae | 75966 | Plants | Plants | 344 | 3.27e-90 | NTclustered | gi|371782094|emb|HE610126.1| | 33092 | g12126 | i0 | 91.903 | 100.113821138211 | 247 | 19 | 100 | 1 | 1 | 246 | 4740 | 4494 | Koliella longiseta 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 470-1 | blastn | 24628 | 344 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 9918550 | 9918550 | PRJEB48218_S_NODE_24348_length_177_cov_34.939189_g23386_i0 | PRJEB48218 | 24348 | 177 | 34.939189 | 61.84236453 | Chlorophyta | 3041 | Plants | Plants | 279 | 6.3e-71 | NTclustered | gi|1799637080|gb|MN968346.1| | 29647 | g23386 | i0 | 98.726 | 88.7005649717514 | 157 | 2 | 89 | 0 | 3 | 159 | 1531 | 1375 | Stichococcus sp. strain USMFM_Antarctica 2 small subunit ribosomal RNA gene, partial sequence | blastn | 15700 | 279 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus sp. | |
| 10265345 | 10265345 | PRJEB48218_S_NODE_23149_length_185_cov_11.134615_g22187_i0 | PRJEB48218 | 23149 | 185 | 11.134615 | 20.59903775 | Stichococcus bacillaris | 37433 | Plants | Plants | 272 | 1.11e-68 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g22187 | i0 | 98.693 | 82.8054054054054 | 153 | 2 | 83 | 0 | 25 | 177 | 4289 | 4137 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 15319 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 11541105 | 11541105 | PRJEB48218_S_NODE_9910_length_289_cov_27.080769_g8948_i0 | PRJEB48218 | 9910 | 289 | 27.080769 | 78.26342241 | Stichococcus bacillaris | 37433 | Plants | Plants | 424 | 4.9199999999999996e-114 | NTclustered | gi|18642518|gb|AF278751.1| | 37433 | g8948 | i0 | 93.662 | 98.1038062283737 | 284 | 17 | 98 | 1 | 7 | 289 | 259 | 542 | Stichococcus bacillaris 16S small subunit ribosomal RNA gene, partial sequence; chloroplast gene for chloroplast product | blastn | 28352 | 424 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 12469569 | 12469569 | PRJEB48218_S_NODE_9470_length_297_cov_1092.529851_g8508_i0 | PRJEB48218 | 9470 | 297 | 1092.529851 | 3244.81365747 | Trebouxiophyceae | 75966 | Plants | Plants | 272 | 1.9499999999999993e-68 | NTclustered | gi|371782094|emb|HE610126.1| | 33092 | g8508 | i0 | 91.045 | 68.8619528619529 | 201 | 18 | 68 | 0 | 97 | 297 | 4942 | 4742 | Koliella longiseta 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 470-1 | blastn | 20452 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 15365089 | 15365089 | PRJEB48218_S_NODE_8973_length_308_cov_13151.358423_g8011_i0 | PRJEB48218 | 8973 | 308 | 13151.358423 | 40506.18394284 | Diplosphaera sundellii | 3135960 | Plants | Plants | 292 | 1.5599999999999999e-74 | NTclustered | gi|2878821371|gb|PQ563290.1| | 3135960 | g8011 | i0 | 94.681 | 58.2987012987013 | 188 | 10 | 61 | 0 | 2 | 189 | 9010 | 8823 | Diplosphaera sundellii mitochondrion, complete genome | blastn | 17956 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Diplosphaera | Diplosphaera sundellii | |
| 16639636 | 16639636 | PRJEB48218_S_NODE_8794_length_313_cov_6.183099_g7832_i0 | PRJEB48218 | 8794 | 313 | 6.183099 | 19.35309987 | Stichococcus bacillaris | 37433 | Plants | Plants | 374 | 5.5e-99 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g7832 | i0 | 89.073 | 92.6996805111821 | 302 | 31 | 96 | 1 | 5 | 304 | 3503 | 3202 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 29015 | 374 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 18841910 | 18841910 | PRJEB48218_S_NODE_12475_length_252_cov_1295.614350_g11513_i0 | PRJEB48218 | 12475 | 252 | 1295.61435 | 3264.948162 | Trebouxiophyceae | 75966 | Plants | Plants | 289 | 1.6e-73 | NTclustered | gi|1799637079|gb|MN968320.1| | 29647 | g11513 | i0 | 100 | 61.9087301587302 | 156 | 0 | 62 | 0 | 1 | 156 | 1221 | 1376 | Stichococcus sp. strain CCAP 822/3 small subunit ribosomal RNA gene, partial sequence | blastn | 15601 | 289 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus sp. | |
| 19188284 | 19188284 | PRJEB48218_S_NODE_6216_length_406_cov_11091.697613_g5256_i0 | PRJEB48218 | 6216 | 406 | 11091.697613 | 45032.29230878 | Stichococcus bacillaris | 37433 | Plants | Plants | 331 | 4.47e-86 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g5256 | i0 | 98.404 | 391.748768472906 | 188 | 3 | 46 | 0 | 102 | 289 | 7179 | 6992 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 159050 | 331 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris |
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);;