contig_metadata
10 rows where bioproject = "PRJNA1159911", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 308174 | 308174 | PRJNA1159911_P_NODE_62081_length_304_cov_1.779221_g61539_i0 | PRJNA1159911 | 62081 | 304 | 1.779221 | 5.40883184 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 124 | 5.919999999999999e-24 | NTclustered | gi|2782925344|ref|XM_067072791.1| | 252671 | g61539 | i0 | 91.209 | 1.53947368421053 | 91 | 8 | 31 | 0 | 69 | 159 | 3289 | 3199 | PREDICTED: Clytia hemisphaerica protein transport protein Sec31A-like (LOC136816463), transcript variant X2, mRNA | blastn | 468 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 6685606 | 6685606 | PRJNA1159911_P_NODE_39646_length_405_cov_1.710843_g39104_i0 | PRJNA1159911 | 39646 | 405 | 1.710843 | 6.92891415 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.039 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g39104 | i0 | 100 | 0.0691358024691358 | 28 | 0 | 7 | 0 | 228 | 255 | 7069975 | 7069948 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 11786970 | 11786970 | PRJNA1159911_P_NODE_70050_length_283_cov_2.414286_g69508_i0 | PRJNA1159911 | 70050 | 283 | 2.414286 | 6.83242938 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 207 | 5.27e-49 | NTclustered | gi|2918369552|emb|OZ237724.1| | 317547 | g69508 | i0 | 82.627 | 6.50883392226148 | 236 | 39 | 83 | 2 | 11 | 245 | 198087 | 197853 | Eunicella cavolini genome assembly, chromosome: 8 | blastn | 1842 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 28101847 | 28101847 | PRJNA1159911_P_NODE_15385_length_783_cov_1.677465_g14905_i0 | PRJNA1159911 | 15385 | 783 | 1.677465 | 13.13455095 | root | 1 | Root_unresolved | Root_unresolved | 218 | 6.37e-63 | NR | KAJ7394266.1 | 174260 | g14905 | i0 | 54.2 | 8.38314176245211 | 214 | 88 | 82 | 2 | 759 | 118 | 387 | 590 | KAJ7394266.1 NADP-dependent malic enzyme [Desmophyllum pertusum] | diamond | 6564 | 218 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 28133721 | 28133721 | PRJNA1159911_P_NODE_51445_length_341_cov_2.324627_g50903_i0 | PRJNA1159911 | 51445 | 341 | 2.324627 | 7.92697807 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 55.8 | 2.57e-6 | NR | XP_001626688.3 | 45351 | g50903 | i0 | 58.1 | 1.51319648093842 | 43 | 18 | 37.8 | 0 | 175 | 303 | 201 | 243 | XP_001626688.3 cathepsin B [Nematostella vectensis] | diamond | 516 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 29680375 | 29680375 | PRJNA1159911_P_NODE_75110_length_272_cov_1.949749_g74568_i0 | PRJNA1159911 | 75110 | 272 | 1.949749 | 5.30331728 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 195 | 1.39e-59 | NR | XP_065663188.1 | 6087 | g74568 | i0 | 97.8 | 396.055147058824 | 90 | 2 | 99.3 | 0 | 272 | 3 | 97 | 186 | XP_065663188.1 serine/threonine-protein phosphatase alpha-2 isoform [Hydra vulgaris] | diamond | 107727 | 196 | 0.994897959183674 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30091128 | 30091128 | PRJNA1159911_P_NODE_102112_length_238_cov_2.266667_g101570_i0 | PRJNA1159911 | 102112 | 238 | 2.266667 | 5.39466746 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99.8 | 2.59e-22 | NR | XP_002163107.3 | 6087 | g101570 | i0 | 68 | 5.72268907563025 | 75 | 24 | 94.5 | 0 | 6 | 230 | 416 | 490 | XP_002163107.3 T-complex protein 1 subunit beta [Hydra vulgaris] | diamond | 1362 | 100 | 0.998 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31304260 | 31304260 | PRJNA1159911_P_NODE_51155_length_342_cov_2.457249_g50613_i0 | PRJNA1159911 | 51155 | 342 | 2.457249 | 8.40379158 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 65.9 | 1.89e-10 | NR | XP_046853964.1 | 2897299 | g50613 | i0 | 59.2 | 3.58771929824561 | 49 | 19 | 43 | 1 | 1 | 147 | 145 | 192 | XP_046853964.1 probable phospholipid hydroperoxide glutathione peroxidase [Xenia sp. Carnegie-2017] | diamond | 1227 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 31513671 | 31513671 | PRJNA1159911_P_NODE_71216_length_281_cov_1.009615_g70674_i0 | PRJNA1159911 | 71216 | 281 | 1.009615 | 2.83701815 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 72.4 | 2.17e-12 | NR | XP_044180321.1 | 45264 | g70674 | i0 | 44.7 | 3.6085409252669 | 85 | 36 | 90.7 | 3 | 14 | 268 | 549 | 622 | XP_044180321.1 uncharacterized protein LOC114977403 [Acropora millepora] | diamond | 1014 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 32538307 | 32538307 | PRJNA1159911_P_NODE_67259_length_290_cov_1.589862_g66717_i0 | PRJNA1159911 | 67259 | 290 | 1.589862 | 4.6105998 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 70.5 | 5.52e-12 | NR | KAK3753335.1 | 3060491 | g66717 | i0 | 42.3 | 1.5 | 104 | 43 | 95.2 | 4 | 276 | 1 | 39 | 137 | KAK3753335.1 hypothetical protein QZH41_015270 [Actinostola sp. cb2023] | diamond | 435 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 |
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);;