contig_metadata
8 rows where bioproject = "PRJNA478247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4274742 | 4274742 | PRJNA478247_P_NODE_1364_length_328_cov_2.381271_g1258_i0 | PRJNA478247 | 1364 | 328 | 2.381271 | 7.81056888 | Metazoa | 33208 | Porifera | other_Eukaryota | 144 | 3.51e-38 | NR | XP_064390539.1 | 6063 | g1258 | i0 | 65.4 | 30.9237804878049 | 107 | 36 | 97 | 1 | 3 | 320 | 338 | 444 | XP_064390539.1 protein disulfide-isomerase A3-like [Halichondria panicea] | diamond | 10143 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 13201399 | 13201399 | PRJNA478247_P_NODE_671_length_527_cov_2.188755_g566_i0 | PRJNA478247 | 671 | 527 | 2.188755 | 11.53473885 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 281 | 1.38e-90 | NR | XP_064394862.1 | 6063 | g566 | i0 | 75.1 | 1.92979127134725 | 169 | 42 | 96.2 | 0 | 21 | 527 | 240 | 408 | XP_064394862.1 adenosylhomocysteinase B-like [Halichondria panicea] | diamond | 1017 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 15750415 | 15750415 | PRJNA478247_P_NODE_253_length_980_cov_8.157729_g194_i0 | PRJNA478247 | 253 | 980 | 8.157729 | 79.9457442 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 369 | 5.0499999999999985e-124 | NR | XP_064388847.1 | 6063 | g194 | i0 | 57.5 | 1.00102040816327 | 327 | 130 | 99.2 | 4 | 972 | 1 | 9 | 329 | XP_064388847.1 procathepsin L-like [Halichondria panicea] | diamond | 981 | 369 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 26871252 | 26871252 | PRJNA478247_P_NODE_3221_length_166_cov_1.992701_g3115_i0 | PRJNA478247 | 3221 | 166 | 1.992701 | 3.30788366 | Metazoa | 33208 | Porifera | other_Eukaryota | 99 | 1.08e-22 | NR | XP_065185159.1 | 27933 | g3115 | i0 | 74.5 | 1.98795180722892 | 55 | 14 | 99.4 | 0 | 165 | 1 | 224 | 278 | XP_065185159.1 carboxypeptidase B-like [Sycon ciliatum] | diamond | 330 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29129141 | 29129141 | PRJNA478247_P_NODE_2109_length_236_cov_4.222222_g2003_i0 | PRJNA478247 | 2109 | 236 | 4.222222 | 9.96444392 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 88.6 | 2.52e-18 | NR | XP_062517534.1 | 121492 | g2003 | i0 | 67.3 | 0.699152542372881 | 55 | 17 | 68.6 | 1 | 1 | 162 | 844 | 898 | XP_062517534.1 neurogenic locus notch homolog protein 1-like [Corticium candelabrum] | diamond | 165 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 31340220 | 31340220 | PRJNA478247_P_NODE_1316_length_336_cov_1.677524_g1210_i0 | PRJNA478247 | 1316 | 336 | 1.677524 | 5.63648064 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 72.8 | 3.22e-12 | NR | XP_065890435.1 | 196820 | g1210 | i0 | 38 | 0.964285714285714 | 108 | 63 | 93.8 | 2 | 22 | 336 | 515 | 621 | XP_065890435.1 filamin-B-like [Dysidea avara] | diamond | 324 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 31909596 | 31909596 | PRJNA478247_P_NODE_357_length_797_cov_2.346354_g275_i0 | PRJNA478247 | 357 | 797 | 2.346354 | 18.70044138 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 78.6 | 5.5e-13 | NR | XP_062503857.1 | 121492 | g275 | i0 | 27.8 | 0.959849435382685 | 255 | 158 | 93 | 12 | 787 | 47 | 1 | 237 | XP_062503857.1 voltage-dependent anion-selective channel protein 2-like [Corticium candelabrum] | diamond | 765 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32810422 | 32810422 | PRJNA478247_P_NODE_2020_length_245_cov_1.796296_g1914_i0 | PRJNA478247 | 2020 | 245 | 1.796296 | 4.4009252 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 66.2 | 1.09e-11 | NR | XP_062501865.1 | 121492 | g1914 | i0 | 45.3 | 7.3469387755102 | 75 | 41 | 91.8 | 0 | 226 | 2 | 6 | 80 | XP_062501865.1 large ribosomal subunit protein eL22-like [Corticium candelabrum] | diamond | 1800 | 66.6 | 0.993993993993994 | 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);;