contig_metadata
6 rows where bioproject = "PRJNA641991", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4445432 | 4445432 | PRJNA641991_P_NODE_4064_length_162_cov_0.902655_g4023_i0 | PRJNA641991 | 4064 | 162 | 0.902655 | 1.4623011 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 67.6 | 4.81e-7 | NTclustered | gi|1133448046|ref|XM_003382388.3| | 400682 | g4023 | i0 | 86.885 | 0.376543209876543 | 61 | 6 | 37 | 2 | 49 | 108 | 1203 | 1262 | PREDICTED: Amphimedon queenslandica 1-phosphatidylinositol 4,5-bisphosphate phosphodiesterase delta-1-like (LOC100634128), mRNA | blastn | 61 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 6996301 | 6996301 | PRJNA641991_P_NODE_2666_length_186_cov_1.240876_g2625_i0 | PRJNA641991 | 2666 | 186 | 1.240876 | 2.30802936 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 126 | 9.24e-25 | NTclustered | gi|1133464558|ref|XM_019997407.1| | 400682 | g2625 | i0 | 82.517 | 4.66129032258065 | 143 | 25 | 77 | 0 | 3 | 145 | 168 | 26 | PREDICTED: Amphimedon queenslandica splicing factor U2AF 35 kDa subunit-like (LOC100634524), mRNA | blastn | 867 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 12097190 | 12097190 | PRJNA641991_S_NODE_3930_length_268_cov_3.027397_g3811_i0 | PRJNA641991 | 3930 | 268 | 3.027397 | 8.11342396 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 209 | 1.38e-49 | NTclustered | gi|2746775371|ref|XM_065971543.1| | 121494 | g3811 | i0 | 85.222 | 147.268656716418 | 203 | 30 | 76 | 0 | 22 | 224 | 279 | 77 | PREDICTED: Oscarella lobularis polyubiquitin (LOC136184629), mRNA | blastn | 39468 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 14646667 | 14646667 | PRJNA641991_P_NODE_2992_length_174_cov_1.240000_g2951_i0 | PRJNA641991 | 2992 | 174 | 1.24 | 2.1576 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 165 | 1.7999999999999998e-36 | NTclustered | gi|2749590118|ref|XM_066061032.1| | 196820 | g2951 | i0 | 84.431 | 86.2931034482759 | 167 | 26 | 96 | 0 | 3 | 169 | 1146 | 1312 | PREDICTED: Dysidea avara polyubiquitin (LOC136266070), mRNA | blastn | 15015 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29575698 | 29575698 | PRJNA641991_S_NODE_6470_length_216_cov_1.179641_g6351_i0 | PRJNA641991 | 6470 | 216 | 1.179641 | 2.54802456 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 56.6 | 3.37e-7 | NR | XP_065919589.1 | 196820 | g6351 | i0 | 49 | 1.70833333333333 | 51 | 19 | 61.1 | 1 | 74 | 205 | 97 | 147 | XP_065919589.1 uncharacterized protein [Dysidea avara] | diamond | 369 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30207334 | 30207334 | PRJNA641991_S_NODE_9452_length_184_cov_1.511111_g9333_i0 | PRJNA641991 | 9452 | 184 | 1.511111 | 2.78044424 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 57 | 3.18e-8 | NR | XP_064393387.1 | 6063 | g9333 | i0 | 51.7 | 1.95652173913043 | 60 | 28 | 97.8 | 1 | 182 | 3 | 57 | 115 | XP_064393387.1 uncharacterized protein LOC135340900 [Halichondria panicea] | diamond | 360 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea |
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);;