contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1248424" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 352645 | 352645 | PRJNA1248424_P_NODE_49981_length_310_cov_0.902954_g43913_i0 | PRJNA1248424 | 49981 | 310 | 0.902954 | 2.7991574 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2917940756|emb|OZ237571.1| | 6108 | g43913 | i0 | 100 | 0.0903225806451613 | 28 | 0 | 9 | 0 | 137 | 164 | 11024943 | 11024916 | Anemonia sulcata genome assembly, chromosome: 17 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 353167 | 353167 | PRJNA1248424_P_NODE_76281_length_244_cov_1.801170_g70212_i0 | PRJNA1248424 | 76281 | 244 | 1.80117 | 4.3948548 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 76.8 | 1.31e-9 | NTclustered | gi|2917940712|emb|OZ237560.1| | 6108 | g70212 | i0 | 85.135 | 0.30327868852459 | 74 | 11 | 30 | 0 | 117 | 190 | 1531220 | 1531293 | Anemonia sulcata genome assembly, chromosome: 6 | blastn | 74 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 353210 | 353210 | PRJNA1248424_P_NODE_78701_length_242_cov_1.224852_g72632_i0 | PRJNA1248424 | 78701 | 242 | 1.224852 | 2.96414184 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2729084061|ref|XM_065204527.1| | 499914 | g72632 | i0 | 100 | 0.231404958677686 | 28 | 0 | 12 | 0 | 105 | 132 | 2235 | 2262 | PREDICTED: Rhopilema esculentum uncharacterized protein K02A2.6-like (LOC135687881), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 1628103 | 1628103 | PRJNA1248424_P_NODE_77642_length_243_cov_1.135294_g71573_i0 | PRJNA1248424 | 77642 | 243 | 1.135294 | 2.75876442 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|1619620933|ref|XM_021039041.2| | 2652724 | g71573 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 133 | 160 | 979 | 952 | PREDICTED: Exaiptasia diaphana uncharacterized LOC110233722 (LOC110233722), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 9280152 | 9280152 | PRJNA1248424_P_NODE_15168_length_1214_cov_2.306748_g10675_i0 | PRJNA1248424 | 15168 | 1214 | 2.306748 | 28.00392072 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 529 | 4.699999999999998e-145 | NTclustered | gi|2744840495|ref|XR_010635829.1| | 6087 | g10675 | i0 | 94.22 | 7.6828665568369 | 346 | 20 | 44 | 0 | 868 | 1213 | 311 | 656 | PREDICTED: Hydra vulgaris uncharacterized LOC136075315 (LOC136075315), ncRNA | blastn | 9327 | 529 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 9281346 | 9281346 | PRJNA1248424_P_NODE_66548_length_258_cov_0.913514_g60479_i0 | PRJNA1248424 | 66548 | 258 | 0.913514 | 2.35686612 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 217 | 7.87e-52 | NTclustered | gi|2782943885|ref|XM_067076883.1| | 252671 | g60479 | i0 | 83.475 | 156.837209302326 | 236 | 35 | 91 | 4 | 1 | 234 | 117 | 350 | PREDICTED: Clytia hemisphaerica ubiquitin-ribosomal protein eL40 fusion protein (LOC136820684), mRNA | blastn | 40464 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 12530527 | 12530527 | PRJNA1248424_P_NODE_64050_length_264_cov_2.078534_g57981_i0 | PRJNA1248424 | 64050 | 264 | 2.078534 | 5.48732976 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 63.9 | 1.11e-5 | NTclustered | gi|1176072230|ref|XM_020750381.1| | 48498 | g57981 | i0 | 95 | 2.22727272727273 | 40 | 2 | 15 | 0 | 34 | 73 | 1363 | 1324 | PREDICTED: Orbicella faveolata zinc finger protein 271-like (LOC110044794), mRNA | blastn | 588 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 19478746 | 19478746 | PRJNA1248424_P_NODE_43576_length_346_cov_2.945055_g37513_i0 | PRJNA1248424 | 43576 | 346 | 2.945055 | 10.1898903 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|2917940714|emb|OZ237561.1| | 6108 | g37513 | i0 | 100 | 0.0809248554913295 | 28 | 0 | 8 | 0 | 210 | 237 | 3778870 | 3778897 | Anemonia sulcata genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 19478887 | 19478887 | PRJNA1248424_P_NODE_51196_length_303_cov_1.160870_g45128_i0 | PRJNA1248424 | 51196 | 303 | 1.16087 | 3.5174361 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|2917940714|emb|OZ237561.1| | 6108 | g45128 | i0 | 100 | 0.0924092409240924 | 28 | 0 | 9 | 0 | 72 | 99 | 13063728 | 13063701 | Anemonia sulcata genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 20753397 | 20753397 | PRJNA1248424_P_NODE_14237_length_1298_cov_1.993469_g9976_i0 | PRJNA1248424 | 14237 | 1298 | 1.993469 | 25.87522762 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 62.1 | 2.21e-4 | NTclustered | gi|2744898063|ref|XM_065814701.1| | 6087 | g9976 | i0 | 97.222 | 0.0277349768875193 | 36 | 1 | 3 | 0 | 1231 | 1266 | 1026 | 1061 | PREDICTED: Hydra vulgaris arginine--tRNA ligase, cytoplasmic (LOC100214624), mRNA | blastn | 36 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 20754738 | 20754738 | PRJNA1248424_P_NODE_71037_length_249_cov_1.414773_g64968_i0 | PRJNA1248424 | 71037 | 249 | 1.414773 | 3.52278477 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|1176115621|ref|XM_020773282.1| | 48498 | g64968 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 81 | 108 | 225 | 252 | PREDICTED: Orbicella faveolata uncharacterized LOC110066082 (LOC110066082), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 23304838 | 23304838 | PRJNA1248424_P_NODE_35399_length_423_cov_1.128571_g29343_i0 | PRJNA1248424 | 35399 | 423 | 1.128571 | 4.77385533 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.041 | NTclustered | gi|2917940714|emb|OZ237561.1| | 6108 | g29343 | i0 | 100 | 0.066193853427896 | 28 | 0 | 7 | 0 | 311 | 338 | 2298710 | 2298683 | Anemonia sulcata genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata |
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);;