contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1126198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 281539 | 281539 | PRJNA1126198_P_NODE_376761_length_251_cov_0.876404_g376040_i0 | PRJNA1126198 | 376761 | 251 | 0.876404 | 2.19977404 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 292 | 1.2299999999999999e-74 | NTclustered | gi|545375598|ref|XM_005651907.1| | 574566 | g376040 | i0 | 87.649 | 1.78884462151394 | 251 | 31 | 100 | 0 | 1 | 251 | 989 | 739 | Coccomyxa subellipsoidea C-169 glucose-6-phosphate dehydrogenase partial mRNA | blastn | 449 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 2832383 | 2832383 | PRJNA1126198_P_NODE_446243_length_244_cov_0.912281_g445522_i0 | PRJNA1126198 | 446243 | 244 | 0.912281 | 2.22596564 | Chloroidium sp. UTEX 3077 | 2686440 | Plants | Plants | 322 | 1.52e-83 | NTclustered | gi|1785188440|gb|MN646686.1| | 2686440 | g445522 | i0 | 90.612 | 1.00409836065574 | 245 | 20 | 100 | 3 | 1 | 244 | 64458 | 64216 | Chloroidium sp. UTEX 3077 mitochondrion, complete genome | blastn | 245 | 322 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. UTEX 3077 | |
| 3580974 | 3580974 | PRJNA1126198_P_NODE_347963_length_255_cov_1.703297_g347242_i0 | PRJNA1126198 | 347963 | 255 | 1.703297 | 4.34340735 | Eukaryota | 2759 | Plants | Plants | 137 | 6.22e-28 | NTclustered | gi|6119991|gb|AF183451.1| | 50039 | g347242 | i0 | 85.401 | 53.6117647058824 | 137 | 15 | 53 | 5 | 116 | 250 | 217 | 350 | Bracteacoccus giganteus strain UTEX 1251 28S ribosomal RNA gene, partial sequence | blastn | 13671 | 137 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus giganteus | |
| 7934903 | 7934903 | PRJNA1126198_P_NODE_83207_length_356_cov_2.558304_g82489_i0 | PRJNA1126198 | 83207 | 356 | 2.558304 | 9.10756224 | Haematococcus lacustris | 44745 | Plants | Plants | 521 | 2.1399999999999998e-143 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g82489 | i0 | 93.258 | 295.480337078652 | 356 | 21 | 100 | 3 | 1 | 356 | 4387 | 4035 | 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 | 105191 | 521 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 9958747 | 9958747 | PRJNA1126198_P_NODE_9128_length_613_cov_2.918519_g8465_i0 | PRJNA1126198 | 9128 | 613 | 2.918519 | 17.89052147 | Eukaryota | 2759 | Plants | Plants | 250 | 2.0099999999999997e-61 | NTclustered | gi|371782091|emb|HE610123.1| | 3107 | g8465 | i0 | 91.398 | 30.6508972267537 | 186 | 10 | 30 | 5 | 197 | 381 | 5126 | 4946 | Hydrodictyon reticulatum 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M2243 | blastn | 18789 | 250 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Hydrodictyon | Hydrodictyon reticulatum | |
| 10485078 | 10485078 | PRJNA1126198_P_NODE_383549_length_250_cov_1.463277_g382828_i0 | PRJNA1126198 | 383549 | 250 | 1.463277 | 3.6581925 | Pseudochlorella signiensis | 173497 | Plants | Plants | 435 | 1.92e-117 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g382828 | i0 | 98.008 | 122.056 | 251 | 4 | 100 | 1 | 1 | 250 | 152244 | 152494 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 30514 | 435 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 11760273 | 11760273 | PRJNA1126198_P_NODE_428150_length_246_cov_0.895954_g427429_i0 | PRJNA1126198 | 428150 | 246 | 0.895954 | 2.20404684 | uncultured Trebouxia photobiont | 285713 | Plants | Plants | 392 | 1.15e-104 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g427429 | i0 | 95.528 | 7.14227642276423 | 246 | 9 | 100 | 2 | 1 | 246 | 8556 | 8799 | 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 | 1757 | 392 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 15057985 | 15057985 | PRJNA1126198_P_NODE_279652_length_270_cov_2.426396_g278931_i0 | PRJNA1126198 | 279652 | 270 | 2.426396 | 6.5512692 | Trebouxia | 13786 | Plants | Plants | 492 | 1.23e-134 | NTclustered | gi|189909382|gb|EU725860.1| | 13787 | g278931 | i0 | 99.628 | 100.833333333333 | 269 | 1 | 99 | 0 | 2 | 270 | 629 | 361 | Trebouxia asymmetrica strain SAG 48.88 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 27225 | 492 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia asymmetrica | |
| 16858873 | 16858873 | PRJNA1126198_P_NODE_419234_length_247_cov_0.885057_g418513_i0 | PRJNA1126198 | 419234 | 247 | 0.885057 | 2.18609079 | Polulichloris maxima | 2704661 | Plants | Plants | 424 | 4.1099999999999996e-114 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g418513 | i0 | 97.571 | 130.02024291498 | 247 | 6 | 100 | 0 | 1 | 247 | 127790 | 127544 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 32115 | 424 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 16859038 | 16859038 | PRJNA1126198_P_NODE_487034_length_230_cov_3.783439_g486313_i0 | PRJNA1126198 | 487034 | 230 | 3.783439 | 8.7019097 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 122 | 1.54e-23 | NTclustered | gi|2082255880|ref|XM_001702589.2| | 3055 | g486313 | i0 | 84.252 | 36.5130434782609 | 127 | 18 | 55 | 2 | 1 | 126 | 327 | 452 | Chlamydomonas reinhardtii ribosomal protein L3 (CHLRE_10g417700v5), mRNA | blastn | 8398 | 122 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20682967 | 20682967 | PRJNA1126198_P_NODE_359477_length_253_cov_1.300000_g358756_i0 | PRJNA1126198 | 359477 | 253 | 1.3 | 3.289 | Polulichloris maxima | 2704661 | Plants | Plants | 435 | 1.95e-117 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g358756 | i0 | 97.628 | 117.320158102767 | 253 | 6 | 100 | 0 | 1 | 253 | 126342 | 126594 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 29682 | 435 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 23233770 | 23233770 | PRJNA1126198_P_NODE_331519_length_259_cov_1.080645_g330798_i0 | PRJNA1126198 | 331519 | 259 | 1.080645 | 2.79887055 | Chloroidium sp. UTEX 3077 | 2686440 | Plants | Plants | 446 | 9.26e-121 | NTclustered | gi|1785188440|gb|MN646686.1| | 2686440 | g330798 | i0 | 97.683 | 82.1235521235521 | 259 | 6 | 100 | 0 | 1 | 259 | 62715 | 62973 | Chloroidium sp. UTEX 3077 mitochondrion, complete genome | blastn | 21270 | 446 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. UTEX 3077 | |
| 24507314 | 24507314 | PRJNA1126198_P_NODE_297180_length_266_cov_1.673575_g296459_i0 | PRJNA1126198 | 297180 | 266 | 1.673575 | 4.4517095 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 472 | 1.5799999999999998e-128 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g296459 | i0 | 98.864 | 99.2518796992481 | 264 | 3 | 99 | 0 | 1 | 264 | 1877 | 2140 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 26401 | 472 | 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);;