contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJEB14803" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5123878 | 5123878 | PRJEB14803_P_NODE_31425_length_192_cov_1.662420_g30959_i0 | PRJEB14803 | 31425 | 192 | 1.66242 | 3.1918464 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 139 | 1.23e-28 | NTclustered | gi|2744910107|ref|XM_065820268.1| | 6087 | g30959 | i0 | 80.791 | 6.11979166666667 | 177 | 34 | 92 | 0 | 1 | 177 | 165 | 341 | PREDICTED: Hydra vulgaris ras-related protein Rab-2 (LOC100208858), transcript variant X2, mRNA | blastn | 1175 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 6399547 | 6399547 | PRJEB14803_P_NODE_19966_length_259_cov_2.799107_g19500_i0 | PRJEB14803 | 19966 | 259 | 2.799107 | 7.24968713 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 73.1 | 1.81e-8 | NTclustered | gi|1191031604|ref|XR_002334281.1| | 2652724 | g19500 | i0 | 93.75 | 0.552123552123552 | 48 | 3 | 19 | 0 | 1 | 48 | 119 | 72 | PREDICTED: Exaiptasia diaphana uncharacterized LOC110232056 (LOC110232056), ncRNA | blastn | 143 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 6399698 | 6399698 | PRJEB14803_P_NODE_6086_length_554_cov_4.524085_g5652_i0 | PRJEB14803 | 6086 | 554 | 4.524085 | 25.0634309 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 436 | 1.29e-117 | NTclustered | gi|2518998737|ref|XM_057450856.1| | 13093 | g5652 | i0 | 82.4 | 213.487364620939 | 500 | 88 | 90 | 0 | 55 | 554 | 1216 | 717 | PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C-like (LOC130645015), mRNA | blastn | 118272 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 7673800 | 7673800 | PRJEB14803_P_NODE_6207_length_547_cov_9.708984_g5772_i0 | PRJEB14803 | 6207 | 547 | 9.708984 | 53.10814248 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 353 | 1.3199999999999997e-92 | NTclustered | gi|1619698735|ref|XM_021060602.2| | 2652724 | g5772 | i0 | 81.84 | 76.4387568555759 | 413 | 71 | 75 | 4 | 103 | 513 | 422 | 12 | PREDICTED: Exaiptasia diaphana histone H3 (LOC110253653), mRNA | blastn | 41812 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 8948440 | 8948440 | PRJEB14803_P_NODE_28788_length_203_cov_1.666667_g28322_i0 | PRJEB14803 | 28788 | 203 | 1.666667 | 3.38333401 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|1778046062|ref|XM_031704821.1| | 6105 | g28322 | i0 | 100 | 0.413793103448276 | 28 | 0 | 14 | 0 | 1 | 28 | 2951 | 2978 | PREDICTED: Actinia tenebrosa caldesmon-like (LOC116296751), transcript variant X2, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 12775098 | 12775098 | PRJEB14803_P_NODE_42371_length_160_cov_1.280000_g41905_i0 | PRJEB14803 | 42371 | 160 | 1.28 | 2.048 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 152 | 1.2699999999999998e-32 | NTclustered | gi|2257876719|ref|XM_032373972.2| | 45351 | g41905 | i0 | 85.135 | 15.325 | 148 | 22 | 93 | 0 | 1 | 148 | 349 | 496 | PREDICTED: Nematostella vectensis ATP synthase subunit alpha, mitochondrial-like (LOC116613484), mRNA | blastn | 2452 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 14049607 | 14049607 | PRJEB14803_P_NODE_35172_length_179_cov_1.666667_g34706_i0 | PRJEB14803 | 35172 | 179 | 1.666667 | 2.98333393 | Ptychogena lactea | 1538289 | Cnidaria | other_Eukaryota | 141 | 3.15e-29 | NTclustered | gi|952952470|gb|KT809322.1| | 1538289 | g34706 | i0 | 88.235 | 26 | 119 | 13 | 66 | 1 | 5 | 122 | 6303 | 6421 | Ptychogena lactea mitochondrion, partial genome | blastn | 4654 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Laodiceidae | Ptychogena | Ptychogena lactea | |
| 14049620 | 14049620 | PRJEB14803_P_NODE_3752_length_731_cov_4.116379_g3397_i0 | PRJEB14803 | 3752 | 731 | 4.116379 | 30.09073049 | Parvicapsula minibicornis | 109801 | Cnidaria | other_Eukaryota | 128 | 1.18e-24 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g3397 | i0 | 86.957 | 15.9876880984952 | 115 | 13 | 16 | 2 | 617 | 731 | 233 | 345 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 11687 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis | |
| 15323657 | 15323657 | PRJEB14803_P_NODE_37453_length_172_cov_2.007299_g36987_i0 | PRJEB14803 | 37453 | 172 | 2.007299 | 3.45255428 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 58.4 | 3.1e-4 | NTclustered | gi|2812185772|ref|XM_068905706.1| | 246305 | g36987 | i0 | 89.583 | 3.45348837209302 | 48 | 2 | 26 | 3 | 104 | 148 | 2536 | 2583 | PREDICTED: Montipora capricornis coiled-coil domain-containing protein 154-like (LOC138060025), transcript variant X4, mRNA | blastn | 594 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 15323716 | 15323716 | PRJEB14803_P_NODE_5713_length_576_cov_4.750462_g5293_i0 | PRJEB14803 | 5713 | 576 | 4.750462 | 27.36266112 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 93.5 | 3.35e-14 | NTclustered | gi|2918369538|emb|OZ237720.1| | 317547 | g5293 | i0 | 94.915 | 1.515625 | 59 | 3 | 10 | 0 | 333 | 391 | 44319161 | 44319219 | Eunicella cavolini genome assembly, chromosome: 4 | blastn | 873 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 17873061 | 17873061 | PRJEB14803_P_NODE_30315_length_196_cov_3.981366_g29849_i0 | PRJEB14803 | 30315 | 196 | 3.981366 | 7.80347736 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 180 | 7.45e-41 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g29849 | i0 | 83.333 | 81.3622448979592 | 198 | 29 | 100 | 4 | 1 | 196 | 25244292 | 25244097 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 15947 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 19146878 | 19146878 | PRJEB14803_P_NODE_15916_length_301_cov_1.654135_g15450_i0 | PRJEB14803 | 15916 | 301 | 1.654135 | 4.97894635 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|2782828384|ref|XM_067064502.1| | 252671 | g15450 | i0 | 100 | 0.0930232558139535 | 28 | 0 | 9 | 0 | 9 | 36 | 4441 | 4414 | PREDICTED: Clytia hemisphaerica ATPase family AAA domain-containing protein 5-like (LOC136807881), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica |
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);;