contig_metadata
23 rows where bioproject = "PRJEB81463", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140489 | 140489 | PRJEB81463_P_NODE_2421_length_650_cov_2.147314_g2158_i0 | PRJEB81463 | 2421 | 650 | 2.147314 | 13.957541 | Suberitida | 1779162 | Porifera | other_Eukaryota | 307 | 4.12e-102 | NR | XP_064395651.1 | 6063 | g2158 | i0 | 70.2 | 3.96461538461538 | 215 | 60 | 99.2 | 1 | 649 | 5 | 4 | 214 | XP_064395651.1 large ribosomal subunit protein uL18 [Halichondria panicea] | diamond | 2577 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 8650622 | 8650622 | PRJEB81463_P_NODE_7767_length_361_cov_0.774306_g7495_i0 | PRJEB81463 | 7767 | 361 | 0.774306 | 2.79524466 | Metazoa | 33208 | Porifera | other_Eukaryota | 130 | 5.24e-34 | NR | XP_064397282.1 | 6063 | g7495 | i0 | 53.7 | 5.99168975069252 | 121 | 55 | 99.7 | 1 | 1 | 360 | 50 | 170 | XP_064397282.1 gamma-glutamyl hydrolase-like [Halichondria panicea] | diamond | 2163 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 9067630 | 9067630 | PRJEB81463_P_NODE_13428_length_285_cov_1.938679_g13156_i0 | PRJEB81463 | 13428 | 285 | 1.938679 | 5.52523515 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 144 | 1.33e-41 | NR | ABB29649.1 | 86007 | g13156 | i0 | 73.4 | 16.8210526315789 | 94 | 25 | 98.9 | 0 | 3 | 284 | 74 | 167 | ABB29649.1 ribosomal protein 3 small subunit, partial [Suberites ficus] | diamond | 4794 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites ficus | |
| 14168699 | 14168699 | PRJEB81463_P_NODE_12672_length_289_cov_2.986111_g12400_i0 | PRJEB81463 | 12672 | 289 | 2.986111 | 8.62986079 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 117 | 3.4e-30 | NR | XP_062521049.1 | 121492 | g12400 | i0 | 67.7 | 0.965397923875433 | 93 | 30 | 96.5 | 0 | 281 | 3 | 41 | 133 | XP_062521049.1 large ribosomal subunit protein uL30-like [Corticium candelabrum] | diamond | 279 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 15443205 | 15443205 | PRJEB81463_P_NODE_8193_length_351_cov_2.100719_g7921_i0 | PRJEB81463 | 8193 | 351 | 2.100719 | 7.37352369 | Metazoa | 33208 | Porifera | other_Eukaryota | 189 | 1.2600000000000001e-59 | NR | XP_065826293.1 | 121494 | g7921 | i0 | 81.7 | 40.3333333333333 | 115 | 21 | 98.3 | 0 | 345 | 1 | 1 | 115 | XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] | diamond | 14157 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 27097431 | 27097431 | PRJEB81463_P_NODE_13102_length_287_cov_1.453271_g12830_i0 | PRJEB81463 | 13102 | 287 | 1.453271 | 4.17088777 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 43.5 | 0.0338 | NR | XP_065888759.1 | 196820 | g12830 | i0 | 30.7 | 0.78397212543554 | 75 | 47 | 73.2 | 2 | 285 | 76 | 640 | 714 | XP_065888759.1 vesicle-fusing ATPase-like [Dysidea avara] | diamond | 225 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 27634696 | 27634696 | PRJEB81463_P_NODE_15284_length_276_cov_1.152709_g15012_i0 | PRJEB81463 | 15284 | 276 | 1.152709 | 3.18147684 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 80.5 | 2.62e-15 | NR | KAI6646252.1 | 111878 | g15012 | i0 | 50 | 0.804347826086957 | 74 | 35 | 80.4 | 1 | 276 | 55 | 243 | 314 | KAI6646252.1 hypothetical protein LOD99_9336 [Oopsacas minuta] | diamond | 222 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 27761174 | 27761174 | PRJEB81463_P_NODE_17524_length_264_cov_2.277487_g17252_i0 | PRJEB81463 | 17524 | 264 | 2.277487 | 6.01256568 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 66.2 | 8.64e-11 | NR | XP_062519832.1 | 121492 | g17252 | i0 | 51.9 | 0.613636363636364 | 54 | 26 | 61.4 | 0 | 257 | 96 | 25 | 78 | XP_062519832.1 LIM and SH3 domain protein 1-like [Corticium candelabrum] | diamond | 162 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27918653 | 27918653 | PRJEB81463_P_NODE_28245_length_242_cov_0.923077_g27973_i0 | PRJEB81463 | 28245 | 242 | 0.923077 | 2.23384634 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 95.5 | 6.59e-21 | NR | XP_065883588.1 | 196820 | g27973 | i0 | 52.5 | 0.991735537190083 | 80 | 38 | 99.2 | 0 | 2 | 241 | 90 | 169 | XP_065883588.1 endoglycoceramidase-like isoform X2 [Dysidea avara] | diamond | 240 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 28108026 | 28108026 | PRJEB81463_P_NODE_16965_length_267_cov_1.386598_g16693_i0 | PRJEB81463 | 16965 | 267 | 1.386598 | 3.70221666 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 101 | 2.919999999999999e-23 | NR | KAI6652366.1 | 111878 | g16693 | i0 | 56.8 | 0.910112359550562 | 81 | 35 | 91 | 0 | 262 | 20 | 203 | 283 | KAI6652366.1 Histone-lysine N-methyltransferase SETMAR-like [Oopsacas minuta] | diamond | 243 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 28676640 | 28676640 | PRJEB81463_P_NODE_9307_length_330_cov_1.501946_g9035_i0 | PRJEB81463 | 9307 | 330 | 1.501946 | 4.9564218 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 117 | 2.3e-30 | NR | CAI8032315.1 | 519541 | g9035 | i0 | 72 | 3.39090909090909 | 75 | 21 | 68.2 | 0 | 328 | 104 | 57 | 131 | CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] | diamond | 1119 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 28708226 | 28708226 | PRJEB81463_P_NODE_14367_length_280_cov_1.797101_g14095_i0 | PRJEB81463 | 14367 | 280 | 1.797101 | 5.0318828 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 51.2 | 5.89e-5 | NR | XP_065177580.1 | 27933 | g14095 | i0 | 34.9 | 0.921428571428571 | 86 | 52 | 90 | 3 | 252 | 1 | 319 | 402 | XP_065177580.1 uncharacterized protein LOC135808335 [Sycon ciliatum] | diamond | 258 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 28732402 | 28732402 | PRJEB81463_P_NODE_14087_length_282_cov_1.167464_g13815_i0 | PRJEB81463 | 14087 | 282 | 1.167464 | 3.29224848 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 59.7 | 6.48e-8 | NR | XP_064406063.1 | 6063 | g13815 | i0 | 51.5 | 6.37234042553191 | 68 | 32 | 72.3 | 1 | 206 | 3 | 514 | 580 | XP_064406063.1 E3 ubiquitin-protein ligase MIB2-like [Halichondria panicea] | diamond | 1797 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 29686569 | 29686569 | PRJEB81463_P_NODE_3290_length_554_cov_3.478170_g3022_i0 | PRJEB81463 | 3290 | 554 | 3.47817 | 19.2690618 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 196 | 5.479999999999999e-60 | NR | CAI8032315.1 | 519541 | g3022 | i0 | 58.7 | 8.99458483754513 | 184 | 57 | 99.6 | 2 | 554 | 3 | 2 | 166 | CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] | diamond | 4983 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 30469585 | 30469585 | PRJEB81463_P_NODE_22533_length_250_cov_0.875706_g22261_i0 | PRJEB81463 | 22533 | 250 | 0.875706 | 2.189265 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 114 | 2.72e-28 | NR | CCQ18610.1 | 27933 | g22261 | i0 | 69.9 | 6.828 | 83 | 25 | 99.6 | 0 | 249 | 1 | 164 | 246 | CCQ18610.1 ribosomal protein RPL1/RPL2/RL4L4 [Sycon ciliatum] | diamond | 1707 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30666140 | 30666140 | PRJEB81463_P_NODE_25533_length_245_cov_1.808140_g25261_i0 | PRJEB81463 | 25533 | 245 | 1.80814 | 4.429943 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 48.1 | 4.69e-4 | NR | XP_065836093.1 | 121494 | g25261 | i0 | 35.4 | 0.96734693877551 | 79 | 44 | 96.7 | 3 | 238 | 2 | 53 | 124 | XP_065836093.1 uncharacterized protein [Oscarella lobularis] | diamond | 237 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30761074 | 30761074 | PRJEB81463_P_NODE_20734_length_252_cov_1.217877_g20462_i0 | PRJEB81463 | 20734 | 252 | 1.217877 | 3.06905004 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 56.6 | 5.17e-7 | NR | KAI6649649.1 | 111878 | g20462 | i0 | 39.5 | 0.964285714285714 | 81 | 45 | 91.7 | 2 | 2 | 232 | 100 | 180 | KAI6649649.1 Bifunctional amine oxidase [Oopsacas minuta] | diamond | 243 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 30919167 | 30919167 | PRJEB81463_P_NODE_8874_length_338_cov_0.833962_g8602_i0 | PRJEB81463 | 8874 | 338 | 0.833962 | 2.81879156 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 73.9 | 1.22e-12 | NR | XP_065911637.1 | 196820 | g8602 | i0 | 41 | 2.66272189349112 | 100 | 49 | 88.8 | 1 | 306 | 7 | 137 | 226 | XP_065911637.1 protein mesh-like [Dysidea avara] | diamond | 900 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30982330 | 30982330 | PRJEB81463_P_NODE_28354_length_242_cov_0.923077_g28082_i0 | PRJEB81463 | 28354 | 242 | 0.923077 | 2.23384634 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 45.1 | 0.00546 | NR | XP_062501884.1 | 121492 | g28082 | i0 | 29.9 | 0.830578512396694 | 67 | 47 | 83.1 | 0 | 223 | 23 | 339 | 405 | XP_062501884.1 nucleoredoxin-like [Corticium candelabrum] | diamond | 201 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 31488243 | 31488243 | PRJEB81463_P_NODE_28896_length_237_cov_2.323171_g28624_i0 | PRJEB81463 | 28896 | 237 | 2.323171 | 5.50591527 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 120 | 5.88e-32 | NR | CAI8032315.1 | 519541 | g28624 | i0 | 76.9 | 5.92405063291139 | 78 | 18 | 98.7 | 0 | 235 | 2 | 15 | 92 | CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] | diamond | 1404 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 31677665 | 31677665 | PRJEB81463_P_NODE_11317_length_302_cov_1.362445_g11045_i0 | PRJEB81463 | 11317 | 302 | 1.362445 | 4.1145839 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 111 | 1.87e-28 | NR | XP_003384061.1 | 400682 | g11045 | i0 | 57.4 | 4.66887417218543 | 94 | 37 | 92.4 | 2 | 13 | 291 | 4 | 95 | XP_003384061.1 PREDICTED: actin-related protein 2/3 complex subunit 3-like [Amphimedon queenslandica] | diamond | 1410 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 31772588 | 31772588 | PRJEB81463_P_NODE_21397_length_251_cov_1.314607_g21125_i0 | PRJEB81463 | 21397 | 251 | 1.314607 | 3.29966357 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 55.8 | 8.2e-7 | NR | CAI8019936.1 | 519541 | g21125 | i0 | 36 | 0.896414342629482 | 75 | 47 | 89.6 | 1 | 226 | 2 | 193 | 266 | CAI8019936.1 hypothetical protein GBAR_LOCUS11939 [Geodia barretti] | diamond | 225 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 31867407 | 31867407 | PRJEB81463_P_NODE_20337_length_253_cov_0.866667_g20065_i0 | PRJEB81463 | 20337 | 253 | 0.866667 | 2.19266751 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 73.9 | 4.46e-13 | NR | XP_065186745.1 | 27933 | g20065 | i0 | 40.5 | 0.99604743083004 | 84 | 48 | 98.4 | 2 | 2 | 250 | 997 | 1079 | XP_065186745.1 ankyrin-3-like [Sycon ciliatum] | diamond | 252 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum |
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);;