contig_metadata
24 rows where bioproject = "PRJNA893346" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2143612 | 2143612 | PRJNA893346_P_NODE_26682_length_292_cov_2.433790_g26192_i0 | PRJNA893346 | 26682 | 292 | 2.43379 | 7.1066668 | Metazoa | 33208 | Porifera | other_Eukaryota | 148 | 1.18e-41 | NR | XP_064395651.1 | 6063 | g26192 | i0 | 76.6 | 20.3013698630137 | 94 | 22 | 96.6 | 0 | 282 | 1 | 1 | 94 | XP_064395651.1 large ribosomal subunit protein uL18 [Halichondria panicea] | diamond | 5928 | 149 | 0.993288590604027 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 5971513 | 5971513 | PRJNA893346_P_NODE_29325_length_276_cov_1.137931_g28835_i0 | PRJNA893346 | 29325 | 276 | 1.137931 | 3.14068956 | Suberites domuncula | 55567 | Porifera | other_Eukaryota | 129 | 2.7399999999999996e-35 | NR | AAX48846.1 | 55567 | g28835 | i0 | 64.8 | 7.68478260869565 | 88 | 31 | 95.7 | 0 | 264 | 1 | 62 | 149 | AAX48846.1 L13a [Suberites domuncula] | diamond | 2121 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 12347273 | 12347273 | PRJNA893346_P_NODE_27950_length_285_cov_0.877358_g27460_i0 | PRJNA893346 | 27950 | 285 | 0.877358 | 2.5004703 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 108 | 8.959999999999999e-28 | NR | XP_064390491.1 | 6063 | g27460 | i0 | 63.8 | 7.53684210526316 | 80 | 29 | 84.2 | 0 | 46 | 285 | 18 | 97 | XP_064390491.1 LOW QUALITY PROTEIN: large ribosomal subunit protein uL22-like [Halichondria panicea] | diamond | 2148 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 12347344 | 12347344 | PRJNA893346_P_NODE_30910_length_266_cov_1.031088_g30420_i0 | PRJNA893346 | 30910 | 266 | 1.031088 | 2.74269408 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 62.1 | 4.04e-5 | NTclustered | gi|2749562659|ref|XM_066048188.1| | 196820 | g30420 | i0 | 83.582 | 13.6165413533835 | 67 | 9 | 25 | 2 | 152 | 217 | 13399 | 13464 | PREDICTED: Dysidea avara midasin-like (LOC136255428), transcript variant X1, mRNA | blastn | 3622 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 13621477 | 13621477 | PRJNA893346_P_NODE_11291_length_466_cov_3.664122_g10806_i0 | PRJNA893346 | 11291 | 466 | 3.664122 | 17.07480852 | Metazoa | 33208 | Porifera | other_Eukaryota | 195 | 2.47e-60 | NR | CAI8032315.1 | 519541 | g10806 | i0 | 67.8 | 10.6995708154506 | 149 | 47 | 95.3 | 1 | 452 | 9 | 1 | 149 | CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] | diamond | 4986 | 196 | 0.994897959183674 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 13621484 | 13621484 | PRJNA893346_P_NODE_11451_length_463_cov_2.092308_g10966_i0 | PRJNA893346 | 11451 | 463 | 2.092308 | 9.68738604 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 242 | 4.49e-75 | NR | XP_064383637.1 | 6063 | g10966 | i0 | 75.3 | 125.449244060475 | 150 | 37 | 97.2 | 0 | 2 | 451 | 47 | 196 | XP_064383637.1 V-type proton ATPase subunit B [Halichondria panicea] | diamond | 58083 | 243 | 0.995884773662551 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 21270195 | 21270195 | PRJNA893346_P_NODE_31217_length_264_cov_0.842932_g30727_i0 | PRJNA893346 | 31217 | 264 | 0.842932 | 2.22534048 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 105 | 1.15e-24 | NR | XP_065831310.1 | 121494 | g30727 | i0 | 61.3 | 0.909090909090909 | 80 | 29 | 90.9 | 1 | 8 | 247 | 156 | 233 | XP_065831310.1 nucleoredoxin-like [Oscarella lobularis] | diamond | 240 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 23820344 | 23820344 | PRJNA893346_P_NODE_25359_length_302_cov_0.986900_g24869_i0 | PRJNA893346 | 25359 | 302 | 0.9869 | 2.980438 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 127 | 5.81e-32 | NR | XP_064391775.1 | 6063 | g24869 | i0 | 71.3 | 2.72185430463576 | 87 | 25 | 86.4 | 0 | 261 | 1 | 251 | 337 | XP_064391775.1 T-complex protein 1 subunit zeta-like [Halichondria panicea] | diamond | 822 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27031689 | 27031689 | PRJNA893346_P_NODE_16782_length_378_cov_1.901639_g16294_i0 | PRJNA893346 | 16782 | 378 | 1.901639 | 7.18819542 | Metazoa | 33208 | Porifera | other_Eukaryota | 130 | 8.29e-34 | NR | CAI8010544.1 | 519541 | g16294 | i0 | 60.2 | 9.49206349206349 | 108 | 43 | 85.7 | 0 | 325 | 2 | 19 | 126 | CAI8010544.1 26S proteasome regulatory subunit 4 [Geodia barretti] | diamond | 3588 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 27474222 | 27474222 | PRJNA893346_P_NODE_4303_length_783_cov_3.615493_g3873_i0 | PRJNA893346 | 4303 | 783 | 3.615493 | 28.30931019 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 339 | 1.26e-114 | NR | AAX48880.1 | 55567 | g3873 | i0 | 66.5 | 37.5938697318008 | 251 | 84 | 96.2 | 0 | 755 | 3 | 1 | 251 | AAX48880.1 S4 [Suberites domuncula] | diamond | 29436 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 27940121 | 27940121 | PRJNA893346_P_NODE_16445_length_382_cov_1.944984_g15957_i0 | PRJNA893346 | 16445 | 382 | 1.944984 | 7.42983888 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 93.2 | 2.15e-20 | NR | XP_062503325.1 | 121492 | g15957 | i0 | 42.6 | 1.57068062827225 | 101 | 57 | 78.5 | 1 | 382 | 83 | 115 | 215 | XP_062503325.1 ribonuclease Oy-like [Corticium candelabrum] | diamond | 600 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28255643 | 28255643 | PRJNA893346_P_NODE_28026_length_284_cov_1.170616_g27536_i0 | PRJNA893346 | 28026 | 284 | 1.170616 | 3.32454944 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 100 | 8.749999999999999e-23 | NR | XP_003386070.1 | 400682 | g27536 | i0 | 57.8 | 0.950704225352113 | 90 | 37 | 94 | 1 | 267 | 1 | 8 | 97 | XP_003386070.1 PREDICTED: anthocyanidin reductase-like [Amphimedon queenslandica] | diamond | 270 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 28326535 | 28326535 | PRJNA893346_P_NODE_36466_length_246_cov_0.890173_g35976_i0 | PRJNA893346 | 36466 | 246 | 0.890173 | 2.18982558 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 8.2e-6 | NR | XP_062516434.1 | 121492 | g35976 | i0 | 35.7 | 4.76829268292683 | 70 | 45 | 85.4 | 0 | 217 | 8 | 619 | 688 | XP_062516434.1 peroxisomal multifunctional enzyme type 2-like [Corticium candelabrum] | diamond | 1173 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28382053 | 28382053 | PRJNA893346_P_NODE_24186_length_310_cov_1.607595_g23696_i0 | PRJNA893346 | 24186 | 310 | 1.607595 | 4.9835445 | Crateromorpha meyeri | 472232 | Porifera | other_Eukaryota | 60.5 | 1.46e-8 | NR | CAP17588.1 | 472232 | g23696 | i0 | 32.3 | 1.66451612903226 | 99 | 65 | 93.9 | 2 | 20 | 310 | 1 | 99 | CAP17588.1 cathepsin-like protein 5, partial [Crateromorpha meyeri] | diamond | 516 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Rossellidae | Crateromorpha | Crateromorpha meyeri | |
| 29013869 | 29013869 | PRJNA893346_P_NODE_28768_length_279_cov_1.495146_g28278_i0 | PRJNA893346 | 28768 | 279 | 1.495146 | 4.17145734 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 43.9 | 0.023 | NR | XP_065905320.1 | 196820 | g28278 | i0 | 41 | 1.64516129032258 | 61 | 32 | 61.3 | 2 | 277 | 107 | 1374 | 1434 | XP_065905320.1 uncharacterized protein [Dysidea avara] | diamond | 459 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29550114 | 29550114 | PRJNA893346_P_NODE_34370_length_249_cov_1.750000_g33880_i0 | PRJNA893346 | 34370 | 249 | 1.75 | 4.3575 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 51.6 | 3.09e-5 | NR | XP_065910404.1 | 196820 | g33880 | i0 | 28.2 | 0.939759036144578 | 78 | 56 | 94 | 0 | 241 | 8 | 1609 | 1686 | XP_065910404.1 E3 ubiquitin-protein ligase HUWE1-like isoform X1 [Dysidea avara] | diamond | 234 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29929411 | 29929411 | PRJNA893346_P_NODE_23111_length_319_cov_0.939024_g22621_i0 | PRJNA893346 | 23111 | 319 | 0.939024 | 2.99548656 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 52.4 | 3.42e-5 | NR | XP_011409030.1 | 400682 | g22621 | i0 | 33.3 | 0.931034482758621 | 99 | 58 | 87.5 | 4 | 290 | 12 | 215 | 311 | XP_011409030.1 PREDICTED: uncharacterized protein LOC105315949, partial [Amphimedon queenslandica] | diamond | 297 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 30474271 | 30474271 | PRJNA893346_P_NODE_24633_length_307_cov_0.987179_g24143_i0 | PRJNA893346 | 24633 | 307 | 0.987179 | 3.03063953 | Metazoa | 33208 | Porifera | other_Eukaryota | 89.4 | 3.41e-18 | NR | XP_064399390.1 | 6063 | g24143 | i0 | 45 | 8.80456026058632 | 100 | 49 | 97.7 | 2 | 3 | 302 | 969 | 1062 | XP_064399390.1 plasma membrane calcium-transporting ATPase 2-like [Halichondria panicea] | diamond | 2703 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30568611 | 30568611 | PRJNA893346_P_NODE_31413_length_262_cov_1.455026_g30923_i0 | PRJNA893346 | 31413 | 262 | 1.455026 | 3.81216812 | Metazoa | 33208 | Porifera | other_Eukaryota | 114 | 2.7300000000000003e-27 | NR | XP_064406484.1 | 6063 | g30923 | i0 | 68.8 | 13.7290076335878 | 80 | 24 | 90.5 | 1 | 3 | 239 | 100 | 179 | XP_064406484.1 uncharacterized protein LOC135351429 [Halichondria panicea] | diamond | 3597 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31137334 | 31137334 | PRJNA893346_P_NODE_33455_length_251_cov_0.865169_g32965_i0 | PRJNA893346 | 33455 | 251 | 0.865169 | 2.17157419 | Porifera | 6040 | Porifera | other_Eukaryota | 100 | 1.45e-22 | NR | XP_065832637.1 | 121494 | g32965 | i0 | 60.2 | 10.1115537848606 | 83 | 25 | 99.2 | 1 | 2 | 250 | 341 | 415 | XP_065832637.1 exportin-1-like [Oscarella lobularis] | diamond | 2538 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31485690 | 31485690 | PRJNA893346_P_NODE_18156_length_363_cov_1.458621_g17667_i0 | PRJNA893346 | 18156 | 363 | 1.458621 | 5.29479423 | Demospongiae | 6042 | Porifera | other_Eukaryota | 161 | 5.25e-45 | NR | XP_064387462.1 | 6063 | g17667 | i0 | 58.7 | 3.95867768595041 | 121 | 44 | 100 | 1 | 1 | 363 | 231 | 345 | XP_064387462.1 uncharacterized protein LOC135335819 [Halichondria panicea] | diamond | 1437 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31793782 | 31793782 | PRJNA893346_P_NODE_39817_length_241_cov_0.916667_g39327_i0 | PRJNA893346 | 39817 | 241 | 0.916667 | 2.20916747 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 43.5 | 0.0187 | NR | XP_019850379.1 | 400682 | g39327 | i0 | 28.4 | 3.01244813278008 | 81 | 57 | 99.6 | 1 | 1 | 240 | 94 | 174 | XP_019850379.1 PREDICTED: growth arrest-specific protein 7-like isoform X2 [Amphimedon queenslandica] | diamond | 726 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 32363720 | 32363720 | PRJNA893346_P_NODE_11459_length_463_cov_1.525641_g10974_i0 | PRJNA893346 | 11459 | 463 | 1.525641 | 7.06371783 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 97.8 | 1.8e-21 | NR | XP_065191569.1 | 27933 | g10974 | i0 | 47.5 | 0.777537796976242 | 120 | 59 | 77.1 | 3 | 461 | 105 | 81 | 197 | XP_065191569.1 countin-3-like [Sycon ciliatum] | diamond | 360 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32585101 | 32585101 | PRJNA893346_P_NODE_23599_length_315_cov_0.954545_g23109_i0 | PRJNA893346 | 23599 | 315 | 0.954545 | 3.00681675 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 150 | 1.13e-40 | NR | XP_062499291.1 | 121492 | g23109 | i0 | 72.2 | 23.552380952381 | 97 | 27 | 92.4 | 0 | 2 | 292 | 270 | 366 | XP_062499291.1 cystathionine beta-synthase-like [Corticium candelabrum] | diamond | 7419 | 150 | 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);;