contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA796753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3768374 | 3768374 | PRJNA796753_P_NODE_26523_length_292_cov_1.310502_g26211_i0 | PRJNA796753 | 26523 | 292 | 1.310502 | 3.82666584 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|1524880682|ref|XM_027192197.1| | 46731 | g26211 | i0 | 96.774 | 0.212328767123288 | 31 | 1 | 11 | 0 | 190 | 220 | 342 | 372 | PREDICTED: Pocillopora damicornis probable phospholipid-transporting ATPase IIA (LOC113675607), mRNA | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 6320759 | 6320759 | PRJNA796753_P_NODE_44305_length_248_cov_0.880000_g43993_i0 | PRJNA796753 | 44305 | 248 | 0.88 | 2.1824 | Acropora | 6127 | Cnidaria | other_Eukaryota | 60.2 | 1.34e-4 | NTclustered | gi|1005471664|ref|XM_015917213.1| | 70779 | g43993 | i0 | 94.872 | 0.314516129032258 | 39 | 0 | 15 | 2 | 32 | 69 | 1233 | 1270 | PREDICTED: Acropora digitifera transient receptor potential cation channel subfamily A member 1-like (LOC107350950), mRNA | blastn | 78 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 13534279 | 13534279 | PRJNA796753_P_NODE_19551_length_332_cov_1.783784_g19239_i0 | PRJNA796753 | 19551 | 332 | 1.783784 | 5.92216288 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 52.8 | 0.031 | NTclustered | gi|1270043809|ref|XM_022928088.1| | 50429 | g19239 | i0 | 100 | 0.0843373493975904 | 28 | 0 | 8 | 0 | 156 | 183 | 884 | 857 | PREDICTED: Stylophora pistillata pre-mRNA-splicing factor 38B-like (LOC111324510), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 19907425 | 19907425 | PRJNA796753_P_NODE_17996_length_343_cov_0.900000_g17684_i0 | PRJNA796753 | 17996 | 343 | 0.9 | 3.087 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 213 | 1.41e-50 | NTclustered | gi|1176092595|ref|XM_020761131.1| | 48498 | g17684 | i0 | 84.163 | 3.9533527696793 | 221 | 34 | 64 | 1 | 2 | 221 | 311 | 91 | PREDICTED: Orbicella faveolata RING-box protein 1 (LOC110054774), mRNA | blastn | 1356 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 19907430 | 19907430 | PRJNA796753_P_NODE_18636_length_338_cov_1.875472_g18324_i0 | PRJNA796753 | 18636 | 338 | 1.875472 | 6.33909536 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|1270084902|ref|XM_022950109.1| | 50429 | g18324 | i0 | 96.875 | 0.0946745562130177 | 32 | 0 | 9 | 1 | 293 | 324 | 2741 | 2711 | PREDICTED: Stylophora pistillata laccase-5-like (LOC111342984), mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 21618841 | 21618841 | PRJNA796753_P_NODE_41817_length_249_cov_1.039773_g41505_i0 | PRJNA796753 | 41817 | 249 | 1.039773 | 2.58903477 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 108 | 4.74e-19 | NTclustered | gi|1524873661|ref|XM_027188455.1| | 46731 | g41505 | i0 | 78.916 | 2.83132530120482 | 166 | 30 | 66 | 5 | 6 | 170 | 226 | 65 | PREDICTED: Pocillopora damicornis 6-phosphogluconate dehydrogenase, decarboxylating-like (LOC113672178), mRNA | blastn | 705 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 22457998 | 22457998 | PRJNA796753_P_NODE_7098_length_511_cov_1.538813_g6789_i0 | PRJNA796753 | 7098 | 511 | 1.538813 | 7.86333443 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|1619690749|ref|XM_021058266.2| | 2652724 | g6789 | i0 | 100 | 0.176125244618395 | 30 | 0 | 6 | 0 | 473 | 502 | 447 | 418 | PREDICTED: Exaiptasia diaphana uncharacterized LOC110251542 (LOC110251542), transcript variant X3, mRNA | blastn | 90 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 23733364 | 23733364 | PRJNA796753_P_NODE_13759_length_381_cov_3.428571_g13447_i0 | PRJNA796753 | 13759 | 381 | 3.428571 | 13.06285551 | Obelia longissima | 32570 | Cnidaria | other_Eukaryota | 318 | 3.24e-82 | NTclustered | gi|62825449|gb|AY789861.1| | 32570 | g13447 | i0 | 83.728 | 43.0419947506562 | 338 | 53 | 88 | 2 | 1 | 337 | 339 | 3 | Obelia longissima voucher 235NZ calmodulin gene, partial cds | blastn | 16399 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Obeliidae | Obelia | Obelia longissima |
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);;