contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA715462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 705831 | 705831 | PRJNA715462_P_NODE_35041_length_298_cov_1.986667_g34245_i0 | PRJNA715462 | 35041 | 298 | 1.986667 | 5.92026766 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2782863103|ref|XM_067059373.1| | 252671 | g34245 | i0 | 100 | 0.100671140939597 | 30 | 0 | 10 | 0 | 182 | 211 | 1090 | 1061 | PREDICTED: Clytia hemisphaerica malate dehydrogenase, cytoplasmic-like (LOC136802621), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 706315 | 706315 | PRJNA715462_P_NODE_58941_length_247_cov_0.885057_g58145_i0 | PRJNA715462 | 58941 | 247 | 0.885057 | 2.18609079 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g58145 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 127 | 154 | 16930281 | 16930308 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 706520 | 706520 | PRJNA715462_P_NODE_7301_length_846_cov_2.657180_g6600_i0 | PRJNA715462 | 7301 | 846 | 2.65718 | 22.4797428 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 54.7 | 0.024 | NTclustered | gi|1176081934|ref|XM_020755445.1| | 48498 | g6600 | i0 | 94.444 | 0.0425531914893617 | 36 | 1 | 4 | 1 | 666 | 701 | 721 | 687 | PREDICTED: Orbicella faveolata cysteine-rich motor neuron 1 protein-like (LOC110049639), mRNA | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 5809089 | 5809089 | PRJNA715462_P_NODE_19005_length_428_cov_2.436620_g18209_i0 | PRJNA715462 | 19005 | 428 | 2.43662 | 10.4287336 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 54.7 | 0.011 | NTclustered | gi|2751551215|ref|XM_059101251.2| | 203993 | g18209 | i0 | 100 | 0.198598130841121 | 29 | 0 | 7 | 0 | 351 | 379 | 1575 | 1547 | PREDICTED: Pocillopora verrucosa sialin (LOC131784448), mRNA | blastn | 85 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 6296340 | 6296340 | PRJNA715462_P_NODE_51625_length_251_cov_0.865169_g50829_i0 | PRJNA715462 | 51625 | 251 | 0.865169 | 2.17157419 | Montipora | 46703 | Cnidaria | other_Eukaryota | 87.9 | 6.24e-13 | NTclustered | gi|2812126610|ref|XM_068876348.1| | 246305 | g50829 | i0 | 82.178 | 2.51394422310757 | 101 | 18 | 40 | 0 | 150 | 250 | 5313 | 5213 | PREDICTED: Montipora capricornis DNA-directed RNA polymerase II subunit RPB1-like (LOC138028746), mRNA | blastn | 631 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 9634379 | 9634379 | PRJNA715462_P_NODE_36008_length_294_cov_1.045249_g35212_i0 | PRJNA715462 | 36008 | 294 | 1.045249 | 3.07303206 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940731|emb|OZ237564.1| | 6108 | g35212 | i0 | 87.755 | 0.166666666666667 | 49 | 5 | 16 | 1 | 229 | 276 | 8791919 | 8791871 | Anemonia sulcata genome assembly, chromosome: 10 | blastn | 49 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 14735391 | 14735391 | PRJNA715462_P_NODE_64332_length_244_cov_0.883041_g63536_i0 | PRJNA715462 | 64332 | 244 | 0.883041 | 2.15462004 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g63536 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 214 | 241 | 12285937 | 12285964 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 15220783 | 15220783 | PRJNA715462_P_NODE_3252_length_1455_cov_3.163531_g2813_i0 | PRJNA715462 | 3252 | 1455 | 3.163531 | 46.02937605 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 54.7 | 0.042 | NTclustered | gi|2257885181|ref|XM_032377135.2| | 45351 | g2813 | i0 | 100 | 0.0398625429553265 | 29 | 0 | 2 | 0 | 438 | 466 | 1750 | 1722 | PREDICTED: Nematostella vectensis homeobox protein notochord (LOC5508358), mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 17284203 | 17284203 | PRJNA715462_P_NODE_50094_length_251_cov_5.382022_g49298_i0 | PRJNA715462 | 50094 | 251 | 5.382022 | 13.50887522 | Parvicapsula minibicornis | 109801 | Cnidaria | other_Eukaryota | 137 | 6.100000000000001e-28 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g49298 | i0 | 86.992 | 50.7888446215139 | 123 | 14 | 49 | 2 | 129 | 251 | 233 | 353 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 12748 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis | |
| 23658270 | 23658270 | PRJNA715462_P_NODE_12259_length_582_cov_1.202358_g11470_i0 | PRJNA715462 | 12259 | 582 | 1.202358 | 6.99772356 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 564 | 5.97e-156 | NTclustered | gi|2744840495|ref|XR_010635829.1| | 6087 | g11470 | i0 | 89.865 | 4.19587628865979 | 444 | 38 | 76 | 7 | 131 | 570 | 311 | 751 | PREDICTED: Hydra vulgaris uncharacterized LOC136075315 (LOC136075315), ncRNA | blastn | 2442 | 564 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris |
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);;