contig_metadata
26 rows where bioproject = "PRJEB14664", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1295456 | 1295456 | PRJEB14664_P_NODE_4682_length_399_cov_4.175824_g4552_i0 | PRJEB14664 | 4682 | 399 | 4.175824 | 16.66153776 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 195 | 3.24e-58 | NR | XP_031557296.1 | 6105 | g4552 | i0 | 80.3 | 23.2781954887218 | 122 | 24 | 91.7 | 0 | 368 | 3 | 25 | 146 | XP_031557296.1 eukaryotic initiation factor 4A-I-like [Actinia tenebrosa] | diamond | 9288 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 1295473 | 1295473 | PRJEB14664_P_NODE_5602_length_354_cov_1.755486_g5472_i0 | PRJEB14664 | 5602 | 354 | 1.755486 | 6.21442044 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 189 | 3.37e-53 | NR | XP_027043019.1 | 46731 | g5472 | i0 | 82.9 | 30.6949152542373 | 117 | 17 | 99.2 | 1 | 353 | 3 | 5 | 118 | XP_027043019.1 elongation factor 2-like [Pocillopora damicornis] | diamond | 10866 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 3847425 | 3847425 | PRJEB14664_P_NODE_19824_length_152_cov_1.709402_g19694_i0 | PRJEB14664 | 19824 | 152 | 1.709402 | 2.59829104 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.9 | 9.61e-17 | NR | XP_065068387.1 | 499914 | g19694 | i0 | 76 | 21.6907894736842 | 50 | 12 | 98.7 | 0 | 2 | 151 | 54 | 103 | XP_065068387.1 large ribosomal subunit protein eL8-like [Rhopilema esculentum] | diamond | 3297 | 81.6 | 0.991421568627451 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 6088882 | 6088882 | PRJEB14664_P_NODE_4145_length_430_cov_3.336709_g4018_i0 | PRJEB14664 | 4145 | 430 | 3.336709 | 14.3478487 | Acropora | 6127 | Cnidaria | other_Eukaryota | 320 | 1.0299999999999999e-82 | NTclustered | gi|2114279968|ref|XM_029330392.2| | 45264 | g4018 | i0 | 80.732 | 97.1372093023256 | 410 | 79 | 95 | 0 | 19 | 428 | 669 | 1078 | PREDICTED: Acropora millepora tubulin beta-4B chain (LOC114953952), mRNA | blastn | 41769 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 8948241 | 8948241 | PRJEB14664_P_NODE_4648_length_401_cov_1.606557_g4518_i0 | PRJEB14664 | 4648 | 401 | 1.606557 | 6.44229357 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 448 | 4.2e-121 | NTclustered | gi|2782844603|ref|XM_067056021.1| | 252671 | g4518 | i0 | 86.849 | 99.9675810473815 | 403 | 49 | 100 | 4 | 1 | 401 | 1398 | 998 | PREDICTED: Clytia hemisphaerica tubulin beta-4B chain (LOC136799316), mRNA | blastn | 40087 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 10224007 | 10224007 | PRJEB14664_P_NODE_6009_length_338_cov_1.970297_g5879_i0 | PRJEB14664 | 6009 | 338 | 1.970297 | 6.65960386 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 200 | 1.08e-46 | NTclustered | gi|1778043721|ref|XM_031703576.1| | 6105 | g5879 | i0 | 80.952 | 21.5147928994083 | 252 | 48 | 75 | 0 | 8 | 259 | 418 | 167 | PREDICTED: Actinia tenebrosa ras-related protein Rap-1A (LOC116295677), mRNA | blastn | 7272 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 12774833 | 12774833 | PRJEB14664_P_NODE_3951_length_442_cov_3.904177_g3824_i0 | PRJEB14664 | 3951 | 442 | 3.904177 | 17.25646234 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 241 | 9.7e-78 | NR | EDO25965.1 | 45351 | g3824 | i0 | 89.5 | 0.970588235294118 | 143 | 15 | 97.1 | 0 | 429 | 1 | 1 | 143 | EDO25965.1 predicted protein, partial [Nematostella vectensis] | diamond | 429 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 14049399 | 14049399 | PRJEB14664_P_NODE_4512_length_408_cov_3.034853_g4384_i0 | PRJEB14664 | 4512 | 408 | 3.034853 | 12.38220024 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 359 | 2.06e-94 | NTclustered | gi|2782889916|ref|XM_067065970.1| | 252671 | g4384 | i0 | 82.759 | 96.7058823529412 | 406 | 67 | 99 | 3 | 5 | 408 | 1058 | 654 | PREDICTED: Clytia hemisphaerica tubulin alpha-1 chain-like (LOC136809439), mRNA | blastn | 39456 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 16597978 | 16597978 | PRJEB14664_P_NODE_13594_length_195_cov_1.650000_g13464_i0 | PRJEB14664 | 13594 | 195 | 1.65 | 3.2175 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|1176080165|ref|XM_020754513.1| | 48498 | g13464 | i0 | 100 | 0.143589743589744 | 28 | 0 | 14 | 0 | 155 | 182 | 554 | 527 | PREDICTED: Orbicella faveolata uncharacterized LOC110048739 (LOC110048739), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 17872923 | 17872923 | PRJEB14664_P_NODE_9835_length_245_cov_1.142857_g9705_i0 | PRJEB14664 | 9835 | 245 | 1.142857 | 2.79999965 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 114 | 2.3199999999999997e-30 | NR | XP_065647034.1 | 6087 | g9705 | i0 | 61.7 | 15.6857142857143 | 81 | 31 | 99.2 | 0 | 2 | 244 | 14 | 94 | XP_065647034.1 small ribosomal subunit protein eS10 [Hydra vulgaris] | diamond | 3843 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 21698008 | 21698008 | PRJEB14664_P_NODE_8918_length_262_cov_1.585903_g8788_i0 | PRJEB14664 | 8918 | 262 | 1.585903 | 4.15506586 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 136 | 4.18e-37 | NR | XP_027055569.1 | 46731 | g8788 | i0 | 79 | 31.5343511450382 | 81 | 17 | 92.7 | 0 | 19 | 261 | 1 | 81 | XP_027055569.1 60S ribosomal protein L5-like [Pocillopora damicornis] | diamond | 8262 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 28012421 | 28012421 | PRJEB14664_P_NODE_17765_length_163_cov_1.250000_g17635_i0 | PRJEB14664 | 17765 | 163 | 1.25 | 2.0375 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 45.1 | 0.00192 | NR | XP_031553830.1 | 6105 | g17635 | i0 | 39.6 | 1.73006134969325 | 48 | 24 | 79.1 | 1 | 35 | 163 | 140 | 187 | XP_031553830.1 uncharacterized protein LOC116290858 [Actinia tenebrosa] | diamond | 282 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28454448 | 28454448 | PRJEB14664_P_NODE_14066_length_191_cov_1.538462_g13936_i0 | PRJEB14664 | 14066 | 191 | 1.538462 | 2.93846242 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 115 | 5.5e-31 | NR | XP_002155359.2 | 6087 | g13936 | i0 | 86.2 | 0.910994764397906 | 58 | 8 | 91.1 | 0 | 191 | 18 | 69 | 126 | XP_002155359.2 small ribosomal subunit protein eS12 [Hydra vulgaris] | diamond | 174 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29710484 | 29710484 | PRJEB14664_P_NODE_16410_length_172_cov_1.452555_g16280_i0 | PRJEB14664 | 16410 | 172 | 1.452555 | 2.4983946 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.8 | 1.14e-9 | NR | XP_031550778.1 | 6105 | g16280 | i0 | 100 | 148.831395348837 | 30 | 0 | 52.3 | 0 | 171 | 82 | 325 | 354 | XP_031550778.1 guanine nucleotide-binding protein subunit alpha-11-like [Actinia tenebrosa] | diamond | 25599 | 63.2 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 29748528 | 29748528 | PRJEB14664_P_NODE_19451_length_154_cov_1.344538_g19321_i0 | PRJEB14664 | 19451 | 154 | 1.344538 | 2.07058852 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 90.1 | 1.83e-19 | NR | XP_065051724.1 | 499914 | g19321 | i0 | 80 | 4.79220779220779 | 50 | 10 | 97.4 | 0 | 152 | 3 | 211 | 260 | XP_065051724.1 kynurenine 3-monooxygenase-like [Rhopilema esculentum] | diamond | 738 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 30152840 | 30152840 | PRJEB14664_P_NODE_1152_length_867_cov_2.655048_g1067_i0 | PRJEB14664 | 1152 | 867 | 2.655048 | 23.01926616 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 367 | 1.8e-124 | NR | XP_027055569.1 | 46731 | g1067 | i0 | 65.4 | 16.5086505190311 | 280 | 97 | 96.9 | 0 | 25 | 864 | 1 | 280 | XP_027055569.1 60S ribosomal protein L5-like [Pocillopora damicornis] | diamond | 14313 | 369 | 0.994579945799458 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 30159195 | 30159195 | PRJEB14664_P_NODE_2072_length_639_cov_1.889073_g1963_i0 | PRJEB14664 | 2072 | 639 | 1.889073 | 12.07117647 | Nemopilema nomurai | 321803 | Cnidaria | other_Eukaryota | 103 | 3.6300000000000003e-22 | NR | YP_009421322.1 | 321803 | g1963 | i0 | 59.8 | 0.765258215962441 | 82 | 33 | 38.5 | 0 | 2 | 247 | 291 | 372 | YP_009421322.1 cytochrome b [Nemopilema nomurai] | diamond | 489 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Nemopilema | Nemopilema nomurai | |
| 30406240 | 30406240 | PRJEB14664_P_NODE_18113_length_161_cov_0.952381_g17983_i0 | PRJEB14664 | 18113 | 161 | 0.952381 | 1.53333341 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 77 | 3.65e-16 | NR | XP_031557202.1 | 6105 | g17983 | i0 | 67.9 | 48.3913043478261 | 53 | 17 | 98.8 | 0 | 159 | 1 | 84 | 136 | XP_031557202.1 60S ribosomal protein L27a-like [Actinia tenebrosa] | diamond | 7791 | 77.4 | 0.994832041343669 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30443960 | 30443960 | PRJEB14664_P_NODE_5553_length_356_cov_1.844237_g5423_i0 | PRJEB14664 | 5553 | 356 | 1.844237 | 6.56548372 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 92.4 | 4.25e-21 | NR | XP_065682362.1 | 6087 | g5423 | i0 | 55.3 | 0.792134831460674 | 94 | 39 | 78.4 | 2 | 60 | 338 | 11 | 102 | XP_065682362.1 inter-alpha-trypsin inhibitor heavy chain H3-like isoform X1 [Hydra vulgaris] | diamond | 282 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30532156 | 30532156 | PRJEB14664_P_NODE_5693_length_350_cov_2.644444_g5563_i0 | PRJEB14664 | 5693 | 350 | 2.644444 | 9.255554 | Actiniaria | 6103 | Cnidaria | other_Eukaryota | 98.6 | 1.37e-23 | NR | XP_031559276.1 | 6105 | g5563 | i0 | 58.8 | 3.53142857142857 | 80 | 32 | 68.6 | 1 | 348 | 109 | 62 | 140 | XP_031559276.1 40S ribosomal protein S19-like [Actinia tenebrosa] | diamond | 1236 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30981139 | 30981139 | PRJEB14664_P_NODE_7094_length_305_cov_1.581481_g6964_i0 | PRJEB14664 | 7094 | 305 | 1.581481 | 4.82351705 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 75.5 | 4.52e-15 | NR | XP_068707130.1 | 591990 | g6964 | i0 | 58.7 | 2.44918032786885 | 63 | 26 | 62 | 0 | 2 | 190 | 6 | 68 | XP_068707130.1 large ribosomal subunit protein P1-like [Montipora foliosa] | diamond | 747 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 31606935 | 31606935 | PRJEB14664_P_NODE_3716_length_460_cov_2.710588_g3591_i0 | PRJEB14664 | 3716 | 460 | 2.710588 | 12.4687048 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 110 | 7.07e-25 | NR | XP_065647153.1 | 6087 | g3591 | i0 | 76.6 | 2.0804347826087 | 64 | 15 | 41.7 | 0 | 1 | 192 | 440 | 503 | XP_065647153.1 V-type proton ATPase subunit B isoform X2 [Hydra vulgaris] | diamond | 957 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 32087790 | 32087790 | PRJEB14664_P_NODE_15198_length_181_cov_1.643836_g15068_i0 | PRJEB14664 | 15198 | 181 | 1.643836 | 2.97534316 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 68.2 | 1.78e-11 | NR | XP_057304108.1 | 13093 | g15068 | i0 | 60 | 0.994475138121547 | 60 | 24 | 99.4 | 0 | 180 | 1 | 276 | 335 | XP_057304108.1 ATP-dependent translocase ABCB1-like isoform X1 [Hydractinia symbiolongicarpus] | diamond | 180 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 32119578 | 32119578 | PRJEB14664_P_NODE_18958_length_156_cov_1.826446_g18828_i0 | PRJEB14664 | 18958 | 156 | 1.826446 | 2.84925576 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 60.8 | 4.94e-10 | NR | XP_022789645.1 | 50429 | g18828 | i0 | 74 | 1.92307692307692 | 50 | 13 | 96.2 | 0 | 155 | 6 | 76 | 125 | XP_022789645.1 40S ribosomal protein S24-like [Stylophora pistillata] | diamond | 300 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32404292 | 32404292 | PRJEB14664_P_NODE_15439_length_179_cov_2.222222_g15309_i0 | PRJEB14664 | 15439 | 179 | 2.222222 | 3.97777738 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 64.7 | 1.75e-10 | NR | XP_015758093.1 | 70779 | g15309 | i0 | 51.7 | 5.81564245810056 | 58 | 28 | 97.2 | 0 | 5 | 178 | 85 | 142 | XP_015758093.1 PREDICTED: LOW QUALITY PROTEIN: zinc-binding alcohol dehydrogenase domain-containing protein 2-like [Acropora digitifera] | diamond | 1041 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 32877252 | 32877252 | PRJEB14664_P_NODE_17640_length_164_cov_0.914729_g17510_i0 | PRJEB14664 | 17640 | 164 | 0.914729 | 1.50015556 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 66.6 | 1.85e-12 | NR | XP_065063050.1 | 499914 | g17510 | i0 | 50 | 0.98780487804878 | 54 | 27 | 98.8 | 0 | 2 | 163 | 15 | 68 | XP_065063050.1 large ribosomal subunit protein P1-like [Rhopilema esculentum] | diamond | 162 | 66.6 | 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);;