contig_metadata
12 rows where bioproject = "PRJNA1126198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14310098 | 14310098 | PRJNA1126198_P_NODE_214012_length_288_cov_1.446512_g213291_i0 | PRJNA1126198 | 214012 | 288 | 1.446512 | 4.16595456 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 248 | 3.17e-61 | NTclustered | gi|2732923973|ref|XM_065328925.1| | 27933 | g213291 | i0 | 90.476 | 67.3020833333333 | 189 | 16 | 65 | 2 | 100 | 287 | 465 | 278 | PREDICTED: Sycon ciliatum histone H3 (LOC135815608), mRNA | blastn | 19383 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 16332830 | 16332830 | PRJNA1126198_P_NODE_38953_length_420_cov_8.080692_g38240_i0 | PRJNA1126198 | 38953 | 420 | 8.080692 | 33.9389064 | Haplosclerida | 6049 | Porifera | other_Eukaryota | 108 | 8.51e-19 | NTclustered | gi|1284883228|gb|KY825184.1| | 178514 | g38240 | i0 | 81.159 | 5.63809523809524 | 138 | 22 | 33 | 3 | 266 | 402 | 3474 | 3340 | Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence | blastn | 2368 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon compressa | |
| 19407714 | 19407714 | PRJNA1126198_P_NODE_5376_length_762_cov_5.153846_g4776_i0 | PRJNA1126198 | 5376 | 762 | 5.153846 | 39.27230652 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 271 | 1.1e-87 | NR | XP_062521049.1 | 121492 | g4776 | i0 | 57.9 | 11.992125984252 | 235 | 99 | 92.5 | 0 | 28 | 732 | 27 | 261 | XP_062521049.1 large ribosomal subunit protein uL30-like [Corticium candelabrum] | diamond | 9138 | 271 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 24507054 | 24507054 | PRJNA1126198_P_NODE_15520_length_525_cov_2.022124_g14835_i0 | PRJNA1126198 | 15520 | 525 | 2.022124 | 10.616151 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 240 | 1.1499999999999998e-73 | NR | XP_065195085.1 | 27933 | g14835 | i0 | 64.6 | 16 | 175 | 62 | 100 | 0 | 525 | 1 | 254 | 428 | XP_065195085.1 methylmalonate-semialdehyde/malonate-semialdehyde dehydrogenase [acylating], mitochondrial-like [Sycon ciliatum] | diamond | 8400 | 240 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27386538 | 27386538 | PRJNA1126198_P_NODE_28703_length_451_cov_1.989418_g27997_i0 | PRJNA1126198 | 28703 | 451 | 1.989418 | 8.97227518 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 107 | 4.38e-26 | NR | XP_064400518.1 | 6063 | g27997 | i0 | 44.5 | 0.851441241685144 | 128 | 60 | 79.8 | 3 | 446 | 87 | 46 | 170 | XP_064400518.1 uncharacterized protein LOC135346725 [Halichondria panicea] | diamond | 384 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27564724 | 27564724 | PRJNA1126198_P_NODE_11084_length_576_cov_2.693837_g10411_i0 | PRJNA1126198 | 11084 | 576 | 2.693837 | 15.51650112 | Metazoa | 33208 | Porifera | other_Eukaryota | 242 | 1.49e-71 | NR | XP_065194361.1 | 27933 | g10411 | i0 | 69.5 | 7.0625 | 190 | 55 | 97.4 | 1 | 1 | 561 | 538 | 727 | XP_065194361.1 major vault protein-like [Sycon ciliatum] | diamond | 4068 | 242 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29659282 | 29659282 | PRJNA1126198_P_NODE_443010_length_244_cov_1.789474_g442289_i0 | PRJNA1126198 | 443010 | 244 | 1.789474 | 4.36631656 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 75.9 | 3.19e-14 | NR | CAI8010875.1 | 519541 | g442289 | i0 | 73.3 | 0.55327868852459 | 45 | 10 | 55.3 | 1 | 236 | 102 | 160 | 202 | CAI8010875.1 F-actin-capping protein subunit alpha [Geodia barretti] | diamond | 135 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 30164860 | 30164860 | PRJNA1126198_P_NODE_386972_length_250_cov_0.881356_g386251_i0 | PRJNA1126198 | 386972 | 250 | 0.881356 | 2.20339 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 45.4 | 0.00453 | NR | XP_019859682.1 | 400682 | g386251 | i0 | 71.4 | 0.672 | 28 | 8 | 33.6 | 0 | 243 | 160 | 288 | 315 | XP_019859682.1 PREDICTED: serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit A-like [Amphimedon queenslandica] | diamond | 168 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 30702136 | 30702136 | PRJNA1126198_P_NODE_25014_length_466_cov_7.740458_g24313_i0 | PRJNA1126198 | 25014 | 466 | 7.740458 | 36.07053428 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 196 | 1.47e-61 | NR | XP_065826293.1 | 121494 | g24313 | i0 | 73.8 | 8.44635193133047 | 130 | 34 | 83.7 | 0 | 442 | 53 | 1 | 130 | XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] | diamond | 3936 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31081425 | 31081425 | PRJNA1126198_P_NODE_196615_length_294_cov_1.054299_g195895_i0 | PRJNA1126198 | 196615 | 294 | 1.054299 | 3.09963906 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 56.2 | 1.21e-6 | NR | XP_064401533.1 | 6063 | g195895 | i0 | 46.8 | 1.62244897959184 | 79 | 32 | 79.6 | 4 | 56 | 289 | 354 | 423 | XP_064401533.1 ATP-binding cassette sub-family F member 2-like [Halichondria panicea] | diamond | 477 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31081431 | 31081431 | PRJNA1126198_P_NODE_273795_length_272_cov_1.386935_g273074_i0 | PRJNA1126198 | 273795 | 272 | 1.386935 | 3.7724632 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 140 | 1.15e-39 | NR | XP_064392692.1 | 6063 | g273074 | i0 | 73 | 0.981617647058823 | 89 | 23 | 97.1 | 1 | 272 | 9 | 53 | 141 | XP_064392692.1 vacuolar protein sorting-associated protein 29-like [Halichondria panicea] | diamond | 267 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31175814 | 31175814 | PRJNA1126198_P_NODE_211195_length_289_cov_1.421296_g210474_i0 | PRJNA1126198 | 211195 | 289 | 1.421296 | 4.10754544 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 89 | 1.24e-18 | NR | XP_065185538.1 | 27933 | g210474 | i0 | 63.4 | 1.57785467128028 | 71 | 25 | 73.7 | 1 | 213 | 1 | 49 | 118 | XP_065185538.1 dolichyl-phosphate beta-glucosyltransferase-like [Sycon ciliatum] | diamond | 456 | 89 | 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);;