contig_metadata
11 rows where bioproject = "PRJEB14175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25918544 | 25918544 | PRJEB14175_P_NODE_55524_length_499_cov_10.383562_g53278_i0 | PRJEB14175 | 55524 | 499 | 10.383562 | 51.81397438 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 60.2 | 2.91e-4 | NTclustered | gi|2665855738|ref|XM_062652469.1| | 121492 | g53278 | i0 | 94.737 | 3.81563126252505 | 38 | 2 | 8 | 0 | 413 | 450 | 398 | 435 | PREDICTED: Corticium candelabrum piggyBac transposable element-derived protein 3-like (LOC134184724), mRNA | blastn | 1904 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 26317165 | 26317165 | PRJEB14175_P_NODE_101927_length_353_cov_9.832192_g99661_i0 | PRJEB14175 | 101927 | 353 | 9.832192 | 34.70763776 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 58.4 | 7.17e-4 | NTclustered | gi|2732905565|ref|XM_065340786.1| | 27933 | g99661 | i0 | 100 | 0.0878186968838527 | 31 | 0 | 9 | 0 | 270 | 300 | 1059 | 1029 | PREDICTED: Sycon ciliatum nuclear cap-binding protein subunit 3-like (LOC135828341), mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 26317707 | 26317707 | PRJEB14175_P_NODE_112511_length_333_cov_1.047794_g110245_i0 | PRJEB14175 | 112511 | 333 | 1.047794 | 3.48915402 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 65.8 | 4.03e-6 | NTclustered | gi|2746780687|ref|XM_065974316.1| | 121494 | g110245 | i0 | 91.489 | 0.141141141141141 | 47 | 4 | 14 | 0 | 200 | 246 | 1624 | 1578 | PREDICTED: Oscarella lobularis putative serine/threonine-protein kinase F31E3.2 (LOC136186845), mRNA | blastn | 47 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 26424480 | 26424480 | PRJEB14175_P_NODE_165247_length_259_cov_4.898990_g162980_i0 | PRJEB14175 | 165247 | 259 | 4.89899 | 12.6883841 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 169 | 2.24e-37 | NTclustered | gi|2719038895|ref|XR_010393624.1| | 6063 | g162980 | i0 | 94.495 | 42.2509652509653 | 109 | 6 | 42 | 0 | 131 | 239 | 2160 | 2052 | PREDICTED: Halichondria panicea large subunit ribosomal RNA (LOC135332780), rRNA | blastn | 10943 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 26427096 | 26427096 | PRJEB14175_P_NODE_52255_length_515_cov_15.409692_g50012_i0 | PRJEB14175 | 52255 | 515 | 15.409692 | 79.3599138 | Leucettidae | 81544 | Porifera | other_Eukaryota | 237 | 1.3e-57 | NTclustered | gi|385158759|gb|JQ272297.1| | 197028 | g50012 | i0 | 84.553 | 42.3533980582524 | 246 | 31 | 47 | 7 | 1 | 243 | 2482 | 2723 | Leucetta microraphis voucher QM G313659 28S ribosomal RNA gene, partial sequence | blastn | 21812 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Clathrinida | Leucettidae | Leucetta | Leucetta microraphis | |
| 32942803 | 32942803 | PRJEB14175_P_NODE_141514_length_287_cov_7.292035_g139247_i0 | PRJEB14175 | 141514 | 287 | 7.292035 | 20.92814045 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 43.5 | 0.0134 | NR | XP_065195667.1 | 27933 | g139247 | i0 | 63 | 0.282229965156794 | 27 | 10 | 28.2 | 0 | 245 | 165 | 65 | 91 | XP_065195667.1 uncharacterized protein LOC135827071 [Sycon ciliatum] | diamond | 81 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32956688 | 32956688 | PRJEB14175_P_NODE_108130_length_341_cov_3.189286_g105864_i0 | PRJEB14175 | 108130 | 341 | 3.189286 | 10.87546526 | Metazoa | 33208 | Porifera | other_Eukaryota | 85.1 | 2.7e-17 | NR | XP_065908667.1 | 196820 | g105864 | i0 | 67.2 | 2.50733137829912 | 58 | 19 | 51 | 0 | 319 | 146 | 197 | 254 | XP_065908667.1 uncharacterized protein [Dysidea avara] | diamond | 855 | 85.9 | 0.990686845168801 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32956720 | 32956720 | PRJEB14175_P_NODE_124906_length_311_cov_11.572000_g122639_i0 | PRJEB14175 | 124906 | 311 | 11.572 | 35.98892 | Metazoa | 33208 | Porifera | other_Eukaryota | 136 | 9.91e-39 | NR | XP_065197478.1 | 27933 | g122639 | i0 | 79.7 | 6.54983922829582 | 74 | 15 | 71.4 | 0 | 27 | 248 | 63 | 136 | XP_065197478.1 nucleoside diphosphate kinase B-like [Sycon ciliatum] | diamond | 2037 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32960902 | 32960902 | PRJEB14175_P_NODE_236938_length_207_cov_0.876712_g234670_i0 | PRJEB14175 | 236938 | 207 | 0.876712 | 1.81479384 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 76.6 | 2.55e-14 | NR | XP_065830259.1 | 121494 | g234670 | i0 | 70 | 0.72463768115942 | 50 | 15 | 72.5 | 0 | 12 | 161 | 430 | 479 | XP_065830259.1 tripeptidyl-peptidase 1-like [Oscarella lobularis] | diamond | 150 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 33025040 | 33025040 | PRJEB14175_P_NODE_156268_length_269_cov_3.947115_g154001_i0 | PRJEB14175 | 156268 | 269 | 3.947115 | 10.61773935 | Metazoa | 33208 | Porifera | other_Eukaryota | 54.7 | 3.12e-6 | NR | XP_065175755.1 | 27933 | g154001 | i0 | 65.7 | 2.20817843866171 | 35 | 12 | 39 | 0 | 191 | 87 | 37 | 71 | XP_065175755.1 T-complex protein 1 subunit gamma-like [Sycon ciliatum] | diamond | 594 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 33110325 | 33110325 | PRJEB14175_P_NODE_205974_length_223_cov_52.635802_g203707_i0 | PRJEB14175 | 205974 | 223 | 52.635802 | 117.37783846 | Metazoa | 33208 | Porifera | other_Eukaryota | 47.8 | 4.74e-4 | NR | XP_065887696.1 | 196820 | g203707 | i0 | 65.6 | 0.780269058295964 | 32 | 10 | 43 | 1 | 27 | 122 | 499 | 529 | XP_065887696.1 beta-hexosaminidase subunit beta-like [Dysidea avara] | diamond | 174 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara |
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);;