contig_metadata
10 rows where bioproject = "PRJNA635397", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1882027 | 1882027 | PRJNA635397_P_NODE_34202_length_271_cov_1.232323_g33748_i0 | PRJNA635397 | 34202 | 271 | 1.232323 | 3.33959533 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|2744853810|ref|XM_065794053.1| | 6087 | g33748 | i0 | 100 | 0.103321033210332 | 28 | 0 | 10 | 0 | 45 | 72 | 1 | 28 | PREDICTED: Hydra vulgaris uncharacterized LOC136078354 (LOC136078354), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 13907735 | 13907735 | PRJNA635397_P_NODE_48491_length_197_cov_4.983871_g48037_i0 | PRJNA635397 | 48491 | 197 | 4.983871 | 9.81822587 | Cystodiscus | 1141733 | Cnidaria | other_Eukaryota | 63.9 | 7.88e-6 | NTclustered | gi|331703992|gb|HQ822182.1| | 1026749 | g48037 | i0 | 84.615 | 21.4162436548223 | 65 | 9 | 32 | 1 | 1 | 64 | 1459 | 1523 | Cystodiscus cf. immersus Brazil 1 isolate CTBR9A01 28S large subunit ribosomal RNA gene, partial sequence | blastn | 4219 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Cystodiscus | Cystodiscus cf. immersus Brazil 1 | |
| 20280155 | 20280155 | PRJNA635397_P_NODE_12956_length_470_cov_1.911839_g12502_i0 | PRJNA635397 | 12956 | 470 | 1.911839 | 8.9856433 | Montipora | 46703 | Cnidaria | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|2812155378|ref|XM_068890345.1| | 246305 | g12502 | i0 | 96.97 | 0.421276595744681 | 33 | 1 | 7 | 0 | 416 | 448 | 1340 | 1308 | PREDICTED: Montipora capricornis myo-inositol 2-dehydrogenase-like (LOC138043856), transcript variant X4, mRNA | blastn | 198 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 21007777 | 21007777 | PRJNA635397_P_NODE_11677_length_501_cov_2.682243_g11224_i0 | PRJNA635397 | 11677 | 501 | 2.682243 | 13.43803743 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 185 | 1.0899999999999995e-55 | NR | CAB4006907.1 | 317549 | g11224 | i0 | 56.1 | 8.01197604790419 | 171 | 67 | 99.4 | 3 | 500 | 3 | 61 | 228 | CAB4006907.1 40S ribosomal S8 [Paramuricea clavata] | diamond | 4014 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 21007825 | 21007825 | PRJNA635397_P_NODE_13957_length_448_cov_3.042667_g13503_i0 | PRJNA635397 | 13957 | 448 | 3.042667 | 13.63114816 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 60.2 | 2.59e-4 | NTclustered | gi|1176113746|ref|XM_020772289.1| | 48498 | g13503 | i0 | 100 | 0.421875 | 32 | 0 | 7 | 0 | 416 | 447 | 646 | 677 | PREDICTED: Orbicella faveolata actin, cytoplasmic-like (LOC110065186), mRNA | blastn | 189 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 22282487 | 22282487 | PRJNA635397_P_NODE_11258_length_513_cov_7.011364_g10805_i0 | PRJNA635397 | 11258 | 513 | 7.011364 | 35.96829732 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.014 | NTclustered | gi|2918369555|emb|OZ237727.1| | 317547 | g10805 | i0 | 96.97 | 0.064327485380117 | 33 | 0 | 6 | 1 | 397 | 428 | 1695045 | 1695077 | Eunicella cavolini genome assembly, chromosome: 11 | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 29828113 | 29828113 | PRJNA635397_P_NODE_29851_length_291_cov_1.325688_g29397_i0 | PRJNA635397 | 29851 | 291 | 1.325688 | 3.85775208 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 44.7 | 0.0122 | NR | XP_044177771.1 | 45264 | g29397 | i0 | 69 | 0.608247422680412 | 29 | 9 | 29.9 | 0 | 5 | 91 | 253 | 281 | XP_044177771.1 uncharacterized protein LOC122960050 [Acropora millepora] | diamond | 177 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 30491759 | 30491759 | PRJNA635397_P_NODE_35393_length_266_cov_1.595855_g34939_i0 | PRJNA635397 | 35393 | 266 | 1.595855 | 4.2449743 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 146 | 2.03e-38 | NR | CAB4035581.1 | 317549 | g34939 | i0 | 75 | 3.96992481203007 | 88 | 22 | 99.2 | 0 | 3 | 266 | 348 | 435 | CAB4035581.1 Retrovirus-related Pol poly from transposon TNT 1-94, partial [Paramuricea clavata] | diamond | 1056 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 32009232 | 32009232 | PRJNA635397_P_NODE_878_length_2010_cov_23.351575_g766_i0 | PRJNA635397 | 878 | 2010 | 23.351575 | 469.3666575 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 48.9 | 0.00757 | NR | KAJ7389166.1 | 174260 | g766 | i0 | 36.3 | 0.135820895522388 | 91 | 45 | 12.7 | 5 | 445 | 699 | 29 | 112 | KAJ7389166.1 hypothetical protein OS493_033252 [Desmophyllum pertusum] | diamond | 273 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 32767509 | 32767509 | PRJNA635397_P_NODE_940_length_1963_cov_23.924868_g766_i1 | PRJNA635397 | 940 | 1963 | 23.924868 | 469.64515884 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 48.9 | 0.00736 | NR | KAJ7389166.1 | 174260 | g766 | i1 | 36.3 | 0.139072847682119 | 91 | 45 | 13 | 5 | 1519 | 1265 | 29 | 112 | KAJ7389166.1 hypothetical protein OS493_033252 [Desmophyllum pertusum] | diamond | 273 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum |
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);;