contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA478247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5551420 | 5551420 | PRJNA478247_P_NODE_3585_length_152_cov_1.699187_g3479_i0 | PRJNA478247 | 3585 | 152 | 1.699187 | 2.58276424 | Stichococcus bacillaris | 37433 | Plants | Plants | 248 | 1.48e-61 | NTclustered | gi|115430291|emb|AM260460.1| | 37433 | g3479 | i0 | 96.053 | 99.9736842105263 | 152 | 6 | 100 | 0 | 1 | 152 | 64 | 215 | Stichococcus bacillaris partial 26S rRNA gene, strain SAG 379-1b | blastn | 15196 | 248 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 16399726 | 16399726 | PRJNA478247_P_NODE_2533_length_206_cov_2.457627_g2427_i0 | PRJNA478247 | 2533 | 206 | 2.457627 | 5.06271162 | Eukaryota | 2759 | Plants | Plants | 259 | 9.89e-65 | NTclustered | gi|2082262574|ref|XM_001694020.2| | 3055 | g2427 | i0 | 89.32 | 99.0291262135922 | 206 | 22 | 100 | 0 | 1 | 206 | 304 | 509 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g542250v5), mRNA | blastn | 20400 | 261 | 0.992337164750958 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17025038 | 17025038 | PRJNA478247_P_NODE_1134_length_373_cov_4.517442_g1028_i0 | PRJNA478247 | 1134 | 373 | 4.517442 | 16.85005866 | Valonia macrophysa | 432605 | Plants | Plants | 449 | 1.0799999999999998e-121 | NTclustered | gi|969822378|gb|KT950956.1| | 432605 | g1028 | i0 | 89.548 | 93.0160857908847 | 354 | 37 | 95 | 0 | 20 | 373 | 12 | 365 | Valonia macrophysa isolate 1528 actin gene, partial cds | blastn | 34695 | 449 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Valoniaceae | Valonia | Valonia macrophysa | |
| 22774131 | 22774131 | PRJNA478247_P_NODE_2818_length_189_cov_1.618750_g2712_i0 | PRJNA478247 | 2818 | 189 | 1.61875 | 3.0594375 | Eukaryota | 2759 | Plants | Plants | 104 | 4.41e-18 | NTclustered | gi|2082259818|ref|XM_001690833.2| | 3055 | g2712 | i0 | 85.714 | 1.92063492063492 | 98 | 14 | 52 | 0 | 60 | 157 | 197 | 100 | Chlamydomonas reinhardtii ribosomal protein L18 (CHLRE_12g512600v5), mRNA | blastn | 363 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii |
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);;