contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJEB7614" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23948867 | 23948867 | PRJEB7614_P_NODE_3519_length_213_cov_1043.195652_g3452_i0 | PRJEB7614 | 3519 | 213 | 1043.195652 | 2222.00673876 | Chlorophyta | 3041 | Plants | Plants | 67.6 | 6.69e-7 | NTclustered | gi|6119987|gb|AF183447.1| | 3109 | g3452 | i0 | 97.436 | 21.4131455399061 | 39 | 1 | 18 | 0 | 106 | 144 | 1370 | 1408 | Ankistrodesmus stipitatus culture SAG:202-5 strain SAG 202-5 28S ribosomal RNA gene, partial sequence | blastn | 4561 | 67.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Ankistrodesmus | Ankistrodesmus stipitatus | |
| 25616358 | 25616358 | PRJEB7614a_S_NODE_123697_length_163_cov_10.421875_g122493_i0 | PRJEB7614 | 123697 | 163 | 10.421875 | 16.98765625 | Trebouxia | 13786 | Plants | Plants | 302 | 1.22e-77 | NTclustered | gi|49781197|gb|AY648107.1| | 283661 | g122493 | i0 | 100 | 100.177914110429 | 163 | 0 | 100 | 0 | 1 | 163 | 1411 | 1249 | Trebouxia sp. Wei 22-c 26S ribosomal RNA gene, partial sequence | blastn | 16329 | 302 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. Wei 22-c | |
| 25616364 | 25616364 | PRJEB7614a_S_NODE_38665_length_302_cov_32.453184_g37461_i0 | PRJEB7614 | 38665 | 302 | 32.453184 | 98.00861568 | Trebouxia | 13786 | Plants | Plants | 503 | 6.459999999999998e-138 | NTclustered | gi|2105086|emb|Z95380.1| | 13787 | g37461 | i0 | 98.258 | 94.9072847682119 | 287 | 5 | 95 | 0 | 1 | 287 | 19 | 305 | T.asymmetrica 26S rRNA gene | blastn | 28662 | 508 | 0.990157480314961 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia asymmetrica | |
| 25616365 | 25616365 | PRJEB7614a_S_NODE_43329_length_288_cov_24.154150_g42125_i0 | PRJEB7614 | 43329 | 288 | 24.15415 | 69.563952 | Jaagichlorella | 2304164 | Plants | Plants | 505 | 1.7e-138 | NTclustered | gi|694226588|gb|KM116462.1| | 31301 | g42125 | i0 | 100 | 94.65625 | 273 | 0 | 95 | 0 | 16 | 288 | 2744 | 2472 | Heterochlorella luteoviridis strain SAG 2213 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 27261 | 505 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Jaagichlorella | Jaagichlorella luteoviridis | |
| 25888335 | 25888335 | PRJEB7614a_S_NODE_130475_length_157_cov_8.918033_g129271_i0 | PRJEB7614 | 130475 | 157 | 8.918033 | 14.00131181 | Trebouxia | 13786 | Plants | Plants | 279 | 5.46e-71 | NTclustered | gi|162134340|gb|EU123979.1| | 160068 | g129271 | i0 | 98.726 | 150.006369426752 | 157 | 2 | 100 | 0 | 1 | 157 | 1200 | 1356 | Trebouxia aggregata strain SAG 219-1d large subunit ribosomal RNA (rrl) gene, complete sequence; and putative site-specific DNA endonuclease (orf210) and hypothetical protein (orf277) genes, complete cds; chloroplast | blastn | 23551 | 279 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 25933944 | 25933944 | PRJEB7614b_S_NODE_5324_length_160_cov_3.240000_g5322_i0 | PRJEB7614 | 5324 | 160 | 3.24 | 5.184 | Sarcinofilum mucosum | 141643 | Plants | Plants | 206 | 9.63e-49 | NTclustered | gi|1197510887|ref|NC_034709.1| | 141643 | g5322 | i0 | 93.478 | 117.04375 | 138 | 9 | 86 | 0 | 1 | 138 | 147770 | 147907 | Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome | blastn | 18727 | 206 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Sarcinofilaceae | Sarcinofilum | Sarcinofilum mucosum | |
| 26024660 | 26024660 | PRJEB7614a_S_NODE_38652_length_302_cov_67.037453_g37448_i0 | PRJEB7614 | 38652 | 302 | 67.037453 | 202.45310806 | Jaagichlorella | 2304164 | Plants | Plants | 388 | 1.89e-103 | NTclustered | gi|1802907783|gb|MT006204.1| | 2704669 | g37448 | i0 | 94.118 | 85.158940397351 | 255 | 15 | 84 | 0 | 1 | 255 | 3239 | 3493 | Jaagichlorella nagensis strain FACHB-2415 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 | 25718 | 388 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Jaagichlorella | Jaagichlorella nagensis | |
| 26024676 | 26024676 | PRJEB7614b_S_NODE_1740_length_188_cov_10.843137_g1738_i0 | PRJEB7614 | 1740 | 188 | 10.843137 | 20.38509756 | Eukaryota | 2759 | Plants | Plants | 348 | 1.84e-91 | NTclustered | gi|1189013852|gb|MF034633.1| | 43939 | g1738 | i0 | 100 | 99.9787234042553 | 188 | 0 | 100 | 0 | 1 | 188 | 883 | 696 | Hazenia basiliensis strain ULVO-15 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 | 18796 | 348 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Hazeniaceae | Hazenia | Hazenia basiliensis | |
| 26069939 | 26069939 | PRJEB7614a_S_NODE_87749_length_201_cov_17.939759_g86545_i0 | PRJEB7614 | 87749 | 201 | 17.939759 | 36.05891559 | Polulichloris maxima | 2704661 | Plants | Plants | 326 | 9.33e-85 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g86545 | i0 | 96.02 | 134.044776119403 | 201 | 7 | 99 | 1 | 1 | 200 | 126038 | 125838 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 26943 | 326 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 26206192 | 26206192 | PRJEB7614a_S_NODE_100998_length_185_cov_10.746667_g99794_i0 | PRJEB7614 | 100998 | 185 | 10.746667 | 19.88133395 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 265 | 1.86e-66 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g99794 | i0 | 92.473 | 101.135135135135 | 186 | 12 | 100 | 2 | 1 | 185 | 3044 | 2860 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 18710 | 265 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 26206198 | 26206198 | PRJEB7614a_S_NODE_125790_length_162_cov_1.267717_g124586_i0 | PRJEB7614 | 125790 | 162 | 1.267717 | 2.05370154 | Polulichloris maxima | 2704661 | Plants | Plants | 270 | 3.4199999999999993e-68 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g124586 | i0 | 96.894 | 60.7530864197531 | 161 | 5 | 99 | 0 | 2 | 162 | 126973 | 126813 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 9842 | 270 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 26296584 | 26296584 | PRJEB7614a_S_NODE_128926_length_159_cov_1.975806_g127722_i0 | PRJEB7614 | 128926 | 159 | 1.975806 | 3.14153154 | Polulichloris | 2511083 | Plants | Plants | 289 | 9.22e-74 | NTclustered | gi|745734040|gb|KM458311.1| | 1301201 | g127722 | i0 | 99.371 | 105.213836477987 | 159 | 1 | 100 | 0 | 1 | 159 | 284 | 126 | Uncultured Heterochlorella isolate OTU 00024 23S ribosomal RNA gene, partial sequence; plastid | blastn | 16729 | 289 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Heterochlorella | ||||
| 26296613 | 26296613 | PRJEB7614e_S_NODE_1998_length_205_cov_1.629412_g1990_i0 | PRJEB7614 | 1998 | 205 | 1.629412 | 3.3402946 | Jaagichlorella | 2304164 | Plants | Plants | 296 | 7.49e-76 | NTclustered | gi|478437260|gb|KC470085.1| | 445995 | g1990 | i0 | 92.683 | 92.4292682926829 | 205 | 15 | 100 | 0 | 1 | 205 | 3335 | 3131 | Heveochlorella hainangensis strain SAG 2360 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 18948 | 296 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Jaagichlorella | Jaagichlorella hainangensis | |
| 26342044 | 26342044 | PRJEB7614b_S_NODE_1591_length_192_cov_2.808917_g1589_i0 | PRJEB7614 | 1591 | 192 | 2.808917 | 5.39312064 | Blidingia sp. DT1 | 2022611 | Plants | Plants | 270 | 4.19e-68 | NTclustered | gi|1220117795|gb|KY401415.1| | 2022611 | g1589 | i0 | 94.857 | 91.25 | 175 | 5 | 89 | 3 | 22 | 192 | 2349 | 2523 | Blidingia sp. DT1 28S ribosomal RNA gene, partial sequence | blastn | 17520 | 270 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Blidingia | Blidingia sp. DT1 | |
| 26432631 | 26432631 | PRJEB7614d_S_NODE_1327_length_204_cov_0.982249_g1289_i0 | PRJEB7614 | 1327 | 204 | 0.982249 | 2.00378796 | Trebouxia | 13786 | Plants | Plants | 331 | 2.04e-86 | NTclustered | gi|2105087|emb|Z95381.1| | 53268 | g1289 | i0 | 99.451 | 89.171568627451 | 182 | 1 | 89 | 0 | 1 | 182 | 281 | 100 | T.arboricola 26S rRNA gene | blastn | 18191 | 331 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia arboricola |
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);;