contig_metadata
4 rows where bioproject = "PRJNA543299" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3669950 | 3669950 | PRJNA543299_P_NODE_8543_length_254_cov_1.429268_g8386_i0 | PRJNA543299 | 8543 | 254 | 1.429268 | 3.63034072 | Tetradesmus | 91192 | Plants | Plants | 459 | 1.1599999999999999e-124 | NTclustered | gi|356494235|gb|JN169784.1| | 3088 | g8386 | i0 | 99.213 | 99.7086614173228 | 254 | 2 | 100 | 0 | 1 | 254 | 566 | 313 | Scenedesmus obliquus isolate RAIW04 large subunit ribosomal RNA gene, partial sequence | blastn | 25326 | 459 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 6222250 | 6222250 | PRJNA543299_P_NODE_12085_length_215_cov_1.614458_g11928_i0 | PRJNA543299 | 12085 | 215 | 1.614458 | 3.4710847 | Scenedesmaceae | 3086 | Plants | Plants | 381 | 2.1299999999999996e-101 | NTclustered | gi|2581663370|gb|OR350844.1| | 3062090 | g11928 | i0 | 98.605 | 131.706976744186 | 215 | 3 | 100 | 0 | 1 | 215 | 106736 | 106522 | Coccoidesmus tetrasporum chloroplast, complete genome | blastn | 28317 | 381 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Coccoidesmus | Coccoidesmus tetrasporum | |
| 13263574 | 13263574 | PRJNA543299_P_NODE_7051_length_278_cov_1.336245_g6894_i0 | PRJNA543299 | 7051 | 278 | 1.336245 | 3.7147611 | Corbierea radiosa | 51318 | Plants | Plants | 501 | 2.11e-137 | NTclustered | gi|18654306|gb|L42987.1|RTCCPRGOLB | 51318 | g6894 | i0 | 99.281 | 135.086330935252 | 278 | 1 | 100 | 1 | 1 | 278 | 545 | 821 | Carteria radiosa large subunit ribosomal RNA gene, complete sequence; chloroplast gene for chloroplast product | blastn | 37554 | 501 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Corbierea | Corbierea radiosa | |
| 13872505 | 13872505 | PRJNA543299_P_NODE_22131_length_165_cov_0.879310_g21974_i0 | PRJNA543299 | 22131 | 165 | 0.87931 | 1.4508615 | Chlorellaceae | 35461 | Plants | Plants | 272 | 9.73e-69 | NTclustered | gi|1768906865|gb|MN128434.1| | 3078 | g21974 | i0 | 96.914 | 200.018181818182 | 162 | 5 | 98 | 0 | 4 | 165 | 51297 | 51136 | Auxenochlorella pyrenoidosa isolate FACHB-5 chloroplast, complete genome | blastn | 33003 | 272 | 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);;