contig_metadata
7 rows where bioproject = "PRJNA1123436", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4107720 | 4107720 | PRJNA1123436_P_NODE_89884_length_259_cov_5.978495_g88670_i0 | PRJNA1123436 | 89884 | 259 | 5.978495 | 15.48430205 | Hydractinia carica | 2752231 | Cnidaria | other_Eukaryota | 172 | 1.7399999999999999e-38 | NTclustered | gi|150368568|emb|AM411418.1| | 2752231 | g88670 | i0 | 79.518 | 19.1737451737452 | 249 | 46 | 95 | 5 | 14 | 259 | 468 | 222 | Hydractinia minuta 16S rRNA gene, haplotype Hydractinia minuta mitochondrial partial 16S rRNA variant New Zealand | blastn | 4966 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia carica | |
| 6132778 | 6132778 | PRJNA1123436_P_NODE_76005_length_285_cov_1.641509_g74791_i0 | PRJNA1123436 | 76005 | 285 | 1.641509 | 4.67830065 | Aglaophenia | 308583 | Cnidaria | other_Eukaryota | 202 | 2.4699999999999997e-47 | NTclustered | gi|1551494896|gb|MH282606.1| | 475195 | g74791 | i0 | 91.216 | 52.4912280701754 | 148 | 13 | 52 | 0 | 138 | 285 | 279 | 426 | Aglaophenia lophocarpa voucher DOP C4317 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 14960 | 204 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Aglaopheniidae | Aglaophenia | Aglaophenia lophocarpa | |
| 13034231 | 13034231 | PRJNA1123436_P_NODE_83471_length_271_cov_24.686869_g82257_i0 | PRJNA1123436 | 83471 | 271 | 24.686869 | 66.90141499 | Liriope tetraphylla | 37524 | Cnidaria | other_Eukaryota | 407 | 4.6e-109 | NTclustered | gi|952952540|gb|KT809327.1| | 37524 | g82257 | i0 | 94.981 | 95.5830258302583 | 259 | 13 | 96 | 0 | 13 | 271 | 2581 | 2839 | Liriope tetraphylla mitochondrion, partial genome | blastn | 25903 | 407 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Limnomedusae | Geryoniidae | Liriope | Liriope tetraphylla | |
| 16331750 | 16331750 | PRJNA1123436_P_NODE_128193_length_237_cov_5.140244_g126979_i0 | PRJNA1123436 | 128193 | 237 | 5.140244 | 12.18237828 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 399 | 6.589999999999999e-107 | NTclustered | gi|2889125804|gb|PQ875201.1| | 51068 | g126979 | i0 | 98.667 | 94.6708860759494 | 225 | 3 | 95 | 0 | 13 | 237 | 1630 | 1406 | Sandalolitha robusta isolate 3209F mitochondrion, complete genome | blastn | 22437 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Fungiidae | Sandalolitha | Sandalolitha robusta | |
| 18130984 | 18130984 | PRJNA1123436_P_NODE_128215_length_237_cov_2.487805_g127001_i0 | PRJNA1123436 | 128215 | 237 | 2.487805 | 5.89609785 | Heterocyathus sulcatus | 2962709 | Cnidaria | other_Eukaryota | 375 | 1.1099999999999998e-99 | NTclustered | gi|2289431949|ref|NC_065774.1| | 2962709 | g127001 | i0 | 96.889 | 95.0210970464135 | 225 | 5 | 95 | 2 | 13 | 237 | 17883 | 17661 | Heterocyathus sulcatus mitochondrion, complete genome | blastn | 22520 | 375 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Heterocyathus | Heterocyathus sulcatus | |
| 21956015 | 21956015 | PRJNA1123436_P_NODE_128358_length_234_cov_7.583851_g127144_i0 | PRJNA1123436 | 128358 | 234 | 7.583851 | 17.74621134 | Actinernus elongatus | 1499596 | Cnidaria | other_Eukaryota | 388 | 1.41e-103 | NTclustered | gi|636577067|gb|KJ482930.1| | 1499596 | g127144 | i0 | 98.198 | 95.457264957265 | 222 | 4 | 95 | 0 | 13 | 234 | 320 | 99 | Actinernus elongatus isolate acus 12S small subunit ribosomal RNA (rns) gene, partial sequence; mitochondrial | blastn | 22337 | 388 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinernidae | Actinernus | Actinernus elongatus | |
| 29238458 | 29238458 | PRJNA1123436_P_NODE_126289_length_241_cov_0.916667_g125075_i0 | PRJNA1123436 | 126289 | 241 | 0.916667 | 2.20916747 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 71.6 | 2.47e-12 | NR | XP_057305551.1 | 13093 | g125075 | i0 | 44 | 5.66390041493776 | 75 | 42 | 93.4 | 0 | 17 | 241 | 290 | 364 | XP_057305551.1 elongation factor-like GTPase 1 isoform X1 [Hydractinia symbiolongicarpus] | diamond | 1365 | 71.6 | 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);;