contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25539813 | 25539813 | PRJNA1233465b_S_NODE_387841_length_151_cov_8.029412_g386156_i0 | PRJNA1233465 | 387841 | 151 | 8.029412 | 12.12441212 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.012 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g386156 | i0 | 100 | 0.370860927152318 | 28 | 0 | 19 | 0 | 1 | 28 | 2993282 | 2993309 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 25557558 | 25557558 | PRJNA1233465f_S_NODE_248817_length_164_cov_1.330435_g246537_i0 | PRJNA1233465 | 248817 | 164 | 1.330435 | 2.1819134 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|2918369565|emb|OZ237731.1| | 317547 | g246537 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 44 | 71 | 4959283 | 4959310 | Eunicella cavolini genome assembly, chromosome: 15 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 25678284 | 25678284 | PRJNA1233465d_S_NODE_142226_length_162_cov_0.902655_g141115_i0 | PRJNA1233465 | 142226 | 162 | 0.902655 | 1.4623011 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2918369563|emb|OZ237729.1| | 317547 | g141115 | i0 | 96.875 | 0.197530864197531 | 32 | 1 | 20 | 0 | 106 | 137 | 12722428 | 12722459 | Eunicella cavolini genome assembly, chromosome: 13 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 25679879 | 25679879 | PRJNA1233465d_S_NODE_56442_length_231_cov_1.450549_g55331_i0 | PRJNA1233465 | 56442 | 231 | 1.450549 | 3.35076819 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 58.4 | 4.44e-4 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g55331 | i0 | 97.143 | 0.151515151515152 | 35 | 0 | 15 | 1 | 32 | 66 | 6420410 | 6420377 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 35 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 25681986 | 25681986 | PRJNA1233465e_S_NODE_111002_length_185_cov_0.911765_g109692_i0 | PRJNA1233465 | 111002 | 185 | 0.911765 | 1.68676525 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 62.1 | 2.62e-5 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g109692 | i0 | 86.441 | 0.318918918918919 | 59 | 5 | 32 | 3 | 73 | 131 | 4232051 | 4232106 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 59 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 25826371 | 25826371 | PRJNA1233465f_S_NODE_166867_length_192_cov_0.930070_g164587_i0 | PRJNA1233465 | 166867 | 192 | 0.93007 | 1.7857344 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2744899243|ref|XM_065815241.1| | 6087 | g164587 | i0 | 96.875 | 0.166666666666667 | 32 | 1 | 17 | 0 | 126 | 157 | 6137 | 6168 | PREDICTED: Hydra vulgaris uncharacterized LOC136089301 (LOC136089301), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 25833298 | 25833298 | PRJNA1233465f_S_NODE_88771_length_251_cov_2.420792_g86491_i0 | PRJNA1233465 | 88771 | 251 | 2.420792 | 6.07618792 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2784681458|ref|XR_010864757.1| | 159855 | g86491 | i0 | 100 | 0.223107569721116 | 28 | 0 | 11 | 0 | 192 | 219 | 2547 | 2574 | PREDICTED: Acropora muricata uncharacterized protein (LOC136898349), transcript variant X4, misc_RNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 26028634 | 26028634 | PRJNA1233465b_S_NODE_294036_length_176_cov_8.677165_g292351_i0 | PRJNA1233465 | 294036 | 176 | 8.677165 | 15.2718104 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2917940752|emb|OZ237570.1| | 6108 | g292351 | i0 | 100 | 1.17045454545455 | 30 | 0 | 17 | 0 | 1 | 30 | 10098435 | 10098464 | Anemonia sulcata genome assembly, chromosome: 16 | blastn | 206 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26029980 | 26029980 | PRJNA1233465d_S_NODE_73348_length_207_cov_1.518987_g72237_i0 | PRJNA1233465 | 73348 | 207 | 1.518987 | 3.14430309 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|2917940701|emb|OZ237558.1| | 6108 | g72237 | i0 | 100 | 0.541062801932367 | 28 | 0 | 14 | 0 | 12 | 39 | 976763 | 976736 | Anemonia sulcata genome assembly, chromosome: 4 | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26090766 | 26090766 | PRJNA1233465e_S_NODE_124373_length_176_cov_2.362205_g123063_i0 | PRJNA1233465 | 124373 | 176 | 2.362205 | 4.1574808 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2744899243|ref|XM_065815241.1| | 6087 | g123063 | i0 | 96.875 | 0.181818181818182 | 32 | 1 | 18 | 0 | 113 | 144 | 6137 | 6168 | PREDICTED: Hydra vulgaris uncharacterized LOC136089301 (LOC136089301), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 26096854 | 26096854 | PRJNA1233465f_S_NODE_129965_length_213_cov_1.780488_g127685_i0 | PRJNA1233465 | 129965 | 213 | 1.780488 | 3.79243944 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 63.9 | 8.66e-6 | NTclustered | gi|2917940740|emb|OZ237567.1| | 6108 | g127685 | i0 | 100 | 0.31924882629108 | 34 | 0 | 16 | 0 | 139 | 172 | 6641946 | 6641913 | Anemonia sulcata genome assembly, chromosome: 13 | blastn | 68 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26098673 | 26098673 | PRJNA1233465f_S_NODE_168981_length_191_cov_0.901408_g166701_i0 | PRJNA1233465 | 168981 | 191 | 0.901408 | 1.72168928 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2918369558|emb|OZ237728.1| | 317547 | g166701 | i0 | 96.875 | 3.71727748691099 | 32 | 1 | 17 | 0 | 87 | 118 | 15468731 | 15468700 | Eunicella cavolini genome assembly, chromosome: 12 | blastn | 710 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 26106061 | 26106061 | PRJNA1233465f_S_NODE_99725_length_239_cov_2.305263_g97445_i0 | PRJNA1233465 | 99725 | 239 | 2.305263 | 5.50957857 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|1603790418|ref|XM_028542926.1| | 151771 | g97445 | i0 | 100 | 0.117154811715481 | 28 | 0 | 12 | 0 | 131 | 158 | 415 | 388 | PREDICTED: Dendronephthya gigantea uncharacterized LOC114522276 (LOC114522276), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 26230499 | 26230499 | PRJNA1233465e_S_NODE_66662_length_228_cov_1.458101_g65352_i0 | PRJNA1233465 | 66662 | 228 | 1.458101 | 3.32447028 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|2784681458|ref|XR_010864757.1| | 159855 | g65352 | i0 | 100 | 0.245614035087719 | 28 | 0 | 12 | 0 | 33 | 60 | 2574 | 2547 | PREDICTED: Acropora muricata uncharacterized protein (LOC136898349), transcript variant X4, misc_RNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 26353595 | 26353595 | PRJNA1233465b_S_NODE_173767_length_222_cov_1.410405_g172082_i0 | PRJNA1233465 | 173767 | 222 | 1.410405 | 3.1310991 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g172082 | i0 | 100 | 0.126126126126126 | 28 | 0 | 13 | 0 | 186 | 213 | 9984584 | 9984557 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26364121 | 26364121 | PRJNA1233465e_S_NODE_156663_length_163_cov_1.342105_g155353_i0 | PRJNA1233465 | 156663 | 163 | 1.342105 | 2.18763115 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 73.1 | 1.04e-8 | NTclustered | gi|2744794681|ref|XM_002160266.5| | 6087 | g155353 | i0 | 86.567 | 1.2638036809816 | 67 | 7 | 40 | 2 | 35 | 100 | 1088 | 1153 | PREDICTED: Hydra vulgaris alanine--tRNA ligase, cytoplasmic (LOC100209075), mRNA | blastn | 206 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 26370466 | 26370466 | PRJNA1233465f_S_NODE_165327_length_192_cov_3.146853_g163047_i0 | PRJNA1233465 | 165327 | 192 | 3.146853 | 6.04195776 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 71.3 | 4.56e-8 | NTclustered | gi|1270070985|ref|XR_002695435.1| | 50429 | g163047 | i0 | 87.097 | 0.822916666666667 | 62 | 8 | 32 | 0 | 97 | 158 | 172 | 111 | PREDICTED: Stylophora pistillata uncharacterized LOC111336533 (LOC111336533), ncRNA | blastn | 158 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 26374720 | 26374720 | PRJNA1233465f_S_NODE_268279_length_161_cov_0.910714_g265999_i0 | PRJNA1233465 | 268279 | 161 | 0.910714 | 1.46624954 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g265999 | i0 | 100 | 0.347826086956522 | 28 | 0 | 17 | 0 | 16 | 43 | 412139 | 412112 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26503661 | 26503661 | PRJNA1233465e_S_NODE_92664_length_199_cov_0.946667_g91354_i0 | PRJNA1233465 | 92664 | 199 | 0.946667 | 1.88386733 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|1603797184|ref|XM_028546571.1| | 151771 | g91354 | i0 | 100 | 0.14070351758794 | 28 | 0 | 14 | 0 | 22 | 49 | 3311 | 3284 | PREDICTED: Dendronephthya gigantea glutamyl aminopeptidase-like (LOC114525317), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 26575398 | 26575398 | PRJNA1233465f_S_NODE_190800_length_181_cov_1.871212_g188520_i0 | PRJNA1233465 | 190800 | 181 | 1.871212 | 3.38689372 | Henneguya | 35590 | Cnidaria | other_Eukaryota | 73.1 | 1.18e-8 | NTclustered | gi|2089706640|gb|OK030699.1| | 66478 | g188520 | i0 | 88.71 | 3.25414364640884 | 62 | 4 | 33 | 3 | 109 | 168 | 580 | 520 | Henneguya exilis large subunit ribosomal RNA gene, partial sequence | blastn | 589 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya exilis |
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);;