contig_metadata
11 rows where bioproject = "PRJNA382357", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6177491 | 6177491 | PRJNA382357_P_NODE_131005_length_213_cov_7.513158_g130266_i0 | PRJNA382357 | 131005 | 213 | 7.513158 | 16.00302654 | Plakinidae | 81001 | Porifera | other_Eukaryota | 147 | 8.359999999999999e-31 | NTclustered | gi|2664284966|ref|XR_009969824.1| | 121492 | g130266 | i0 | 98.78 | 38.8920187793427 | 82 | 1 | 38 | 0 | 1 | 82 | 1650 | 1569 | PREDICTED: Corticium candelabrum small subunit ribosomal RNA (LOC134179215), rRNA | blastn | 8284 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 8055991 | 8055991 | PRJNA382357_P_NODE_1307_length_1466_cov_1.834164_g741_i1 | PRJNA382357 | 1307 | 1466 | 1.834164 | 26.88884424 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 109 | 1.48e-21 | NR | XP_065891564.1 | 196820 | g741 | i1 | 39.7 | 0.268076398362892 | 131 | 79 | 26.8 | 0 | 1013 | 621 | 140 | 270 | XP_065891564.1 uncharacterized protein [Dysidea avara] | diamond | 393 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 9330575 | 9330575 | PRJNA382357_P_NODE_1128_length_1565_cov_2.117021_g741_i0 | PRJNA382357 | 1128 | 1565 | 2.117021 | 33.13137865 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 108 | 4.8100000000000005e-21 | NR | XP_065891564.1 | 196820 | g741 | i0 | 38.7 | 0.262619808306709 | 137 | 84 | 26.3 | 0 | 1031 | 621 | 134 | 270 | XP_065891564.1 uncharacterized protein [Dysidea avara] | diamond | 411 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 20200872 | 20200872 | PRJNA382357_P_NODE_155076_length_202_cov_1.368794_g154337_i0 | PRJNA382357 | 155076 | 202 | 1.368794 | 2.76496388 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 174 | 3.6e-39 | NTclustered | gi|512765322|gb|KC869560.1| | 798311 | g154337 | i0 | 89.781 | 69.5 | 137 | 12 | 67 | 2 | 21 | 156 | 479 | 614 | Ptilocaulis spiculifer voucher NCI205 28S ribosomal RNA gene, partial sequence | blastn | 14039 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Axinellida | Axinellidae | Ptilocaulis | Ptilocaulis spiculifer | |
| 28748868 | 28748868 | PRJNA382357_P_NODE_80087_length_267_cov_0.864078_g79348_i0 | PRJNA382357 | 80087 | 267 | 0.864078 | 2.30708826 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 100 | 1.8000000000000001e-22 | NR | XP_062517561.1 | 121492 | g79348 | i0 | 51.1 | 2.96629213483146 | 88 | 43 | 98.9 | 0 | 3 | 266 | 1059 | 1146 | XP_062517561.1 uncharacterized protein LOC134192818 [Corticium candelabrum] | diamond | 792 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 29128006 | 29128006 | PRJNA382357_P_NODE_85069_length_260_cov_1.221106_g84330_i0 | PRJNA382357 | 85069 | 260 | 1.221106 | 3.1748756 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 58.5 | 1.21e-7 | NR | KAI6654037.1 | 111878 | g84330 | i0 | 42.6 | 0.623076923076923 | 54 | 31 | 62.3 | 0 | 76 | 237 | 117 | 170 | KAI6654037.1 Protein mesh-like [Oopsacas minuta] | diamond | 162 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 30548926 | 30548926 | PRJNA382357_P_NODE_127073_length_217_cov_1.243590_g126334_i0 | PRJNA382357 | 127073 | 217 | 1.24359 | 2.6985903 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 42.7 | 0.0264 | NR | XP_065902420.1 | 196820 | g126334 | i0 | 32.3 | 0.857142857142857 | 62 | 40 | 82.9 | 1 | 185 | 6 | 179 | 240 | XP_065902420.1 uncharacterized protein [Dysidea avara] | diamond | 186 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30675294 | 30675294 | PRJNA382357_P_NODE_8293_length_713_cov_1.237730_g7613_i0 | PRJNA382357 | 8293 | 713 | 1.23773 | 8.8250149 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 174 | 6.989999999999999e-46 | NR | XP_065186116.1 | 27933 | g7613 | i0 | 42.5 | 3.49649368863955 | 207 | 117 | 86.3 | 2 | 1 | 615 | 1266 | 1472 | XP_065186116.1 uncharacterized protein LOC135816938 [Sycon ciliatum] | diamond | 2493 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31086222 | 31086222 | PRJNA382357_P_NODE_99475_length_243_cov_0.994505_g98736_i0 | PRJNA382357 | 99475 | 243 | 0.994505 | 2.41664715 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 52 | 1.96e-5 | NR | XP_065194931.1 | 27933 | g98736 | i0 | 41.9 | 1.59259259259259 | 43 | 25 | 53.1 | 0 | 242 | 114 | 225 | 267 | XP_065194931.1 uncharacterized protein LOC135826231 [Sycon ciliatum] | diamond | 387 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32256780 | 32256780 | PRJNA382357_P_NODE_146078_length_206_cov_0.896552_g145339_i0 | PRJNA382357 | 146078 | 206 | 0.896552 | 1.84689712 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 42 | 0.042 | NR | XP_062514119.1 | 121492 | g145339 | i0 | 38.8 | 0.713592233009709 | 49 | 25 | 64.1 | 1 | 9 | 140 | 17 | 65 | XP_062514119.1 TNF receptor-associated factor 4-like [Corticium candelabrum] | diamond | 147 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32841516 | 32841516 | PRJNA382357_P_NODE_42720_length_352_cov_1.872852_g41981_i0 | PRJNA382357 | 42720 | 352 | 1.872852 | 6.59243904 | Metazoa | 33208 | Porifera | other_Eukaryota | 51.6 | 1.05e-4 | NR | XP_065183206.1 | 27933 | g41981 | i0 | 38.7 | 1.24431818181818 | 75 | 39 | 59.7 | 4 | 319 | 110 | 1019 | 1091 | XP_065183206.1 macrophage mannose receptor 1-like [Sycon ciliatum] | diamond | 438 | 52 | 0.992307692307692 | 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);;