contig_metadata
14 rows where bioproject = "PRJNA1073183", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4013626 | 4013626 | PRJNA1073183_P_NODE_2224_length_824_cov_1.496671_g2147_i0 | PRJNA1073183 | 2224 | 824 | 1.496671 | 12.33256904 | Metazoa | 33208 | Porifera | other_Eukaryota | 389 | 2.99e-132 | NR | XP_065841661.1 | 121494 | g2147 | i0 | 68.2 | 7.98058252427184 | 274 | 86 | 99.8 | 1 | 2 | 823 | 44 | 316 | XP_065841661.1 large ribosomal subunit protein uL4A-like [Oscarella lobularis] | diamond | 6576 | 389 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 5290218 | 5290218 | PRJNA1073183_P_NODE_34125_length_241_cov_0.916667_g34030_i0 | PRJNA1073183 | 34125 | 241 | 0.916667 | 2.20916747 | Halisarca dujardinii | 2583056 | Porifera | other_Eukaryota | 129 | 2.06e-36 | NR | QEH04774.1 | 2583056 | g34030 | i0 | 73.8 | 0.995850622406639 | 80 | 21 | 99.6 | 0 | 1 | 240 | 37 | 116 | QEH04774.1 copper/zinc superoxide dismutase, partial [Halisarca dujardinii] | diamond | 240 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Chondrillida | Halisarcidae | Halisarca | Halisarca dujardinii | |
| 16764247 | 16764247 | PRJNA1073183_P_NODE_30194_length_246_cov_1.335260_g30099_i0 | PRJNA1073183 | 30194 | 246 | 1.33526 | 3.2847396 | root | 1 | Root_unresolved | Root_unresolved | 122 | 7.699999999999999e-31 | NR | XP_065904401.1 | 196820 | g30099 | i0 | 74.4 | 37.8658536585366 | 78 | 20 | 95.1 | 0 | 12 | 245 | 98 | 175 | XP_065904401.1 glutaryl-CoA dehydrogenase, mitochondrial-like [Dysidea avara] | diamond | 9315 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 23139539 | 23139539 | PRJNA1073183_P_NODE_24399_length_263_cov_2.473684_g24304_i0 | PRJNA1073183 | 24399 | 263 | 2.473684 | 6.50578892 | Porifera | 6040 | Porifera | other_Eukaryota | 133 | 1.21e-36 | NR | XP_064383513.1 | 6063 | g24304 | i0 | 70.9 | 7.87072243346008 | 86 | 25 | 98.1 | 0 | 4 | 261 | 58 | 143 | XP_064383513.1 large ribosomal subunit protein uL30-like [Halichondria panicea] | diamond | 2070 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27817233 | 27817233 | PRJNA1073183_P_NODE_31284_length_245_cov_0.895349_g31189_i0 | PRJNA1073183 | 31284 | 245 | 0.895349 | 2.19360505 | Porifera | 6040 | Porifera | other_Eukaryota | 104 | 5.29e-24 | NR | XP_003389229.2 | 400682 | g31189 | i0 | 54.3 | 7.95918367346939 | 81 | 36 | 99.2 | 1 | 2 | 244 | 247 | 326 | XP_003389229.2 PREDICTED: autocrine proliferation repressor protein A-like [Amphimedon queenslandica] | diamond | 1950 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 29404246 | 29404246 | PRJNA1073183_P_NODE_29689_length_247_cov_0.885057_g29594_i0 | PRJNA1073183 | 29689 | 247 | 0.885057 | 2.18609079 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 110 | 2.37e-26 | NR | XP_065842109.1 | 121494 | g29594 | i0 | 63.8 | 0.97165991902834 | 80 | 29 | 97.2 | 0 | 245 | 6 | 226 | 305 | XP_065842109.1 uncharacterized protein [Oscarella lobularis] | diamond | 240 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 29719684 | 29719684 | PRJNA1073183_P_NODE_25630_length_255_cov_2.115385_g25535_i0 | PRJNA1073183 | 25630 | 255 | 2.115385 | 5.39423175 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 58.9 | 8.34e-8 | NR | XP_062502844.1 | 121492 | g25535 | i0 | 39.1 | 0.752941176470588 | 64 | 39 | 75.3 | 0 | 230 | 39 | 493 | 556 | XP_062502844.1 uncharacterized protein LOC134179856 [Corticium candelabrum] | diamond | 192 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 29941192 | 29941192 | PRJNA1073183_P_NODE_14231_length_344_cov_1.664207_g14136_i0 | PRJNA1073183 | 14231 | 344 | 1.664207 | 5.72487208 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 123 | 2.61e-31 | NR | XP_064392077.1 | 6063 | g14136 | i0 | 53.5 | 0.994186046511628 | 114 | 50 | 99.4 | 3 | 343 | 2 | 96 | 206 | XP_064392077.1 serine dehydratase-like [Halichondria panicea] | diamond | 342 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31607536 | 31607536 | PRJNA1073183_P_NODE_31036_length_245_cov_0.895349_g30941_i0 | PRJNA1073183 | 31036 | 245 | 0.895349 | 2.19360505 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 86.3 | 1.8e-17 | NR | XP_064385622.1 | 6063 | g30941 | i0 | 54.9 | 2.48571428571429 | 71 | 32 | 86.9 | 0 | 244 | 32 | 162 | 232 | XP_064385622.1 long-chain-fatty-acid--CoA ligase ACSBG2-like isoform X2 [Halichondria panicea] | diamond | 609 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31710921 | 31710921 | PRJNA1073183_P_NODE_32797_length_243_cov_0.905882_g32702_i0 | PRJNA1073183 | 32797 | 243 | 0.905882 | 2.20129326 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 52.8 | 1.12e-5 | NR | XP_065887667.1 | 196820 | g32702 | i0 | 41.7 | 1.48148148148148 | 60 | 35 | 74.1 | 0 | 199 | 20 | 6753 | 6812 | XP_065887667.1 uncharacterized protein [Dysidea avara] | diamond | 360 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 31774064 | 31774064 | PRJNA1073183_P_NODE_28617_length_248_cov_1.565714_g28522_i0 | PRJNA1073183 | 28617 | 248 | 1.565714 | 3.88297072 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 51.6 | 2.89e-5 | NR | CAI8002216.1 | 519541 | g28522 | i0 | 50 | 1.16129032258065 | 48 | 24 | 58.1 | 0 | 1 | 144 | 217 | 264 | CAI8002216.1 WD repeat-containing protein 31 [Geodia barretti] | diamond | 288 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 32343905 | 32343905 | PRJNA1073183_P_NODE_26379_length_251_cov_1.258427_g26284_i0 | PRJNA1073183 | 26379 | 251 | 1.258427 | 3.15865177 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 105 | 4.7e-24 | NR | XP_065838139.1 | 121494 | g26284 | i0 | 64.9 | 0.884462151394422 | 74 | 26 | 88.4 | 0 | 250 | 29 | 454 | 527 | XP_065838139.1 uncharacterized protein [Oscarella lobularis] | diamond | 222 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 32343910 | 32343910 | PRJNA1073183_P_NODE_33739_length_242_cov_0.911243_g33644_i0 | PRJNA1073183 | 33739 | 242 | 0.911243 | 2.20520806 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 59.7 | 3.69e-8 | NR | XP_062519777.1 | 121492 | g33644 | i0 | 35.4 | 1.01652892561983 | 82 | 51 | 99.2 | 1 | 2 | 241 | 246 | 327 | XP_062519777.1 uncharacterized protein LOC134194821 [Corticium candelabrum] | diamond | 246 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32375433 | 32375433 | PRJNA1073183_P_NODE_32859_length_243_cov_0.905882_g32764_i0 | PRJNA1073183 | 32859 | 243 | 0.905882 | 2.20129326 | Suberites domuncula | 55567 | Porifera | other_Eukaryota | 62 | 5.3e-9 | NR | CAH04630.1 | 55567 | g32764 | i0 | 43 | 0.975308641975309 | 79 | 44 | 96.3 | 1 | 4 | 237 | 4 | 82 | CAH04630.1 cathepsin B [Suberites domuncula] | diamond | 237 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula |
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);;