contig_metadata
14 rows where bioproject = "PRJNA983848", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2246215 | 2246215 | PRJNA983848_P_NODE_86282_length_330_cov_4.408560_g80399_i0 | PRJNA983848 | 86282 | 330 | 4.40856 | 14.548248 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 78.7 | 5.13e-10 | NTclustered | gi|2732913824|ref|XM_065323734.1| | 27933 | g80399 | i0 | 97.778 | 0.239393939393939 | 45 | 1 | 14 | 0 | 273 | 317 | 1572 | 1616 | PREDICTED: Sycon ciliatum isobutyryl-CoA dehydrogenase, mitochondrial-like (LOC135810254), mRNA | blastn | 79 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 11173696 | 11173696 | PRJNA983848_P_NODE_68209_length_385_cov_1.660256_g62326_i0 | PRJNA983848 | 68209 | 385 | 1.660256 | 6.3919856 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 52.8 | 0.037 | NTclustered | gi|2732934645|ref|XM_065334403.1| | 27933 | g62326 | i0 | 100 | 0.0727272727272727 | 28 | 0 | 7 | 0 | 64 | 91 | 3136 | 3163 | PREDICTED: Sycon ciliatum uncharacterized LOC135821340 (LOC135821340), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 12445453 | 12445453 | PRJNA983848_P_NODE_104990_length_294_cov_2.452489_g99107_i0 | PRJNA983848 | 104990 | 294 | 2.452489 | 7.21031766 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2749555105|ref|XM_066044695.1| | 196820 | g99107 | i0 | 96.875 | 0.108843537414966 | 32 | 1 | 11 | 0 | 48 | 79 | 1149 | 1118 | PREDICTED: Dysidea avara deoxyribonuclease-1-like (LOC136252285), transcript variant X2, mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 27026308 | 27026308 | PRJNA983848_P_NODE_118682_length_275_cov_1.584158_g112799_i0 | PRJNA983848 | 118682 | 275 | 1.584158 | 4.3564345 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 47.8 | 9.35e-4 | NR | CAI8016205.1 | 519541 | g112799 | i0 | 36.9 | 0.709090909090909 | 65 | 39 | 68.7 | 2 | 79 | 267 | 168 | 232 | CAI8016205.1 Dolichol kinase [Geodia barretti] | diamond | 195 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 28068644 | 28068644 | PRJNA983848_P_NODE_77425_length_353_cov_3.446429_g71542_i0 | PRJNA983848 | 77425 | 353 | 3.446429 | 12.16589437 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 68.9 | 3.97e-12 | NR | KAI6655347.1 | 111878 | g71542 | i0 | 73 | 3.14447592067989 | 37 | 10 | 31.4 | 0 | 135 | 245 | 19 | 55 | KAI6655347.1 hypothetical protein LOD99_2182 [Oopsacas minuta] | diamond | 1110 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 29552420 | 29552420 | PRJNA983848_P_NODE_78050_length_352_cov_0.838710_g72167_i0 | PRJNA983848 | 78050 | 352 | 0.83871 | 2.9522592 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 53.1 | 2.51e-5 | NR | KAI6651179.1 | 111878 | g72167 | i0 | 33.3 | 0.767045454545455 | 90 | 60 | 76.7 | 0 | 272 | 3 | 39 | 128 | KAI6651179.1 Transposase [Oopsacas minuta] | diamond | 270 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 29558527 | 29558527 | PRJNA983848_P_NODE_86170_length_331_cov_1.209302_g80287_i0 | PRJNA983848 | 86170 | 331 | 1.209302 | 4.00278962 | Metazoa | 33208 | Porifera | other_Eukaryota | 69.7 | 2.61e-11 | NR | KAI6655359.1 | 111878 | g80287 | i0 | 46 | 3.99697885196375 | 63 | 33 | 56.2 | 1 | 142 | 327 | 31 | 93 | KAI6655359.1 hypothetical protein LOD99_2194 [Oopsacas minuta] | diamond | 1323 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 29836744 | 29836744 | PRJNA983848_P_NODE_151311_length_246_cov_0.942197_g145428_i0 | PRJNA983848 | 151311 | 246 | 0.942197 | 2.31780462 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 50.4 | 7.76e-5 | NR | XP_065191859.1 | 27933 | g145428 | i0 | 54.3 | 0.853658536585366 | 35 | 16 | 42.7 | 0 | 240 | 136 | 245 | 279 | XP_065191859.1 uncharacterized protein LOC135822946 [Sycon ciliatum] | diamond | 210 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30753063 | 30753063 | PRJNA983848_P_NODE_105614_length_293_cov_2.481818_g99731_i0 | PRJNA983848 | 105614 | 293 | 2.481818 | 7.27172674 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 74.3 | 4.75e-13 | NR | XP_065835795.1 | 121494 | g99731 | i0 | 54.8 | 1.26962457337884 | 62 | 28 | 63.5 | 0 | 224 | 39 | 144 | 205 | XP_065835795.1 uncharacterized protein [Oscarella lobularis] | diamond | 372 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31986019 | 31986019 | PRJNA983848_P_NODE_144938_length_249_cov_1.710227_g139055_i0 | PRJNA983848 | 144938 | 249 | 1.710227 | 4.25846523 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 54.7 | 2.44e-6 | NR | XP_065196529.1 | 27933 | g139055 | i0 | 49.1 | 2.79518072289157 | 57 | 29 | 68.7 | 0 | 78 | 248 | 32 | 88 | XP_065196529.1 uncharacterized protein LOC135828021 [Sycon ciliatum] | diamond | 696 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31992111 | 31992111 | PRJNA983848_P_NODE_111598_length_284_cov_3.341232_g105715_i0 | PRJNA983848 | 111598 | 284 | 3.341232 | 9.48909888 | Metazoa | 33208 | Porifera | other_Eukaryota | 57.8 | 3.1e-7 | NR | KAI6646243.1 | 111878 | g105715 | i0 | 45.8 | 3.45422535211268 | 72 | 39 | 76.1 | 0 | 236 | 21 | 19 | 90 | KAI6646243.1 hypothetical protein LOD99_9327 [Oopsacas minuta] | diamond | 981 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 32176216 | 32176216 | PRJNA983848_P_NODE_112558_length_283_cov_1.971429_g106675_i0 | PRJNA983848 | 112558 | 283 | 1.971429 | 5.57914407 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 105 | 4.16e-26 | NR | KAI6657155.1 | 111878 | g106675 | i0 | 72.1 | 3.23321554770318 | 61 | 17 | 64.7 | 0 | 97 | 279 | 43 | 103 | KAI6657155.1 hypothetical protein LOD99_15941 [Oopsacas minuta] | diamond | 915 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 32271059 | 32271059 | PRJNA983848_P_NODE_44438_length_545_cov_1.811441_g38577_i0 | PRJNA983848 | 44438 | 545 | 1.811441 | 9.87235345 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 46.6 | 0.0187 | NR | XP_062513485.1 | 121492 | g38577 | i0 | 32.6 | 0.946788990825688 | 86 | 52 | 44 | 2 | 414 | 175 | 165 | 250 | XP_062513485.1 uncharacterized protein LOC134189265 [Corticium candelabrum] | diamond | 516 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32776063 | 32776063 | PRJNA983848_P_NODE_144580_length_249_cov_2.426136_g138697_i0 | PRJNA983848 | 144580 | 249 | 2.426136 | 6.04107864 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 81.3 | 1.09e-15 | NR | XP_065196529.1 | 27933 | g138697 | i0 | 44.7 | 2.74698795180723 | 76 | 42 | 91.6 | 0 | 248 | 21 | 50 | 125 | XP_065196529.1 uncharacterized protein LOC135828021 [Sycon ciliatum] | diamond | 684 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum |
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);;