contig_metadata
10 rows where bioproject = "PRJNA643700" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4446034 | 4446034 | PRJNA643700_P_NODE_94984_length_429_cov_1.355263_g93432_i0 | PRJNA643700 | 94984 | 429 | 1.355263 | 5.81407827 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 56.5 | 0.003 | NTclustered | gi|2917929619|emb|OZ234907.1| | 3350044 | g93432 | i0 | 97.059 | 0.144522144522145 | 34 | 0 | 8 | 1 | 338 | 370 | 468846 | 468879 | Trebouxia sp. SL0000003 genome assembly, chromosome: 2 | blastn | 62 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 7536582 | 7536582 | PRJNA643700_P_NODE_354046_length_183_cov_2.328358_g352490_i0 | PRJNA643700 | 354046 | 183 | 2.328358 | 4.26089514 | Trebouxiaceae | 2507902 | Plants | Plants | 278 | 2.36e-70 | NTclustered | gi|255506491|gb|GQ168957.1| | 41462 | g352490 | i0 | 93.989 | 108.983606557377 | 183 | 11 | 100 | 0 | 1 | 183 | 249 | 67 | Myrmecia bisecta strain SAG 2043 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 19944 | 278 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 14647095 | 14647095 | PRJNA643700_P_NODE_334412_length_193_cov_0.812500_g332856_i0 | PRJNA643700 | 334412 | 193 | 0.8125 | 1.568125 | Rhexinema sarcinoideum | 43261 | Plants | Plants | 52.8 | 0.017 | NTclustered | gi|1052423652|gb|KX306821.1| | 43261 | g332856 | i0 | 100 | 0.145077720207254 | 28 | 0 | 15 | 0 | 63 | 90 | 114637 | 114610 | Rhexinema sarcinoideum chloroplast, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Helicodictyaceae | Rhexinema | Rhexinema sarcinoideum | |
| 18470270 | 18470270 | PRJNA643700_P_NODE_103195_length_410_cov_2.861496_g101641_i0 | PRJNA643700 | 103195 | 410 | 2.861496 | 11.7321336 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 54.7 | 0.011 | NTclustered | gi|2917929620|emb|OZ234908.1| | 3350044 | g101641 | i0 | 94.444 | 0.180487804878049 | 36 | 1 | 9 | 1 | 179 | 213 | 3415715 | 3415750 | Trebouxia sp. SL0000003 genome assembly, chromosome: 3 | blastn | 74 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 22295136 | 22295136 | PRJNA643700_P_NODE_147118_length_336_cov_3.411150_g145563_i0 | PRJNA643700 | 147118 | 336 | 3.41115 | 11.461464 | Haematococcus lacustris | 44745 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|1337018090|gb|MG677935.1| | 44745 | g145563 | i0 | 94.595 | 0.220238095238095 | 37 | 1 | 11 | 1 | 295 | 331 | 805185 | 805220 | Haematococcus lacustris strain UTEX 2505 chloroplast, complete genome | blastn | 74 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 23570839 | 23570839 | PRJNA643700_P_NODE_253859_length_237_cov_1.228723_g252303_i0 | PRJNA643700 | 253859 | 237 | 1.228723 | 2.91207351 | Hyalomonas oviformis | 40531 | Plants | Plants | 52.8 | 0.021 | NTclustered | gi|2386956266|ref|NC_068624.1| | 40531 | g252303 | i0 | 96.774 | 0.130801687763713 | 31 | 1 | 13 | 0 | 90 | 120 | 49594 | 49564 | Hyalomonas oviformis strain SAG62-27 chloroplast, complete genome | blastn | 31 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Hyalomonas | Hyalomonas oviformis | |
| 23570952 | 23570952 | PRJNA643700_P_NODE_388619_length_169_cov_0.866667_g387063_i0 | PRJNA643700 | 388619 | 169 | 0.866667 | 1.46466723 | Trebouxia aggregata | 160068 | Plants | Plants | 52.8 | 0.014 | NTclustered | gi|162134382|gb|EU123993.1| | 160068 | g387063 | i0 | 100 | 0.165680473372781 | 28 | 0 | 17 | 0 | 30 | 57 | 2505 | 2532 | Trebouxia aggregata strain SAG 219-1d small-subunit ribosomal RNA (rrs), 5S ribosomal RNA (rrf), and tRNA-Gly (trnG(gcc)) genes, complete sequence; chloroplast | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 28881212 | 28881212 | PRJNA643700_P_NODE_146368_length_337_cov_3.604167_g144813_i0 | PRJNA643700 | 146368 | 337 | 3.604167 | 12.14604279 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 44.3 | 0.0278 | NR | XP_042921633.1 | 3055 | g144813 | i0 | 48.7 | 0.347181008902077 | 39 | 20 | 34.7 | 0 | 149 | 33 | 4 | 42 | XP_042921633.1 uncharacterized protein CHLRE_09g413700v5 [Chlamydomonas reinhardtii] | diamond | 117 | 44.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 29291735 | 29291735 | PRJNA643700_P_NODE_252689_length_238_cov_0.825397_g251133_i0 | PRJNA643700 | 252689 | 238 | 0.825397 | 1.96444486 | Volvox africanus | 51714 | Plants | Plants | 42.4 | 0.0496 | NR | GIL47893.1 | 51714 | g251133 | i0 | 42.9 | 1.41176470588235 | 56 | 31 | 70.6 | 1 | 178 | 11 | 162 | 216 | GIL47893.1 hypothetical protein Vafri_4524 [Volvox africanus] | diamond | 336 | 42.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 32041207 | 32041207 | PRJNA643700_P_NODE_241658_length_245_cov_1.969388_g240102_i0 | PRJNA643700 | 241658 | 245 | 1.969388 | 4.8250006 | Flabellia petiolata | 189428 | Plants | Plants | 43.9 | 0.0146 | NR | AYC63916.1 | 189428 | g240102 | i0 | 36.4 | 0.538775510204082 | 44 | 28 | 53.9 | 0 | 201 | 70 | 162 | 205 | AYC63916.1 hypothetical protein [Flabellia petiolata] | diamond | 132 | 43.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Halimedaceae | Flabellia | Flabellia petiolata |
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);;