contig_metadata
23 rows where bioproject = "PRJNA950981", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 933874 | 933874 | PRJNA950981_P_NODE_20621_length_244_cov_0.912281_g20445_i0 | PRJNA950981 | 20621 | 244 | 0.912281 | 2.22596564 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 150 | 1.23e-42 | NR | XP_062504277.1 | 121492 | g20445 | i0 | 85 | 21.6393442622951 | 80 | 12 | 98.4 | 0 | 3 | 242 | 167 | 246 | XP_062504277.1 vacuolar protein sorting-associated protein 26B-like [Corticium candelabrum] | diamond | 5280 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 6036969 | 6036969 | PRJNA950981_P_NODE_11265_length_305_cov_1.344828_g11089_i0 | PRJNA950981 | 11265 | 305 | 1.344828 | 4.1017254 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 116 | 4.529999999999999e-31 | NR | XP_062513731.1 | 121492 | g11089 | i0 | 66.7 | 3.22622950819672 | 84 | 28 | 82.6 | 0 | 51 | 302 | 2 | 85 | XP_062513731.1 large ribosomal subunit protein eL31-like [Corticium candelabrum] | diamond | 984 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 10191245 | 10191245 | PRJNA950981_P_NODE_9688_length_326_cov_1.233202_g9512_i0 | PRJNA950981 | 9688 | 326 | 1.233202 | 4.02023852 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 79 | 1.82e-14 | NR | XP_065842109.1 | 121494 | g9512 | i0 | 56.9 | 0.533742331288344 | 58 | 25 | 53.4 | 0 | 178 | 5 | 198 | 255 | XP_065842109.1 uncharacterized protein [Oscarella lobularis] | diamond | 174 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 22610825 | 22610825 | PRJNA950981_P_NODE_15198_length_264_cov_1.481675_g15022_i0 | PRJNA950981 | 15198 | 264 | 1.481675 | 3.911622 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 145 | 2.7e-39 | NR | XP_065179342.1 | 27933 | g15022 | i0 | 79.3 | 67.3863636363636 | 87 | 18 | 98.9 | 0 | 263 | 3 | 217 | 303 | XP_065179342.1 probable citrate synthase 2, mitochondrial [Sycon ciliatum] | diamond | 17790 | 146 | 0.993150684931507 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27032029 | 27032029 | PRJNA950981_P_NODE_19962_length_246_cov_0.872832_g19786_i0 | PRJNA950981 | 19962 | 246 | 0.872832 | 2.14716672 | root | 1 | Root_unresolved | Root_unresolved | 55.5 | 1.25e-6 | NR | XP_065191547.1 | 27933 | g19786 | i0 | 29.7 | 8.5609756097561 | 74 | 52 | 90.2 | 0 | 245 | 24 | 557 | 630 | XP_065191547.1 protein white-like [Sycon ciliatum] | diamond | 2106 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27341801 | 27341801 | PRJNA950981_P_NODE_10023_length_321_cov_1.258065_g9847_i0 | PRJNA950981 | 10023 | 321 | 1.258065 | 4.03838865 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 127 | 5.05e-34 | NR | XP_062501471.1 | 121492 | g9847 | i0 | 67.4 | 0.85981308411215 | 92 | 30 | 86 | 0 | 277 | 2 | 6 | 97 | XP_062501471.1 ribosomal RNA small subunit methyltransferase NEP1-like [Corticium candelabrum] | diamond | 276 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27341808 | 27341808 | PRJNA950981_P_NODE_21743_length_242_cov_0.923077_g21567_i0 | PRJNA950981 | 21743 | 242 | 0.923077 | 2.23384634 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 63.9 | 1.21e-9 | NR | XP_062513867.1 | 121492 | g21567 | i0 | 42.6 | 0.84297520661157 | 68 | 37 | 84.3 | 1 | 1 | 204 | 372 | 437 | XP_062513867.1 cyclin-A2-like [Corticium candelabrum] | diamond | 204 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28099379 | 28099379 | PRJNA950981_P_NODE_5365_length_420_cov_1.740634_g5189_i0 | PRJNA950981 | 5365 | 420 | 1.740634 | 7.3106628 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 133 | 3.73e-33 | NR | XP_062522735.1 | 121492 | g5189 | i0 | 51 | 2.14285714285714 | 149 | 51 | 90.7 | 3 | 5 | 385 | 562 | 710 | XP_062522735.1 protein DD3-3-like [Corticium candelabrum] | diamond | 900 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28611263 | 28611263 | PRJNA950981_P_NODE_17067_length_252_cov_0.871508_g16891_i0 | PRJNA950981 | 17067 | 252 | 0.871508 | 2.19620016 | root | 1 | Root_unresolved | Root_unresolved | 52.4 | 1.71e-5 | NR | XP_065827354.1 | 121494 | g16891 | i0 | 41.5 | 3.69047619047619 | 65 | 36 | 76.2 | 2 | 248 | 57 | 986 | 1049 | XP_065827354.1 uncharacterized protein [Oscarella lobularis] | diamond | 930 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28667936 | 28667936 | PRJNA950981_P_NODE_13667_length_279_cov_1.135922_g13491_i0 | PRJNA950981 | 13667 | 279 | 1.135922 | 3.16922238 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 55.5 | 1.02e-6 | NR | XP_064388538.1 | 6063 | g13491 | i0 | 45.1 | 0.881720430107527 | 82 | 32 | 81.7 | 3 | 228 | 1 | 80 | 154 | XP_064388538.1 uncharacterized protein LOC135336602 [Halichondria panicea] | diamond | 246 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28762412 | 28762412 | PRJNA950981_P_NODE_12507_length_290_cov_4.271889_g12331_i0 | PRJNA950981 | 12507 | 290 | 4.271889 | 12.3884781 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 102 | 2.32e-25 | NR | XP_064393387.1 | 6063 | g12331 | i0 | 53.1 | 0.993103448275862 | 96 | 45 | 99.3 | 0 | 3 | 290 | 7 | 102 | XP_064393387.1 uncharacterized protein LOC135340900 [Halichondria panicea] | diamond | 288 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28832126 | 28832126 | PRJNA950981_P_NODE_21328_length_243_cov_0.917647_g21152_i0 | PRJNA950981 | 21328 | 243 | 0.917647 | 2.22988221 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 116 | 3.7e-28 | NR | XP_064406205.1 | 6063 | g21152 | i0 | 69.6 | 10.7901234567901 | 79 | 22 | 97.5 | 1 | 3 | 239 | 423 | 499 | XP_064406205.1 periodic tryptophan protein 2 homolog [Halichondria panicea] | diamond | 2622 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28857053 | 28857053 | PRJNA950981_P_NODE_1288_length_817_cov_2.896505_g1136_i0 | PRJNA950981 | 1288 | 817 | 2.896505 | 23.66444585 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 148 | 1.7499999999999999e-40 | NR | CAI8030757.1 | 519541 | g1136 | i0 | 51.8 | 0.609547123623011 | 166 | 65 | 58.4 | 6 | 532 | 56 | 18 | 175 | CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] | diamond | 498 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29305749 | 29305749 | PRJNA950981_P_NODE_13909_length_276_cov_1.536946_g13733_i0 | PRJNA950981 | 13909 | 276 | 1.536946 | 4.24197096 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 44.3 | 0.0153 | NR | CAI8027740.1 | 519541 | g13733 | i0 | 36 | 3.33695652173913 | 75 | 39 | 71.7 | 3 | 267 | 70 | 211 | 285 | CAI8027740.1 Protein Aster-B, partial [Geodia barretti] | diamond | 921 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29994106 | 29994106 | PRJNA950981_P_NODE_21511_length_242_cov_0.923077_g21335_i0 | PRJNA950981 | 21511 | 242 | 0.923077 | 2.23384634 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 50.1 | 9.63e-5 | NR | XP_065836874.1 | 121494 | g21335 | i0 | 53.7 | 0.508264462809917 | 41 | 19 | 50.8 | 0 | 119 | 241 | 16 | 56 | XP_065836874.1 enolase-phosphatase E1-like [Oscarella lobularis] | diamond | 123 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30025697 | 30025697 | PRJNA950981_P_NODE_16731_length_253_cov_0.866667_g16555_i0 | PRJNA950981 | 16731 | 253 | 0.866667 | 2.19266751 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 62.4 | 3.07e-10 | NR | XP_065183262.1 | 27933 | g16555 | i0 | 82.9 | 0.41501976284585 | 35 | 6 | 41.5 | 0 | 3 | 107 | 82 | 116 | XP_065183262.1 large ribosomal subunit protein eL33-like [Sycon ciliatum] | diamond | 105 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30600759 | 30600759 | PRJNA950981_P_NODE_12253_length_293_cov_2.127273_g12077_i0 | PRJNA950981 | 12253 | 293 | 2.127273 | 6.23290989 | Metazoa | 33208 | Porifera | other_Eukaryota | 64.7 | 1.29e-9 | NR | XP_065191369.1 | 27933 | g12077 | i0 | 39.3 | 4.4641638225256 | 61 | 37 | 62.5 | 0 | 188 | 6 | 702 | 762 | XP_065191369.1 nucleolar protein dao-5-like isoform X2 [Sycon ciliatum] | diamond | 1308 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30942010 | 30942010 | PRJNA950981_P_NODE_18654_length_248_cov_1.645714_g18478_i0 | PRJNA950981 | 18654 | 248 | 1.645714 | 4.08137072 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 73.6 | 3.81e-13 | NR | KAI6648496.1 | 111878 | g18478 | i0 | 51.6 | 0.75 | 62 | 29 | 75 | 1 | 243 | 58 | 272 | 332 | KAI6648496.1 Ribose-phosphate pyrophosphokinase 4-like [Oopsacas minuta] | diamond | 186 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 31447637 | 31447637 | PRJNA950981_P_NODE_15416_length_262_cov_1.650794_g15240_i0 | PRJNA950981 | 15416 | 262 | 1.650794 | 4.32508028 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 155 | 1.62e-41 | NR | XP_065886217.1 | 196820 | g15240 | i0 | 72.7 | 2.01526717557252 | 88 | 23 | 99.6 | 1 | 2 | 262 | 4165 | 4252 | XP_065886217.1 E3 ubiquitin-protein ligase MYCBP2-like [Dysidea avara] | diamond | 528 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 31763919 | 31763919 | PRJNA950981_P_NODE_17917_length_250_cov_0.881356_g17741_i0 | PRJNA950981 | 17917 | 250 | 0.881356 | 2.20339 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 48.5 | 3.87e-4 | NR | XP_065826102.1 | 121494 | g17741 | i0 | 55.3 | 0.456 | 38 | 17 | 45.6 | 0 | 246 | 133 | 602 | 639 | XP_065826102.1 death-associated protein kinase 1-like isoform X2 [Oscarella lobularis] | diamond | 114 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31985271 | 31985271 | PRJNA950981_P_NODE_10338_length_317_cov_1.122951_g10162_i0 | PRJNA950981 | 10338 | 317 | 1.122951 | 3.55975467 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 45.8 | 0.00706 | NR | CAI8029546.1 | 519541 | g10162 | i0 | 32.1 | 0.766561514195584 | 81 | 55 | 76.7 | 0 | 313 | 71 | 316 | 396 | CAI8029546.1 hypothetical protein GBAR_LOCUS16781 [Geodia barretti] | diamond | 243 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 32435228 | 32435228 | PRJNA950981_P_NODE_15059_length_265_cov_2.406250_g14883_i0 | PRJNA950981 | 15059 | 265 | 2.40625 | 6.3765625 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.5 | 8.58e-12 | NR | CAI8034215.1 | 519541 | g14883 | i0 | 45 | 3.48679245283019 | 80 | 43 | 90.6 | 1 | 259 | 20 | 667 | 745 | CAI8034215.1 Circularly permutated Ras protein 1 [Geodia barretti] | diamond | 924 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 32806805 | 32806805 | PRJNA950981_P_NODE_21740_length_242_cov_0.923077_g21564_i0 | PRJNA950981 | 21740 | 242 | 0.923077 | 2.23384634 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 76.3 | 4.78e-14 | NR | CAI8012763.1 | 519541 | g21564 | i0 | 45 | 0.991735537190083 | 80 | 41 | 99.2 | 2 | 2 | 241 | 280 | 356 | CAI8012763.1 hypothetical protein GBAR_LOCUS8158 [Geodia barretti] | diamond | 240 | 76.3 | 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);;