contig_metadata
15 rows where bioproject = "PRJNA1120771", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13030410 | 13030410 | PRJNA1120771_S_NODE_8191_length_360_cov_20.820189_g7791_i0 | PRJNA1120771 | 8191 | 360 | 20.820189 | 74.9526804 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 294 | 5.13e-75 | NTclustered | gi|457866940|emb|HF570264.1| | 27933 | g7791 | i0 | 83.178 | 31.5555555555556 | 321 | 54 | 89 | 0 | 1 | 321 | 98 | 418 | Sycon ciliatum mRNA for 40S ribosomal protein S23 (rps23 gene) | blastn | 11360 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 26995830 | 26995830 | PRJNA1120771_S_NODE_6522_length_390_cov_6.654179_g6122_i0 | PRJNA1120771 | 6522 | 390 | 6.654179 | 25.9512981 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 51.6 | 9.65e-5 | NR | CAI7992070.1 | 519541 | g6122 | i0 | 65 | 1.53846153846154 | 40 | 14 | 30.8 | 0 | 388 | 269 | 178 | 217 | CAI7992070.1 40S ribosomal protein S6 [Geodia barretti] | diamond | 600 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 27354755 | 27354755 | PRJNA1120771_S_NODE_27443_length_230_cov_1.855615_g27043_i0 | PRJNA1120771 | 27443 | 230 | 1.855615 | 4.2679145 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 96.3 | 4.4900000000000005e-21 | NR | XP_065191399.1 | 27933 | g27043 | i0 | 62.1 | 0.860869565217391 | 66 | 25 | 86.1 | 0 | 230 | 33 | 613 | 678 | XP_065191399.1 conditioned medium factor-like [Sycon ciliatum] | diamond | 198 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27754575 | 27754575 | PRJNA1120771_S_NODE_10824_length_327_cov_1.302817_g10424_i0 | PRJNA1120771 | 10824 | 327 | 1.302817 | 4.26021159 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 133 | 1.51e-35 | NR | ACV87967.1 | 666293 | g10424 | i0 | 57.4 | 4.91743119266055 | 108 | 46 | 99.1 | 0 | 326 | 3 | 88 | 195 | ACV87967.1 methionine adenosyltransferase, partial [Halisarca sp. KJP-2009] | diamond | 1608 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Chondrillida | Halisarcidae | Halisarca | Halisarca sp. KJP-2009 | |
| 28144167 | 28144167 | PRJNA1120771_S_NODE_9105_length_347_cov_3.960526_g8705_i0 | PRJNA1120771 | 9105 | 347 | 3.960526 | 13.74302522 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 82.8 | 6.59e-17 | NR | XP_062511357.1 | 121492 | g8705 | i0 | 36.4 | 2.0835734870317 | 121 | 70 | 99.4 | 4 | 345 | 1 | 47 | 166 | XP_062511357.1 uncharacterized protein LOC134187252 [Corticium candelabrum] | diamond | 723 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28227671 | 28227671 | PRJNA1120771_S_NODE_7766_length_367_cov_3.203704_g7366_i0 | PRJNA1120771 | 7766 | 367 | 3.203704 | 11.75759368 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 157 | 2.58e-44 | NR | CCQ18616.1 | 27933 | g7366 | i0 | 59.5 | 6.95640326975477 | 121 | 49 | 98.9 | 0 | 3 | 365 | 196 | 316 | CCQ18616.1 40S ribosomal protein S4 [Sycon ciliatum] | diamond | 2553 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29459002 | 29459002 | PRJNA1120771_S_NODE_14230_length_296_cov_2.612648_g13830_i0 | PRJNA1120771 | 14230 | 296 | 2.612648 | 7.73343808 | Metazoa | 33208 | Porifera | other_Eukaryota | 74.7 | 4.95e-14 | NR | XP_064399734.1 | 6063 | g13830 | i0 | 65.4 | 6.21283783783784 | 52 | 18 | 52.7 | 0 | 4 | 159 | 148 | 199 | XP_064399734.1 COMM domain-containing protein 7-like [Halichondria panicea] | diamond | 1839 | 75.1 | 0.994673768308922 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 29469734 | 29469734 | PRJNA1120771_S_NODE_15370_length_288_cov_2.693878_g14970_i0 | PRJNA1120771 | 15370 | 288 | 2.693878 | 7.75836864 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 55.1 | 2.6e-6 | NR | XP_064399613.1 | 6063 | g14970 | i0 | 36.5 | 1 | 96 | 49 | 94.8 | 4 | 2 | 274 | 216 | 304 | XP_064399613.1 retinol dehydrogenase 11-like [Halichondria panicea] | diamond | 288 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30386462 | 30386462 | PRJNA1120771_S_NODE_8313_length_359_cov_1.870253_g7913_i0 | PRJNA1120771 | 8313 | 359 | 1.870253 | 6.71420827 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 53.9 | 1.69e-5 | NR | XP_065837644.1 | 121494 | g7913 | i0 | 37.2 | 0.71866295264624 | 86 | 52 | 70.2 | 2 | 348 | 97 | 721 | 806 | XP_065837644.1 alpha-N-acetylglucosaminidase-like [Oscarella lobularis] | diamond | 258 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31808511 | 31808511 | PRJNA1120771_S_NODE_37117_length_200_cov_2.770701_g36717_i0 | PRJNA1120771 | 37117 | 200 | 2.770701 | 5.541402 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 78.2 | 6.14e-15 | NR | XP_062513488.1 | 121492 | g36717 | i0 | 57.6 | 2.79 | 66 | 27 | 99 | 1 | 198 | 1 | 357 | 421 | XP_062513488.1 protein dcd1A-like [Corticium candelabrum] | diamond | 558 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 31860838 | 31860838 | PRJNA1120771_S_NODE_25297_length_238_cov_2.420513_g24897_i0 | PRJNA1120771 | 25297 | 238 | 2.420513 | 5.76082094 | root | 1 | Root_unresolved | Root_unresolved | 58.9 | 6.78e-8 | NR | XP_065197947.1 | 27933 | g24897 | i0 | 61.7 | 4.05882352941176 | 47 | 18 | 59.2 | 0 | 237 | 97 | 402 | 448 | XP_065197947.1 phosphonopyruvate decarboxylase-like [Sycon ciliatum] | diamond | 966 | 59.3 | 0.993254637436762 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31871691 | 31871691 | PRJNA1120771_S_NODE_25637_length_237_cov_1.345361_g25237_i0 | PRJNA1120771 | 25637 | 237 | 1.345361 | 3.18850557 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 49.3 | 9.41e-5 | NR | XP_003384140.2 | 400682 | g25237 | i0 | 53.8 | 0.493670886075949 | 39 | 18 | 49.4 | 0 | 6 | 122 | 142 | 180 | XP_003384140.2 PREDICTED: tryparedoxin-like [Amphimedon queenslandica] | diamond | 117 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 32177569 | 32177569 | PRJNA1120771_S_NODE_13558_length_301_cov_4.217054_g13158_i0 | PRJNA1120771 | 13558 | 301 | 4.217054 | 12.69333254 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 44.7 | 0.0146 | NR | XP_064386088.1 | 6063 | g13158 | i0 | 35.6 | 3.43853820598007 | 59 | 38 | 58.8 | 0 | 275 | 99 | 413 | 471 | XP_064386088.1 serine palmitoyltransferase 1-like [Halichondria panicea] | diamond | 1035 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 32283350 | 32283350 | PRJNA1120771_S_NODE_15279_length_289_cov_1.036585_g14879_i0 | PRJNA1120771 | 15279 | 289 | 1.036585 | 2.99573065 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 125 | 4.17e-31 | NR | XP_064403925.1 | 6063 | g14879 | i0 | 62.5 | 0.996539792387543 | 96 | 35 | 98.6 | 1 | 289 | 5 | 1207 | 1302 | XP_064403925.1 uncharacterized protein LOC135349329 [Halichondria panicea] | diamond | 288 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 32819745 | 32819745 | PRJNA1120771_S_NODE_22420_length_250_cov_1.975845_g22020_i0 | PRJNA1120771 | 22420 | 250 | 1.975845 | 4.9396125 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 47 | 8.33e-4 | NR | XP_062509816.1 | 121492 | g22020 | i0 | 50 | 3.576 | 52 | 24 | 60 | 1 | 248 | 99 | 147 | 198 | XP_062509816.1 COMM domain-containing protein 9-like [Corticium candelabrum] | diamond | 894 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum |
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);;