contig_metadata
23 rows where bioproject = "PRJNA414036", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14447626 | 14447626 | PRJNA414036_P_NODE_39892_length_233_cov_2.075758_g38153_i0 | PRJNA414036 | 39892 | 233 | 2.075758 | 4.83651614 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2732938948|ref|XM_065336629.1| | 27933 | g38153 | i0 | 100 | 0.240343347639485 | 28 | 0 | 12 | 0 | 17 | 44 | 6765 | 6738 | PREDICTED: Sycon ciliatum mucin-2-like (LOC135823784), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 24645231 | 24645231 | PRJNA414036_P_NODE_62660_length_206_cov_3.380117_g60921_i0 | PRJNA414036 | 62660 | 206 | 3.380117 | 6.96304102 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 113 | 8.14e-21 | NTclustered | gi|2664225733|ref|XM_062666977.1| | 121492 | g60921 | i0 | 77.901 | 0.878640776699029 | 181 | 40 | 88 | 0 | 10 | 190 | 2487 | 2307 | PREDICTED: Corticium candelabrum pre-mRNA-processing-splicing factor 8 (LOC134197630), mRNA | blastn | 181 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 26632404 | 26632404 | PRJNA414036_P_NODE_31741_length_265_cov_16.178261_g30005_i0 | PRJNA414036 | 31741 | 265 | 16.178261 | 42.87239165 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 63.9 | 1.01e-9 | NR | CAI8032863.1 | 519541 | g30005 | i0 | 53.3 | 1.0188679245283 | 90 | 37 | 96.2 | 2 | 10 | 264 | 12 | 101 | CAI8032863.1 Tubulin beta-4B chain, partial [Geodia barretti] | diamond | 270 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 27201780 | 27201780 | PRJNA414036_P_NODE_59722_length_217_cov_8.192308_g57983_i0 | PRJNA414036 | 59722 | 217 | 8.192308 | 17.77730836 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 42 | 0.0494 | NR | XP_065911089.1 | 196820 | g57983 | i0 | 77.3 | 0.649769585253456 | 22 | 5 | 30.4 | 0 | 12 | 77 | 872 | 893 | XP_065911089.1 eukaryotic translation initiation factor 4 gamma 2-like isoform X2 [Dysidea avara] | diamond | 141 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 27296833 | 27296833 | PRJNA414036_P_NODE_62683_length_206_cov_2.865497_g60944_i0 | PRJNA414036 | 62683 | 206 | 2.865497 | 5.90292382 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 43.9 | 0.00905 | NR | CAI8006499.1 | 519541 | g60944 | i0 | 52.8 | 3.0873786407767 | 53 | 25 | 77.2 | 0 | 46 | 204 | 341 | 393 | CAI8006499.1 Threonine--tRNA ligase 1, cytoplasmic [Geodia barretti] | diamond | 636 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 27581000 | 27581000 | PRJNA414036_P_NODE_76064_length_170_cov_1.444444_g74325_i0 | PRJNA414036 | 76064 | 170 | 1.444444 | 2.4555548 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 70.5 | 2.29e-12 | NR | XP_019858857.1 | 400682 | g74325 | i0 | 68.1 | 9.35294117647059 | 47 | 15 | 82.9 | 0 | 147 | 7 | 799 | 845 | XP_019858857.1 PREDICTED: intron-binding protein aquarius isoform X2 [Amphimedon queenslandica] | diamond | 1590 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 27787341 | 27787341 | PRJNA414036_P_NODE_62084_length_208_cov_3.236994_g60345_i0 | PRJNA414036 | 62084 | 208 | 3.236994 | 6.73294752 | Metazoa | 33208 | Porifera | other_Eukaryota | 70.9 | 2.87e-12 | NR | XP_064391775.1 | 6063 | g60345 | i0 | 72.5 | 158.0625 | 69 | 19 | 99.5 | 0 | 2 | 208 | 42 | 110 | XP_064391775.1 T-complex protein 1 subunit zeta-like [Halichondria panicea] | diamond | 32877 | 71.2 | 0.995786516853933 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27976555 | 27976555 | PRJNA414036_P_NODE_77045_length_168_cov_1.962406_g75306_i0 | PRJNA414036 | 77045 | 168 | 1.962406 | 3.29684208 | Metazoa | 33208 | Porifera | other_Eukaryota | 45.8 | 0.0011 | NR | XP_064383665.1 | 6063 | g75306 | i0 | 81.8 | 23.1785714285714 | 22 | 4 | 39.3 | 0 | 155 | 90 | 171 | 192 | XP_064383665.1 DNA-directed RNA polymerase II subunit RPB2 [Halichondria panicea] | diamond | 3894 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28117710 | 28117710 | PRJNA414036_P_NODE_38205_length_238_cov_24.088670_g36466_i0 | PRJNA414036 | 38205 | 238 | 24.08867 | 57.3310346 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 97.8 | 1.09e-22 | NR | XP_062510329.1 | 121492 | g36466 | i0 | 79.3 | 73.0588235294118 | 58 | 12 | 73.1 | 0 | 175 | 2 | 23 | 80 | XP_062510329.1 small ribosomal subunit protein eS4-like [Corticium candelabrum] | diamond | 17388 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28812137 | 28812137 | PRJNA414036_P_NODE_39748_length_233_cov_3.954545_g38009_i0 | PRJNA414036 | 39748 | 233 | 3.954545 | 9.21408985 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 56.6 | 4.11e-7 | NR | XP_065901257.1 | 196820 | g38009 | i0 | 62.1 | 4.48068669527897 | 58 | 22 | 74.7 | 0 | 58 | 231 | 239 | 296 | XP_065901257.1 protein transport protein Sec61 subunit alpha [Dysidea avara] | diamond | 1044 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 28843839 | 28843839 | PRJNA414036_P_NODE_24448_length_306_cov_11.741697_g22716_i0 | PRJNA414036 | 24448 | 306 | 11.741697 | 35.92959282 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 57.8 | 3.21e-7 | NR | CAI8018902.1 | 519541 | g22716 | i0 | 62.8 | 0.843137254901961 | 43 | 16 | 42.2 | 0 | 249 | 121 | 161 | 203 | CAI8018902.1 Actin, nonmuscle [Geodia barretti] | diamond | 258 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 28892035 | 28892035 | PRJNA414036_P_NODE_73488_length_175_cov_2.378571_g71749_i0 | PRJNA414036 | 73488 | 175 | 2.378571 | 4.16249925 | Metazoa | 33208 | Porifera | other_Eukaryota | 47.8 | 2.45e-4 | NR | XP_064383639.1 | 6063 | g71749 | i0 | 58.3 | 3.30857142857143 | 48 | 20 | 82.3 | 0 | 155 | 12 | 67 | 114 | XP_064383639.1 dol-P-Man:Man(5)GlcNAc(2)-PP-Dol alpha-1,3-mannosyltransferase-like isoform X1 [Halichondria panicea] | diamond | 579 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28923661 | 28923661 | PRJNA414036_P_NODE_26768_length_291_cov_13.378906_g25033_i0 | PRJNA414036 | 26768 | 291 | 13.378906 | 38.93261646 | Metazoa | 33208 | Porifera | other_Eukaryota | 74.3 | 5.02e-13 | NR | CAI8045514.1 | 519541 | g25033 | i0 | 56.8 | 18.6185567010309 | 95 | 41 | 97.9 | 0 | 6 | 290 | 320 | 414 | CAI8045514.1 Tubulin alpha-3 chain [Geodia barretti] | diamond | 5418 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29096739 | 29096739 | PRJNA414036_P_NODE_71028_length_181_cov_1.486301_g69289_i0 | PRJNA414036 | 71028 | 181 | 1.486301 | 2.69020481 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 47.4 | 3.8e-4 | NR | XP_003388074.1 | 400682 | g69289 | i0 | 75 | 8.81767955801105 | 28 | 7 | 46.4 | 0 | 127 | 44 | 35 | 62 | XP_003388074.1 PREDICTED: calreticulin-like [Amphimedon queenslandica] | diamond | 1596 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 29649575 | 29649575 | PRJNA414036_P_NODE_28950_length_279_cov_5.639344_g27215_i0 | PRJNA414036 | 28950 | 279 | 5.639344 | 15.73376976 | Metazoa | 33208 | Porifera | other_Eukaryota | 54.3 | 4.83e-6 | NR | XP_064406142.1 | 6063 | g27215 | i0 | 96 | 91.9354838709677 | 25 | 1 | 26.9 | 0 | 83 | 9 | 281 | 305 | XP_064406142.1 eukaryotic peptide chain release factor GTP-binding subunit ERF3A-like [Halichondria panicea] | diamond | 25650 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30391974 | 30391974 | PRJNA414036_P_NODE_26813_length_291_cov_4.109375_g25078_i0 | PRJNA414036 | 26813 | 291 | 4.109375 | 11.95828125 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 121 | 2.1099999999999998e-31 | NR | XP_065193136.1 | 27933 | g25078 | i0 | 76.5 | 8.15463917525773 | 85 | 20 | 87.6 | 0 | 31 | 285 | 146 | 230 | XP_065193136.1 uncharacterized protein LOC135824331 [Sycon ciliatum] | diamond | 2373 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30471508 | 30471508 | PRJNA414036_P_NODE_86213_length_154_cov_1.134454_g84474_i0 | PRJNA414036 | 86213 | 154 | 1.134454 | 1.74705916 | Metazoa | 33208 | Porifera | other_Eukaryota | 51.2 | 1.13e-5 | NR | XP_064384613.1 | 6063 | g84474 | i0 | 66.7 | 14.025974025974 | 48 | 15 | 91.6 | 1 | 13 | 153 | 390 | 437 | XP_064384613.1 recombining binding protein suppressor of hairless-like isoform X2 [Halichondria panicea] | diamond | 2160 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31055307 | 31055307 | PRJNA414036_P_NODE_64255_length_200_cov_37.957576_g62516_i0 | PRJNA414036 | 64255 | 200 | 37.957576 | 75.915152 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 48.9 | 1.36e-4 | NR | XP_065842245.1 | 121494 | g62516 | i0 | 44.6 | 0.975 | 65 | 36 | 97.5 | 0 | 1 | 195 | 199 | 263 | XP_065842245.1 ADP/ATP translocase 3-like [Oscarella lobularis] | diamond | 195 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31356296 | 31356296 | PRJNA414036_P_NODE_36956_length_243_cov_3.177885_g35220_i0 | PRJNA414036 | 36956 | 243 | 3.177885 | 7.72226055 | Metazoa | 33208 | Porifera | other_Eukaryota | 42.7 | 0.0389 | NR | XP_064403448.1 | 6063 | g35220 | i0 | 39.4 | 126.222222222222 | 71 | 43 | 87.7 | 0 | 213 | 1 | 520 | 590 | XP_064403448.1 exportin-1-like [Halichondria panicea] | diamond | 30672 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31719065 | 31719065 | PRJNA414036_P_NODE_80177_length_162_cov_10.015748_g78438_i0 | PRJNA414036 | 80177 | 162 | 10.015748 | 16.22551176 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 60.5 | 5.27e-9 | NR | CAI8018902.1 | 519541 | g78438 | i0 | 67.4 | 0.851851851851852 | 46 | 15 | 85.2 | 0 | 152 | 15 | 209 | 254 | CAI8018902.1 Actin, nonmuscle [Geodia barretti] | diamond | 138 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 32147054 | 32147054 | PRJNA414036_P_NODE_31158_length_268_cov_3.437768_g29422_i0 | PRJNA414036 | 31158 | 268 | 3.437768 | 9.21321824 | Metazoa | 33208 | Porifera | other_Eukaryota | 62.8 | 4.44e-9 | NR | XP_065180462.1 | 27933 | g29422 | i0 | 68.3 | 266.25 | 60 | 19 | 67.2 | 0 | 266 | 87 | 614 | 673 | XP_065180462.1 splicing factor 3B subunit 1-like isoform X2 [Sycon ciliatum] | diamond | 71355 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32352064 | 32352064 | PRJNA414036_P_NODE_21359_length_327_cov_3.393836_g19631_i0 | PRJNA414036 | 21359 | 327 | 3.393836 | 11.09784372 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 51.2 | 8.46e-5 | NR | XP_064403724.1 | 6063 | g19631 | i0 | 54.1 | 0.559633027522936 | 61 | 28 | 56 | 0 | 308 | 126 | 148 | 208 | XP_064403724.1 uncharacterized protein LOC135349158 [Halichondria panicea] | diamond | 183 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 32778631 | 32778631 | PRJNA414036_P_NODE_59340_length_219_cov_2.298913_g57601_i0 | PRJNA414036 | 59340 | 219 | 2.298913 | 5.03461947 | Metazoa | 33208 | Porifera | other_Eukaryota | 77.4 | 1.63e-14 | NR | XP_064396618.1 | 6063 | g57601 | i0 | 78 | 173.287671232877 | 50 | 11 | 68.5 | 0 | 208 | 59 | 287 | 336 | XP_064396618.1 DNA replication licensing factor MCM6-like [Halichondria panicea] | diamond | 37950 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea |
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);;