contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJEB17675" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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);;