contig_metadata
21 rows where bioproject = "PRJNA493632", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6839430 | 6839430 | PRJNA493632_P_NODE_326046_length_288_cov_1.776744_g322607_i0 | PRJNA493632 | 326046 | 288 | 1.776744 | 5.11702272 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|2664241156|ref|XM_062660598.1| | 121492 | g322607 | i0 | 100 | 0.0972222222222222 | 28 | 0 | 10 | 0 | 222 | 249 | 2675 | 2702 | PREDICTED: Corticium candelabrum beta-mannosidase-like (LOC134191945), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 11938483 | 11938483 | PRJNA493632_P_NODE_215670_length_334_cov_5.858238_g212235_i0 | PRJNA493632 | 215670 | 334 | 5.858238 | 19.56651492 | Halisarca dujardinii | 2583056 | Porifera | other_Eukaryota | 113 | 1.42e-20 | NTclustered | gi|2006291129|gb|MT451960.1| | 2583056 | g212235 | i0 | 84.348 | 12.6526946107784 | 115 | 18 | 34 | 0 | 218 | 332 | 1339 | 1225 | Halisarca dujardinii tubulin alpha 1 mRNA, complete cds | blastn | 4226 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Chondrillida | Halisarcidae | Halisarca | Halisarca dujardinii | |
| 13221430 | 13221430 | PRJNA493632_P_NODE_656751_length_241_cov_0.916667_g653310_i0 | PRJNA493632 | 656751 | 241 | 0.916667 | 2.20916747 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2749581959|ref|XM_066057253.1| | 196820 | g653310 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 84 | 111 | 1254 | 1227 | PREDICTED: Dysidea avara eukaryotic translation initiation factor 2 subunit 2-like (LOC136262840), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 13222626 | 13222626 | PRJNA493632_P_NODE_724211_length_206_cov_6.135338_g720769_i0 | PRJNA493632 | 724211 | 206 | 6.135338 | 12.63879628 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1133471186|ref|XM_011407450.2| | 400682 | g720769 | i0 | 94.444 | 0.174757281553398 | 36 | 1 | 17 | 1 | 128 | 163 | 39 | 5 | PREDICTED: Amphimedon queenslandica mitochondrial inner membrane protease subunit 1-like (LOC105313763), mRNA | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 14495246 | 14495246 | PRJNA493632_P_NODE_593132_length_245_cov_1.424419_g589691_i0 | PRJNA493632 | 593132 | 245 | 1.424419 | 3.48982655 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 165 | 2.72e-36 | NTclustered | gi|2719041159|ref|XM_064528782.1| | 6063 | g589691 | i0 | 82.54 | 7.11836734693878 | 189 | 32 | 77 | 1 | 21 | 208 | 812 | 1000 | PREDICTED: Halichondria panicea WD repeat-containing protein 5-like (LOC135333750), transcript variant X2, mRNA | blastn | 1744 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 17041928 | 17041928 | PRJNA493632_P_NODE_476634_length_256_cov_3.633880_g473195_i0 | PRJNA493632 | 476634 | 256 | 3.63388 | 9.3027328 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 108 | 4.27e-25 | NR | XP_064404647.1 | 6063 | g473195 | i0 | 59.5 | 0.984375 | 84 | 33 | 98.4 | 1 | 2 | 253 | 833 | 915 | XP_064404647.1 presequence protease, mitochondrial-like [Halichondria panicea] | diamond | 252 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 17042312 | 17042312 | PRJNA493632_P_NODE_499314_length_252_cov_1.709497_g495875_i0 | PRJNA493632 | 499314 | 252 | 1.709497 | 4.30793244 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2749565488|ref|XM_066049461.1| | 196820 | g495875 | i0 | 96.97 | 0.821428571428571 | 33 | 0 | 13 | 1 | 127 | 159 | 512 | 481 | PREDICTED: Dysidea avara uncharacterized protein (LOC136256487), mRNA | blastn | 207 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 23415965 | 23415965 | PRJNA493632_P_NODE_422379_length_267_cov_2.927835_g418940_i0 | PRJNA493632 | 422379 | 267 | 2.927835 | 7.81731945 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2732936996|ref|XM_065335646.1| | 27933 | g418940 | i0 | 94.444 | 0.955056179775281 | 36 | 1 | 13 | 1 | 215 | 249 | 1790 | 1825 | PREDICTED: Sycon ciliatum uncharacterized LOC135822814 (LOC135822814), transcript variant X1, mRNA | blastn | 255 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 23416440 | 23416440 | PRJNA493632_P_NODE_448059_length_262_cov_2.031746_g444620_i0 | PRJNA493632 | 448059 | 262 | 2.031746 | 5.32317452 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2664361103|ref|XM_062651289.1| | 121492 | g444620 | i0 | 100 | 0.110687022900763 | 29 | 0 | 11 | 0 | 56 | 84 | 1195 | 1223 | PREDICTED: Corticium candelabrum UPF0746 protein DDB_G0281095-like (LOC134183698), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27044954 | 27044954 | PRJNA493632_P_NODE_26342_length_795_cov_4.699446_g23546_i0 | PRJNA493632 | 26342 | 795 | 4.699446 | 37.3605957 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 53.5 | 5.97e-4 | NR | XP_065183553.1 | 27933 | g23546 | i0 | 44.9 | 0.184905660377358 | 49 | 25 | 18.5 | 1 | 456 | 602 | 1312 | 1358 | XP_065183553.1 uncharacterized protein LOC135814371 [Sycon ciliatum] | diamond | 147 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27392880 | 27392880 | PRJNA493632_P_NODE_583003_length_246_cov_0.890173_g579562_i0 | PRJNA493632 | 583003 | 246 | 0.890173 | 2.18982558 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 42.4 | 0.0372 | NR | XP_065902579.1 | 196820 | g579562 | i0 | 46.2 | 0.475609756097561 | 39 | 21 | 47.6 | 0 | 246 | 130 | 83 | 121 | XP_065902579.1 uncharacterized protein [Dysidea avara] | diamond | 117 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 28371428 | 28371428 | PRJNA493632_P_NODE_508746_length_251_cov_0.865169_g505307_i0 | PRJNA493632 | 508746 | 251 | 0.865169 | 2.17157419 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 79.3 | 1.33e-15 | NR | CAI8031468.1 | 519541 | g505307 | i0 | 52.4 | 1.93625498007968 | 82 | 39 | 98 | 0 | 248 | 3 | 98 | 179 | CAI8031468.1 RNA-directed DNA polymerase from mobile element jockey, partial [Geodia barretti] | diamond | 486 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 28923908 | 28923908 | PRJNA493632_P_NODE_366248_length_279_cov_2.223301_g362809_i0 | PRJNA493632 | 366248 | 279 | 2.223301 | 6.20300979 | Metazoa | 33208 | Porifera | other_Eukaryota | 62.8 | 4.76e-9 | NR | KAI6661017.1 | 111878 | g362809 | i0 | 41.9 | 12.3225806451613 | 74 | 41 | 77.4 | 1 | 4 | 219 | 288 | 361 | KAI6661017.1 Protein roadkill [Oopsacas minuta] | diamond | 3438 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 28987434 | 28987434 | PRJNA493632_P_NODE_149668_length_387_cov_0.859873_g146246_i0 | PRJNA493632 | 149668 | 387 | 0.859873 | 3.32770851 | root | 1 | Root_unresolved | Root_unresolved | 120 | 4.33e-29 | NR | XP_065193010.1 | 27933 | g146246 | i0 | 47.4 | 37.4496124031008 | 114 | 60 | 88.4 | 0 | 344 | 3 | 335 | 448 | XP_065193010.1 uncharacterized protein LOC135824206 [Sycon ciliatum] | diamond | 14493 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29823637 | 29823637 | PRJNA493632_P_NODE_384871_length_275_cov_2.257426_g381432_i0 | PRJNA493632 | 384871 | 275 | 2.257426 | 6.2079215 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 48.9 | 3.57e-4 | NR | XP_065889535.1 | 196820 | g381432 | i0 | 32.2 | 0.981818181818182 | 90 | 61 | 98.2 | 0 | 270 | 1 | 160 | 249 | XP_065889535.1 eukaryotic translation initiation factor 3 subunit E-like isoform X2 [Dysidea avara] | diamond | 270 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30298155 | 30298155 | PRJNA493632_P_NODE_147332_length_389_cov_1.670886_g143910_i0 | PRJNA493632 | 147332 | 389 | 1.670886 | 6.49974654 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 110 | 2.74e-25 | NR | XP_003389582.1 | 400682 | g143910 | i0 | 52.7 | 3.60925449871465 | 93 | 44 | 71.7 | 0 | 389 | 111 | 312 | 404 | XP_003389582.1 PREDICTED: uncharacterized protein K02A2.6-like [Amphimedon queenslandica] | diamond | 1404 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 30613673 | 30613673 | PRJNA493632_P_NODE_647153_length_242_cov_0.881657_g643712_i0 | PRJNA493632 | 647153 | 242 | 0.881657 | 2.13360994 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 43.5 | 0.00641 | NR | CAI8020430.1 | 519541 | g643712 | i0 | 58.1 | 1.06611570247934 | 43 | 17 | 52.1 | 1 | 240 | 115 | 73 | 115 | CAI8020430.1 hypothetical protein GBAR_LOCUS12222 [Geodia barretti] | diamond | 258 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 31277325 | 31277325 | PRJNA493632_P_NODE_713795_length_216_cov_8.286713_g710353_i0 | PRJNA493632 | 713795 | 216 | 8.286713 | 17.89930008 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 105 | 2.98e-24 | NR | XP_065196530.1 | 27933 | g710353 | i0 | 64.8 | 1.94444444444444 | 71 | 25 | 98.6 | 0 | 1 | 213 | 69 | 139 | XP_065196530.1 uncharacterized protein LOC135828022 [Sycon ciliatum] | diamond | 420 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31751694 | 31751694 | PRJNA493632_P_NODE_594137_length_245_cov_0.895349_g590696_i0 | PRJNA493632 | 594137 | 245 | 0.895349 | 2.19360505 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 48.9 | 2.52e-4 | NR | XP_065917218.1 | 196820 | g590696 | i0 | 60.6 | 0.404081632653061 | 33 | 13 | 40.4 | 0 | 3 | 101 | 334 | 366 | XP_065917218.1 uncharacterized protein [Dysidea avara] | diamond | 99 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32242481 | 32242481 | PRJNA493632_P_NODE_380078_length_276_cov_2.369458_g376639_i0 | PRJNA493632 | 380078 | 276 | 2.369458 | 6.53970408 | root | 1 | Root_unresolved | Root_unresolved | 77 | 4.4e-14 | NR | XP_064384823.1 | 6063 | g376639 | i0 | 55.1 | 62.3695652173913 | 69 | 31 | 75 | 0 | 212 | 6 | 286 | 354 | XP_064384823.1 AP-2 complex subunit mu-like [Halichondria panicea] | diamond | 17214 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 32637030 | 32637030 | PRJNA493632_P_NODE_411660_length_270_cov_0.791878_g408221_i0 | PRJNA493632 | 411660 | 270 | 0.791878 | 2.1380706 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 45.1 | 0.00795 | NR | XP_062504948.1 | 121492 | g408221 | i0 | 43.6 | 1.3 | 39 | 22 | 43.3 | 0 | 132 | 248 | 455 | 493 | XP_062504948.1 LOW QUALITY PROTEIN: uncharacterized protein K02A2.6-like [Corticium candelabrum] | diamond | 351 | 45.1 | 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);;