contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9473813 | 9473813 | PRJNA561212_P_NODE_11828_length_322_cov_2.172691_g11617_i0 | PRJNA561212 | 11828 | 322 | 2.172691 | 6.99606502 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 134 | 2.02e-36 | NR | CCQ18597.1 | 27933 | g11617 | i0 | 82.5 | 9.71739130434783 | 80 | 14 | 74.5 | 0 | 44 | 283 | 132 | 211 | CCQ18597.1 60S ribosomal protein L7A [Sycon ciliatum] | diamond | 3129 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 12609682 | 12609682 | PRJNA561212_P_NODE_4150_length_543_cov_2.944681_g3942_i0 | PRJNA561212 | 4150 | 543 | 2.944681 | 15.98961783 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 223 | 1.24e-70 | NR | XP_003387703.1 | 400682 | g3942 | i0 | 70.3 | 17.5414364640884 | 158 | 46 | 87.3 | 1 | 486 | 13 | 23 | 179 | XP_003387703.1 PREDICTED: ras-related protein Rab-5C-like [Amphimedon queenslandica] | diamond | 9525 | 223 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 13299611 | 13299611 | PRJNA561212_P_NODE_5551_length_469_cov_1.239899_g5340_i0 | PRJNA561212 | 5551 | 469 | 1.239899 | 5.81512631 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 134 | 4.33e-33 | NR | XP_065904741.1 | 196820 | g5340 | i0 | 50 | 4.5543710021322 | 142 | 63 | 88.9 | 2 | 453 | 37 | 524 | 660 | XP_065904741.1 uncharacterized protein [Dysidea avara] | diamond | 2136 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 17122971 | 17122971 | PRJNA561212_P_NODE_13614_length_303_cov_1.169565_g13403_i0 | PRJNA561212 | 13614 | 303 | 1.169565 | 3.54378195 | Porifera | 6040 | Porifera | other_Eukaryota | 73.2 | 2.52e-13 | NR | XP_019863838.1 | 400682 | g13403 | i0 | 46.1 | 1.8019801980198 | 89 | 46 | 88.1 | 1 | 290 | 24 | 95 | 181 | XP_019863838.1 PREDICTED: heme-binding protein 2-like [Amphimedon queenslandica] | diamond | 546 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 22222470 | 22222470 | PRJNA561212_P_NODE_21978_length_250_cov_0.881356_g21767_i0 | PRJNA561212 | 21978 | 250 | 0.881356 | 2.20339 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 113 | 5e-27 | NR | XP_003386368.1 | 400682 | g21767 | i0 | 65.4 | 1.872 | 78 | 27 | 93.6 | 0 | 8 | 241 | 200 | 277 | XP_003386368.1 PREDICTED: glycerol kinase-like [Amphimedon queenslandica] | diamond | 468 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 26857980 | 26857980 | PRJNA561212_P_NODE_8101_length_385_cov_1.647436_g7890_i0 | PRJNA561212 | 8101 | 385 | 1.647436 | 6.3426286 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 55.1 | 4.71e-6 | NR | XP_065844306.1 | 121494 | g7890 | i0 | 33 | 1.70649350649351 | 112 | 65 | 84.2 | 5 | 58 | 381 | 3 | 108 | XP_065844306.1 G2/mitotic-specific cyclin-B-like [Oscarella lobularis] | diamond | 657 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 26984130 | 26984130 | PRJNA561212_P_NODE_22662_length_248_cov_0.965714_g22451_i0 | PRJNA561212 | 22662 | 248 | 0.965714 | 2.39497072 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 95.1 | 1.47e-20 | NR | XP_065838139.1 | 121494 | g22451 | i0 | 51.9 | 0.979838709677419 | 81 | 39 | 98 | 0 | 248 | 6 | 586 | 666 | XP_065838139.1 uncharacterized protein [Oscarella lobularis] | diamond | 243 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 26984136 | 26984136 | PRJNA561212_P_NODE_6902_length_419_cov_1.309249_g6691_i0 | PRJNA561212 | 6902 | 419 | 1.309249 | 5.48575331 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 50.8 | 3.76e-4 | NR | XP_065911704.1 | 196820 | g6691 | i0 | 50.8 | 0.451073985680191 | 63 | 28 | 43.7 | 2 | 407 | 225 | 817 | 878 | XP_065911704.1 protein NLRC3-like [Dysidea avara] | diamond | 189 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 27346085 | 27346085 | PRJNA561212_P_NODE_20483_length_253_cov_0.866667_g20272_i0 | PRJNA561212 | 20483 | 253 | 0.866667 | 2.19266751 | Demospongiae | 6042 | Porifera | other_Eukaryota | 47 | 0.00133 | NR | XP_064405641.1 | 6063 | g20272 | i0 | 39.7 | 3.85375494071146 | 73 | 39 | 84.2 | 3 | 30 | 242 | 289 | 358 | XP_064405641.1 uncharacterized protein LOC135350735 [Halichondria panicea] | diamond | 975 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27458507 | 27458507 | PRJNA561212_P_NODE_8783_length_371_cov_0.728188_g8572_i0 | PRJNA561212 | 8783 | 371 | 0.728188 | 2.70157748 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 61.2 | 4.39e-8 | NR | XP_064385240.1 | 6063 | g8572 | i0 | 56.5 | 1.15633423180593 | 46 | 20 | 37.2 | 0 | 361 | 224 | 83 | 128 | XP_064385240.1 lysosomal amino acid transporter 1 homolog [Halichondria panicea] | diamond | 429 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27472330 | 27472330 | PRJNA561212_P_NODE_13803_length_301_cov_1.127193_g13592_i0 | PRJNA561212 | 13803 | 301 | 1.127193 | 3.39285093 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 162 | 5.59e-44 | NR | XP_065183765.1 | 27933 | g13592 | i0 | 81.8 | 1.96345514950166 | 99 | 18 | 98.7 | 0 | 4 | 300 | 91 | 189 | XP_065183765.1 von Willebrand factor A domain-containing protein 8-like [Sycon ciliatum] | diamond | 591 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27552786 | 27552786 | PRJNA561212_P_NODE_11404_length_328_cov_1.533333_g11193_i0 | PRJNA561212 | 11404 | 328 | 1.533333 | 5.02933224 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 69.7 | 3.48e-11 | NR | KAI6655606.1 | 111878 | g11193 | i0 | 48.5 | 0.621951219512195 | 68 | 33 | 62.2 | 2 | 242 | 39 | 725 | 790 | KAI6655606.1 hypothetical protein LOD99_2104 [Oopsacas minuta] | diamond | 204 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 28563496 | 28563496 | PRJNA561212_P_NODE_12087_length_320_cov_0.878543_g11876_i0 | PRJNA561212 | 12087 | 320 | 0.878543 | 2.8113376 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 47 | 0.00191 | NR | XP_019863788.1 | 400682 | g11876 | i0 | 34.7 | 0.91875 | 98 | 57 | 85.3 | 2 | 311 | 39 | 97 | 194 | XP_019863788.1 PREDICTED: leucine-rich repeat-containing protein 34-like [Amphimedon queenslandica] | diamond | 294 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 28563511 | 28563511 | PRJNA561212_P_NODE_21887_length_250_cov_0.881356_g21676_i0 | PRJNA561212 | 21887 | 250 | 0.881356 | 2.20339 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 65.1 | 5.51e-10 | NR | XP_065834378.1 | 121494 | g21676 | i0 | 44.7 | 2.748 | 76 | 28 | 91.2 | 2 | 243 | 16 | 363 | 424 | XP_065834378.1 uncharacterized protein [Oscarella lobularis] | diamond | 687 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28703741 | 28703741 | PRJNA561212_P_NODE_18807_length_262_cov_1.439153_g18596_i0 | PRJNA561212 | 18807 | 262 | 1.439153 | 3.77058086 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.8 | 1.57e-8 | NR | XP_062522545.1 | 121492 | g18596 | i0 | 47.5 | 4.03053435114504 | 61 | 31 | 68.7 | 1 | 182 | 3 | 8 | 68 | XP_062522545.1 uncharacterized protein LOC134197272 [Corticium candelabrum] | diamond | 1056 | 61.2 | 0.993464052287582 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28879024 | 28879024 | PRJNA561212_P_NODE_10848_length_336_cov_1.326996_g10637_i0 | PRJNA561212 | 10848 | 336 | 1.326996 | 4.45870656 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 54.3 | 9.89e-6 | NR | XP_064405851.1 | 6063 | g10637 | i0 | 53.1 | 0.4375 | 49 | 22 | 43.8 | 1 | 252 | 106 | 173 | 220 | XP_064405851.1 myosin-10-like isoform X3 [Halichondria panicea] | diamond | 147 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 29257797 | 29257797 | PRJNA561212_P_NODE_15329_length_287_cov_2.200935_g15118_i0 | PRJNA561212 | 15329 | 287 | 2.200935 | 6.31668345 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 89.4 | 2.1e-18 | NR | CAI8058234.1 | 519541 | g15118 | i0 | 50.6 | 3.71080139372822 | 89 | 43 | 92 | 1 | 15 | 278 | 49 | 137 | CAI8058234.1 WD repeat-containing protein 1 [Geodia barretti] | diamond | 1065 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29826254 | 29826254 | PRJNA561212_P_NODE_3211_length_615_cov_2.071956_g3006_i0 | PRJNA561212 | 3211 | 615 | 2.071956 | 12.7425294 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 67 | 3.43e-9 | NR | XP_065830202.1 | 121494 | g3006 | i0 | 44.4 | 0.439024390243902 | 90 | 41 | 42.4 | 3 | 521 | 261 | 247 | 330 | XP_065830202.1 uncharacterized protein [Oscarella lobularis] | diamond | 270 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 29857896 | 29857896 | PRJNA561212_P_NODE_17231_length_273_cov_1.770000_g17020_i0 | PRJNA561212 | 17231 | 273 | 1.77 | 4.8321 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 50.4 | 9.56e-5 | NR | XP_065830202.1 | 121494 | g17020 | i0 | 46.7 | 0.659340659340659 | 60 | 27 | 62.6 | 2 | 172 | 2 | 247 | 304 | XP_065830202.1 uncharacterized protein [Oscarella lobularis] | diamond | 180 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30078946 | 30078946 | PRJNA561212_P_NODE_13772_length_301_cov_1.596491_g13561_i0 | PRJNA561212 | 13772 | 301 | 1.596491 | 4.80543791 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 68.2 | 8.36e-11 | NR | XP_019848915.1 | 400682 | g13561 | i0 | 44 | 0.906976744186046 | 91 | 45 | 90.7 | 1 | 27 | 299 | 249 | 333 | XP_019848915.1 PREDICTED: zinc metalloproteinase-disintegrin-like batroxstatin-3 [Amphimedon queenslandica] | diamond | 273 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 30395450 | 30395450 | PRJNA561212_P_NODE_12013_length_320_cov_2.348178_g11802_i0 | PRJNA561212 | 12013 | 320 | 2.348178 | 7.5141696 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 52.4 | 3.53e-5 | NR | XP_062504150.1 | 121492 | g11802 | i0 | 36.5 | 1.678125 | 63 | 39 | 59.1 | 1 | 124 | 312 | 40 | 101 | XP_062504150.1 SH3 domain-containing YSC84-like protein 1 [Corticium candelabrum] | diamond | 537 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 31184667 | 31184667 | PRJNA561212_P_NODE_19755_length_255_cov_2.192308_g19544_i0 | PRJNA561212 | 19755 | 255 | 2.192308 | 5.5903854 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 44.3 | 0.0124 | NR | XP_019854455.1 | 400682 | g19544 | i0 | 37.9 | 0.776470588235294 | 66 | 40 | 76.5 | 1 | 15 | 209 | 808 | 873 | XP_019854455.1 PREDICTED: uncharacterized protein LOC109583508 [Amphimedon queenslandica] | diamond | 198 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 31596330 | 31596330 | PRJNA561212_P_NODE_24416_length_245_cov_0.906977_g24205_i0 | PRJNA561212 | 24416 | 245 | 0.906977 | 2.22209365 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 44.7 | 0.00778 | NR | XP_065194717.1 | 27933 | g24205 | i0 | 36.5 | 0.771428571428571 | 63 | 27 | 77.1 | 1 | 43 | 231 | 322 | 371 | XP_065194717.1 uncharacterized protein LOC135826014 [Sycon ciliatum] | diamond | 189 | 44.7 | 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);;