contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1151565 | 1151565 | PRJNA630162_P_NODE_63541_length_222_cov_1.150289_g62018_i0 | PRJNA630162 | 63541 | 222 | 1.150289 | 2.55364158 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 137 | 2.61e-39 | NR | ABO26242.1 | 177573 | g62018 | i0 | 97.2 | 3.83783783783784 | 71 | 2 | 95.9 | 0 | 9 | 221 | 91 | 161 | ABO26242.1 14-3-3 E, partial [Hymeniacidon perlevis] | diamond | 852 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Hymeniacidon | Hymeniacidon perlevis | |
| 12081957 | 12081957 | PRJNA630162_P_NODE_67030_length_216_cov_1.898204_g65507_i0 | PRJNA630162 | 67030 | 216 | 1.898204 | 4.10012064 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 105 | 2.11e-24 | NR | XP_065890700.1 | 196820 | g65507 | i0 | 71.4 | 3.83333333333333 | 70 | 20 | 97.2 | 0 | 210 | 1 | 325 | 394 | XP_065890700.1 transmembrane 9 superfamily member 4-like [Dysidea avara] | diamond | 828 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 22279581 | 22279581 | PRJNA630162_P_NODE_58238_length_231_cov_2.060440_g56715_i0 | PRJNA630162 | 58238 | 231 | 2.06044 | 4.7596164 | Metazoa | 33208 | Porifera | other_Eukaryota | 121 | 6.1399999999999995e-30 | NR | XP_062517687.1 | 121492 | g56715 | i0 | 76 | 14.4675324675325 | 75 | 18 | 97.4 | 0 | 226 | 2 | 72 | 146 | XP_062517687.1 protein disulfide-isomerase A4-like [Corticium candelabrum] | diamond | 3342 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 24827555 | 24827555 | PRJNA630162_P_NODE_104060_length_183_cov_1.723881_g102537_i0 | PRJNA630162 | 104060 | 183 | 1.723881 | 3.15470223 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 88.2 | 3.12e-20 | NR | XP_064384635.1 | 6063 | g102537 | i0 | 78.6 | 21.8852459016393 | 56 | 12 | 91.8 | 0 | 170 | 3 | 53 | 108 | XP_064384635.1 large ribosomal subunit protein uL11-like [Halichondria panicea] | diamond | 4005 | 89 | 0.991011235955056 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27093382 | 27093382 | PRJNA630162_P_NODE_161002_length_162_cov_0.920354_g159479_i0 | PRJNA630162 | 161002 | 162 | 0.920354 | 1.49097348 | Demospongiae | 6042 | Porifera | other_Eukaryota | 50.4 | 2.41e-5 | NR | XP_019863948.1 | 400682 | g159479 | i0 | 50 | 2.96296296296296 | 52 | 25 | 94.4 | 1 | 153 | 1 | 320 | 371 | XP_019863948.1 PREDICTED: U4/U6.U5 tri-snRNP-associated protein 2-like [Amphimedon queenslandica] | diamond | 480 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 27143469 | 27143469 | PRJNA630162_P_NODE_131962_length_169_cov_0.866667_g130439_i0 | PRJNA630162 | 131962 | 169 | 0.866667 | 1.46466723 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 50.8 | 1.86e-5 | NR | XP_062505535.1 | 121492 | g130439 | i0 | 47.1 | 0.905325443786982 | 51 | 27 | 90.5 | 0 | 9 | 161 | 368 | 418 | XP_062505535.1 uncharacterized protein LOC134182184 [Corticium candelabrum] | diamond | 153 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27143639 | 27143639 | PRJNA630162_P_NODE_92722_length_190_cov_1.460993_g91199_i0 | PRJNA630162 | 92722 | 190 | 1.460993 | 2.7758867 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 42.7 | 0.0189 | NR | XP_062522369.1 | 121492 | g91199 | i0 | 57.1 | 0.442105263157895 | 28 | 12 | 44.2 | 0 | 38 | 121 | 610 | 637 | XP_062522369.1 disintegrin and metalloproteinase domain-containing protein 12-like isoform X2 [Corticium candelabrum] | diamond | 84 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27156272 | 27156272 | PRJNA630162_P_NODE_169462_length_155_cov_2.226415_g167939_i0 | PRJNA630162 | 169462 | 155 | 2.226415 | 3.45094325 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 83.6 | 3.66e-17 | NR | CAI8058462.1 | 519541 | g167939 | i0 | 75.5 | 62.6129032258064 | 49 | 12 | 94.8 | 0 | 8 | 154 | 364 | 412 | CAI8058462.1 26S proteasome regulatory subunit 6A [Geodia barretti] | diamond | 9705 | 84.3 | 0.991696322657177 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 27712895 | 27712895 | PRJNA630162_P_NODE_141724_length_166_cov_2.290598_g140201_i0 | PRJNA630162 | 141724 | 166 | 2.290598 | 3.80239268 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 43.1 | 0.00784 | NR | KAI6654919.1 | 111878 | g140201 | i0 | 44.7 | 3.66867469879518 | 47 | 26 | 84.9 | 0 | 25 | 165 | 13 | 59 | KAI6654919.1 Tetratricopeptide repeat protein 9C-like [Oopsacas minuta] | diamond | 609 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 27838591 | 27838591 | PRJNA630162_P_NODE_120984_length_174_cov_1.352000_g119461_i0 | PRJNA630162 | 120984 | 174 | 1.352 | 2.35248 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 52.8 | 4.44e-6 | NR | XP_065832505.1 | 121494 | g119461 | i0 | 61.3 | 8.37931034482759 | 31 | 12 | 53.4 | 0 | 82 | 174 | 1271 | 1301 | XP_065832505.1 uncharacterized protein [Oscarella lobularis] | diamond | 1458 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28280589 | 28280589 | PRJNA630162_P_NODE_111126_length_179_cov_1.561538_g109603_i0 | PRJNA630162 | 111126 | 179 | 1.561538 | 2.79515302 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 45.8 | 0.00129 | NR | XP_064399271.1 | 6063 | g109603 | i0 | 51.4 | 0.620111731843575 | 37 | 18 | 62 | 0 | 151 | 41 | 311 | 347 | XP_064399271.1 endoglycoceramidase-like [Halichondria panicea] | diamond | 111 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28343975 | 28343975 | PRJNA630162_P_NODE_156306_length_163_cov_0.912281_g154783_i0 | PRJNA630162 | 156306 | 163 | 0.912281 | 1.48701803 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 45.8 | 0.00105 | NR | XP_064384731.1 | 6063 | g154783 | i0 | 46.2 | 0.957055214723926 | 52 | 20 | 81 | 1 | 156 | 25 | 217 | 268 | XP_064384731.1 uncharacterized protein LOC135333659 [Halichondria panicea] | diamond | 156 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28533621 | 28533621 | PRJNA630162_P_NODE_151867_length_164_cov_0.904348_g150344_i0 | PRJNA630162 | 151867 | 164 | 0.904348 | 1.48313072 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 79.3 | 1.73e-17 | NR | CAI8027902.1 | 519541 | g150344 | i0 | 60.4 | 0.878048780487805 | 48 | 19 | 87.8 | 0 | 146 | 3 | 3 | 50 | CAI8027902.1 Protein PLANT CADMIUM RESISTANCE 2 [Geodia barretti] | diamond | 144 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 28735603 | 28735603 | PRJNA630162_P_NODE_45447_length_262_cov_3.056338_g43924_i0 | PRJNA630162 | 45447 | 262 | 3.0563380000000002 | 8.00760556 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.5 | 4.39e-4 | NR | KAI6650853.1 | 111878 | g43924 | i0 | 38.4 | 2.70229007633588 | 86 | 43 | 98.5 | 3 | 258 | 1 | 106 | 181 | KAI6650853.1 Vanilloid receptor [Oopsacas minuta] | diamond | 708 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 28944209 | 28944209 | PRJNA630162_P_NODE_151128_length_164_cov_1.408696_g149605_i0 | PRJNA630162 | 151128 | 164 | 1.408696 | 2.31026144 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 84.7 | 3.93e-18 | NR | XP_065918428.1 | 196820 | g149605 | i0 | 84.8 | 2.52439024390244 | 46 | 7 | 84.1 | 0 | 164 | 27 | 35 | 80 | XP_065918428.1 large ribosomal subunit protein eL8-like [Dysidea avara] | diamond | 414 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29133453 | 29133453 | PRJNA630162_P_NODE_100789_length_185_cov_1.727941_g99266_i0 | PRJNA630162 | 100789 | 185 | 1.727941 | 3.19669085 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 48.5 | 1.6e-4 | NR | XP_062500709.1 | 121492 | g99266 | i0 | 43.8 | 0.778378378378378 | 48 | 27 | 77.8 | 0 | 183 | 40 | 1970 | 2017 | XP_062500709.1 reelin-like [Corticium candelabrum] | diamond | 144 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 29291130 | 29291130 | PRJNA630162_P_NODE_128729_length_170_cov_1.545455_g127206_i0 | PRJNA630162 | 128729 | 170 | 1.545455 | 2.6272735 | Axinella verrucosa | 237119 | Porifera | other_Eukaryota | 59.3 | 1.97e-8 | NR | CRX66588.1 | 237119 | g127206 | i0 | 50.9 | 0.970588235294118 | 55 | 27 | 97.1 | 0 | 165 | 1 | 397 | 451 | CRX66588.1 putative reverse transcriptase protein [Axinella verrucosa] | diamond | 165 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Axinellida | Axinellidae | Axinella | Axinella verrucosa | |
| 29354534 | 29354534 | PRJNA630162_P_NODE_31849_length_319_cov_3.177778_g30327_i0 | PRJNA630162 | 31849 | 319 | 3.177778 | 10.13711182 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 73.6 | 3.74e-14 | NR | XP_062515044.1 | 121492 | g30327 | i0 | 44.6 | 15.3573667711599 | 101 | 40 | 95 | 1 | 304 | 2 | 17 | 101 | XP_062515044.1 large ribosomal subunit protein uL29-like [Corticium candelabrum] | diamond | 4899 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30080513 | 30080513 | PRJNA630162_P_NODE_164312_length_160_cov_2.054054_g162789_i0 | PRJNA630162 | 164312 | 160 | 2.054054 | 3.2864864 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 58.2 | 4.36e-8 | NR | CAI8005950.1 | 519541 | g162789 | i0 | 49 | 0.95625 | 51 | 26 | 95.6 | 0 | 153 | 1 | 34 | 84 | CAI8005950.1 U3 small nucleolar RNA-associated protein 15 homolog [Geodia barretti] | diamond | 153 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 30093212 | 30093212 | PRJNA630162_P_NODE_82132_length_199_cov_1.673333_g80609_i0 | PRJNA630162 | 82132 | 199 | 1.673333 | 3.32993267 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.9 | 5.54e-15 | NR | XP_062513731.1 | 121492 | g80609 | i0 | 66.7 | 1.4321608040201 | 48 | 16 | 72.4 | 0 | 190 | 47 | 53 | 100 | XP_062513731.1 large ribosomal subunit protein eL31-like [Corticium candelabrum] | diamond | 285 | 74.3 | 0.994616419919246 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30333983 | 30333983 | PRJNA630162_P_NODE_49472_length_251_cov_1.019802_g47949_i0 | PRJNA630162 | 49472 | 251 | 1.019802 | 2.55970302 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 93.6 | 5.45e-20 | NR | XP_065899317.1 | 196820 | g47949 | i0 | 50.6 | 2.91633466135458 | 81 | 37 | 95.6 | 2 | 243 | 4 | 526 | 604 | XP_065899317.1 myosin heavy chain, striated muscle-like [Dysidea avara] | diamond | 732 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 31534613 | 31534613 | PRJNA630162_P_NODE_132576_length_169_cov_0.866667_g131053_i0 | PRJNA630162 | 132576 | 169 | 0.866667 | 1.46466723 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 41.2 | 0.049 | NR | XP_064383922.1 | 6063 | g131053 | i0 | 40.9 | 0.781065088757396 | 44 | 24 | 74.6 | 1 | 148 | 23 | 147 | 190 | XP_064383922.1 G-protein coupled receptor 157-like [Halichondria panicea] | diamond | 132 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31831622 | 31831622 | PRJNA630162_P_NODE_67437_length_215_cov_3.542169_g65914_i0 | PRJNA630162 | 67437 | 215 | 3.542169 | 7.61566335 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 79.7 | 2.42e-15 | NR | XP_065194361.1 | 27933 | g65914 | i0 | 63.2 | 8.65116279069767 | 68 | 25 | 94.9 | 0 | 209 | 6 | 635 | 702 | XP_065194361.1 major vault protein-like [Sycon ciliatum] | diamond | 1860 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31882274 | 31882274 | PRJNA630162_P_NODE_161977_length_162_cov_0.920354_g160454_i0 | PRJNA630162 | 161977 | 162 | 0.920354 | 1.49097348 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 85.1 | 1.49e-17 | NR | XP_062519464.1 | 121492 | g160454 | i0 | 71.7 | 0.981481481481482 | 53 | 12 | 92.6 | 1 | 150 | 1 | 2891 | 2943 | XP_062519464.1 uncharacterized protein LOC134194536 [Corticium candelabrum] | diamond | 159 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 31914018 | 31914018 | PRJNA630162_P_NODE_161337_length_162_cov_0.920354_g159814_i0 | PRJNA630162 | 161337 | 162 | 0.920354 | 1.49097348 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 44.3 | 0.00356 | NR | XP_065888524.1 | 196820 | g159814 | i0 | 45 | 0.740740740740741 | 40 | 22 | 74.1 | 0 | 145 | 26 | 3646 | 3685 | XP_065888524.1 uncharacterized protein [Dysidea avara] | diamond | 120 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32388558 | 32388558 | PRJNA630162_P_NODE_116699_length_176_cov_1.614173_g115176_i0 | PRJNA630162 | 116699 | 176 | 1.614173 | 2.84094448 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 84.7 | 7.42e-18 | NR | XP_065196485.1 | 27933 | g115176 | i0 | 69.8 | 0.903409090909091 | 53 | 16 | 90.3 | 0 | 167 | 9 | 112 | 164 | XP_065196485.1 uncharacterized protein LOC135827974 [Sycon ciliatum] | diamond | 159 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32483696 | 32483696 | PRJNA630162_P_NODE_20259_length_411_cov_2.765193_g18744_i0 | PRJNA630162 | 20259 | 411 | 2.765193 | 11.36494323 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 80.9 | 1.1e-14 | NR | XP_062510609.1 | 121492 | g18744 | i0 | 44.9 | 1.64233576642336 | 98 | 50 | 71.5 | 3 | 407 | 114 | 606 | 699 | XP_062510609.1 uncharacterized protein LOC134186626 [Corticium candelabrum] | diamond | 675 | 80.9 | 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);;