contig_metadata
13 rows where bioproject = "PRJDB9741", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20411714 | 20411714 | PRJDB9741_P_NODE_7577_length_228_cov_1.620112_g7260_i0 | PRJDB9741 | 7577 | 228 | 1.620112 | 3.69385536 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 121 | 1.8799999999999998e-32 | NR | KAJ7361828.1 | 174260 | g7260 | i0 | 82.2 | 10.5789473684211 | 73 | 13 | 96.1 | 0 | 221 | 3 | 1 | 73 | KAJ7361828.1 40S ribosomal protein [Desmophyllum pertusum] | diamond | 2412 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 21687687 | 21687687 | PRJDB9741_P_NODE_8718_length_214_cov_1.721212_g8401_i0 | PRJDB9741 | 8718 | 214 | 1.721212 | 3.68339368 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 122 | 7.009999999999999e-34 | NR | XP_001632549.1 | 45351 | g8401 | i0 | 82.6 | 19.4719626168224 | 69 | 12 | 96.7 | 0 | 207 | 1 | 15 | 83 | XP_001632549.1 60S ribosomal protein L31 [Nematostella vectensis] | diamond | 4167 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 22962878 | 22962878 | PRJDB9741_P_NODE_37399_length_162_cov_1.353982_g37082_i0 | PRJDB9741 | 37399 | 162 | 1.353982 | 2.19345084 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 93.5 | 7.94e-15 | NTclustered | gi|2729093386|ref|XM_065209468.1| | 499914 | g37082 | i0 | 79.286 | 6.03703703703704 | 140 | 23 | 85 | 4 | 25 | 161 | 84 | 220 | PREDICTED: Rhopilema esculentum histone H3.3 (LOC135691579), mRNA | blastn | 978 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 22962955 | 22962955 | PRJDB9741_P_NODE_7559_length_228_cov_2.245810_g7242_i0 | PRJDB9741 | 7559 | 228 | 2.24581 | 5.1204468 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 75.5 | 5.87e-15 | NR | XP_068735082.1 | 246305 | g7242 | i0 | 60.8 | 1.38157894736842 | 51 | 20 | 67.1 | 0 | 3 | 155 | 118 | 168 | XP_068735082.1 large ribosomal subunit protein uL5-like [Montipora capricornis] | diamond | 315 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 27374576 | 27374576 | PRJDB9741_P_NODE_21623_length_175_cov_1.619048_g21306_i0 | PRJDB9741 | 21623 | 175 | 1.619048 | 2.833334 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 61.6 | 3.18e-9 | NR | XP_031560190.1 | 6105 | g21306 | i0 | 54.5 | 1.97142857142857 | 55 | 20 | 85.7 | 1 | 18 | 167 | 1696 | 1750 | XP_031560190.1 uncharacterized protein LOC116296305 [Actinia tenebrosa] | diamond | 345 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28043292 | 28043292 | PRJDB9741_P_NODE_32545_length_165_cov_0.879310_g32228_i0 | PRJDB9741 | 32545 | 165 | 0.87931 | 1.4508615 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 52 | 6.9e-7 | NR | KAF1744446.1 | 59785 | g32228 | i0 | 75.9 | 0.527272727272727 | 29 | 7 | 52.7 | 0 | 142 | 56 | 51 | 79 | KAF1744446.1 hypothetical protein MXB_1627, partial [Myxobolus squamalis] | diamond | 87 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 28700474 | 28700474 | PRJDB9741_P_NODE_18607_length_180_cov_1.961832_g18290_i0 | PRJDB9741 | 18607 | 180 | 1.961832 | 3.5312976 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 43.5 | 0.00822 | NR | XP_029208386.2 | 45264 | g18290 | i0 | 40 | 1.9 | 60 | 31 | 95 | 2 | 2 | 172 | 40 | 97 | XP_029208386.2 cilia- and flagella-associated protein 410-like isoform X1 [Acropora millepora] | diamond | 342 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 28826426 | 28826426 | PRJDB9741_P_NODE_13388_length_189_cov_2.750000_g13071_i0 | PRJDB9741 | 13388 | 189 | 2.75 | 5.1975 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 87 | 1.53e-20 | NR | XP_057300244.1 | 13093 | g13071 | i0 | 75.5 | 3.3015873015873 | 49 | 12 | 77.8 | 0 | 40 | 186 | 1 | 49 | XP_057300244.1 probable 60S ribosomal protein L37-A [Hydractinia symbiolongicarpus] | diamond | 624 | 87.4 | 0.995423340961098 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 29268520 | 29268520 | PRJDB9741_P_NODE_6829_length_240_cov_1.476440_g6512_i0 | PRJDB9741 | 6829 | 240 | 1.47644 | 3.543456 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 121 | 8.46e-30 | NR | XP_028411344.1 | 151771 | g6512 | i0 | 72.2 | 47.2 | 79 | 22 | 98.8 | 0 | 238 | 2 | 395 | 473 | XP_028411344.1 elongation factor 2-like [Dendronephthya gigantea] | diamond | 11328 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 29521261 | 29521261 | PRJDB9741_P_NODE_36510_length_163_cov_0.894737_g36193_i0 | PRJDB9741 | 36510 | 163 | 0.894737 | 1.45842131 | Acropora | 6127 | Cnidaria | other_Eukaryota | 44.7 | 0.00271 | NR | XP_044168355.1 | 45264 | g36193 | i0 | 48.8 | 2.31901840490798 | 43 | 20 | 79.1 | 1 | 130 | 2 | 17 | 57 | XP_044168355.1 myoferlin-like isoform X3 [Acropora millepora] | diamond | 378 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 29527315 | 29527315 | PRJDB9741_P_NODE_37490_length_162_cov_0.902655_g37173_i0 | PRJDB9741 | 37490 | 162 | 0.902655 | 1.4623011 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 51.2 | 9.8e-6 | NR | XP_031566932.1 | 6105 | g37173 | i0 | 42.6 | 2 | 54 | 27 | 100 | 2 | 162 | 1 | 173 | 222 | XP_031566932.1 E3 SUMO-protein ligase NSE2-like [Actinia tenebrosa] | diamond | 324 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 31417005 | 31417005 | PRJDB9741_P_NODE_21096_length_176_cov_1.590551_g20779_i0 | PRJDB9741 | 21096 | 176 | 1.590551 | 2.79936976 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 84.3 | 1.92e-18 | NR | XP_068672297.1 | 591990 | g20779 | i0 | 67.2 | 2.96590909090909 | 58 | 19 | 98.9 | 0 | 3 | 176 | 80 | 137 | XP_068672297.1 rho GDP-dissociation inhibitor 1-like [Montipora foliosa] | diamond | 522 | 84.7 | 0.995277449822904 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 32087279 | 32087279 | PRJDB9741_P_NODE_17378_length_182_cov_2.180451_g17061_i0 | PRJDB9741 | 17378 | 182 | 2.180451 | 3.96842082 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 68.2 | 1.67e-12 | NR | XP_065051429.1 | 499914 | g17061 | i0 | 58.8 | 8.45604395604396 | 51 | 21 | 84.1 | 0 | 29 | 181 | 1 | 51 | XP_065051429.1 small ribosomal subunit protein uS17-like [Rhopilema esculentum] | diamond | 1539 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum |
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);;