contig_metadata
27 rows where bioproject = "PRJNA1010662", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7807426 | 7807426 | PRJNA1010662_P_NODE_15887_length_163_cov_0.921053_g15828_i0 | PRJNA1010662 | 15887 | 163 | 0.921053 | 1.50131639 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 68.9 | 7.28e-12 | NR | XP_065898274.1 | 196820 | g15828 | i0 | 66 | 0.865030674846626 | 47 | 16 | 86.5 | 0 | 1 | 141 | 134 | 180 | XP_065898274.1 polyadenylate-binding protein 1-like [Dysidea avara] | diamond | 141 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 10357967 | 10357967 | PRJNA1010662_P_NODE_13269_length_167_cov_1.745763_g13210_i0 | PRJNA1010662 | 13269 | 167 | 1.745763 | 2.91542421 | Metazoa | 33208 | Porifera | other_Eukaryota | 106 | 3.1900000000000004e-27 | NR | XP_065199288.1 | 27933 | g13210 | i0 | 90.9 | 205.508982035928 | 55 | 5 | 98.8 | 0 | 2 | 166 | 14 | 68 | XP_065199288.1 ras-related protein Rap-1b [Sycon ciliatum] | diamond | 34320 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 10358064 | 10358064 | PRJNA1010662_P_NODE_7969_length_201_cov_1.348684_g7910_i0 | PRJNA1010662 | 7969 | 201 | 1.348684 | 2.71085484 | Metazoa | 33208 | Porifera | other_Eukaryota | 62.4 | 2.02e-9 | NR | AAX48841.1 | 55567 | g7910 | i0 | 63 | 5.49253731343284 | 46 | 17 | 68.7 | 0 | 140 | 3 | 10 | 55 | AAX48841.1 L10e/P0 [Suberites domuncula] | diamond | 1104 | 62.8 | 0.993630573248408 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 11633575 | 11633575 | PRJNA1010662_S_NODE_1710_length_240_cov_1.385787_g1665_i0 | PRJNA1010662 | 1710 | 240 | 1.385787 | 3.3258888 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2749588844|ref|XM_066060469.1| | 196820 | g1665 | i0 | 100 | 0.116666666666667 | 28 | 0 | 12 | 0 | 107 | 134 | 863 | 890 | PREDICTED: Dysidea avara uncharacterized protein (LOC136265593), transcript variant X1, mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 18006638 | 18006638 | PRJNA1010662_P_NODE_1855_length_372_cov_1.594427_g1796_i0 | PRJNA1010662 | 1855 | 372 | 1.594427 | 5.93126844 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 174 | 5.51e-52 | NR | AAX48880.1 | 55567 | g1796 | i0 | 66.1 | 15.3225806451613 | 118 | 40 | 95.2 | 0 | 3 | 356 | 135 | 252 | AAX48880.1 S4 [Suberites domuncula] | diamond | 5700 | 175 | 0.994285714285714 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 23107254 | 23107254 | PRJNA1010662_P_NODE_8279_length_198_cov_1.557047_g8220_i0 | PRJNA1010662 | 8279 | 198 | 1.557047 | 3.08295306 | Porifera | 6040 | Porifera | other_Eukaryota | 125 | 3.63e-33 | NR | XP_062505957.1 | 121492 | g8220 | i0 | 84.6 | 8.86363636363636 | 65 | 10 | 98.5 | 0 | 197 | 3 | 47 | 111 | XP_062505957.1 F-actin-capping protein subunit beta-like [Corticium candelabrum] | diamond | 1755 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27153007 | 27153007 | PRJNA1010662_P_NODE_12062_length_171_cov_1.516393_g12003_i0 | PRJNA1010662 | 12062 | 171 | 1.516393 | 2.59303203 | Metazoa | 33208 | Porifera | other_Eukaryota | 65.9 | 3e-11 | NR | XP_064398260.1 | 6063 | g12003 | i0 | 63.2 | 2.98245614035088 | 57 | 21 | 100 | 0 | 171 | 1 | 144 | 200 | XP_064398260.1 large ribosomal subunit protein eL13-like [Halichondria panicea] | diamond | 510 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27350885 | 27350885 | PRJNA1010662_P_NODE_5783_length_226_cov_2.090395_g5724_i0 | PRJNA1010662 | 5783 | 226 | 2.090395 | 4.7242927 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 89.4 | 8.7e-19 | NR | XP_062513488.1 | 121492 | g5724 | i0 | 58.1 | 0.982300884955752 | 74 | 30 | 98.2 | 1 | 223 | 2 | 360 | 432 | XP_062513488.1 protein dcd1A-like [Corticium candelabrum] | diamond | 222 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28069349 | 28069349 | PRJNA1010662_P_NODE_13545_length_167_cov_0.881356_g13486_i0 | PRJNA1010662 | 13545 | 167 | 0.881356 | 1.47186452 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.1 | 2.98e-12 | NR | XP_065827063.1 | 121494 | g13486 | i0 | 55.1 | 1.79640718562874 | 49 | 22 | 88 | 0 | 147 | 1 | 410 | 458 | XP_065827063.1 spondin-1-like [Oscarella lobularis] | diamond | 300 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28360884 | 28360884 | PRJNA1010662_P_NODE_5986_length_223_cov_2.568966_g5927_i0 | PRJNA1010662 | 5986 | 223 | 2.568966 | 5.72879418 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 55.1 | 1.25e-6 | NR | CAI8057942.1 | 519541 | g5927 | i0 | 37.7 | 0.820627802690583 | 61 | 38 | 82.1 | 0 | 39 | 221 | 465 | 525 | CAI8057942.1 Filamin-B [Geodia barretti] | diamond | 183 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 28732468 | 28732468 | PRJNA1010662_P_NODE_16347_length_162_cov_1.840708_g16288_i0 | PRJNA1010662 | 16347 | 162 | 1.840708 | 2.98194696 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.00255 | NR | XP_062501784.1 | 121492 | g16288 | i0 | 74.1 | 5.40740740740741 | 27 | 7 | 50 | 0 | 83 | 3 | 170 | 196 | XP_062501784.1 uncharacterized protein LOC134178888 [Corticium candelabrum] | diamond | 876 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28953660 | 28953660 | PRJNA1010662_P_NODE_3888_length_266_cov_1.359447_g3829_i0 | PRJNA1010662 | 3888 | 266 | 1.359447 | 3.61612902 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 118 | 1.48e-28 | NR | XP_065196530.1 | 27933 | g3829 | i0 | 62.5 | 2.97744360902256 | 88 | 33 | 99.2 | 0 | 1 | 264 | 315 | 402 | XP_065196530.1 uncharacterized protein LOC135828022 [Sycon ciliatum] | diamond | 792 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29364035 | 29364035 | PRJNA1010662_P_NODE_7169_length_209_cov_1.775000_g7110_i0 | PRJNA1010662 | 7169 | 209 | 1.775 | 3.70975 | Metazoa | 33208 | Porifera | other_Eukaryota | 54.3 | 1.2e-6 | NR | XP_065914926.1 | 196820 | g7110 | i0 | 50 | 1.80861244019139 | 42 | 21 | 60.3 | 0 | 2 | 127 | 142 | 183 | XP_065914926.1 uncharacterized protein [Dysidea avara] | diamond | 378 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29718442 | 29718442 | PRJNA1010662_P_NODE_8550_length_195_cov_2.342466_g8491_i0 | PRJNA1010662 | 8550 | 195 | 2.342466 | 4.5678087 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 79.3 | 2.44e-15 | NR | XP_065884760.1 | 196820 | g8491 | i0 | 56.7 | 0.923076923076923 | 60 | 26 | 92.3 | 0 | 187 | 8 | 304 | 363 | XP_065884760.1 uncharacterized protein [Dysidea avara] | diamond | 180 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30003077 | 30003077 | PRJNA1010662_P_NODE_4591_length_248_cov_1.532663_g4532_i0 | PRJNA1010662 | 4591 | 248 | 1.532663 | 3.80100424 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 108 | 1.16e-25 | NR | KAI6660693.1 | 111878 | g4532 | i0 | 69.6 | 1.88709677419355 | 79 | 24 | 95.6 | 0 | 240 | 4 | 180 | 258 | KAI6660693.1 hypothetical protein LOD99_10304 [Oopsacas minuta] | diamond | 468 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 30153149 | 30153149 | PRJNA1010662_P_NODE_10152_length_183_cov_1.940299_g10093_i0 | PRJNA1010662 | 10152 | 183 | 1.940299 | 3.55074717 | Metazoa | 33208 | Porifera | other_Eukaryota | 85.1 | 1.36e-19 | NR | XP_064389397.1 | 6063 | g10093 | i0 | 84.1 | 41.2622950819672 | 44 | 7 | 72.1 | 0 | 132 | 1 | 34 | 77 | XP_064389397.1 small ribosomal subunit protein eS27 [Halichondria panicea] | diamond | 7551 | 85.9 | 0.990686845168801 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30343524 | 30343524 | PRJNA1010662_P_NODE_2032_length_356_cov_2.315961_g1973_i0 | PRJNA1010662 | 2032 | 356 | 2.315961 | 8.24482116 | Metazoa | 33208 | Porifera | other_Eukaryota | 52 | 7.44e-5 | NR | XP_062508855.1 | 121492 | g1973 | i0 | 37.8 | 4.39044943820225 | 74 | 34 | 62.4 | 1 | 283 | 62 | 68 | 129 | XP_062508855.1 uncharacterized protein LOC134185084 isoform X2 [Corticium candelabrum] | diamond | 1563 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30382494 | 30382494 | PRJNA1010662_P_NODE_13513_length_167_cov_0.881356_g13454_i0 | PRJNA1010662 | 13513 | 167 | 0.881356 | 1.47186452 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 60.8 | 5.31e-9 | NR | XP_062502294.1 | 121492 | g13454 | i0 | 62.8 | 3.07185628742515 | 43 | 16 | 77.2 | 0 | 131 | 3 | 67 | 109 | XP_062502294.1 tryptophan--tRNA ligase, cytoplasmic-like [Corticium candelabrum] | diamond | 513 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30508510 | 30508510 | PRJNA1010662_P_NODE_8553_length_195_cov_2.191781_g8494_i0 | PRJNA1010662 | 8553 | 195 | 2.191781 | 4.27397295 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 49.7 | 6.85e-5 | NR | KAI6653171.1 | 111878 | g8494 | i0 | 45.5 | 0.846153846153846 | 55 | 26 | 78.5 | 2 | 157 | 5 | 112 | 166 | KAI6653171.1 Phospholipase B1, membrane-associated-like [Oopsacas minuta] | diamond | 165 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 30563854 | 30563854 | PRJNA1010662_P_NODE_4413_length_252_cov_1.536946_g4354_i0 | PRJNA1010662 | 4413 | 252 | 1.536946 | 3.87310392 | Porifera | 6040 | Porifera | other_Eukaryota | 57.4 | 2.98e-7 | NR | XP_065842416.1 | 121494 | g4354 | i0 | 42.3 | 2.23809523809524 | 71 | 38 | 81 | 2 | 210 | 7 | 35 | 105 | XP_065842416.1 DNA ligase 3-like [Oscarella lobularis] | diamond | 564 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30792749 | 30792749 | PRJNA1010662_P_NODE_14834_length_165_cov_0.887931_g14775_i0 | PRJNA1010662 | 14834 | 165 | 0.887931 | 1.46508615 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 46.6 | 5.65e-4 | NR | KAI6654086.1 | 111878 | g14775 | i0 | 45.2 | 2.27272727272727 | 42 | 23 | 76.4 | 0 | 127 | 2 | 4879 | 4920 | KAI6654086.1 Midasin [Oopsacas minuta] | diamond | 375 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 30975035 | 30975035 | PRJNA1010662_P_NODE_14274_length_166_cov_0.880342_g14215_i0 | PRJNA1010662 | 14274 | 166 | 0.880342 | 1.46136772 | Metazoa | 33208 | Porifera | other_Eukaryota | 60.1 | 3.82e-9 | NR | KAI6645786.1 | 111878 | g14215 | i0 | 59.5 | 3.30722891566265 | 42 | 17 | 75.9 | 0 | 165 | 40 | 150 | 191 | KAI6645786.1 hypothetical protein LOD99_13049 [Oopsacas minuta] | diamond | 549 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 31354280 | 31354280 | PRJNA1010662_P_NODE_15136_length_164_cov_1.765217_g15077_i0 | PRJNA1010662 | 15136 | 164 | 1.765217 | 2.89495588 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 60.8 | 4.78e-9 | NR | XP_065194069.1 | 27933 | g15077 | i0 | 50 | 3.75 | 52 | 22 | 95.1 | 1 | 8 | 163 | 233 | 280 | XP_065194069.1 poly(3-hydroxybutyrate) depolymerase-like isoform X2 [Sycon ciliatum] | diamond | 615 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31361885 | 31361885 | PRJNA1010662_P_NODE_5636_length_229_cov_0.816667_g5577_i0 | PRJNA1010662 | 5636 | 229 | 0.816667 | 1.87016743 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 42.4 | 0.0443 | NR | CAI8039461.1 | 519541 | g5577 | i0 | 43.5 | 2.41048034934498 | 46 | 15 | 60.3 | 1 | 79 | 216 | 828 | 862 | CAI8039461.1 Peptidyl-tRNA hydrolase ICT1, mitochondrial, partial [Geodia barretti] | diamond | 552 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 31583286 | 31583286 | PRJNA1010662_P_NODE_11856_length_172_cov_1.691057_g11797_i0 | PRJNA1010662 | 11856 | 172 | 1.691057 | 2.90861804 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 67.8 | 1.64e-11 | NR | XP_065837944.1 | 121494 | g11797 | i0 | 56.9 | 6.5406976744186 | 51 | 22 | 89 | 0 | 20 | 172 | 170 | 220 | XP_065837944.1 uncharacterized protein [Oscarella lobularis] | diamond | 1125 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 32057586 | 32057586 | PRJNA1010662_P_NODE_14478_length_165_cov_1.775862_g14419_i0 | PRJNA1010662 | 14478 | 165 | 1.775862 | 2.9301723 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 44.7 | 0.00281 | NR | XP_062519255.1 | 121492 | g14419 | i0 | 42 | 2.72727272727273 | 50 | 28 | 90.9 | 1 | 16 | 165 | 464 | 512 | XP_062519255.1 uncharacterized glycosidase Rv0584-like [Corticium candelabrum] | diamond | 450 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32784170 | 32784170 | PRJNA1010662_P_NODE_15060_length_164_cov_2.634783_g15001_i0 | PRJNA1010662 | 15060 | 164 | 2.634783 | 4.32104412 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 91.3 | 3.2e-20 | NR | XP_062502390.1 | 121492 | g15001 | i0 | 70.4 | 0.98780487804878 | 54 | 16 | 98.8 | 0 | 1 | 162 | 82 | 135 | XP_062502390.1 uncharacterized protein LOC134179495 [Corticium candelabrum] | diamond | 162 | 91.3 | 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);;