contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA700095" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6288306 | 6288306 | PRJNA700095_P_NODE_66945_length_236_cov_5.723926_g65681_i0 | PRJNA700095 | 66945 | 236 | 5.723926 | 13.50846536 | Ellisella | 328399 | Cnidaria | other_Eukaryota | 97.1 | 9.64e-16 | NTclustered | gi|2689317297|gb|PP410744.1| | 2751895 | g65681 | i0 | 95.161 | 24.0042372881356 | 62 | 2 | 26 | 1 | 155 | 216 | 3528 | 3588 | Ellisella elongata voucher USNM:1660444 large subunit ribosomal RNA gene, partial sequence | blastn | 5665 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Ellisellidae | Ellisella | Ellisella elongata | |
| 8336280 | 8336280 | PRJNA700095_P_NODE_17507_length_430_cov_19.109244_g16244_i0 | PRJNA700095 | 17507 | 430 | 19.109244 | 82.1697492 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 207 | 8.37e-49 | NTclustered | gi|2918369552|emb|OZ237724.1| | 317547 | g16244 | i0 | 82.627 | 4.61395348837209 | 236 | 39 | 55 | 2 | 125 | 359 | 198087 | 197853 | Eunicella cavolini genome assembly, chromosome: 8 | blastn | 1984 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 9611647 | 9611647 | PRJNA700095_P_NODE_30548_length_309_cov_2.576271_g29284_i0 | PRJNA700095 | 30548 | 309 | 2.576271 | 7.96067739 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 75 | 6.16e-9 | NTclustered | gi|2202626640|ref|XM_046990664.1| | 2897299 | g29284 | i0 | 86.567 | 0.867313915857605 | 67 | 9 | 22 | 0 | 135 | 201 | 2534 | 2600 | PREDICTED: Xenia sp. Carnegie-2017 deleted in malignant brain tumors 1 protein-like (LOC124440303), transcript variant X4, mRNA | blastn | 268 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 15212781 | 15212781 | PRJNA700095_P_NODE_40332_length_275_cov_1.450495_g39068_i0 | PRJNA700095 | 40332 | 275 | 1.450495 | 3.98886125 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 91.6 | 5.36e-14 | NTclustered | gi|2744908866|ref|XM_065819693.1| | 6087 | g39068 | i0 | 98.077 | 11.3345454545455 | 52 | 1 | 19 | 0 | 217 | 268 | 434 | 485 | PREDICTED: Hydra vulgaris uncharacterized LOC136091973 (LOC136091973), mRNA | blastn | 3117 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris |
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);;