contig_metadata
9 rows where bioproject = "PRJNA745553", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2474033 | 2474033 | PRJNA745553_S_NODE_19802_length_278_cov_1.434146_g19607_i0 | PRJNA745553 | 19802 | 278 | 1.434146 | 3.98692588 | Demospongiae | 6042 | Porifera | other_Eukaryota | 172 | 1.8799999999999998e-38 | NTclustered | gi|512765266|gb|KC869504.1| | 283510 | g19607 | i0 | 88.811 | 47.6762589928058 | 143 | 12 | 50 | 4 | 59 | 198 | 1999 | 2140 | Spirastrella hartmani voucher P21 28S ribosomal RNA gene, partial sequence | blastn | 13254 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Clionaida | Spirastrellidae | Spirastrella | Spirastrella hartmani | |
| 4552867 | 4552867 | PRJNA745553_S_NODE_3564_length_560_cov_9.665298_g3379_i0 | PRJNA745553 | 3564 | 560 | 9.665298 | 54.1256688 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 178 | 4.16e-54 | NR | CCQ18628.1 | 27933 | g3379 | i0 | 64.7 | 1.41964285714286 | 133 | 46 | 71.3 | 1 | 86 | 484 | 1 | 132 | CCQ18628.1 40S ribosomal protein S2 [Sycon ciliatum] | diamond | 795 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 13477822 | 13477822 | PRJNA745553_S_NODE_10811_length_370_cov_6.225589_g10616_i0 | PRJNA745553 | 10811 | 370 | 6.225589 | 23.0346793 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 150 | 2.6e-40 | NR | XP_065920557.1 | 196820 | g10616 | i0 | 81.5 | 3.02432432432432 | 92 | 17 | 74.6 | 0 | 1 | 276 | 434 | 525 | XP_065920557.1 T-complex protein 1 subunit delta-like [Dysidea avara] | diamond | 1119 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 17302412 | 17302412 | PRJNA745553_S_NODE_29014_length_225_cov_8.203947_g28819_i0 | PRJNA745553 | 29014 | 225 | 8.203947 | 18.45888075 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 86.7 | 2.49e-19 | NR | XP_062521421.1 | 121492 | g28819 | i0 | 80.4 | 5.44 | 51 | 10 | 68 | 0 | 22 | 174 | 118 | 168 | XP_062521421.1 actin-related protein 2/3 complex subunit 4 [Corticium candelabrum] | diamond | 1224 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 22876167 | 22876167 | PRJNA745553_S_NODE_20058_length_276_cov_2.216749_g19863_i0 | PRJNA745553 | 20058 | 276 | 2.216749 | 6.11822724 | Metazoa | 33208 | Porifera | other_Eukaryota | 171 | 6.72e-38 | NTclustered | gi|54639914|gb|AY626288.1| | 297660 | g19863 | i0 | 82.323 | 71.1739130434783 | 198 | 32 | 71 | 3 | 77 | 273 | 778 | 973 | Cliona sp. UCMPWC1066 28S ribosomal RNA gene, partial sequence | blastn | 19644 | 172 | 0.994186046511628 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Clionaida | Clionaidae | Cliona | Cliona sp. UCMPWC1066 | |
| 26957654 | 26957654 | PRJNA745553_S_NODE_23602_length_254_cov_4.143646_g23407_i0 | PRJNA745553 | 23602 | 254 | 4.143646 | 10.52486084 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 52.4 | 7.24e-6 | NR | XP_064384657.1 | 6063 | g23407 | i0 | 79.3 | 1.02755905511811 | 29 | 6 | 34.3 | 0 | 232 | 146 | 151 | 179 | XP_064384657.1 60S ribosome subunit biogenesis protein NIP7 homolog [Halichondria panicea] | diamond | 261 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27242328 | 27242328 | PRJNA745553_S_NODE_1603_length_692_cov_4.224556_g1451_i0 | PRJNA745553 | 1603 | 692 | 4.224556 | 29.23392752 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 94.4 | 2.76e-18 | NR | XP_064386088.1 | 6063 | g1451 | i0 | 33.7 | 0.823699421965318 | 190 | 84 | 82.4 | 4 | 3 | 572 | 328 | 475 | XP_064386088.1 serine palmitoyltransferase 1-like [Halichondria panicea] | diamond | 570 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30905992 | 30905992 | PRJNA745553_S_NODE_6494_length_459_cov_4.044041_g6300_i0 | PRJNA745553 | 6494 | 459 | 4.044041 | 18.56214819 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 182 | 3.73e-56 | NR | XP_065187500.1 | 27933 | g6300 | i0 | 76.3 | 2.9281045751634 | 114 | 26 | 73.9 | 1 | 28 | 366 | 14 | 127 | XP_065187500.1 adenosine 5'-monophosphoramidase HINT1-like [Sycon ciliatum] | diamond | 1344 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31790960 | 31790960 | PRJNA745553_S_NODE_17517_length_295_cov_1.734234_g17322_i0 | PRJNA745553 | 17517 | 295 | 1.734234 | 5.1159903 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 49.3 | 3.28e-4 | NR | XP_065177666.1 | 27933 | g17322 | i0 | 32.5 | 0.783050847457627 | 77 | 43 | 72.2 | 2 | 284 | 72 | 473 | 546 | XP_065177666.1 sialate O-acetylesterase-like [Sycon ciliatum] | diamond | 231 | 49.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);;