contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA515078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1762139 | 1762139 | PRJNA515078_P_NODE_3942_length_487_cov_10.377778_g3710_i0 | PRJNA515078 | 3942 | 487 | 10.377778 | 50.53977886 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 398 | 5.2899999999999975e-106 | NTclustered | gi|2519013169|ref|XM_057457998.1| | 13093 | g3710 | i0 | 81.557 | 158.560574948665 | 488 | 84 | 99 | 6 | 1 | 485 | 284 | 768 | PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C (LOC130655264), mRNA | blastn | 77219 | 398 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 3038008 | 3038008 | PRJNA515078_P_NODE_8263_length_319_cov_1.517730_g8030_i0 | PRJNA515078 | 8263 | 319 | 1.51773 | 4.8415587 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 65.8 | 3.84e-6 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g8030 | i0 | 93.182 | 2.70532915360502 | 44 | 3 | 14 | 0 | 261 | 304 | 20600740 | 20600697 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 863 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 6864653 | 6864653 | PRJNA515078_P_NODE_30366_length_159_cov_0.959016_g30133_i0 | PRJNA515078 | 30366 | 159 | 0.959016 | 1.52483544 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 128 | 2.13e-25 | NTclustered | gi|2782846292|ref|XM_067056275.1| | 252671 | g30133 | i0 | 87.387 | 18.1194968553459 | 111 | 14 | 70 | 0 | 23 | 133 | 930 | 1040 | PREDICTED: Clytia hemisphaerica 26S proteasome regulatory subunit 8 (LOC136799556), mRNA | blastn | 2881 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 10690526 | 10690526 | PRJNA515078_P_NODE_12049_length_256_cov_13.721461_g11816_i0 | PRJNA515078 | 12049 | 256 | 13.721461 | 35.12694016 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 211 | 3.63e-50 | NTclustered | gi|2519013169|ref|XM_057457998.1| | 13093 | g11816 | i0 | 82.645 | 71.75390625 | 242 | 38 | 94 | 4 | 3 | 242 | 540 | 301 | PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C (LOC130655264), mRNA | blastn | 18369 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 11965485 | 11965485 | PRJNA515078_P_NODE_10610_length_276_cov_2.602510_g10377_i0 | PRJNA515078 | 10610 | 276 | 2.60251 | 7.1829276 | Calycella syringa | 314529 | Cnidaria | other_Eukaryota | 122 | 1.9099999999999998e-23 | NTclustered | gi|256674468|gb|FJ550372.1| | 314529 | g10377 | i0 | 86.087 | 36.1992753623188 | 115 | 14 | 41 | 2 | 152 | 265 | 1567 | 1454 | Calycella syringa 28S ribosomal RNA gene, partial sequence | blastn | 9991 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Campanulariidae | Calycella | Calycella syringa | |
| 13864753 | 13864753 | PRJNA515078_P_NODE_29571_length_161_cov_0.862903_g29338_i0 | PRJNA515078 | 29571 | 161 | 0.862903 | 1.38927383 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 58.4 | 2.87e-4 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g29338 | i0 | 100 | 10.9192546583851 | 31 | 0 | 19 | 0 | 7 | 37 | 21150140 | 21150110 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 1758 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 19612981 | 19612981 | PRJNA515078_P_NODE_5116_length_421_cov_1.421875_g4883_i0 | PRJNA515078 | 5116 | 421 | 1.421875 | 5.98609375 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2917940731|emb|OZ237564.1| | 6108 | g4883 | i0 | 100 | 3.77672209026128 | 30 | 0 | 7 | 0 | 149 | 178 | 995552 | 995523 | Anemonia sulcata genome assembly, chromosome: 10 | blastn | 1590 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 22788012 | 22788012 | PRJNA515078_P_NODE_29278_length_161_cov_1.572581_g29045_i0 | PRJNA515078 | 29278 | 161 | 1.572581 | 2.53185541 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 148 | 1.6599999999999998e-31 | NTclustered | gi|2518959458|ref|XM_057433663.1| | 13093 | g29045 | i0 | 86.567 | 85.9316770186335 | 134 | 18 | 83 | 0 | 24 | 157 | 1184 | 1317 | PREDICTED: Hydractinia symbiolongicarpus endoplasmic reticulum chaperone BiP-like (LOC130612358), mRNA | blastn | 13835 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus |
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);;