contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA541476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1784645 | 1784645 | PRJNA541476_P_NODE_4162_length_563_cov_1.918367_g3966_i0 | PRJNA541476 | 4162 | 563 | 1.918367 | 10.80040621 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 187 | 1.46e-42 | NTclustered | gi|2917940744|emb|OZ237568.1| | 6108 | g3966 | i0 | 79.699 | 54.2415630550622 | 266 | 48 | 47 | 6 | 30 | 292 | 3009806 | 3009544 | Anemonia sulcata genome assembly, chromosome: 14 | blastn | 30538 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 9437589 | 9437589 | PRJNA541476_P_NODE_9808_length_364_cov_1.580756_g9602_i0 | PRJNA541476 | 9808 | 364 | 1.580756 | 5.75395184 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 87.9 | 9.47e-13 | NTclustered | gi|1778067270|ref|XM_031715293.1| | 6105 | g9602 | i0 | 86.42 | 1.26373626373626 | 81 | 10 | 22 | 1 | 171 | 251 | 597 | 676 | PREDICTED: Actinia tenebrosa thioredoxin reductase 1, cytoplasmic-like (LOC116305390), mRNA | blastn | 460 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 15812064 | 15812064 | PRJNA541476_P_NODE_7673_length_408_cov_11.014925_g7469_i0 | PRJNA541476 | 7673 | 408 | 11.014925 | 44.940894 | Ceratomyxa leatherjacketi | 1579382 | Cnidaria | other_Eukaryota | 73.1 | 3.01e-8 | NTclustered | gi|730837044|gb|KM392428.1| | 1579382 | g7469 | i0 | 97.619 | 0.20343137254902 | 42 | 1 | 10 | 0 | 2 | 43 | 421 | 380 | Ceratomyxa leatherjacketi isolate LJ-GB-B 28S ribosomal RNA gene, partial sequence | blastn | 83 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ceratomyxidae | Ceratomyxa | Ceratomyxa leatherjacketi | |
| 17085895 | 17085895 | PRJNA541476_P_NODE_12834_length_327_cov_1.870079_g12628_i0 | PRJNA541476 | 12834 | 327 | 1.870079 | 6.11515833 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 289 | 2.1500000000000003e-73 | NTclustered | gi|2918369536|emb|OZ237718.1| | 317547 | g12628 | i0 | 82.769 | 94.7217125382263 | 325 | 54 | 99 | 2 | 4 | 327 | 17083004 | 17082681 | Eunicella cavolini genome assembly, chromosome: 2 | blastn | 30974 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 22186011 | 22186011 | PRJNA541476_P_NODE_4078_length_568_cov_2.668687_g3882_i0 | PRJNA541476 | 4078 | 568 | 2.668687 | 15.15814216 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 65.8 | 7.19e-6 | NTclustered | gi|2917940735|emb|OZ237565.1| | 6108 | g3882 | i0 | 97.368 | 0.820422535211268 | 38 | 1 | 7 | 0 | 391 | 428 | 8531717 | 8531680 | Anemonia sulcata genome assembly, chromosome: 11 | blastn | 466 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 23460569 | 23460569 | PRJNA541476_P_NODE_10539_length_353_cov_1.382143_g10333_i0 | PRJNA541476 | 10539 | 353 | 1.382143 | 4.87896479 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 60.2 | 1.99e-4 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g10333 | i0 | 90.909 | 0.124645892351275 | 44 | 4 | 12 | 0 | 189 | 232 | 21626739 | 21626782 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 44 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 23461499 | 23461499 | PRJNA541476_P_NODE_5779_length_471_cov_2.987437_g5577_i0 | PRJNA541476 | 5779 | 471 | 2.987437 | 14.07082827 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 207 | 9.24e-49 | NTclustered | gi|2918369552|emb|OZ237724.1| | 317547 | g5577 | i0 | 82.627 | 4.21231422505308 | 236 | 39 | 50 | 2 | 114 | 348 | 197853 | 198087 | Eunicella cavolini genome assembly, chromosome: 8 | blastn | 1984 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 25344870 | 25344870 | PRJNA541476_P_NODE_24360_length_265_cov_1.604167_g24154_i0 | PRJNA541476 | 24360 | 265 | 1.604167 | 4.25104255 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2812148277|ref|XM_068886669.1| | 246305 | g24154 | i0 | 100 | 0.969811320754717 | 29 | 0 | 11 | 0 | 8 | 36 | 676 | 648 | PREDICTED: Montipora capricornis cilia- and flagella-associated protein 251-like (LOC138040935), mRNA | blastn | 257 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis |
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);;