contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA437204" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 431763 | 431763 | PRJNA437204_P_NODE_114221_length_244_cov_0.900585_g113922_i0 | PRJNA437204 | 114221 | 244 | 0.900585 | 2.1974274 | Eunicea fusca | 204327 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|148250091|gb|EF490983.1| | 204327 | g113922 | i0 | 92.5 | 0.520491803278688 | 40 | 2 | 16 | 1 | 183 | 222 | 170 | 208 | Eunicea fusca internal transcribed spacer 2, partial sequence | blastn | 127 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Eunicea | Eunicea fusca | |
| 1707450 | 1707450 | PRJNA437204_P_NODE_40022_length_324_cov_1.597610_g39723_i0 | PRJNA437204 | 40022 | 324 | 1.59761 | 5.1762564 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 599 | 8.67e-167 | NTclustered | gi|681870001|gb|KM001684.1| | 1542451 | g39723 | i0 | 100 | 5.76851851851852 | 324 | 0 | 100 | 0 | 1 | 324 | 2340 | 2017 | Myxidium streisingeri clone ZF2 18S small subunit ribosomal RNA gene, partial sequence | blastn | 1869 | 599 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 10636927 | 10636927 | PRJNA437204_P_NODE_63589_length_275_cov_1.252475_g63290_i0 | PRJNA437204 | 63589 | 275 | 1.252475 | 3.44430625 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g63290 | i0 | 100 | 0.414545454545455 | 30 | 0 | 11 | 0 | 192 | 221 | 25480024 | 25479995 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 114 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 15735793 | 15735793 | PRJNA437204_P_NODE_69593_length_265_cov_2.645833_g69294_i0 | PRJNA437204 | 69593 | 265 | 2.645833 | 7.01145745 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 93.5 | 1.43e-14 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g69294 | i0 | 77.64 | 2.35471698113208 | 161 | 31 | 59 | 4 | 67 | 223 | 30575131 | 30575290 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 624 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 15735865 | 15735865 | PRJNA437204_P_NODE_73153_length_260_cov_1.582888_g72854_i0 | PRJNA437204 | 73153 | 260 | 1.582888 | 4.1155088 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 58.4 | 5.09e-4 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g72854 | i0 | 97.059 | 0.376923076923077 | 34 | 1 | 13 | 0 | 79 | 112 | 11929962 | 11929929 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 98 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 18283213 | 18283213 | PRJNA437204_P_NODE_106635_length_245_cov_0.982558_g106336_i0 | PRJNA437204 | 106635 | 245 | 0.982558 | 2.4072671 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2782863103|ref|XM_067059373.1| | 252671 | g106336 | i0 | 100 | 0.624489795918367 | 29 | 0 | 12 | 0 | 56 | 84 | 1090 | 1062 | PREDICTED: Clytia hemisphaerica malate dehydrogenase, cytoplasmic-like (LOC136802621), mRNA | blastn | 153 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 18283753 | 18283753 | PRJNA437204_P_NODE_16935_length_439_cov_1.051913_g16636_i0 | PRJNA437204 | 16935 | 439 | 1.051913 | 4.61789807 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 52.8 | 0.042 | NTclustered | gi|1603803351|ref|XM_028549886.1| | 151771 | g16636 | i0 | 100 | 0.0637813211845103 | 28 | 0 | 6 | 0 | 326 | 353 | 444 | 417 | PREDICTED: Dendronephthya gigantea methylcrotonoyl-CoA carboxylase subunit alpha, mitochondrial-like (LOC114528258), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 18284255 | 18284255 | PRJNA437204_P_NODE_44475_length_313_cov_1.283333_g44176_i0 | PRJNA437204 | 44475 | 313 | 1.283333 | 4.01683229 | Stauridiosarsia ophiogaster | 1279102 | Cnidaria | other_Eukaryota | 86.1 | 2.89e-12 | NTclustered | gi|259130312|gb|GQ424307.1| | 1279102 | g44176 | i0 | 85.556 | 26.1916932907348 | 90 | 4 | 28 | 9 | 201 | 287 | 1835 | 1752 | Dipurena ophiogaster 28S ribosomal RNA gene, partial sequence | blastn | 8198 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Corynidae | Stauridiosarsia | Stauridiosarsia ophiogaster | |
| 22110013 | 22110013 | PRJNA437204_P_NODE_84118_length_250_cov_1.011299_g83819_i0 | PRJNA437204 | 84118 | 250 | 1.011299 | 2.5282475 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2729063189|ref|XM_065214364.1| | 499914 | g83819 | i0 | 96.97 | 0.264 | 33 | 1 | 13 | 0 | 69 | 101 | 4242 | 4274 | PREDICTED: Rhopilema esculentum uncharacterized LOC135695305 (LOC135695305), transcript variant X1, mRNA | blastn | 66 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 24659938 | 24659938 | PRJNA437204_P_NODE_97100_length_247_cov_1.770115_g96801_i0 | PRJNA437204 | 97100 | 247 | 1.770115 | 4.37218405 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 163 | 9.88e-36 | NTclustered | gi|2782881614|ref|XM_067063607.1| | 252671 | g96801 | i0 | 80.357 | 29.3036437246964 | 224 | 36 | 89 | 5 | 3 | 222 | 407 | 188 | PREDICTED: Clytia hemisphaerica large ribosomal subunit protein uL4B-like (LOC136807038), mRNA | blastn | 7238 | 163 | 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);;