contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA493632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6839430 | 6839430 | PRJNA493632_P_NODE_326046_length_288_cov_1.776744_g322607_i0 | PRJNA493632 | 326046 | 288 | 1.776744 | 5.11702272 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|2664241156|ref|XM_062660598.1| | 121492 | g322607 | i0 | 100 | 0.0972222222222222 | 28 | 0 | 10 | 0 | 222 | 249 | 2675 | 2702 | PREDICTED: Corticium candelabrum beta-mannosidase-like (LOC134191945), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 11938483 | 11938483 | PRJNA493632_P_NODE_215670_length_334_cov_5.858238_g212235_i0 | PRJNA493632 | 215670 | 334 | 5.858238 | 19.56651492 | Halisarca dujardinii | 2583056 | Porifera | other_Eukaryota | 113 | 1.42e-20 | NTclustered | gi|2006291129|gb|MT451960.1| | 2583056 | g212235 | i0 | 84.348 | 12.6526946107784 | 115 | 18 | 34 | 0 | 218 | 332 | 1339 | 1225 | Halisarca dujardinii tubulin alpha 1 mRNA, complete cds | blastn | 4226 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Chondrillida | Halisarcidae | Halisarca | Halisarca dujardinii | |
| 13221430 | 13221430 | PRJNA493632_P_NODE_656751_length_241_cov_0.916667_g653310_i0 | PRJNA493632 | 656751 | 241 | 0.916667 | 2.20916747 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2749581959|ref|XM_066057253.1| | 196820 | g653310 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 84 | 111 | 1254 | 1227 | PREDICTED: Dysidea avara eukaryotic translation initiation factor 2 subunit 2-like (LOC136262840), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 13222626 | 13222626 | PRJNA493632_P_NODE_724211_length_206_cov_6.135338_g720769_i0 | PRJNA493632 | 724211 | 206 | 6.135338 | 12.63879628 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1133471186|ref|XM_011407450.2| | 400682 | g720769 | i0 | 94.444 | 0.174757281553398 | 36 | 1 | 17 | 1 | 128 | 163 | 39 | 5 | PREDICTED: Amphimedon queenslandica mitochondrial inner membrane protease subunit 1-like (LOC105313763), mRNA | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 14495246 | 14495246 | PRJNA493632_P_NODE_593132_length_245_cov_1.424419_g589691_i0 | PRJNA493632 | 593132 | 245 | 1.424419 | 3.48982655 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 165 | 2.72e-36 | NTclustered | gi|2719041159|ref|XM_064528782.1| | 6063 | g589691 | i0 | 82.54 | 7.11836734693878 | 189 | 32 | 77 | 1 | 21 | 208 | 812 | 1000 | PREDICTED: Halichondria panicea WD repeat-containing protein 5-like (LOC135333750), transcript variant X2, mRNA | blastn | 1744 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 17042312 | 17042312 | PRJNA493632_P_NODE_499314_length_252_cov_1.709497_g495875_i0 | PRJNA493632 | 499314 | 252 | 1.709497 | 4.30793244 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2749565488|ref|XM_066049461.1| | 196820 | g495875 | i0 | 96.97 | 0.821428571428571 | 33 | 0 | 13 | 1 | 127 | 159 | 512 | 481 | PREDICTED: Dysidea avara uncharacterized protein (LOC136256487), mRNA | blastn | 207 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 23415965 | 23415965 | PRJNA493632_P_NODE_422379_length_267_cov_2.927835_g418940_i0 | PRJNA493632 | 422379 | 267 | 2.927835 | 7.81731945 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2732936996|ref|XM_065335646.1| | 27933 | g418940 | i0 | 94.444 | 0.955056179775281 | 36 | 1 | 13 | 1 | 215 | 249 | 1790 | 1825 | PREDICTED: Sycon ciliatum uncharacterized LOC135822814 (LOC135822814), transcript variant X1, mRNA | blastn | 255 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 23416440 | 23416440 | PRJNA493632_P_NODE_448059_length_262_cov_2.031746_g444620_i0 | PRJNA493632 | 448059 | 262 | 2.031746 | 5.32317452 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2664361103|ref|XM_062651289.1| | 121492 | g444620 | i0 | 100 | 0.110687022900763 | 29 | 0 | 11 | 0 | 56 | 84 | 1195 | 1223 | PREDICTED: Corticium candelabrum UPF0746 protein DDB_G0281095-like (LOC134183698), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum |
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);;