contig_metadata
24 rows where bioproject = "PRJEB39643", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3883905 | 3883905 | PRJEB39643_P_NODE_20704_length_400_cov_2.825688_g20511_i0 | PRJEB39643 | 20704 | 400 | 2.825688 | 11.302752 | Halisarca dujardinii | 2583056 | Porifera | other_Eukaryota | 163 | 7.06e-44 | NR | QIE05298.1 | 2583056 | g20511 | i0 | 71.9 | 3.555 | 114 | 31 | 84.8 | 1 | 62 | 400 | 37 | 150 | QIE05298.1 mitochondrial aconitase ACO2 [Halisarca dujardinii] | diamond | 1422 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Chondrillida | Halisarcidae | Halisarca | Halisarca dujardinii | |
| 7710985 | 7710985 | PRJEB39643_P_NODE_9407_length_647_cov_12.379791_g9227_i0 | PRJEB39643 | 9407 | 647 | 12.379791 | 80.09724777 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 259 | 1.09e-84 | NR | CAI8032315.1 | 519541 | g9227 | i0 | 64.4 | 4.83153013910356 | 208 | 69 | 95.1 | 2 | 6 | 620 | 1 | 206 | CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] | diamond | 3126 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 14086970 | 14086970 | PRJEB39643_P_NODE_9872_length_626_cov_12.376130_g9690_i0 | PRJEB39643 | 9872 | 626 | 12.37613 | 77.4745738 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 258 | 3.39e-84 | NR | CAI8032315.1 | 519541 | g9690 | i0 | 66.7 | 16.629392971246 | 204 | 64 | 96.8 | 2 | 621 | 16 | 1 | 202 | CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] | diamond | 10410 | 258 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 19182683 | 19182683 | PRJEB39643_P_NODE_107696_length_258_cov_1.329730_g107503_i0 | PRJEB39643 | 107696 | 258 | 1.32973 | 3.4307034 | Porifera | 6040 | Porifera | other_Eukaryota | 87 | 2.7e-20 | NR | ABQ11843.1 | 76350 | g107503 | i0 | 68.9 | 2.87209302325581 | 61 | 19 | 70.9 | 0 | 183 | 1 | 5 | 65 | ABQ11843.1 ATP synthase F0 subunit 9 [Sympagella nux] | diamond | 741 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Rossellidae | Sympagella | Sympagella nux | |
| 21734474 | 21734474 | PRJEB39643_P_NODE_18638_length_423_cov_3.722857_g18445_i0 | PRJEB39643 | 18638 | 423 | 3.722857 | 15.74768511 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 214 | 2.78e-69 | NR | XP_065826293.1 | 121494 | g18445 | i0 | 79.2 | 7.3758865248227 | 130 | 27 | 92.2 | 0 | 421 | 32 | 1 | 130 | XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] | diamond | 3120 | 214 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 27279753 | 27279753 | PRJEB39643_P_NODE_93163_length_264_cov_1.685864_g92970_i0 | PRJEB39643 | 93163 | 264 | 1.685864 | 4.45068096 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 110 | 7.88e-27 | NR | XP_065183523.1 | 27933 | g92970 | i0 | 58.1 | 5.59090909090909 | 86 | 36 | 97.7 | 0 | 262 | 5 | 45 | 130 | XP_065183523.1 mitochondrial substrate carrier family protein G-like [Sycon ciliatum] | diamond | 1476 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 28012762 | 28012762 | PRJEB39643_P_NODE_37885_length_304_cov_3.333333_g37692_i0 | PRJEB39643 | 37885 | 304 | 3.333333 | 10.13333232 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 165 | 4.42e-48 | NR | XP_003388041.1 | 400682 | g37692 | i0 | 77 | 4.96381578947368 | 100 | 23 | 98.7 | 0 | 1 | 300 | 104 | 203 | XP_003388041.1 PREDICTED: inorganic pyrophosphatase-like [Amphimedon queenslandica] | diamond | 1509 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 28201815 | 28201815 | PRJEB39643_P_NODE_29626_length_338_cov_3.064151_g29433_i0 | PRJEB39643 | 29626 | 338 | 3.064151 | 10.35683038 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 63.5 | 5.65e-9 | NR | XP_065830295.1 | 121494 | g29433 | i0 | 40.8 | 0.869822485207101 | 98 | 50 | 81.7 | 3 | 41 | 316 | 273 | 368 | XP_065830295.1 uncharacterized protein [Oscarella lobularis] | diamond | 294 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28289952 | 28289952 | PRJEB39643_P_NODE_127866_length_249_cov_1.750000_g127673_i0 | PRJEB39643 | 127866 | 249 | 1.75 | 4.3575 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 118 | 8.840000000000001e-29 | NR | XP_065890981.1 | 196820 | g127673 | i0 | 63.3 | 11.3373493975904 | 79 | 29 | 95.2 | 0 | 237 | 1 | 36 | 114 | XP_065890981.1 RING-type E3 ubiquitin-protein ligase PPIL2-like [Dysidea avara] | diamond | 2823 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 28448178 | 28448178 | PRJEB39643_P_NODE_39966_length_297_cov_2.062500_g39773_i0 | PRJEB39643 | 39966 | 297 | 2.0625 | 6.125625 | Homosclerophorida | 81000 | Porifera | other_Eukaryota | 79.3 | 9.48e-15 | NR | XP_062503312.1 | 121492 | g39773 | i0 | 50.6 | 7.5959595959596 | 89 | 43 | 89.9 | 1 | 296 | 30 | 55 | 142 | XP_062503312.1 uncharacterized protein LOC134180224 [Corticium candelabrum] | diamond | 2256 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28644219 | 28644219 | PRJEB39643_P_NODE_40107_length_296_cov_3.515695_g39914_i0 | PRJEB39643 | 40107 | 296 | 3.515695 | 10.4064572 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 65.5 | 7.02e-10 | NR | XP_065835085.1 | 121494 | g39914 | i0 | 44.9 | 2.88851351351351 | 69 | 28 | 59.8 | 1 | 109 | 285 | 258 | 326 | XP_065835085.1 uncharacterized protein [Oscarella lobularis] | diamond | 855 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 29048031 | 29048031 | PRJEB39643_P_NODE_62448_length_279_cov_2.737864_g62255_i0 | PRJEB39643 | 62448 | 279 | 2.737864 | 7.63864056 | Metazoa | 33208 | Porifera | other_Eukaryota | 100 | 1.1099999999999999e-23 | NR | XP_065828922.1 | 121494 | g62255 | i0 | 57.6 | 9.74193548387097 | 85 | 36 | 91.4 | 0 | 6 | 260 | 143 | 227 | XP_065828922.1 ubiquitin carboxyl-terminal hydrolase isozyme L3-like isoform X2 [Oscarella lobularis] | diamond | 2718 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 29458062 | 29458062 | PRJEB39643_P_NODE_51490_length_285_cov_1.452830_g51297_i0 | PRJEB39643 | 51490 | 285 | 1.45283 | 4.1405655 | Metazoa | 33208 | Porifera | other_Eukaryota | 52.4 | 2.31e-5 | NR | CAI8022780.1 | 519541 | g51297 | i0 | 38.3 | 2.8 | 81 | 48 | 83.2 | 1 | 5 | 241 | 253 | 333 | CAI8022780.1 Ubiquitin carboxyl-terminal hydrolase isozyme L5 [Geodia barretti] | diamond | 798 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29584345 | 29584345 | PRJEB39643_P_NODE_107850_length_257_cov_2.793478_g107657_i0 | PRJEB39643 | 107850 | 257 | 2.793478 | 7.17923846 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 4.5600000000000005e-33 | NR | XP_065891031.1 | 196820 | g107657 | i0 | 68.2 | 14.8832684824903 | 85 | 26 | 99.2 | 1 | 1 | 255 | 90 | 173 | XP_065891031.1 60S ribosome subunit biogenesis protein NIP7 homolog [Dysidea avara] | diamond | 3825 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29963665 | 29963665 | PRJEB39643_P_NODE_17631_length_436_cov_1.696970_g17438_i0 | PRJEB39643 | 17631 | 436 | 1.69697 | 7.3987892 | Metazoa | 33208 | Porifera | other_Eukaryota | 105 | 7.1e-24 | NR | CAI8049614.1 | 519541 | g17438 | i0 | 47.1 | 9.33715596330275 | 119 | 57 | 81.9 | 3 | 418 | 62 | 223 | 335 | CAI8049614.1 Eukaryotic translation initiation factor 3 subunit L [Geodia barretti] | diamond | 4071 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 30026906 | 30026906 | PRJEB39643_P_NODE_147951_length_242_cov_0.911243_g147758_i0 | PRJEB39643 | 147951 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 7e-28 | NR | XP_065176979.1 | 27933 | g147758 | i0 | 67.5 | 4.97107438016529 | 80 | 26 | 99.2 | 0 | 242 | 3 | 195 | 274 | XP_065176979.1 unconventional myosin-XV-like [Sycon ciliatum] | diamond | 1203 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30286563 | 30286563 | PRJEB39643_P_NODE_135172_length_246_cov_1.780347_g134979_i0 | PRJEB39643 | 135172 | 246 | 1.780347 | 4.37965362 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 89.4 | 1.43e-18 | NR | XP_065910196.1 | 196820 | g134979 | i0 | 54.5 | 1.8780487804878 | 77 | 26 | 93.9 | 2 | 12 | 242 | 335 | 402 | XP_065910196.1 phospholipase B-like 1 [Dysidea avara] | diamond | 462 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30343260 | 30343260 | PRJEB39643_P_NODE_27372_length_350_cov_5.306859_g27179_i0 | PRJEB39643 | 27372 | 350 | 5.306859 | 18.5740065 | Homosclerophorida | 81000 | Porifera | other_Eukaryota | 178 | 1.69e-51 | NR | XP_062510156.1 | 121492 | g27179 | i0 | 65.2 | 2.94857142857143 | 115 | 40 | 98.6 | 0 | 2 | 346 | 216 | 330 | XP_062510156.1 uncharacterized protein LOC134186259 [Corticium candelabrum] | diamond | 1032 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30349894 | 30349894 | PRJEB39643_P_NODE_16212_length_457_cov_3.375000_g16020_i0 | PRJEB39643 | 16212 | 457 | 3.375 | 15.42375 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 186 | 1.37e-56 | NR | CAI8032315.1 | 519541 | g16020 | i0 | 74.6 | 1.65426695842451 | 126 | 30 | 82.7 | 1 | 3 | 380 | 10 | 133 | CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] | diamond | 756 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 30728478 | 30728478 | PRJEB39643_P_NODE_37374_length_306_cov_2.643777_g37181_i0 | PRJEB39643 | 37374 | 306 | 2.643777 | 8.08995762 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 57.8 | 4.37e-7 | NR | XP_064404393.1 | 6063 | g37181 | i0 | 39.1 | 2.40196078431373 | 87 | 47 | 85.3 | 3 | 10 | 270 | 731 | 811 | XP_064404393.1 uncharacterized protein LOC135349721 isoform X2 [Halichondria panicea] | diamond | 735 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30879796 | 30879796 | PRJEB39643_P_NODE_152374_length_236_cov_3.165644_g152181_i0 | PRJEB39643 | 152374 | 236 | 3.165644 | 7.47091984 | Metazoa | 33208 | Porifera | other_Eukaryota | 103 | 4.61e-24 | NR | XP_065833744.1 | 121494 | g152181 | i0 | 58.9 | 4.72881355932203 | 73 | 30 | 92.8 | 0 | 226 | 8 | 311 | 383 | XP_065833744.1 elongation factor 1-gamma-like [Oscarella lobularis] | diamond | 1116 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31645084 | 31645084 | PRJEB39643_P_NODE_22997_length_380_cov_2.912052_g22804_i0 | PRJEB39643 | 22997 | 380 | 2.912052 | 11.0657976 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 132 | 8.39e-35 | NR | XP_065832753.1 | 121494 | g22804 | i0 | 51.1 | 1.03421052631579 | 131 | 59 | 99.5 | 2 | 2 | 379 | 106 | 236 | XP_065832753.1 mitochondrial substrate carrier family protein G-like [Oscarella lobularis] | diamond | 393 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31708482 | 31708482 | PRJEB39643_P_NODE_18217_length_428_cov_3.870423_g18024_i0 | PRJEB39643 | 18217 | 428 | 3.870423 | 16.56541044 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 58.5 | 4.17e-7 | NR | XP_065828752.1 | 121494 | g18024 | i0 | 42.6 | 0.427570093457944 | 61 | 35 | 42.8 | 0 | 5 | 187 | 177 | 237 | XP_065828752.1 uncharacterized protein [Oscarella lobularis] | diamond | 183 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31771765 | 31771765 | PRJEB39643_P_NODE_93077_length_264_cov_2.314136_g92884_i0 | PRJEB39643 | 93077 | 264 | 2.314136 | 6.10931904 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 59.3 | 7.02e-8 | NR | XP_065199181.1 | 27933 | g92884 | i0 | 50 | 1.22727272727273 | 54 | 27 | 61.4 | 0 | 259 | 98 | 735 | 788 | XP_065199181.1 uncharacterized protein LOC135830891 isoform X3 [Sycon ciliatum] | diamond | 324 | 59.3 | 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);;