contig_metadata
18 rows where bioproject = "PRJNA704949", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9625992 | 9625992 | PRJNA704949_P_NODE_40708_length_1207_cov_6.621762_g30704_i0 | PRJNA704949 | 40708 | 1207 | 6.621762 | 79.92466734 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 54.7 | 0.034 | NTclustered | gi|2732931524|ref|XM_065332834.1| | 27933 | g30704 | i0 | 100 | 0.024026512013256 | 29 | 0 | 2 | 0 | 1018 | 1046 | 467 | 495 | PREDICTED: Sycon ciliatum uncharacterized LOC135819598 (LOC135819598), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 9630047 | 9630047 | PRJNA704949_P_NODE_86208_length_836_cov_6.077510_g30704_i1 | PRJNA704949 | 86208 | 836 | 6.07751 | 50.8079836 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 54.7 | 0.023 | NTclustered | gi|2732931524|ref|XM_065332834.1| | 27933 | g30704 | i1 | 100 | 0.034688995215311 | 29 | 0 | 3 | 0 | 162 | 190 | 495 | 467 | PREDICTED: Sycon ciliatum uncharacterized LOC135819598 (LOC135819598), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 12180035 | 12180035 | PRJNA704949_P_NODE_776290_length_303_cov_2.118110_g760959_i0 | PRJNA704949 | 776290 | 303 | 2.11811 | 6.4178733 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|2719014049|ref|XM_064540739.1| | 6063 | g760959 | i0 | 96.875 | 0.105610561056106 | 32 | 0 | 11 | 1 | 210 | 241 | 1483 | 1453 | PREDICTED: Halichondria panicea uncharacterized LOC135343734 (LOC135343734), mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 16001830 | 16001830 | PRJNA704949_P_NODE_609293_length_347_cov_3.030201_g593970_i0 | PRJNA704949 | 609293 | 347 | 3.030201 | 10.51479747 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2732940498|ref|XM_065337428.1| | 27933 | g593970 | i0 | 97.059 | 0.0979827089337176 | 34 | 0 | 10 | 1 | 248 | 281 | 1325 | 1293 | PREDICTED: Sycon ciliatum uncharacterized LOC135824720 (LOC135824720), mRNA | blastn | 34 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 24924483 | 24924483 | PRJNA704949_P_NODE_466720_length_399_cov_1.028571_g451503_i0 | PRJNA704949 | 466720 | 399 | 1.028571 | 4.10399829 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 1.3400000000000002e-21 | NR | XP_019864517.1 | 400682 | g451503 | i0 | 63.5 | 5.30075187969925 | 74 | 27 | 55.6 | 0 | 226 | 5 | 44 | 117 | XP_019864517.1 PREDICTED: paired amphipathic helix protein Sin3a [Amphimedon queenslandica] | diamond | 2115 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 26671435 | 26671435 | PRJNA704949_P_NODE_2134021_length_163_cov_0.912281_g2118682_i0 | PRJNA704949 | 2134021 | 163 | 0.912281 | 1.48701803 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 73.9 | 1.21e-13 | NR | XP_064404894.1 | 6063 | g2118682 | i0 | 61.7 | 1.73006134969325 | 47 | 18 | 86.5 | 0 | 21 | 161 | 540 | 586 | XP_064404894.1 uncharacterized protein LOC135350110 isoform X2 [Halichondria panicea] | diamond | 282 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27335974 | 27335974 | PRJNA704949_P_NODE_1455023_length_205_cov_1.333333_g1439685_i0 | PRJNA704949 | 1455023 | 205 | 1.333333 | 2.73333265 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 43.1 | 0.0163 | NR | XP_065894488.1 | 196820 | g1439685 | i0 | 45.3 | 1.4780487804878 | 53 | 22 | 67.3 | 2 | 142 | 5 | 105 | 157 | XP_065894488.1 nidogen-1-like isoform X3 [Dysidea avara] | diamond | 303 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 27809697 | 27809697 | PRJNA704949_P_NODE_140784_length_679_cov_2.400000_g127479_i0 | PRJNA704949 | 140784 | 679 | 2.4 | 16.296 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 119 | 6.0400000000000005e-27 | NR | XP_062506652.1 | 121492 | g127479 | i0 | 41.5 | 0.808541973490427 | 183 | 93 | 80.4 | 6 | 649 | 104 | 823 | 992 | XP_062506652.1 uncharacterized protein LOC134183183 [Corticium candelabrum] | diamond | 549 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28230810 | 28230810 | PRJNA704949_P_NODE_787366_length_301_cov_1.238095_g772034_i0 | PRJNA704949 | 787366 | 301 | 1.238095 | 3.72666595 | root | 1 | Root_unresolved | Root_unresolved | 105 | 5.02e-24 | NR | CAI8046726.1 | 519541 | g772034 | i0 | 48.4 | 3.82724252491694 | 95 | 47 | 92.7 | 2 | 4 | 282 | 649 | 743 | CAI8046726.1 Bis(5'-nucleosyl)-tetraphosphatase PrpE [asymmetrical] [Geodia barretti] | diamond | 1152 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29872945 | 29872945 | PRJNA704949_P_NODE_2192231_length_158_cov_2.385321_g2176892_i0 | PRJNA704949 | 2192231 | 158 | 2.385321 | 3.76880718 | Metazoa | 33208 | Porifera | other_Eukaryota | 42.4 | 0.0163 | NR | XP_064387395.1 | 6063 | g2176892 | i0 | 43.9 | 4.61392405063291 | 41 | 19 | 77.8 | 1 | 156 | 34 | 1187 | 1223 | XP_064387395.1 uncharacterized protein LOC135335773 isoform X3 [Halichondria panicea] | diamond | 729 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 29956933 | 29956933 | PRJNA704949_P_NODE_649091_length_336_cov_1.268293_g633765_i0 | PRJNA704949 | 649091 | 336 | 1.268293 | 4.26146448 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 87 | 1.91e-17 | NR | KAI6651527.1 | 111878 | g633765 | i0 | 45.4 | 2.01785714285714 | 108 | 56 | 94.6 | 2 | 1 | 318 | 202 | 308 | KAI6651527.1 Cathepsin L [Oopsacas minuta] | diamond | 678 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 30114615 | 30114615 | PRJNA704949_P_NODE_1758892_length_180_cov_2.335878_g1743553_i0 | PRJNA704949 | 1758892 | 180 | 2.335878 | 4.2045804 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 61.2 | 4.93e-9 | NR | XP_062516816.1 | 121492 | g1743553 | i0 | 54.9 | 0.85 | 51 | 23 | 85 | 0 | 25 | 177 | 246 | 296 | XP_062516816.1 lysosomal alpha-mannosidase-like isoform X2 [Corticium candelabrum] | diamond | 153 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30220289 | 30220289 | PRJNA704949_P_NODE_126172_length_711_cov_2.451662_g113136_i0 | PRJNA704949 | 126172 | 711 | 2.451662 | 17.43131682 | Metazoa | 33208 | Porifera | other_Eukaryota | 55.5 | 7.05e-5 | NR | XP_064393647.1 | 6063 | g113136 | i0 | 36.2 | 4.13502109704641 | 116 | 58 | 45.1 | 4 | 386 | 66 | 381 | 489 | XP_064393647.1 protein LSM14 homolog car-1-like [Halichondria panicea] | diamond | 2940 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30304723 | 30304723 | PRJNA704949_P_NODE_1761752_length_180_cov_1.587786_g1746413_i0 | PRJNA704949 | 1761752 | 180 | 1.587786 | 2.8580148 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 44.7 | 0.00336 | NR | XP_065190169.1 | 27933 | g1746413 | i0 | 44.6 | 0.933333333333333 | 56 | 29 | 90 | 1 | 9 | 170 | 86 | 141 | XP_065190169.1 uncharacterized protein LOC135821036 [Sycon ciliatum] | diamond | 168 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30809580 | 30809580 | PRJNA704949_P_NODE_1080234_length_248_cov_1.567839_g1064898_i0 | PRJNA704949 | 1080234 | 248 | 1.567839 | 3.88824072 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 65.9 | 1.96e-10 | NR | XP_062518690.1 | 121492 | g1064898 | i0 | 51.2 | 0.520161290322581 | 43 | 21 | 52 | 0 | 243 | 115 | 227 | 269 | XP_062518690.1 fibropellin-1-like [Corticium candelabrum] | diamond | 129 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 31010238 | 31010238 | PRJNA704949_P_NODE_1763234_length_180_cov_1.587786_g1747895_i0 | PRJNA704949 | 1763234 | 180 | 1.587786 | 2.8580148 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 61.2 | 4.7e-9 | NR | KAI6653363.1 | 111878 | g1747895 | i0 | 65 | 5.05 | 40 | 14 | 66.7 | 0 | 124 | 5 | 491 | 530 | KAI6653363.1 hypothetical protein LOD99_3583 [Oopsacas minuta] | diamond | 909 | 61.6 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 31863958 | 31863958 | PRJNA704949_P_NODE_764857_length_306_cov_1.463035_g749526_i0 | PRJNA704949 | 764857 | 306 | 1.463035 | 4.4768871 | Metazoa | 33208 | Porifera | other_Eukaryota | 105 | 1.7999999999999997e-24 | NR | XP_065184897.1 | 27933 | g749526 | i0 | 53.6 | 6.06862745098039 | 97 | 34 | 84.3 | 2 | 278 | 21 | 2 | 98 | XP_065184897.1 tryptophan--tRNA ligase, cytoplasmic-like [Sycon ciliatum] | diamond | 1857 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32643750 | 32643750 | PRJNA704949_P_NODE_667660_length_330_cov_3.352313_g652332_i0 | PRJNA704949 | 667660 | 330 | 3.352313 | 11.0626329 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 65.9 | 6.72e-10 | NR | CAI8040380.1 | 519541 | g652332 | i0 | 32 | 1.10909090909091 | 122 | 62 | 91.8 | 2 | 22 | 324 | 81 | 202 | CAI8040380.1 Peptidyl-tRNA hydrolase [Geodia barretti] | diamond | 366 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti |
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);;