contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA763243" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1205041 | 1205041 | PRJNA763243_P_NODE_18581_length_364_cov_19.316151_g18236_i0 | PRJNA763243 | 18581 | 364 | 19.316151 | 70.31078964 | Eukaryota | 2759 | Plants | Plants | 656 | 0 | NTclustered | gi|1898545223|gb|MT951391.1| | 3078 | g18236 | i0 | 99.446 | 99.1401098901099 | 361 | 2 | 99 | 0 | 4 | 364 | 1255 | 1615 | Auxenochlorella pyrenoidosa strain Ozcimen001 small subunit ribosomal RNA gene, partial sequence | blastn | 36087 | 656 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 4571747 | 4571747 | PRJNA763243_P_NODE_44324_length_266_cov_4.393782_g43978_i0 | PRJNA763243 | 44324 | 266 | 4.393782 | 11.68746012 | Blidingia sp. DT1 | 2022611 | Plants | Plants | 363 | 9.889999999999997e-96 | NTclustered | gi|1220117795|gb|KY401415.1| | 2022611 | g43978 | i0 | 91.923 | 98.3496240601504 | 260 | 19 | 97 | 2 | 5 | 263 | 274 | 16 | Blidingia sp. DT1 28S ribosomal RNA gene, partial sequence | blastn | 26161 | 363 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Blidingia | Blidingia sp. DT1 | |
| 6309278 | 6309278 | PRJNA763243_P_NODE_37745_length_282_cov_84.569378_g37399_i0 | PRJNA763243 | 37745 | 282 | 84.569378 | 238.48564596 | Eukaryota | 2759 | Plants | Plants | 496 | 1e-135 | NTclustered | gi|1201359270|gb|MF040792.1| | 3078 | g37399 | i0 | 98.925 | 98.936170212766 | 279 | 0 | 98 | 1 | 4 | 279 | 53 | 331 | Auxenochlorella pyrenoidosa isolate HIT9 18S ribosomal RNA gene, partial sequence | blastn | 27900 | 496 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 7122595 | 7122595 | PRJNA763243_P_NODE_65386_length_236_cov_39.312883_g65040_i0 | PRJNA763243 | 65386 | 236 | 39.312883 | 92.77840388 | Desmochloris halophila | 138176 | Plants | Plants | 412 | 8.43e-111 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g65040 | i0 | 99.127 | 94.7966101694915 | 229 | 2 | 97 | 0 | 4 | 232 | 2334 | 2562 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 22372 | 412 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 12222385 | 12222385 | PRJNA763243_P_NODE_1710_length_977_cov_12.902655_g1500_i0 | PRJNA763243 | 1710 | 977 | 12.902655 | 126.05893935 | Stigeoclonium helveticum | 55999 | Plants | Plants | 65.8 | 1.27e-5 | NTclustered | gi|162134275|gb|EU123958.1| | 55999 | g1500 | i0 | 97.368 | 0.230296827021494 | 38 | 1 | 4 | 0 | 7 | 44 | 1858 | 1821 | Stigeoclonium helveticum strain UTEX 441 small-subunit ribosomal RNA (rns) gene, complete sequence; mitochondrial | blastn | 225 | 65.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetophorales | Chaetophoraceae | Stigeoclonium | Stigeoclonium helveticum | |
| 12684865 | 12684865 | PRJNA763243_P_NODE_29690_length_310_cov_2.481013_g29344_i0 | PRJNA763243 | 29690 | 310 | 2.481013 | 7.6911403 | Pseudendoclonium | 43938 | Plants | Plants | 272 | 2.04e-68 | NTclustered | gi|50507928|dbj|AB183573.1| | 284945 | g29344 | i0 | 100 | 93.2516129032258 | 147 | 0 | 94 | 0 | 161 | 307 | 2217 | 2071 | Filamentous ulvophyte sp. MBIC10030 gene for 18S rRNA, partial sequence, strain: MBIC10030 | blastn | 28908 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvophyceae sp. MBIC10030 | ||||
| 13497436 | 13497436 | PRJNA763243_P_NODE_58031_length_245_cov_4.645349_g57685_i0 | PRJNA763243 | 58031 | 245 | 4.645349 | 11.38110505 | uncultured Apatococcus | 1229086 | Plants | Plants | 429 | 8.739999999999998e-116 | NTclustered | gi|1031961068|gb|KX025109.1| | 1229086 | g57685 | i0 | 100 | 92.3632653061224 | 232 | 0 | 95 | 0 | 11 | 242 | 1521 | 1290 | Uncultured Apatococcus clone GOGs_K08 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 | 22629 | 429 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Apatococcus | ||||
| 13497844 | 13497844 | PRJNA763243_P_NODE_74231_length_201_cov_4.992188_g73885_i0 | PRJNA763243 | 74231 | 201 | 4.992188 | 10.03429788 | Chlorella variabilis | 554065 | Plants | Plants | 121 | 4.7199999999999996e-23 | NTclustered | gi|552831009|ref|XM_005847974.1| | 554065 | g73885 | i0 | 91.86 | 7.01990049751244 | 86 | 7 | 43 | 0 | 102 | 187 | 682 | 767 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_145209) mRNA, complete cds | blastn | 1411 | 121 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 16046006 | 16046006 | PRJNA763243_P_NODE_43213_length_269_cov_1.775510_g42867_i0 | PRJNA763243 | 43213 | 269 | 1.77551 | 4.7761219 | Pleurastrum terricola | 34116 | Plants | Plants | 460 | 3.45e-125 | NTclustered | gi|153805558|ref|NC_009681.1| | 34116 | g42867 | i0 | 99.605 | 116.24907063197 | 253 | 0 | 94 | 1 | 14 | 266 | 428 | 177 | Leptosira terrestris chloroplast, complete genome | blastn | 31271 | 460 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Pleurastraceae | Pleurastrum | Pleurastrum terricola | |
| 17322137 | 17322137 | PRJNA763243_P_NODE_63374_length_241_cov_1.339286_g63028_i0 | PRJNA763243 | 63374 | 241 | 1.339286 | 3.22767926 | Volvox carteri | 3067 | Plants | Plants | 167 | 7.429999999999999e-37 | NTclustered | gi|302837497|ref|XM_002950262.1| | 3068 | g63028 | i0 | 80.087 | 44.3983402489627 | 231 | 40 | 95 | 6 | 3 | 230 | 964 | 737 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_81049), partial mRNA | blastn | 10700 | 167 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 17782851 | 17782851 | PRJNA763243_P_NODE_37154_length_284_cov_2.952607_g36808_i0 | PRJNA763243 | 37154 | 284 | 2.952607 | 8.38540388 | Bryopsis | 3128 | Plants | Plants | 348 | 2.99e-91 | NTclustered | gi|969822372|gb|KT950953.1| | 3129 | g36808 | i0 | 88.968 | 94.9964788732394 | 281 | 31 | 99 | 0 | 1 | 281 | 674 | 394 | Bryopsis maxima actin gene, partial cds | blastn | 26979 | 348 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis maxima | |
| 17782944 | 17782944 | PRJNA763243_P_NODE_65774_length_235_cov_10.098765_g65428_i0 | PRJNA763243 | 65774 | 235 | 10.098765 | 23.73209775 | Myrmecia | 13617 | Plants | Plants | 409 | 1.08e-109 | NTclustered | gi|168144|gb|M62995.1|FRIUGEAA | 3171 | g65428 | i0 | 98.696 | 97.3574468085106 | 230 | 3 | 98 | 0 | 4 | 233 | 640 | 869 | Friedmannia israeliensis 18S ribosomal RNA gene | blastn | 22879 | 409 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia israelensis | |
| 21146497 | 21146497 | PRJNA763243_P_NODE_68717_length_226_cov_4.581699_g68371_i0 | PRJNA763243 | 68717 | 226 | 4.581699 | 10.35463974 | Auxenochlorella pyrenoidosa | 3078 | Plants | Plants | 401 | 1.7299999999999993e-107 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g68371 | i0 | 99.545 | 97.287610619469 | 220 | 1 | 97 | 0 | 1 | 220 | 1695 | 1476 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 21987 | 401 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 21607292 | 21607292 | PRJNA763243_P_NODE_15197_length_395_cov_9.583851_g14852_i0 | PRJNA763243 | 15197 | 395 | 9.583851 | 37.856211450000004 | Desmochloris | 138596 | Plants | Plants | 689 | 0 | NTclustered | gi|313476264|emb|FM882217.1| | 578869 | g14852 | i0 | 98.465 | 99.0075949367089 | 391 | 6 | 99 | 0 | 4 | 394 | 572 | 962 | Desmochloris sp. TP-2008 partial 18S rRNA gene, ITS1, 5.8S rRNA and ITS2, strain CCAP 6006/2 | blastn | 39108 | 689 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris mollenhaueri | |
| 22882887 | 22882887 | PRJNA763243_P_NODE_27298_length_312_cov_3.577406_g26952_i0 | PRJNA763243 | 27298 | 312 | 3.577406 | 11.16150672 | Viridiplantae | 33090 | Plants | Plants | 132 | 3.64e-26 | NTclustered | gi|1847694119|ref|NC_048526.1| | 3133 | g26952 | i0 | 87.179 | 60.1314102564103 | 117 | 14 | 37 | 1 | 35 | 150 | 41081 | 41197 | Codium fragile mitochondrion, complete genome | blastn | 18761 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Codiaceae | Codium | Codium fragile | |
| 23696303 | 23696303 | PRJNA763243_P_NODE_42359_length_271_cov_1.555556_g42013_i0 | PRJNA763243 | 42359 | 271 | 1.555556 | 4.21555676 | Pediastrum duplex | 3105 | Plants | Plants | 315 | 2.87e-81 | NTclustered | gi|21040380|gb|AF183479.2| | 3105 | g42013 | i0 | 95.025 | 90.3874538745387 | 201 | 9 | 96 | 1 | 72 | 271 | 3138 | 2938 | Pediastrum duplex strain UTEX LB 1364 28S ribosomal RNA gene, partial sequence | blastn | 24495 | 315 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Pediastrum | Pediastrum duplex | |
| 25431747 | 25431747 | PRJNA763243_P_NODE_12500_length_430_cov_12.198880_g12155_i0 | PRJNA763243 | 12500 | 430 | 12.19888 | 52.455184 | Eukaryota | 2759 | Plants | Plants | 773 | 0 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g12155 | i0 | 99.297 | 95.9906976744186 | 427 | 3 | 99 | 0 | 4 | 430 | 517 | 91 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 41276 | 773 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa |
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);;