contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA550047" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6896394 | 6896394 | PRJNA550047_P_NODE_68226_length_345_cov_12.735294_g66266_i0 | PRJNA550047 | 68226 | 345 | 12.735294 | 43.9367643 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|2917940703|emb|OZ237559.1| | 6108 | g66266 | i0 | 94.286 | 0.101449275362319 | 35 | 1 | 10 | 1 | 31 | 65 | 16590595 | 16590628 | Anemonia sulcata genome assembly, chromosome: 5 | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 11324933 | 11324933 | PRJNA550047_P_NODE_502009_length_230_cov_2.273885_g500036_i0 | PRJNA550047 | 502009 | 230 | 2.273885 | 5.2299355 | Actiniaria | 6103 | Cnidaria | other_Eukaryota | 86.1 | 2.02e-12 | NTclustered | gi|1573349586|gb|MK519645.1| | 6118 | g500036 | i0 | 88.571 | 31.5 | 70 | 8 | 30 | 0 | 64 | 133 | 421 | 352 | Entacmaea quadricolor voucher E_quadricolor_TGEQ9 large subunit ribosomal RNA gene, partial sequence | blastn | 7245 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Entacmaea | Entacmaea quadricolor | |
| 14542479 | 14542479 | PRJNA550047_P_NODE_203552_length_337_cov_2.837121_g201590_i0 | PRJNA550047 | 203552 | 337 | 2.837121 | 9.56109777 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|2744838618|ref|XM_065787177.1| | 6087 | g201590 | i0 | 100 | 0.249258160237389 | 28 | 0 | 8 | 0 | 131 | 158 | 1302 | 1275 | PREDICTED: Hydra vulgaris uncharacterized LOC136074994 (LOC136074994), transcript variant X3, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 15815861 | 15815861 | PRJNA550047_P_NODE_159693_length_345_cov_4.091912_g157733_i0 | PRJNA550047 | 159693 | 345 | 4.091912 | 14.1170964 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2917940744|emb|OZ237568.1| | 6108 | g157733 | i0 | 96.97 | 0.257971014492754 | 33 | 1 | 10 | 0 | 310 | 342 | 4577865 | 4577833 | Anemonia sulcata genome assembly, chromosome: 14 | blastn | 89 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 19639828 | 19639828 | PRJNA550047_P_NODE_201376_length_342_cov_3.877323_g199415_i0 | PRJNA550047 | 201376 | 342 | 3.877323 | 13.26044466 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|1691426760|gb|MK253652.1| | 45351 | g199415 | i0 | 100 | 0.409356725146199 | 28 | 0 | 8 | 0 | 121 | 148 | 12945 | 12918 | Nematostella vectensis cadherin 3 mRNA, complete cds | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 23467260 | 23467260 | PRJNA550047_P_NODE_317359_length_295_cov_3.918919_g315390_i0 | PRJNA550047 | 317359 | 295 | 3.918919 | 11.56081105 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 512 | 1.04e-140 | NTclustered | gi|2744886754|ref|XM_065809437.1| | 6087 | g315390 | i0 | 97.966 | 14.7830508474576 | 295 | 6 | 100 | 0 | 1 | 295 | 46 | 340 | PREDICTED: Hydra vulgaris uncharacterized LOC136086936 (LOC136086936), mRNA | blastn | 4361 | 512 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 23471038 | 23471038 | PRJNA550047_P_NODE_74279_length_345_cov_11.602941_g72319_i0 | PRJNA550047 | 74279 | 345 | 11.602941 | 40.03014645 | Umbellula sp. 2 RH-2019 | 2598118 | Cnidaria | other_Eukaryota | 196 | 1.43e-45 | NTclustered | gi|2160785911|gb|OL741705.1| | 2598118 | g72319 | i0 | 91.034 | 46.3159420289855 | 145 | 13 | 42 | 0 | 197 | 341 | 4944 | 4800 | Umbellula sp. NMS.Z.2019.25.13 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15979 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Umbellulidae | Umbellula | Umbellula sp. 2 RH-2019 | |
| 24745059 | 24745059 | PRJNA550047_P_NODE_94160_length_345_cov_9.007353_g92200_i0 | PRJNA550047 | 94160 | 345 | 9.007353 | 31.07536785 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 89.8 | 2.49e-13 | NTclustered | gi|2519013169|ref|XM_057457998.1| | 13093 | g92200 | i0 | 89.855 | 4.0463768115942 | 69 | 7 | 20 | 0 | 277 | 345 | 301 | 369 | PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C (LOC130655264), mRNA | blastn | 1396 | 89.8 | 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);;