contig_metadata
17 rows where bioproject = "PRJNA807685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3774510 | 3774510 | PRJNA807685_P_NODE_16183_length_369_cov_1.674699_g15113_i0 | PRJNA807685 | 16183 | 369 | 1.674699 | 6.17963931 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.01 | NTclustered | gi|1603819787|ref|XM_028558535.1| | 151771 | g15113 | i0 | 88.636 | 0.653116531165312 | 44 | 5 | 12 | 0 | 53 | 96 | 2117 | 2074 | PREDICTED: Dendronephthya gigantea putative ankyrin repeat protein RF_0381 (LOC114537495), mRNA | blastn | 241 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 4634890 | 4634890 | PRJNA807685_P_NODE_21984_length_292_cov_1.796078_g20911_i0 | PRJNA807685 | 21984 | 292 | 1.796078 | 5.24454776 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g20911 | i0 | 100 | 0.0958904109589041 | 28 | 0 | 10 | 0 | 85 | 112 | 13121443 | 13121470 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 19933403 | 19933403 | PRJNA807685_P_NODE_63216_length_155_cov_0.983051_g62143_i0 | PRJNA807685 | 63216 | 155 | 0.983051 | 1.52372905 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g62143 | i0 | 100 | 0.180645161290323 | 28 | 0 | 18 | 0 | 111 | 138 | 8736399 | 8736372 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26968051 | 26968051 | PRJNA807685_P_NODE_64422_length_153_cov_2.293103_g63349_i0 | PRJNA807685 | 64422 | 153 | 2.293103 | 3.50844759 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 44.3 | 0.00321 | NR | XP_065667861.1 | 6087 | g63349 | i0 | 46 | 3.90196078431373 | 50 | 24 | 92.2 | 1 | 13 | 153 | 70 | 119 | XP_065667861.1 uncharacterized protein LOC136088125 [Hydra vulgaris] | diamond | 597 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 27401967 | 27401967 | PRJNA807685_P_NODE_21043_length_302_cov_1.467925_g19970_i0 | PRJNA807685 | 21043 | 302 | 1.467925 | 4.4331335 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 64.7 | 1.18e-9 | NR | XP_065684496.1 | 6087 | g19970 | i0 | 52.7 | 2.37417218543046 | 55 | 25 | 53.6 | 1 | 164 | 3 | 216 | 270 | XP_065684496.1 uncharacterized protein LOC136096874 [Hydra vulgaris] | diamond | 717 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 27938699 | 27938699 | PRJNA807685_P_NODE_17085_length_354_cov_3.665615_g16015_i0 | PRJNA807685 | 17085 | 354 | 3.665615 | 12.9762771 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 101 | 4.1e-22 | NR | XP_031561241.1 | 6105 | g16015 | i0 | 49.1 | 0.983050847457627 | 116 | 57 | 98.3 | 2 | 2 | 349 | 898 | 1011 | XP_031561241.1 uncharacterized protein LOC116297202 [Actinia tenebrosa] | diamond | 348 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28222586 | 28222586 | PRJNA807685_P_NODE_47526_length_177_cov_1.578571_g46453_i0 | PRJNA807685 | 47526 | 177 | 1.578571 | 2.79407067 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 47.8 | 2.43e-4 | NR | XP_065057260.1 | 499914 | g46453 | i0 | 54.3 | 0.593220338983051 | 35 | 16 | 59.3 | 0 | 31 | 135 | 106 | 140 | XP_065057260.1 LOW QUALITY PROTEIN: uncharacterized protein LOC135685294 [Rhopilema esculentum] | diamond | 105 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 29399826 | 29399826 | PRJNA807685_P_NODE_49589_length_173_cov_2.161765_g48516_i0 | PRJNA807685 | 49589 | 173 | 2.161765 | 3.73985345 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.00164 | NR | PFX13958.1 | 50429 | g48516 | i0 | 40.9 | 9.01734104046243 | 44 | 26 | 76.3 | 0 | 41 | 172 | 780 | 823 | PFX13958.1 Gamma-aminobutyric acid receptor subunit beta-2 [Stylophora pistillata] | diamond | 1560 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 29588962 | 29588962 | PRJNA807685_P_NODE_54450_length_165_cov_2.921875_g53377_i0 | PRJNA807685 | 54450 | 165 | 2.921875 | 4.82109375 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 53.5 | 1.98e-6 | NR | XP_057296667.1 | 13093 | g53377 | i0 | 53.5 | 3.52727272727273 | 43 | 20 | 78.2 | 0 | 131 | 3 | 600 | 642 | XP_057296667.1 uncharacterized protein LOC130625579 [Hydractinia symbiolongicarpus] | diamond | 582 | 53.9 | 0.992578849721707 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 30180469 | 30180469 | PRJNA807685_P_NODE_50152_length_172_cov_2.266667_g49079_i0 | PRJNA807685 | 50152 | 172 | 2.266667 | 3.89866724 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 58.5 | 3.13e-8 | NR | CAB4013063.1 | 317549 | g49079 | i0 | 49.1 | 1.98837209302326 | 57 | 28 | 97.7 | 1 | 170 | 3 | 92 | 148 | CAB4013063.1 Hypothetical predicted protein, partial [Paramuricea clavata] | diamond | 342 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 31065479 | 31065479 | PRJNA807685_P_NODE_46615_length_179_cov_1.098592_g45542_i0 | PRJNA807685 | 46615 | 179 | 1.098592 | 1.96647968 | Acropora cervicornis | 6130 | Cnidaria | other_Eukaryota | 42 | 0.0303 | NR | KAK2568091.1 | 6130 | g45542 | i0 | 40 | 0.837988826815642 | 50 | 29 | 83.8 | 1 | 30 | 179 | 896 | 944 | KAK2568091.1 Transposon TX1 uncharacterized 149 kDa protein [Acropora cervicornis] | diamond | 150 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 31318077 | 31318077 | PRJNA807685_P_NODE_17275_length_351_cov_2.133758_g16203_i0 | PRJNA807685 | 17275 | 351 | 2.133758 | 7.48949058 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 106 | 4.7499999999999994e-24 | NR | CAB4040716.1 | 317549 | g16203 | i0 | 47 | 3.93162393162393 | 115 | 61 | 98.3 | 0 | 6 | 350 | 471 | 585 | CAB4040716.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 1380 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 31358741 | 31358741 | PRJNA807685_P_NODE_67656_length_150_cov_1.716814_g66583_i0 | PRJNA807685 | 67656 | 150 | 1.716814 | 2.575221 | Porites | 46719 | Cnidaria | other_Eukaryota | 62.8 | 6.45e-11 | NR | CAH3025268.1 | 104178 | g66583 | i0 | 50 | 19.2 | 48 | 24 | 96 | 0 | 149 | 6 | 23 | 70 | CAH3025268.1 unnamed protein product, partial [Porites evermanni] | diamond | 2880 | 63.2 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 32077291 | 32077291 | PRJNA807685_P_NODE_31378_length_227_cov_1.410526_g30305_i0 | PRJNA807685 | 31378 | 227 | 1.410526 | 3.20189402 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 50.1 | 7.55e-5 | NR | XP_047129514.1 | 6087 | g30305 | i0 | 35.6 | 0.964757709251101 | 73 | 47 | 96.5 | 0 | 223 | 5 | 179 | 251 | XP_047129514.1 putative uncharacterized protein DDB_G0286901 [Hydra vulgaris] | diamond | 219 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 32077299 | 32077299 | PRJNA807685_P_NODE_53538_length_167_cov_1.192308_g52465_i0 | PRJNA807685 | 53538 | 167 | 1.192308 | 1.99115436 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 86.3 | 6.1e-18 | NR | XP_020900831.2 | 2652724 | g52465 | i0 | 72.7 | 0.988023952095808 | 55 | 15 | 98.8 | 0 | 167 | 3 | 457 | 511 | XP_020900831.2 uncharacterized protein LOC110239454, partial [Exaiptasia diaphana] | diamond | 165 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 32203890 | 32203890 | PRJNA807685_P_NODE_43458_length_186_cov_1.040268_g42385_i0 | PRJNA807685 | 43458 | 186 | 1.040268 | 1.93489848 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 52 | 9.74e-6 | NR | XP_057316643.1 | 13093 | g42385 | i0 | 51.3 | 3.29032258064516 | 39 | 19 | 62.9 | 0 | 177 | 61 | 11 | 49 | XP_057316643.1 oocyte zinc finger protein XlCOF6-like isoform X2 [Hydractinia symbiolongicarpus] | diamond | 612 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 32330794 | 32330794 | PRJNA807685_P_NODE_54479_length_165_cov_2.585938_g53406_i0 | PRJNA807685 | 54479 | 165 | 2.585938 | 4.2667977 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 88.6 | 9.41e-19 | NR | XP_028413782.1 | 151771 | g53406 | i0 | 63 | 2.92727272727273 | 54 | 20 | 98.2 | 0 | 165 | 4 | 682 | 735 | XP_028413782.1 uncharacterized protein K02A2.6-like [Dendronephthya gigantea] | diamond | 483 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea |
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);;