contig_metadata
17 rows where bioproject = "PRJNA315314", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1065354 | 1065354 | PRJNA315314_S_NODE_27301_length_161_cov_2.674242_g26980_i0 | PRJNA315314 | 27301 | 161 | 2.674242 | 4.30552962 | Petrosiidae | 68562 | Porifera | other_Eukaryota | 150 | 4.61e-32 | NTclustered | gi|512765353|gb|KC869591.1| | 595385 | g26980 | i0 | 85.256 | 69.5093167701863 | 156 | 12 | 97 | 5 | 6 | 161 | 3121 | 3265 | Neopetrosia subtriangularis voucher P10x50 28S ribosomal RNA gene, partial sequence | blastn | 11191 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Petrosiidae | Neopetrosia | Neopetrosia subtriangularis | |
| 2931457 | 2931457 | PRJNA315314_S_NODE_21723_length_178_cov_2.463087_g21402_i0 | PRJNA315314 | 21723 | 178 | 2.463087 | 4.38429486 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 86.3 | 5.45e-18 | NR | KAI6646745.1 | 111878 | g21402 | i0 | 69.5 | 0.99438202247191 | 59 | 18 | 99.4 | 0 | 177 | 1 | 328 | 386 | KAI6646745.1 Phosphoglycerate kinase 1-like [Oopsacas minuta] | diamond | 177 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 2931731 | 2931731 | PRJNA315314_S_NODE_9323_length_265_cov_4.508475_g9002_i0 | PRJNA315314 | 9323 | 265 | 4.508475 | 11.94745875 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 120 | 3.78e-30 | NR | XP_062510034.1 | 121492 | g9002 | i0 | 69.7 | 6.13584905660377 | 76 | 23 | 86 | 0 | 265 | 38 | 314 | 389 | XP_062510034.1 S-adenosylmethionine synthase-like [Corticium candelabrum] | diamond | 1626 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 4208328 | 4208328 | PRJNA315314_S_NODE_9264_length_266_cov_3.405063_g8943_i0 | PRJNA315314 | 9264 | 266 | 3.405063 | 9.05746758 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 124 | 2e-34 | NR | XP_065826773.1 | 121494 | g8943 | i0 | 69 | 8.45864661654135 | 84 | 26 | 94.7 | 0 | 13 | 264 | 1 | 84 | XP_065826773.1 NHP2-like protein 1 [Oscarella lobularis] | diamond | 2250 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 5484256 | 5484256 | PRJNA315314_S_NODE_19445_length_187_cov_3.341772_g19124_i0 | PRJNA315314 | 19445 | 187 | 3.341772 | 6.24911364 | Haliclona cinerea | 178541 | Porifera | other_Eukaryota | 78.7 | 2.64e-10 | NTclustered | gi|2842131310|emb|OZ194986.1| | 178541 | g19124 | i0 | 95.833 | 34.048128342246 | 48 | 2 | 26 | 0 | 59 | 106 | 2801 | 2754 | Haliclona cinerea genome assembly, organelle: mitochondrion | blastn | 6367 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Chalinidae | Haliclona | Haliclona cinerea | |
| 14409737 | 14409737 | PRJNA315314_S_NODE_23692_length_171_cov_10.992958_g23371_i0 | PRJNA315314 | 23692 | 171 | 10.992958 | 18.79795818 | Crateromorpha meyeri | 472232 | Porifera | other_Eukaryota | 62.1 | 2.38e-5 | NTclustered | gi|190350204|emb|AM886359.1| | 472232 | g23371 | i0 | 100 | 0.192982456140351 | 33 | 0 | 19 | 0 | 139 | 171 | 651 | 683 | Crateromorpha meyeri partial 28S rRNA gene, isolated from Japan | blastn | 33 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Rossellidae | Crateromorpha | Crateromorpha meyeri | |
| 14409971 | 14409971 | PRJNA315314_S_NODE_7152_length_302_cov_2.644689_g6831_i0 | PRJNA315314 | 7152 | 302 | 2.644689 | 7.98696078 | Metazoa | 33208 | Porifera | other_Eukaryota | 135 | 5.439999999999998e-35 | NR | XP_064390098.1 | 6063 | g6831 | i0 | 65.7 | 3.94370860927152 | 99 | 32 | 98.3 | 1 | 4 | 300 | 241 | 337 | XP_064390098.1 4-aminobutyrate aminotransferase, mitochondrial-like isoform X1 [Halichondria panicea] | diamond | 1191 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 15092975 | 15092975 | PRJNA315314_S_NODE_15912_length_205_cov_10.437500_g15591_i0 | PRJNA315314 | 15912 | 205 | 10.4375 | 21.396875 | Demospongiae | 6042 | Porifera | other_Eukaryota | 58.4 | 3.85e-4 | NTclustered | gi|2719038895|ref|XR_010393624.1| | 6063 | g15591 | i0 | 100 | 14.8536585365854 | 31 | 0 | 15 | 0 | 175 | 205 | 3369 | 3339 | PREDICTED: Halichondria panicea large subunit ribosomal RNA (LOC135332780), rRNA | blastn | 3045 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 15092991 | 15092991 | PRJNA315314_S_NODE_18272_length_193_cov_2.176829_g17951_i0 | PRJNA315314 | 18272 | 193 | 2.176829 | 4.20127997 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 120 | 2.31e-30 | NR | AZI95702.1 | 6063 | g17951 | i0 | 87.5 | 147.233160621762 | 64 | 8 | 99.5 | 0 | 2 | 193 | 194 | 257 | AZI95702.1 26S proteasome regulatory subunit 6A-B, partial [Halichondria panicea] | diamond | 28416 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 18232611 | 18232611 | PRJNA315314_S_NODE_31515_length_152_cov_1.813008_g31194_i0 | PRJNA315314 | 31515 | 152 | 1.813008 | 2.75577216 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 95.5 | 1.3100000000000002e-21 | NR | KAI6654578.1 | 111878 | g31194 | i0 | 81.6 | 0.967105263157895 | 49 | 9 | 96.7 | 0 | 151 | 5 | 84 | 132 | KAI6654578.1 Actin-related protein 2-B [Oopsacas minuta] | diamond | 147 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 25291500 | 25291500 | PRJNA315314_S_NODE_4620_length_372_cov_29.116618_g4299_i0 | PRJNA315314 | 4620 | 372 | 29.116618 | 108.31381896 | Haplosclerida | 6049 | Porifera | other_Eukaryota | 128 | 5.71e-25 | NTclustered | gi|1284883228|gb|KY825184.1| | 178514 | g4299 | i0 | 80.337 | 8.45698924731183 | 178 | 28 | 47 | 5 | 198 | 372 | 3474 | 3301 | Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence | blastn | 3146 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon compressa | |
| 27579768 | 27579768 | PRJNA315314_S_NODE_12404_length_231_cov_1.900990_g12083_i0 | PRJNA315314 | 12404 | 231 | 1.90099 | 4.3912869 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 79.7 | 2.57e-16 | NR | CAI8035304.1 | 519541 | g12083 | i0 | 51.3 | 2.94805194805195 | 76 | 31 | 96.1 | 2 | 9 | 230 | 120 | 191 | CAI8035304.1 hypothetical protein GBAR_LOCUS19830 [Geodia barretti] | diamond | 681 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 27769576 | 27769576 | PRJNA315314_S_NODE_6284_length_322_cov_2.525597_g5963_i0 | PRJNA315314 | 6284 | 322 | 2.525597 | 8.13242234 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 88.2 | 2.89e-19 | NR | CAI8030757.1 | 519541 | g5963 | i0 | 52.8 | 0.829192546583851 | 89 | 36 | 81.1 | 2 | 13 | 273 | 91 | 175 | CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] | diamond | 267 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 27958732 | 27958732 | PRJNA315314_S_NODE_18625_length_191_cov_2.425926_g18304_i0 | PRJNA315314 | 18625 | 191 | 2.425926 | 4.63351866 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 74.7 | 9.04e-15 | NR | CAI8030757.1 | 519541 | g18304 | i0 | 56.7 | 0.942408376963351 | 60 | 25 | 94.2 | 1 | 1 | 180 | 118 | 176 | CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] | diamond | 180 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 28084961 | 28084961 | PRJNA315314_S_NODE_21765_length_178_cov_1.959732_g21444_i0 | PRJNA315314 | 21765 | 178 | 1.959732 | 3.48832296 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 65.5 | 1.5e-10 | NR | XP_065839251.1 | 121494 | g21444 | i0 | 52.5 | 6.89325842696629 | 59 | 28 | 99.4 | 0 | 178 | 2 | 636 | 694 | XP_065839251.1 dipeptidyl peptidase 3-like [Oscarella lobularis] | diamond | 1227 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31229069 | 31229069 | PRJNA315314_S_NODE_18915_length_190_cov_1.409938_g18594_i0 | PRJNA315314 | 18915 | 190 | 1.409938 | 2.6788822 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 63.9 | 5.95e-10 | NR | XP_065909556.1 | 196820 | g18594 | i0 | 47.6 | 5.00526315789474 | 63 | 32 | 97.9 | 1 | 188 | 3 | 387 | 449 | XP_065909556.1 leukotriene A-4 hydrolase-like [Dysidea avara] | diamond | 951 | 64.3 | 0.993779160186625 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32540695 | 32540695 | PRJNA315314_S_NODE_21519_length_179_cov_1.673333_g21198_i0 | PRJNA315314 | 21519 | 179 | 1.673333 | 2.99526607 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 47 | 5.07e-4 | NR | XP_003387954.2 | 400682 | g21198 | i0 | 50 | 1.29050279329609 | 40 | 20 | 67 | 0 | 2 | 121 | 316 | 355 | XP_003387954.2 PREDICTED: pre-rRNA processing protein FTSJ3-like [Amphimedon queenslandica] | diamond | 231 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica |
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);;