contig_metadata
23 rows where bioproject = "PRJNA689790" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 668720 | 668720 | PRJNA689790_S_NODE_15941_length_153_cov_2.008621_g15826_i0 | PRJNA689790 | 15941 | 153 | 2.008621 | 3.07319013 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 95.3 | 2.05e-15 | NTclustered | gi|457867032|emb|HF570310.1| | 27933 | g15826 | i0 | 80.952 | 3.09803921568627 | 126 | 18 | 80 | 5 | 9 | 131 | 208 | 330 | Sycon ciliatum mRNA for 60S ribosomal protein L22 (rpl22 gene) | blastn | 474 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 1178134 | 1178134 | PRJNA689790_S_NODE_421_length_1145_cov_3.591155_g381_i0 | PRJNA689790 | 421 | 1145 | 3.591155 | 41.11872475 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 198 | 4.63e-52 | NR | XP_064404248.1 | 6063 | g381 | i0 | 60.3 | 37.2026200873362 | 179 | 68 | 46.9 | 2 | 529 | 1065 | 530 | 705 | XP_064404248.1 ATP-dependent translocase ABCB1-like [Halichondria panicea] | diamond | 42597 | 199 | 0.994974874371859 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 5006460 | 5006460 | PRJNA689790_S_NODE_2904_length_370_cov_5.843844_g2789_i0 | PRJNA689790 | 2904 | 370 | 5.843844 | 21.6222228 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 137 | 1.39e-35 | NR | XP_062508004.1 | 121492 | g2789 | i0 | 66 | 1.57297297297297 | 97 | 32 | 78.6 | 1 | 368 | 78 | 374 | 469 | XP_062508004.1 protein disulfide-isomerase-like [Corticium candelabrum] | diamond | 582 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 8831085 | 8831085 | PRJNA689790_S_NODE_2687_length_387_cov_3.337143_g2572_i0 | PRJNA689790 | 2687 | 387 | 3.337143 | 12.91474341 | Porifera | 6040 | Porifera | other_Eukaryota | 111 | 1.3e-28 | NR | XP_062501865.1 | 121492 | g2572 | i0 | 63.2 | 3.85271317829457 | 87 | 32 | 67.4 | 0 | 267 | 7 | 16 | 102 | XP_062501865.1 large ribosomal subunit protein eL22-like [Corticium candelabrum] | diamond | 1491 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 12148057 | 12148057 | PRJNA689790_S_NODE_4410_length_289_cov_1.996032_g4295_i0 | PRJNA689790 | 4410 | 289 | 1.996032 | 5.76853248 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 137 | 1.59e-36 | NR | KAI6661215.1 | 111878 | g4295 | i0 | 70.8 | 4.96193771626298 | 96 | 27 | 99.7 | 1 | 289 | 2 | 82 | 176 | KAI6661215.1 Ribosomal protein L4/L1 family [Oopsacas minuta] | diamond | 1434 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 17246617 | 17246617 | PRJNA689790_S_NODE_15974_length_153_cov_1.681034_g15859_i0 | PRJNA689790 | 15974 | 153 | 1.681034 | 2.57198202 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 143 | 7.23e-30 | NTclustered | gi|2746767005|ref|XM_065987471.1| | 121494 | g15859 | i0 | 84 | 23.718954248366 | 150 | 22 | 97 | 2 | 1 | 149 | 1032 | 1180 | PREDICTED: Oscarella lobularis succinate dehydrogenase [ubiquinone] flavoprotein subunit, mitochondrial-like (LOC136197657), mRNA | blastn | 3629 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 19795648 | 19795648 | PRJNA689790_S_NODE_15656_length_154_cov_2.076923_g15541_i0 | PRJNA689790 | 15656 | 154 | 2.076923 | 3.19846142 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 121 | 3.4199999999999996e-23 | NTclustered | gi|2732905537|ref|XM_065340773.1| | 27933 | g15541 | i0 | 86.364 | 10.012987012987 | 110 | 15 | 71 | 0 | 8 | 117 | 189 | 80 | PREDICTED: Sycon ciliatum actin-2-like (LOC135828326), mRNA | blastn | 1542 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 26904122 | 26904122 | PRJNA689790_S_NODE_3521_length_331_cov_3.989796_g3406_i0 | PRJNA689790 | 3521 | 331 | 3.989796 | 13.20622476 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.5 | 9.66e-4 | NR | XP_064404144.1 | 6063 | g3406 | i0 | 33.3 | 8.19335347432024 | 108 | 47 | 87 | 6 | 41 | 328 | 4 | 98 | XP_064404144.1 E3 ubiquitin-protein ligase TRIM36-like [Halichondria panicea] | diamond | 2712 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 26987311 | 26987311 | PRJNA689790_S_NODE_7602_length_214_cov_1.757062_g7487_i0 | PRJNA689790 | 7602 | 214 | 1.757062 | 3.76011268 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 86.3 | 4.11e-18 | NR | XP_019854374.1 | 400682 | g7487 | i0 | 66.7 | 0.841121495327103 | 60 | 20 | 84.1 | 0 | 2 | 181 | 257 | 316 | XP_019854374.1 PREDICTED: GDP-L-fucose synthase-like [Amphimedon queenslandica] | diamond | 180 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 27145145 | 27145145 | PRJNA689790_S_NODE_6322_length_238_cov_1.711443_g6207_i0 | PRJNA689790 | 6322 | 238 | 1.711443 | 4.07323434 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 95.9 | 1.7700000000000003e-21 | NR | XP_065843521.1 | 121494 | g6207 | i0 | 53 | 1.04621848739496 | 83 | 26 | 95.8 | 2 | 5 | 232 | 117 | 193 | XP_065843521.1 cathepsin B-like cysteine proteinase 3 [Oscarella lobularis] | diamond | 249 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 27619518 | 27619518 | PRJNA689790_S_NODE_11824_length_173_cov_2.007353_g11709_i0 | PRJNA689790 | 11824 | 173 | 2.007353 | 3.47272069 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 77 | 9.3e-15 | NR | XP_064393767.1 | 6063 | g11709 | i0 | 51.9 | 0.936416184971098 | 54 | 26 | 93.6 | 0 | 2 | 163 | 114 | 167 | XP_064393767.1 SH2/SH3 adapter protein NCK1-like [Halichondria panicea] | diamond | 162 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27662665 | 27662665 | PRJNA689790_S_NODE_8164_length_207_cov_1.264706_g8049_i0 | PRJNA689790 | 8164 | 207 | 1.264706 | 2.61794142 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 123 | 8.299999999999999e-32 | NR | XP_065182952.1 | 27933 | g8049 | i0 | 86.8 | 20.695652173913 | 68 | 9 | 98.6 | 0 | 2 | 205 | 122 | 189 | XP_065182952.1 actin-related protein 2-B [Sycon ciliatum] | diamond | 4284 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27998508 | 27998508 | PRJNA689790_S_NODE_7665_length_213_cov_2.431818_g7550_i0 | PRJNA689790 | 7665 | 213 | 2.431818 | 5.17977234 | Lubomirskia baikalensis | 289074 | Porifera | other_Eukaryota | 42 | 0.0499 | NR | CAP69654.1 | 289074 | g7550 | i0 | 40.4 | 0.802816901408451 | 57 | 31 | 80.3 | 1 | 171 | 1 | 1276 | 1329 | CAP69654.1 polyprotein [Lubomirskia baikalensis] | diamond | 171 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Spongillida | Lubomirskiidae | Lubomirskia | Lubomirskia baikalensis | |
| 29387707 | 29387707 | PRJNA689790_S_NODE_1209_length_603_cov_9.054770_g1114_i0 | PRJNA689790 | 1209 | 603 | 9.05477 | 54.6002631 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 85.9 | 1.32e-15 | NR | XP_064401886.1 | 6063 | g1114 | i0 | 36.6 | 1.44776119402985 | 145 | 65 | 67.7 | 7 | 469 | 62 | 366 | 492 | XP_064401886.1 von Willebrand factor-like isoform X3 [Halichondria panicea] | diamond | 873 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 29861207 | 29861207 | PRJNA689790_S_NODE_5011_length_270_cov_1.875536_g4896_i0 | PRJNA689790 | 5011 | 270 | 1.875536 | 5.0639472 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 105 | 2.76e-24 | NR | KAI6652895.1 | 111878 | g4896 | i0 | 63 | 2.8 | 73 | 27 | 81.1 | 0 | 2 | 220 | 353 | 425 | KAI6652895.1 Eukaryotic peptide chain release factor subunit 1 [Oopsacas minuta] | diamond | 756 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 29987608 | 29987608 | PRJNA689790_S_NODE_4871_length_274_cov_1.810127_g4756_i0 | PRJNA689790 | 4871 | 274 | 1.810127 | 4.95974798 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 45.8 | 0.00447 | NR | XP_011405206.1 | 400682 | g4756 | i0 | 41.4 | 1.27007299270073 | 58 | 33 | 62.4 | 1 | 273 | 103 | 517 | 574 | XP_011405206.1 PREDICTED: uncharacterized protein LOC105313455 [Amphimedon queenslandica] | diamond | 348 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 30240352 | 30240352 | PRJNA689790_S_NODE_1732_length_502_cov_4.701075_g1623_i0 | PRJNA689790 | 1732 | 502 | 4.701075 | 23.5993965 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 77.4 | 4.13e-13 | NR | XP_065177580.1 | 27933 | g1623 | i0 | 43.2 | 0.705179282868526 | 118 | 58 | 68.7 | 7 | 369 | 25 | 186 | 297 | XP_065177580.1 uncharacterized protein LOC135808335 [Sycon ciliatum] | diamond | 354 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30852067 | 30852067 | PRJNA689790_S_NODE_4434_length_288_cov_2.573705_g4319_i0 | PRJNA689790 | 4434 | 288 | 2.573705 | 7.4122704 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 133 | 3.2399999999999997e-35 | NR | KAI6661215.1 | 111878 | g4319 | i0 | 63 | 14.3645833333333 | 100 | 30 | 97.9 | 2 | 3 | 284 | 203 | 301 | KAI6661215.1 Ribosomal protein L4/L1 family [Oopsacas minuta] | diamond | 4137 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 31010083 | 31010083 | PRJNA689790_S_NODE_4334_length_291_cov_3.153543_g4219_i0 | PRJNA689790 | 4334 | 291 | 3.153543 | 9.17681013 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 94.7 | 2.2700000000000003e-22 | NR | XP_065836264.1 | 121494 | g4219 | i0 | 84 | 10.8247422680412 | 50 | 8 | 51.5 | 0 | 2 | 151 | 98 | 147 | XP_065836264.1 small ribosomal subunit protein uS19-like [Oscarella lobularis] | diamond | 3150 | 95.5 | 0.991623036649215 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 32180430 | 32180430 | PRJNA689790_S_NODE_15978_length_153_cov_1.681034_g15863_i0 | PRJNA689790 | 15978 | 153 | 1.681034 | 2.57198202 | Metazoa | 33208 | Porifera | other_Eukaryota | 75.5 | 1.29e-15 | NR | XP_062511004.1 | 121492 | g15863 | i0 | 66.7 | 15.1764705882353 | 48 | 16 | 94.1 | 0 | 2 | 145 | 57 | 104 | XP_062511004.1 eukaryotic translation initiation factor 1A, X-chromosomal-like [Corticium candelabrum] | diamond | 2322 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32465216 | 32465216 | PRJNA689790_S_NODE_9059_length_196_cov_4.723270_g8944_i0 | PRJNA689790 | 9059 | 196 | 4.72327 | 9.2576092 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.5 | 6.53e-7 | NR | XP_062515828.1 | 121492 | g8944 | i0 | 42.2 | 2.95408163265306 | 64 | 34 | 98 | 1 | 1 | 192 | 330 | 390 | XP_062515828.1 arylsulfatase B-like [Corticium candelabrum] | diamond | 579 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32674336 | 32674336 | PRJNA689790_S_NODE_4860_length_274_cov_2.510549_g4745_i0 | PRJNA689790 | 4860 | 274 | 2.510549 | 6.87890426 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 48.1 | 6.38e-5 | NR | XP_003382991.1 | 400682 | g4745 | i0 | 65.8 | 0.416058394160584 | 38 | 13 | 41.6 | 0 | 265 | 152 | 31 | 68 | XP_003382991.1 PREDICTED: 60S ribosomal protein L29-like [Amphimedon queenslandica] | diamond | 114 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 32685834 | 32685834 | PRJNA689790_S_NODE_10200_length_186_cov_1.046980_g10085_i0 | PRJNA689790 | 10200 | 186 | 1.04698 | 1.9473828 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 77.4 | 1.03e-14 | NR | XP_065889370.1 | 196820 | g10085 | i0 | 56.7 | 5.79032258064516 | 60 | 26 | 96.8 | 0 | 180 | 1 | 405 | 464 | XP_065889370.1 5'-nucleotidase domain-containing protein 3-like isoform X4 [Dysidea avara] | diamond | 1077 | 77.8 | 0.994858611825193 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara |
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);;