contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA627467" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2425912 | 2425912 | PRJNA627467_P_NODE_13102_length_177_cov_2.140625_g13033_i0 | PRJNA627467 | 13102 | 177 | 2.140625 | 3.78890625 | Balticola | 1328802 | Plants | Plants | 207 | 3.02e-49 | NTclustered | gi|6120015|gb|AF183475.1| | 51690 | g13033 | i0 | 88.136 | 6.7909604519774 | 177 | 18 | 99 | 3 | 2 | 177 | 1699 | 1525 | Balticola zimbabwiensis strain UTEX LB 1758 28S ribosomal RNA gene, partial sequence | blastn | 1202 | 207 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Balticola | Balticola zimbabwiensis | |
| 3150154 | 3150154 | PRJNA627467_P_NODE_7943_length_219_cov_1.964706_g7874_i0 | PRJNA627467 | 7943 | 219 | 1.964706 | 4.30270614 | Dicloster acuatus | 91190 | Plants | Plants | 337 | 4.78e-88 | NTclustered | gi|725651324|ref|NC_025546.1| | 91190 | g7874 | i0 | 94.907 | 137.840182648402 | 216 | 10 | 98 | 1 | 2 | 216 | 98668 | 98453 | Dicloster acuatus culture-collection SAG:41.98 chloroplast, complete genome | blastn | 30187 | 337 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 4426874 | 4426874 | PRJNA627467_P_NODE_3904_length_316_cov_1.898876_g3836_i0 | PRJNA627467 | 3904 | 316 | 1.898876 | 6.00044816 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 54.7 | 0.008 | NTclustered | gi|2082243229|ref|XM_043061197.1| | 3055 | g3836 | i0 | 94.286 | 0.110759493670886 | 35 | 2 | 11 | 0 | 31 | 65 | 9721 | 9687 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g192300v5), mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 4426903 | 4426903 | PRJNA627467_P_NODE_6344_length_298_cov_2.216867_g6276_i0 | PRJNA627467 | 6344 | 298 | 2.216867 | 6.60626366 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 433 | 8.47e-117 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g6276 | i0 | 93.243 | 6.46308724832215 | 296 | 16 | 99 | 4 | 2 | 295 | 5761 | 5468 | 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 | 1926 | 433 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 4979070 | 4979070 | PRJNA627467_P_NODE_384_length_512_cov_6.654428_g322_i0 | PRJNA627467 | 384 | 512 | 6.654428 | 34.07067136 | Trebouxiophyceae | 75966 | Plants | Plants | 739 | 0 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g322 | i0 | 93.097 | 99.392578125 | 507 | 31 | 98 | 3 | 3 | 506 | 4279 | 3774 | 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 | 50889 | 743 | 0.994616419919246 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 14628197 | 14628197 | PRJNA627467_P_NODE_7812_length_222_cov_3.502890_g7743_i0 | PRJNA627467 | 7812 | 222 | 3.50289 | 7.7764158 | Oltmannsiellopsis sp. CCMP1240 | 1108793 | Plants | Plants | 272 | 1.3899999999999999e-68 | NTclustered | gi|371782088|emb|HE610120.1| | 1108793 | g7743 | i0 | 89.091 | 99.1171171171171 | 220 | 22 | 98 | 2 | 3 | 220 | 4180 | 3961 | Oltmannsiellopsis sp. CCMP1240 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain CCMP1240 | blastn | 22004 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Oltmannsiellopsidales | Oltmannsiellopsidaceae | Oltmannsiellopsis | Oltmannsiellopsis sp. CCMP1240 | |
| 15902063 | 15902063 | PRJNA627467_P_NODE_12713_length_178_cov_3.511628_g12644_i0 | PRJNA627467 | 12713 | 178 | 3.511628 | 6.25069784 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 97.1 | 6.86e-16 | NTclustered | gi|760448014|ref|XM_011402774.1| | 3075 | g12644 | i0 | 76.966 | 1 | 178 | 35 | 98 | 5 | 3 | 177 | 240 | 414 | Auxenochlorella protothecoides Acyl-[acyl-carrier-protein] desaturase 5, chloroplastic partial mRNA | blastn | 178 | 97.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 15902110 | 15902110 | PRJNA627467_P_NODE_16933_length_166_cov_0.871795_g16864_i0 | PRJNA627467 | 16933 | 166 | 0.871795 | 1.4471797 | Lobosphaera incisa | 312850 | Plants | Plants | 137 | 3.73e-28 | NTclustered | gi|821316988|ref|NC_027060.1| | 312850 | g16864 | i0 | 91.262 | 15.2771084337349 | 103 | 5 | 60 | 3 | 64 | 163 | 29026 | 28925 | Lobosphaera incisa strain SAG 2468 mitochondrion, complete genome | blastn | 2536 | 137 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Lobosphaera | Lobosphaera incisa | |
| 16453505 | 16453505 | PRJNA627467_P_NODE_1453_length_325_cov_11.554348_g1386_i0 | PRJNA627467 | 1453 | 325 | 11.554348 | 37.551631 | Eukaryota | 2759 | Plants | Plants | 592 | 1.4599999999999996e-164 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g1386 | i0 | 100 | 97.6523076923077 | 320 | 0 | 98 | 0 | 4 | 323 | 567 | 886 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 31737 | 592 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 16453525 | 16453525 | PRJNA627467_P_NODE_15473_length_169_cov_2.750000_g15404_i0 | PRJNA627467 | 15473 | 169 | 2.75 | 4.6475 | Chlorophyta | 3041 | Plants | Plants | 292 | 7.64e-75 | NTclustered | gi|2528847353|gb|OR211494.1| | 3076 | g15404 | i0 | 98.78 | 97.0414201183432 | 164 | 2 | 97 | 0 | 3 | 166 | 777 | 614 | Chlorella sorokiniana isolate M18 small subunit ribosomal RNA gene, partial sequence | blastn | 16400 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 22828382 | 22828382 | PRJNA627467_P_NODE_8298_length_209_cov_5.456250_g8229_i0 | PRJNA627467 | 8298 | 209 | 5.45625 | 11.4035625 | Eukaryota | 2759 | Plants | Plants | 374 | 3.4399999999999996e-99 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g8229 | i0 | 100 | 96.4497607655502 | 202 | 0 | 97 | 0 | 5 | 206 | 256 | 55 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 20158 | 374 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 23551785 | 23551785 | PRJNA627467_P_NODE_319_length_556_cov_8.737673_g257_i0 | PRJNA627467 | 319 | 556 | 8.737673 | 48.58146188 | Parachlorella kessleri | 3074 | Plants | Plants | 933 | 0 | NTclustered | gi|254798615|ref|NC_012978.1| | 3074 | g257 | i0 | 96.942 | 118.773381294964 | 556 | 17 | 100 | 0 | 1 | 556 | 94451 | 93896 | Parachlorella kessleri chloroplast, complete genome | blastn | 66038 | 933 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 25377169 | 25377169 | PRJNA627467_P_NODE_19020_length_161_cov_3.705357_g18951_i0 | PRJNA627467 | 19020 | 161 | 3.705357 | 5.96562477 | root | 1 | Root_unresolved | Root_unresolved | 257 | 2.64e-64 | NTclustered | gi|77627727|dbj|AB237642.1| | 3077 | g18951 | i0 | 96.753 | 101.900621118012 | 154 | 5 | 96 | 0 | 5 | 158 | 2528 | 2375 | Chlorella vulgaris NIES:227 gene for 28S ribosomal RNA, partial sequence | blastn | 16406 | 259 | 0.992277992277992 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris |
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);;