contig_metadata
12 rows where bioproject = "PRJNA330616" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 389916 | 389916 | PRJNA330616_P_NODE_7441_length_305_cov_1.394531_g7032_i0 | PRJNA330616 | 7441 | 305 | 1.394531 | 4.25331955 | Metazoa | 33208 | Porifera | other_Eukaryota | 154 | 2.8e-45 | NR | XP_065897848.1 | 196820 | g7032 | i0 | 80 | 11.2032786885246 | 95 | 19 | 93.4 | 0 | 19 | 303 | 1 | 95 | XP_065897848.1 large ribosomal subunit protein eL19-like [Dysidea avara] | diamond | 3417 | 155 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 4217029 | 4217029 | PRJNA330616_P_NODE_2844_length_523_cov_1.757384_g2440_i0 | PRJNA330616 | 2844 | 523 | 1.757384 | 9.19111832 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 196 | 8.619999999999999e-60 | NR | XP_064383513.1 | 6063 | g2440 | i0 | 66.7 | 9.8604206500956 | 156 | 52 | 89.5 | 0 | 56 | 523 | 11 | 166 | XP_064383513.1 large ribosomal subunit protein uL30-like [Halichondria panicea] | diamond | 5157 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 8043184 | 8043184 | PRJNA330616_P_NODE_8647_length_282_cov_2.051502_g8238_i0 | PRJNA330616 | 8647 | 282 | 2.051502 | 5.78523564 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 125 | 1.3899999999999998e-32 | NR | XP_062520409.1 | 121492 | g8238 | i0 | 67.7 | 19.9468085106383 | 93 | 30 | 98.9 | 0 | 281 | 3 | 4 | 96 | XP_062520409.1 large ribosomal subunit protein uL10-like [Corticium candelabrum] | diamond | 5625 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 10593544 | 10593544 | PRJNA330616_P_NODE_4369_length_407_cov_3.164804_g3961_i0 | PRJNA330616 | 4369 | 407 | 3.164804 | 12.88075228 | Homosclerophorida | 81000 | Porifera | other_Eukaryota | 164 | 1.49e-49 | NR | XP_062505213.1 | 121492 | g3961 | i0 | 70 | 3.83292383292383 | 130 | 39 | 95.8 | 0 | 5 | 394 | 1 | 130 | XP_062505213.1 small ribosomal subunit protein eS24-like [Corticium candelabrum] | diamond | 1560 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 23341406 | 23341406 | PRJNA330616_P_NODE_11119_length_248_cov_1.532663_g10710_i0 | PRJNA330616 | 11119 | 248 | 1.532663 | 3.80100424 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 132 | 5.139999999999999e-37 | NR | XP_003386009.1 | 400682 | g10710 | i0 | 84.1 | 16.8387096774194 | 82 | 13 | 99.2 | 0 | 246 | 1 | 32 | 113 | XP_003386009.1 PREDICTED: 60S ribosomal protein L19-like [Amphimedon queenslandica] | diamond | 4176 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 26853318 | 26853318 | PRJNA330616_P_NODE_18401_length_196_cov_1.387755_g17992_i0 | PRJNA330616 | 18401 | 196 | 1.387755 | 2.7199998 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 59.3 | 2.82e-8 | NR | XP_065908559.1 | 196820 | g17992 | i0 | 40.6 | 2.05102040816327 | 69 | 34 | 94.9 | 1 | 8 | 193 | 322 | 390 | XP_065908559.1 uncharacterized protein [Dysidea avara] | diamond | 402 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 27011242 | 27011242 | PRJNA330616_P_NODE_21762_length_181_cov_1.712121_g21353_i0 | PRJNA330616 | 21762 | 181 | 1.712121 | 3.09893901 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 72.8 | 4.2e-13 | NR | XP_062502741.1 | 121492 | g21353 | i0 | 55.2 | 0.961325966850829 | 58 | 25 | 94.5 | 1 | 172 | 2 | 1685 | 1742 | XP_062502741.1 unconventional myosin heavy chain 6-like [Corticium candelabrum] | diamond | 174 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27597578 | 27597578 | PRJNA330616_P_NODE_32724_length_159_cov_2.727273_g32315_i0 | PRJNA330616 | 32724 | 159 | 2.727273 | 4.33636407 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 40.8 | 0.0213 | NR | CCQ18668.1 | 27933 | g32315 | i0 | 52.5 | 3.0188679245283 | 40 | 19 | 75.5 | 0 | 159 | 40 | 68 | 107 | CCQ18668.1 40S ribosomal protein S24 [Sycon ciliatum] | diamond | 480 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 28085223 | 28085223 | PRJNA330616_P_NODE_25925_length_167_cov_0.864407_g25516_i0 | PRJNA330616 | 25925 | 167 | 0.864407 | 1.44355969 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 93.2 | 1.79e-22 | NR | XP_062499517.1 | 121492 | g25516 | i0 | 75.9 | 11.622754491018 | 54 | 13 | 97 | 0 | 2 | 163 | 40 | 93 | XP_062499517.1 small ribosomal subunit protein eS19-like [Corticium candelabrum] | diamond | 1941 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 28211414 | 28211414 | PRJNA330616_P_NODE_25566_length_167_cov_0.864407_g25157_i0 | PRJNA330616 | 25566 | 167 | 0.864407 | 1.44355969 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 52 | 7.13e-6 | NR | XP_065827040.1 | 121494 | g25157 | i0 | 44.9 | 3.55688622754491 | 49 | 25 | 88 | 1 | 156 | 10 | 282 | 328 | XP_065827040.1 chitinase domain-containing protein 1-like [Oscarella lobularis] | diamond | 594 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30074422 | 30074422 | PRJNA330616_P_NODE_17552_length_200_cov_2.006623_g17143_i0 | PRJNA330616 | 17552 | 200 | 2.006623 | 4.013246 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 78.2 | 1e-16 | NR | XP_065178029.1 | 27933 | g17143 | i0 | 81 | 1.86 | 42 | 8 | 63 | 0 | 1 | 126 | 71 | 112 | XP_065178029.1 uncharacterized protein LOC135808728 [Sycon ciliatum] | diamond | 372 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32192772 | 32192772 | PRJNA330616_P_NODE_28078_length_165_cov_0.879310_g27669_i0 | PRJNA330616 | 28078 | 165 | 0.87931 | 1.4508615 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 42.4 | 0.0176 | NR | XP_064381964.1 | 6063 | g27669 | i0 | 43.8 | 0.872727272727273 | 48 | 24 | 87.3 | 1 | 2 | 145 | 4 | 48 | XP_064381964.1 uncharacterized protein LOC135330916 [Halichondria panicea] | diamond | 144 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea |
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);;