contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJEB17675" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3847888 | 3847888 | PRJEB17675_P_NODE_4024_length_488_cov_2.814570_g3733_i0 | PRJEB17675 | 4024 | 488 | 2.81457 | 13.7351016 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 431 | 5.229999999999998e-116 | NTclustered | gi|2082262214|ref|XM_001693945.2| | 3055 | g3733 | i0 | 84.687 | 117.934426229508 | 431 | 66 | 88 | 0 | 1 | 431 | 541 | 111 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g549550v5), mRNA | blastn | 57552 | 431 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 5124059 | 5124059 | PRJEB17675_P_NODE_16685_length_196_cov_1.434783_g16381_i0 | PRJEB17675 | 16685 | 196 | 1.434783 | 2.81217468 | Monoraphidium neglectum | 145388 | Plants | Plants | 54.7 | 0.005 | NTclustered | gi|926784117|ref|XM_014045079.1| | 145388 | g16381 | i0 | 96.875 | 0.306122448979592 | 32 | 1 | 16 | 0 | 74 | 105 | 1968 | 1999 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 60 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 6088956 | 6088956 | PRJEB17675_P_NODE_1765_length_736_cov_6.613409_g1550_i0 | PRJEB17675 | 1765 | 736 | 6.613409 | 48.67469024 | Eukaryota | 2759 | Plants | Plants | 202 | 6.92e-47 | NTclustered | gi|2082240135|ref|XM_001699602.2| | 3055 | g1550 | i0 | 87.429 | 20.7513586956522 | 175 | 22 | 24 | 0 | 223 | 397 | 74 | 248 | Chlamydomonas reinhardtii ribosomal protein L27a (CHLRE_02g115200v5), mRNA | blastn | 15273 | 204 | 0.990196078431373 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 6088958 | 6088958 | PRJEB17675_P_NODE_1865_length_719_cov_6.814327_g1641_i0 | PRJEB17675 | 1865 | 719 | 6.814327 | 48.99501113 | Eukaryota | 2759 | Plants | Plants | 202 | 6.749999999999999e-47 | NTclustered | gi|2082240135|ref|XM_001699602.2| | 3055 | g1641 | i0 | 87.429 | 21.2420027816412 | 175 | 22 | 24 | 0 | 323 | 497 | 248 | 74 | Chlamydomonas reinhardtii ribosomal protein L27a (CHLRE_02g115200v5), mRNA | blastn | 15273 | 204 | 0.990196078431373 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 12465013 | 12465013 | PRJEB17675_P_NODE_1770_length_735_cov_6.528571_g1555_i0 | PRJEB17675 | 1770 | 735 | 6.528571 | 47.98499685 | Eukaryota | 2759 | Plants | Plants | 292 | 3.98e-74 | NTclustered | gi|926781221|ref|XM_014043631.1| | 145388 | g1555 | i0 | 89.868 | 90.8843537414966 | 227 | 23 | 31 | 0 | 368 | 594 | 227 | 1 | Monoraphidium neglectum large subunit ribosomal protein L40e mRNA | blastn | 66800 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 12465019 | 12465019 | PRJEB17675_P_NODE_2330_length_644_cov_6.709360_g2088_i0 | PRJEB17675 | 2330 | 644 | 6.70936 | 43.2082784 | Eukaryota | 2759 | Plants | Plants | 202 | 6.01e-47 | NTclustered | gi|2082240135|ref|XM_001699602.2| | 3055 | g2088 | i0 | 87.429 | 22.7003105590062 | 175 | 22 | 27 | 0 | 410 | 584 | 248 | 74 | Chlamydomonas reinhardtii ribosomal protein L27a (CHLRE_02g115200v5), mRNA | blastn | 14619 | 204 | 0.990196078431373 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 12775271 | 12775271 | PRJEB17675_P_NODE_451_length_1311_cov_11.423981_g340_i1 | PRJEB17675 | 451 | 1311 | 11.423981 | 149.76839091 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 1157 | 0 | NTclustered | gi|2082262214|ref|XM_001693945.2| | 3055 | g340 | i1 | 83.386 | 93.604118993135 | 1258 | 199 | 96 | 9 | 2 | 1254 | 1363 | 111 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g549550v5), mRNA | blastn | 122715 | 1157 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 15323824 | 15323824 | PRJEB17675_P_NODE_19373_length_178_cov_0.832168_g19069_i0 | PRJEB17675 | 19373 | 178 | 0.832168 | 1.48125904 | Mantoniella tinhauana | 3097027 | Plants | Plants | 158 | 3.1e-34 | NTclustered | gi|2735153280|gb|CP140065.1| | 3097027 | g19069 | i0 | 85.43 | 3.58988764044944 | 151 | 22 | 85 | 0 | 1 | 151 | 1233419 | 1233269 | Mantoniella tinhauana isolate LFS chromosome 4 | blastn | 639 | 158 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 20422338 | 20422338 | PRJEB17675_P_NODE_13217_length_228_cov_3.554404_g12913_i0 | PRJEB17675 | 13217 | 228 | 3.554404 | 8.10404112 | Nephroselmis astigmatica | 259378 | Plants | Plants | 100 | 7.16e-17 | NTclustered | gi|371782113|emb|HE610145.1| | 259378 | g12913 | i0 | 83.036 | 6.43859649122807 | 112 | 17 | 49 | 2 | 68 | 178 | 3736 | 3846 | Nephroselmis astigmatica 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain NIES N-252 | blastn | 1468 | 100 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Nephroselmidophyceae | Nephroselmidales | Nephroselmidaceae | Nephroselmis | Nephroselmis astigmatica | ||
| 20422407 | 20422407 | PRJEB17675_P_NODE_5517_length_407_cov_10.102151_g5218_i0 | PRJEB17675 | 5517 | 407 | 10.102151 | 41.11575457 | Micromonas commoda | 296587 | Plants | Plants | 158 | 8.05e-34 | NTclustered | gi|255080797|ref|XM_002503926.1| | 296587 | g5218 | i0 | 81.218 | 11.5528255528256 | 197 | 35 | 48 | 2 | 184 | 379 | 371 | 176 | Micromonas commoda predicted protein mRNA | blastn | 4702 | 158 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 21387980 | 21387980 | PRJEB17675_P_NODE_4157_length_481_cov_2.762332_g3863_i0 | PRJEB17675 | 4157 | 481 | 2.762332 | 13.28681692 | Eukaryota | 2759 | Plants | Plants | 723 | 0 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g3863 | i0 | 93.958 | 95.9147609147609 | 480 | 25 | 99 | 4 | 1 | 479 | 48 | 524 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 46135 | 723 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 23938218 | 23938218 | PRJEB17675_P_NODE_3299_length_540_cov_7.239604_g3020_i0 | PRJEB17675 | 3299 | 540 | 7.239604 | 39.0938616 | Eukaryota | 2759 | Plants | Plants | 202 | 4.979999999999999e-47 | NTclustered | gi|2082240135|ref|XM_001699602.2| | 3055 | g3020 | i0 | 87.429 | 26.8074074074074 | 175 | 22 | 32 | 0 | 61 | 235 | 74 | 248 | Chlamydomonas reinhardtii ribosomal protein L27a (CHLRE_02g115200v5), mRNA | blastn | 14476 | 204 | 0.990196078431373 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 24247484 | 24247484 | PRJEB17675_P_NODE_1960_length_702_cov_2.893553_g1728_i0 | PRJEB17675 | 1960 | 702 | 2.893553 | 20.31274206 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 56.5 | 0.005 | NTclustered | gi|2082250453|ref|XM_001690409.2| | 3055 | g1728 | i0 | 100 | 0.0427350427350427 | 30 | 0 | 4 | 0 | 188 | 217 | 206 | 177 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_07g328350v5), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 24247486 | 24247486 | PRJEB17675_P_NODE_20040_length_173_cov_3.427536_g19736_i0 | PRJEB17675 | 20040 | 173 | 3.427536 | 5.92963728 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 91.6 | 3.08e-14 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g19736 | i0 | 88.312 | 3.35838150289017 | 77 | 8 | 44 | 1 | 12 | 87 | 86129 | 86205 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 581 | 91.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 |
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);;