contig_metadata
16 rows where bioproject = "PRJNA576995", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1136971 | 1136971 | PRJNA576995_P_NODE_26001_length_299_cov_3.353982_g25409_i0 | PRJNA576995 | 26001 | 299 | 3.353982 | 10.02840618 | Acropora | 6127 | Cnidaria | other_Eukaryota | 166 | 1.08e-50 | NR | XP_029193069.2 | 45264 | g25409 | i0 | 82.5 | 1.94648829431438 | 97 | 17 | 97.3 | 0 | 293 | 3 | 19 | 115 | XP_029193069.2 40S ribosomal protein S15a isoform X1 [Acropora millepora] | diamond | 582 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 4387909 | 4387909 | PRJNA576995_P_NODE_13524_length_409_cov_1.901786_g12932_i0 | PRJNA576995 | 13524 | 409 | 1.901786 | 7.77830474 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.039 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g12932 | i0 | 100 | 0.0684596577017115 | 28 | 0 | 7 | 0 | 2 | 29 | 20052075 | 20052048 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13314880 | 13314880 | PRJNA576995_P_NODE_40651_length_244_cov_1.175439_g40059_i0 | PRJNA576995 | 40651 | 244 | 1.175439 | 2.86807116 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2729074993|ref|XM_065199736.1| | 499914 | g40059 | i0 | 100 | 0.122950819672131 | 30 | 0 | 12 | 0 | 188 | 217 | 2154 | 2125 | PREDICTED: Rhopilema esculentum uncharacterized LOC135684265 (LOC135684265), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 15863333 | 15863333 | PRJNA576995_P_NODE_23813_length_312_cov_2.368201_g23221_i0 | PRJNA576995 | 23813 | 312 | 2.368201 | 7.38878712 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 113 | 8.86e-28 | NR | CAB3998061.1 | 317549 | g23221 | i0 | 55.9 | 6.375 | 93 | 41 | 89.4 | 0 | 27 | 305 | 10 | 102 | CAB3998061.1 60S acidic ribosomal P0-like [Paramuricea clavata] | diamond | 1989 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 20263467 | 20263467 | PRJNA576995_P_NODE_31836_length_268_cov_1.579487_g31244_i0 | PRJNA576995 | 31836 | 268 | 1.579487 | 4.23302516 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 99 | 1.48e-23 | NR | XP_068758539.1 | 246305 | g31244 | i0 | 58.1 | 3.41417910447761 | 74 | 31 | 82.8 | 0 | 42 | 263 | 7 | 80 | XP_068758539.1 ras-related protein Rab-7a-like [Montipora capricornis] | diamond | 915 | 100 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 28090226 | 28090226 | PRJNA576995_P_NODE_43285_length_241_cov_0.916667_g42693_i0 | PRJNA576995 | 43285 | 241 | 0.916667 | 2.20916747 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 76.3 | 5.54e-14 | NR | XP_028403201.1 | 151771 | g42693 | i0 | 63.2 | 2.97510373443983 | 57 | 21 | 71 | 0 | 209 | 39 | 10 | 66 | XP_028403201.1 protein DD3-3-like [Dendronephthya gigantea] | diamond | 717 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 29069261 | 29069261 | PRJNA576995_P_NODE_968_length_1491_cov_1.699577_g787_i0 | PRJNA576995 | 968 | 1491 | 1.699577 | 25.34069307 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 72.4 | 3.67e-9 | NR | XP_068695663.1 | 591990 | g787 | i0 | 25.2 | 0.86317907444668 | 429 | 267 | 81.3 | 16 | 267 | 1478 | 934 | 1333 | XP_068695663.1 ankyrin repeat domain-containing protein 17-like [Montipora foliosa] | diamond | 1287 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 29461191 | 29461191 | PRJNA576995_P_NODE_34110_length_254_cov_1.276243_g33518_i0 | PRJNA576995 | 34110 | 254 | 1.276243 | 3.24165722 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 134 | 2.2099999999999993e-34 | NR | XP_031562492.1 | 6105 | g33518 | i0 | 83.3 | 44.5866141732283 | 84 | 14 | 99.2 | 0 | 254 | 3 | 12 | 95 | XP_031562492.1 V-type proton ATPase catalytic subunit A-like [Actinia tenebrosa] | diamond | 11325 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 29903674 | 29903674 | PRJNA576995_P_NODE_42731_length_242_cov_0.905325_g42139_i0 | PRJNA576995 | 42731 | 242 | 0.905325 | 2.1908865 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 94.7 | 1.87e-20 | NR | XP_044182620.1 | 45264 | g42139 | i0 | 54.8 | 9.0495867768595 | 73 | 33 | 90.5 | 0 | 24 | 242 | 533 | 605 | XP_044182620.1 LOW QUALITY PROTEIN: cytosolic carboxypeptidase-like protein 5 [Acropora millepora] | diamond | 2190 | 95.1 | 0.995793901156677 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 30079426 | 30079426 | PRJNA576995_P_NODE_39292_length_246_cov_0.890173_g38700_i0 | PRJNA576995 | 39292 | 246 | 0.890173 | 2.18982558 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 115 | 5.02e-30 | NR | XP_065063122.1 | 499914 | g38700 | i0 | 70 | 5.86585365853659 | 80 | 24 | 97.6 | 0 | 240 | 1 | 1 | 80 | XP_065063122.1 large ribosomal subunit protein eL19-like [Rhopilema esculentum] | diamond | 1443 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 30395973 | 30395973 | PRJNA576995_P_NODE_42573_length_242_cov_0.911243_g41981_i0 | PRJNA576995 | 42573 | 242 | 0.911243 | 2.20520806 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 85.5 | 3.1e-17 | NR | XP_020899356.1 | 2652724 | g41981 | i0 | 50 | 3.86776859504132 | 78 | 38 | 95.5 | 1 | 231 | 1 | 354 | 431 | XP_020899356.1 eukaryotic translation initiation factor 3 subunit L [Exaiptasia diaphana] | diamond | 936 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 30472388 | 30472388 | PRJNA576995_P_NODE_30533_length_275_cov_1.524752_g29941_i0 | PRJNA576995 | 30533 | 275 | 1.524752 | 4.193068 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 102 | 1.07e-24 | NR | XP_066910485.1 | 252671 | g29941 | i0 | 57.1 | 9.09818181818182 | 91 | 39 | 99.3 | 0 | 3 | 275 | 95 | 185 | XP_066910485.1 ras-related protein Rab6-like [Clytia hemisphaerica] | diamond | 2502 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 31388869 | 31388869 | PRJNA576995_P_NODE_29176_length_282_cov_2.066986_g28584_i0 | PRJNA576995 | 29176 | 282 | 2.066986 | 5.82890052 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 89.4 | 6.9e-21 | NR | XP_031563295.1 | 6105 | g28584 | i0 | 63.4 | 1.46808510638298 | 71 | 23 | 75.5 | 1 | 5 | 217 | 24 | 91 | XP_031563295.1 60S ribosomal protein L38 [Actinia tenebrosa] | diamond | 414 | 89.7 | 0.996655518394649 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 31483844 | 31483844 | PRJNA576995_P_NODE_35556_length_250_cov_0.870056_g34964_i0 | PRJNA576995 | 35556 | 250 | 0.870056 | 2.17514 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 82.8 | 1.35e-16 | NR | XP_029189251.2 | 45264 | g34964 | i0 | 59 | 9.912 | 61 | 25 | 73.2 | 0 | 249 | 67 | 167 | 227 | XP_029189251.2 macro domain-containing protein CT2219-like isoform X2 [Acropora millepora] | diamond | 2478 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 32324561 | 32324561 | PRJNA576995_P_NODE_35639_length_250_cov_0.870056_g35047_i0 | PRJNA576995 | 35639 | 250 | 0.870056 | 2.17514 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 43.1 | 0.0294 | NR | XP_001638431.2 | 45351 | g35047 | i0 | 36.3 | 0.96 | 80 | 43 | 96 | 2 | 2 | 241 | 254 | 325 | XP_001638431.2 adenylyl cyclase-associated protein 1 [Nematostella vectensis] | diamond | 240 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32892057 | 32892057 | PRJNA576995_P_NODE_40840_length_244_cov_0.900585_g40248_i0 | PRJNA576995 | 40840 | 244 | 0.900585 | 2.1974274 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 115 | 1.34e-27 | NR | XP_048588551.1 | 45351 | g40248 | i0 | 66.3 | 3.9344262295082 | 80 | 27 | 98.4 | 0 | 5 | 244 | 21 | 100 | XP_048588551.1 26S proteasome non-ATPase regulatory subunit 1 [Nematostella vectensis] | diamond | 960 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis |
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);;