contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA643700" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26669469 | 26669469 | PRJNA643700_P_NODE_263161_length_231_cov_1.142857_g261605_i0 | PRJNA643700 | 263161 | 231 | 1.142857 | 2.63999967 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 51.6 | 2.24e-5 | NR | XP_068704443.1 | 591990 | g261605 | i0 | 62.5 | 0.519480519480519 | 40 | 15 | 51.9 | 0 | 167 | 48 | 217 | 256 | XP_068704443.1 uncharacterized protein [Montipora foliosa] | diamond | 120 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 26986243 | 26986243 | PRJNA643700_P_NODE_58602_length_545_cov_1.673387_g57101_i0 | PRJNA643700 | 58602 | 545 | 1.673387 | 9.11995915 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 47.8 | 0.00948 | NR | XP_047129534.1 | 6087 | g57101 | i0 | 58.5 | 0.699082568807339 | 41 | 13 | 20.9 | 2 | 116 | 229 | 31 | 70 | XP_047129534.1 E3 SUMO-protein ligase ZBED1-like [Hydra vulgaris] | diamond | 381 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 27523615 | 27523615 | PRJNA643700_P_NODE_223763_length_258_cov_2.488038_g222207_i0 | PRJNA643700 | 223763 | 258 | 2.488038 | 6.41913804 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 45.4 | 0.00491 | NR | CAB3988564.1 | 317549 | g222207 | i0 | 33.3 | 1.01162790697674 | 87 | 40 | 88.4 | 2 | 8 | 235 | 265 | 344 | CAB3988564.1 RNA-directed DNA polymerase from mobile element jockey [Paramuricea clavata] | diamond | 261 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 27618497 | 27618497 | PRJNA643700_P_NODE_399644_length_167_cov_0.881356_g398088_i0 | PRJNA643700 | 399644 | 167 | 0.881356 | 1.47186452 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 52 | 6.13e-6 | NR | KAF1741030.1 | 59785 | g398088 | i0 | 39.6 | 0.952095808383233 | 53 | 32 | 95.2 | 0 | 5 | 163 | 177 | 229 | KAF1741030.1 hypothetical protein MXB_2623 [Myxobolus squamalis] | diamond | 159 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 27713478 | 27713478 | PRJNA643700_P_NODE_268564_length_227_cov_3.505618_g267008_i0 | PRJNA643700 | 268564 | 227 | 3.505618 | 7.95775286 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 70.5 | 3.72e-12 | NR | XP_015779734.1 | 70779 | g267008 | i0 | 52.5 | 2.76211453744493 | 59 | 28 | 78 | 0 | 31 | 207 | 9 | 67 | XP_015779734.1 PREDICTED: uncharacterized protein LOC107357609 [Acropora digitifera] | diamond | 627 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 27757197 | 27757197 | PRJNA643700_P_NODE_380764_length_171_cov_2.000000_g379208_i0 | PRJNA643700 | 380764 | 171 | 2 | 3.42 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 48.5 | 1.31e-4 | NR | XP_015773467.1 | 70779 | g379208 | i0 | 83.3 | 3.66666666666667 | 24 | 4 | 42.1 | 0 | 72 | 1 | 292 | 315 | XP_015773467.1 PREDICTED: F-box/WD repeat-containing protein 11-like [Acropora digitifera] | diamond | 627 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 27902322 | 27902322 | PRJNA643700_P_NODE_365825_length_178_cov_1.410853_g364269_i0 | PRJNA643700 | 365825 | 178 | 1.410853 | 2.51131834 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 69.3 | 4.9e-12 | NR | XP_015779734.1 | 70779 | g364269 | i0 | 59.6 | 0.960674157303371 | 57 | 13 | 96.1 | 1 | 176 | 6 | 23 | 69 | XP_015779734.1 PREDICTED: uncharacterized protein LOC107357609 [Acropora digitifera] | diamond | 171 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 28028935 | 28028935 | PRJNA643700_P_NODE_239605_length_247_cov_1.020202_g238049_i0 | PRJNA643700 | 239605 | 247 | 1.020202 | 2.51989894 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 79.7 | 3.73e-15 | NR | PFX27087.1 | 50429 | g238049 | i0 | 50.6 | 1.96761133603239 | 81 | 40 | 98.4 | 0 | 245 | 3 | 619 | 699 | PFX27087.1 Transposon Ty3-G Gag-Pol polyprotein [Stylophora pistillata] | diamond | 486 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 28060352 | 28060352 | PRJNA643700_P_NODE_399445_length_167_cov_0.881356_g397889_i0 | PRJNA643700 | 399445 | 167 | 0.881356 | 1.47186452 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 63.2 | 8.29e-10 | NR | KII67035.1 | 669202 | g397889 | i0 | 50.9 | 0.988023952095808 | 55 | 27 | 98.8 | 0 | 165 | 1 | 708 | 762 | KII67035.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Thelohanellus kitauei] | diamond | 165 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 28313072 | 28313072 | PRJNA643700_P_NODE_396066_length_167_cov_1.762712_g394510_i0 | PRJNA643700 | 396066 | 167 | 1.762712 | 2.94372904 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 44.7 | 0.00282 | NR | KXJ16858.1 | 2652724 | g394510 | i0 | 53.8 | 1.40119760479042 | 39 | 16 | 66.5 | 1 | 14 | 124 | 983 | 1021 | KXJ16858.1 Collagen alpha-6(VI) chain [Exaiptasia diaphana] | diamond | 234 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 28439413 | 28439413 | PRJNA643700_P_NODE_182686_length_295_cov_1.691057_g181130_i0 | PRJNA643700 | 182686 | 295 | 1.691057 | 4.98861815 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 43.9 | 0.0229 | NR | XP_022780978.1 | 50429 | g181130 | i0 | 45.3 | 1.46440677966102 | 53 | 17 | 53.9 | 1 | 136 | 294 | 118 | 158 | XP_022780978.1 uncharacterized protein LOC111322178 [Stylophora pistillata] | diamond | 432 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30093350 | 30093350 | PRJNA643700_P_NODE_321332_length_199_cov_1.326667_g319776_i0 | PRJNA643700 | 321332 | 199 | 1.326667 | 2.64006733 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 50.1 | 4.65e-5 | NR | XP_067053850.1 | 159855 | g319776 | i0 | 67.6 | 4.17587939698493 | 34 | 11 | 51.3 | 0 | 106 | 5 | 217 | 250 | XP_067053850.1 uncharacterized protein [Acropora muricata] | diamond | 831 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 30630525 | 30630525 | PRJNA643700_P_NODE_68653_length_505_cov_2.664474_g67124_i0 | PRJNA643700 | 68653 | 505 | 2.664474 | 13.4555937 | root | 1 | Root_unresolved | Root_unresolved | 112 | 2.82e-27 | NR | XP_065680711.1 | 6087 | g67124 | i0 | 41.9 | 3.16633663366337 | 129 | 73 | 75.4 | 1 | 408 | 28 | 99 | 227 | XP_065680711.1 uncharacterized protein LOC136094703 [Hydra vulgaris] | diamond | 1599 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31471937 | 31471937 | PRJNA643700_P_NODE_403396_length_166_cov_0.888889_g401840_i0 | PRJNA643700 | 403396 | 166 | 0.888889 | 1.47555574 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 56.6 | 1.48e-7 | NR | KAF0986816.1 | 69463 | g401840 | i0 | 73 | 0.668674698795181 | 37 | 10 | 66.9 | 0 | 113 | 3 | 92 | 128 | KAF0986816.1 hypothetical protein HZS_4766 [Henneguya salminicola] | diamond | 111 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 32085025 | 32085025 | PRJNA643700_P_NODE_171058_length_307_cov_2.468992_g169502_i0 | PRJNA643700 | 171058 | 307 | 2.468992 | 7.57980544 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 73.6 | 2.84e-13 | NR | CAB4044841.1 | 317549 | g169502 | i0 | 58.9 | 2.46254071661238 | 56 | 23 | 54.7 | 0 | 251 | 84 | 49 | 104 | CAB4044841.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 756 | 73.9 | 0.995940460081191 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata |
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);;