contig_metadata
13 rows where bioproject = "PRJEB9859" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 999046 | 999046 | PRJEB9859_P_NODE_7261_length_215_cov_102.467742_g7226_i0 | PRJEB9859 | 7261 | 215 | 102.467742 | 220.3056453 | Myrmecia | 13617 | Plants | Plants | 122 | 1.42e-23 | NTclustered | gi|1158556132|emb|LT717572.1| | 1938899 | g7226 | i0 | 100 | 30.7023255813953 | 66 | 0 | 31 | 0 | 1 | 66 | 348 | 283 | Chlorobiont of Psora decipiens partial 26S rRNA gene, isolate Swe2-Aus | blastn | 6601 | 122 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | chlorobiont of Psora decipiens | ||||
| 1419613 | 1419613 | PRJEB9859_P_NODE_2202_length_311_cov_1.556738_g2167_i0 | PRJEB9859 | 2202 | 311 | 1.556738 | 4.84145518 | [Myrmecia] bisecta | 41462 | Plants | Plants | 86.3 | 2.78e-18 | NR | KAK9817689.1 | 41462 | g2167 | i0 | 83.7 | 3.80064308681672 | 49 | 8 | 47.3 | 0 | 306 | 160 | 160 | 208 | KAK9817689.1 hypothetical protein WJX72_000657 [[Myrmecia] bisecta] | diamond | 1182 | 86.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 7797439 | 7797439 | PRJEB9859_P_NODE_4007_length_254_cov_294.182222_g3972_i0 | PRJEB9859 | 4007 | 254 | 294.182222 | 747.22284388 | Polulichloris maxima | 2704661 | Plants | Plants | 255 | 1.64e-63 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g3972 | i0 | 96.154 | 4.87795275590551 | 156 | 6 | 61 | 0 | 76 | 231 | 125440 | 125285 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 1239 | 255 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 8652196 | 8652196 | PRJEB9859_S_NODE_307_length_299_cov_403.537879_g302_i0 | PRJEB9859 | 307 | 299 | 403.537879 | 1206.57825821 | Trebouxia | 13786 | Plants | Plants | 374 | 5.22e-99 | NTclustered | gi|2105086|emb|Z95380.1| | 13787 | g302 | i0 | 99.512 | 68.7123745819398 | 205 | 1 | 69 | 0 | 41 | 245 | 305 | 101 | T.asymmetrica 26S rRNA gene | blastn | 20545 | 374 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia asymmetrica | |
| 9072442 | 9072442 | PRJEB9859_S_NODE_468_length_193_cov_128.632911_g463_i0 | PRJEB9859 | 468 | 193 | 128.632911 | 248.26151823 | Polulichloris maxima | 2704661 | Plants | Plants | 287 | 4.189999999999999e-73 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g463 | i0 | 97.059 | 10.2072538860104 | 170 | 5 | 88 | 0 | 1 | 170 | 125454 | 125285 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 1970 | 287 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 17996649 | 17996649 | PRJEB9859_P_NODE_3675_length_262_cov_471.351931_g3640_i0 | PRJEB9859 | 3675 | 262 | 471.351931 | 1234.94205922 | Polulichloris maxima | 2704661 | Plants | Plants | 255 | 1.7e-63 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g3640 | i0 | 96.154 | 15.2290076335878 | 156 | 6 | 60 | 0 | 24 | 179 | 125285 | 125440 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 3990 | 255 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 26812855 | 26812855 | PRJEB9859_P_NODE_3821_length_259_cov_5.195652_g3786_i0 | PRJEB9859 | 3821 | 259 | 5.195652 | 13.45673868 | Monoraphidium minutum | 39955 | Plants | Plants | 90.5 | 6.99e-19 | NR | KAI8476985.1 | 39955 | g3786 | i0 | 64.2 | 0.776061776061776 | 67 | 23 | 77.6 | 1 | 257 | 57 | 780 | 845 | KAI8476985.1 MAG: elongation factor 2 [Monoraphidium minutum] | diamond | 201 | 90.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 27438089 | 27438089 | PRJEB9859_P_NODE_423_length_507_cov_5.924686_g399_i0 | PRJEB9859 | 423 | 507 | 5.924686 | 30.03815802 | Chlorophyta | 3041 | Plants | Plants | 99 | 1.2300000000000002e-21 | NR | GBF95511.1 | 307507 | g399 | i0 | 38.3 | 1.65680473372781 | 141 | 80 | 82.2 | 3 | 505 | 89 | 141 | 276 | GBF95511.1 60S ribosomal protein L18a-2 [Raphidocelis subcapitata] | diamond | 840 | 100 | 0.99 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 28045049 | 28045049 | PRJEB9859_P_NODE_6405_length_225_cov_4.581633_g6370_i0 | PRJEB9859 | 6405 | 225 | 4.581633 | 10.30867425 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 66.2 | 1.56e-10 | NR | KAF8058473.1 | 2742167 | g6370 | i0 | 84.2 | 4.74666666666667 | 38 | 6 | 50.7 | 0 | 225 | 112 | 574 | 611 | KAF8058473.1 RpL37a [Scenedesmus sp. PABB004] | diamond | 1068 | 66.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 28069305 | 28069305 | PRJEB9859_P_NODE_1125_length_379_cov_6.782857_g1091_i0 | PRJEB9859 | 1125 | 379 | 6.782857 | 25.70702803 | Eukaryota | 2759 | Plants | Plants | 117 | 1.4399999999999998e-30 | NR | ADB77798.1 | 34128 | g1091 | i0 | 57.1 | 26.6200527704485 | 98 | 42 | 77.6 | 0 | 376 | 83 | 77 | 174 | ADB77798.1 40S ribosomal protein S9, partial [Cladophora coelothrix] | diamond | 10089 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Cladophoraceae | Cladophora | Cladophora coelothrix | |
| 28290180 | 28290180 | PRJEB9859_P_NODE_966_length_396_cov_9.528610_g932_i0 | PRJEB9859 | 966 | 396 | 9.52861 | 37.7332956 | Chlamydomonadaceae | 3051 | Plants | Plants | 164 | 1.74e-48 | NR | GAX77325.1 | 1157962 | g932 | i0 | 70.8 | 5.98484848484848 | 113 | 33 | 85.6 | 0 | 388 | 50 | 92 | 204 | GAX77325.1 hypothetical protein CEUSTIGMA_g4771.t1 [Chlamydomonas eustigma] | diamond | 2370 | 164 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 30413784 | 30413784 | PRJEB9859_P_NODE_2993_length_282_cov_2.039526_g2958_i0 | PRJEB9859 | 2993 | 282 | 2.039526 | 5.75146332 | Tetradesmus obliquus | 3088 | Plants | Plants | 72.4 | 1.64e-12 | NR | WIA20814.1 | 3088 | g2958 | i0 | 54.4 | 0.723404255319149 | 68 | 31 | 72.3 | 0 | 276 | 73 | 277 | 344 | WIA20814.1 hypothetical protein OEZ85_005170 [Tetradesmus obliquus] | diamond | 204 | 72.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 32437417 | 32437417 | PRJEB9859_P_NODE_4299_length_250_cov_2.185520_g4264_i0 | PRJEB9859 | 4299 | 250 | 2.18552 | 5.4638 | [Myrmecia] bisecta | 41462 | Plants | Plants | 43.1 | 0.0297 | NR | KAK9813021.1 | 41462 | g4264 | i0 | 71.4 | 0.336 | 28 | 8 | 33.6 | 0 | 246 | 163 | 508 | 535 | KAK9813021.1 hypothetical protein WJX72_007639 [[Myrmecia] bisecta] | diamond | 84 | 43.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta |
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);;