contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA674308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7023519 | 7023519 | PRJNA674308_P_NODE_44166_length_166_cov_0.888889_g43931_i0 | PRJNA674308 | 44166 | 166 | 0.888889 | 1.47555574 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 63.9 | 6.42e-6 | NTclustered | gi|2918369563|emb|OZ237729.1| | 317547 | g43931 | i0 | 97.297 | 6.18072289156626 | 37 | 1 | 22 | 0 | 2 | 38 | 12151987 | 12152023 | Eunicella cavolini genome assembly, chromosome: 13 | blastn | 1026 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 16469308 | 16469308 | PRJNA674308_P_NODE_14853_length_250_cov_50.651741_g14618_i0 | PRJNA674308 | 14853 | 250 | 50.651741 | 126.6293525 | Ellisella | 328399 | Cnidaria | other_Eukaryota | 97.1 | 1.03e-15 | NTclustered | gi|2689317297|gb|PP410744.1| | 2751895 | g14618 | i0 | 95.161 | 22.66 | 62 | 2 | 25 | 1 | 169 | 230 | 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 | |
| 22321983 | 22321983 | PRJNA674308_P_NODE_22818_length_208_cov_1.308176_g22583_i0 | PRJNA674308 | 22818 | 208 | 1.308176 | 2.72100608 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|2918369551|emb|OZ237723.1| | 317547 | g22583 | i0 | 100 | 0.134615384615385 | 28 | 0 | 13 | 0 | 119 | 146 | 15179012 | 15178985 | Eunicella cavolini genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 22844065 | 22844065 | PRJNA674308_P_NODE_34918_length_171_cov_1.704918_g34683_i0 | PRJNA674308 | 34918 | 171 | 1.704918 | 2.91540978 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 62.1 | 2.38e-5 | NTclustered | gi|2744830952|ref|XM_002165653.5| | 6087 | g34683 | i0 | 92.857 | 0.976608187134503 | 42 | 3 | 25 | 0 | 51 | 92 | 433 | 392 | PREDICTED: Hydra vulgaris protein DD3-3 (LOC100210880), transcript variant X1, mRNA | blastn | 167 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 23597456 | 23597456 | PRJNA674308_P_NODE_18139_length_229_cov_1.666667_g17904_i0 | PRJNA674308 | 18139 | 229 | 1.666667 | 3.81666743 | Physonectae sp. | 3052288 | Cnidaria | other_Eukaryota | 206 | 1.48e-48 | NTclustered | gi|2523517676|gb|OQ957211.1| | 3052288 | g17904 | i0 | 83.043 | 96.471615720524 | 230 | 36 | 99 | 1 | 1 | 227 | 962 | 1191 | Physonectae sp. mitochondrion, complete genome | blastn | 22092 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Siphonophorae | Physonectae sp. | |||
| 23597777 | 23597777 | PRJNA674308_P_NODE_5459_length_406_cov_1.862745_g5224_i0 | PRJNA674308 | 5459 | 406 | 1.862745 | 7.5627447 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 265 | 4.6e-66 | NTclustered | gi|2744868955|ref|XM_065801111.1| | 6087 | g5224 | i0 | 79.275 | 40.4187192118227 | 386 | 74 | 94 | 5 | 19 | 401 | 1012 | 1394 | PREDICTED: Hydra vulgaris transitional endoplasmic reticulum ATPase (LOC100205318), mRNA | blastn | 16410 | 265 | 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);;