contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA752278" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3752914 | 3752914 | PRJNA752278_P_NODE_7843_length_497_cov_1.919811_g7640_i0 | PRJNA752278 | 7843 | 497 | 1.919811 | 9.54146067 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|2917940740|emb|OZ237567.1| | 6108 | g7640 | i0 | 100 | 4.58148893360161 | 30 | 0 | 6 | 0 | 170 | 199 | 910297 | 910268 | Anemonia sulcata genome assembly, chromosome: 13 | blastn | 2277 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 6305240 | 6305240 | PRJNA752278_P_NODE_765_length_1182_cov_11.196573_g278_i1 | PRJNA752278 | 765 | 1182 | 11.196573 | 132.34349286 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 135 | 1.16e-26 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g278 | i1 | 86.885 | 10.7021996615905 | 122 | 14 | 10 | 2 | 1060 | 1181 | 233 | 352 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 12650 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis | |
| 7578827 | 7578827 | PRJNA752278_P_NODE_366_length_1556_cov_9.664869_g278_i0 | PRJNA752278 | 366 | 1556 | 9.664869 | 150.38536164 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 135 | 1.54e-26 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g278 | i0 | 86.885 | 8.12982005141388 | 122 | 14 | 8 | 2 | 1434 | 1555 | 233 | 352 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 12650 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis | |
| 8381478 | 8381478 | PRJNA752278_P_NODE_78967_length_251_cov_0.865169_g78764_i0 | PRJNA752278 | 78967 | 251 | 0.865169 | 2.17157419 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2917940752|emb|OZ237570.1| | 6108 | g78764 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 156 | 183 | 10897227 | 10897200 | Anemonia sulcata genome assembly, chromosome: 16 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 11404757 | 11404757 | PRJNA752278_P_NODE_43149_length_284_cov_1.066351_g42946_i0 | PRJNA752278 | 43149 | 284 | 1.066351 | 3.02843684 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 65.8 | 3.37e-6 | NTclustered | gi|2917940737|emb|OZ237566.1| | 6108 | g42946 | i0 | 100 | 12.2746478873239 | 35 | 0 | 12 | 0 | 87 | 121 | 3014320 | 3014354 | Anemonia sulcata genome assembly, chromosome: 12 | blastn | 3486 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 16030706 | 16030706 | PRJNA752278_P_NODE_75893_length_252_cov_2.162011_g75690_i0 | PRJNA752278 | 75893 | 252 | 2.162011 | 5.44826772 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 422 | 1.51e-113 | NTclustered | gi|1176101009|ref|XM_020765566.1| | 48498 | g75690 | i0 | 96.825 | 6 | 252 | 8 | 100 | 0 | 1 | 252 | 10132 | 9881 | PREDICTED: Orbicella faveolata nesprin-1-like (LOC110058896), transcript variant X5, mRNA | blastn | 1512 | 422 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 19854802 | 19854802 | PRJNA752278_P_NODE_55616_length_272_cov_1.321608_g55413_i0 | PRJNA752278 | 55616 | 272 | 1.321608 | 3.59477376 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 60.2 | 1.49e-4 | NTclustered | gi|1270088824|ref|XM_022952205.1| | 50429 | g55413 | i0 | 84.375 | 0.341911764705882 | 64 | 6 | 23 | 4 | 52 | 113 | 132 | 193 | PREDICTED: Stylophora pistillata transcription elongation factor SPT6-like (LOC111344939), mRNA | blastn | 93 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 22404242 | 22404242 | PRJNA752278_P_NODE_111338_length_204_cov_4.122137_g111135_i0 | PRJNA752278 | 111338 | 204 | 4.122137 | 8.40915948 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2784646192|ref|XM_067174192.1| | 159855 | g111135 | i0 | 100 | 0.147058823529412 | 30 | 0 | 15 | 0 | 156 | 185 | 2307 | 2278 | PREDICTED: Acropora muricata opioid-binding protein/cell adhesion molecule-like (LOC136907489), transcript variant X1, mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 24953619 | 24953619 | PRJNA752278_P_NODE_22900_length_339_cov_1.071429_g22697_i0 | PRJNA752278 | 22900 | 339 | 1.071429 | 3.63214431 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 60.2 | 1.91e-4 | NTclustered | gi|1176100932|ref|XM_020765523.1| | 48498 | g22697 | i0 | 97.143 | 0.103244837758112 | 35 | 1 | 10 | 0 | 121 | 155 | 60 | 94 | PREDICTED: Orbicella faveolata 26S proteasome complex subunit SEM1-like (LOC110058861), mRNA | blastn | 35 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 24954454 | 24954454 | PRJNA752278_P_NODE_65780_length_262_cov_1.735450_g65577_i0 | PRJNA752278 | 65780 | 262 | 1.73545 | 4.546879 | Actinia equina | 6106 | Cnidaria | other_Eukaryota | 62.1 | 3.97e-5 | NTclustered | gi|1811115965|gb|MN307080.1| | 6106 | g65577 | i0 | 95 | 3.06106870229008 | 40 | 1 | 18 | 1 | 72 | 110 | 3835 | 3874 | Actinia equina DNA replication licensing factor MCM3-like protein (Mcm3) gene, complete cds | blastn | 802 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia equina |
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);;