contig_metadata
19 rows where bioproject = "PRJNA1025141", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10365954 | 10365954 | PRJNA1025141_P_NODE_1209_length_750_cov_7.270310_g1154_i0 | PRJNA1025141 | 1209 | 750 | 7.27031 | 54.527325 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 271 | 6.669999999999998e-88 | NR | XP_062521049.1 | 121492 | g1154 | i0 | 57.9 | 12.184 | 235 | 99 | 94 | 0 | 729 | 25 | 27 | 261 | XP_062521049.1 large ribosomal subunit protein uL30-like [Corticium candelabrum] | diamond | 9138 | 272 | 0.996323529411765 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 11641388 | 11641388 | PRJNA1025141_P_NODE_3430_length_441_cov_1.614130_g3369_i0 | PRJNA1025141 | 3430 | 441 | 1.61413 | 7.1183133 | Metazoa | 33208 | Porifera | other_Eukaryota | 160 | 1.87e-43 | NR | XP_065826796.1 | 121494 | g3369 | i0 | 59.1 | 2.74149659863946 | 132 | 53 | 89.1 | 1 | 424 | 32 | 31 | 162 | XP_065826796.1 protein disulfide-isomerase 2-like [Oscarella lobularis] | diamond | 1209 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 18014672 | 18014672 | PRJNA1025141_P_NODE_4235_length_395_cov_1.645963_g4174_i0 | PRJNA1025141 | 4235 | 395 | 1.645963 | 6.50155385 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 162 | 1.57e-48 | NR | XP_065829718.1 | 121494 | g4174 | i0 | 73 | 11.3924050632911 | 100 | 27 | 75.9 | 0 | 389 | 90 | 45 | 144 | XP_065829718.1 small ribosomal subunit protein uS9-like [Oscarella lobularis] | diamond | 4500 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 26741840 | 26741840 | PRJNA1025141_P_NODE_11581_length_245_cov_0.895349_g11520_i0 | PRJNA1025141 | 11581 | 245 | 0.895349 | 2.19360505 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 47.8 | 6.5e-4 | NR | XP_064382739.1 | 6063 | g11520 | i0 | 39.2 | 4.26122448979592 | 74 | 31 | 79.6 | 2 | 10 | 204 | 293 | 361 | XP_064382739.1 glutamate--cysteine ligase catalytic subunit-like [Halichondria panicea] | diamond | 1044 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 26845376 | 26845376 | PRJNA1025141_P_NODE_981_length_833_cov_1.635526_g932_i0 | PRJNA1025141 | 981 | 833 | 1.635526 | 13.62393158 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 71.6 | 4.95e-10 | NR | XP_065830579.1 | 121494 | g932 | i0 | 23.2 | 1.56302521008403 | 250 | 180 | 87.9 | 6 | 781 | 50 | 71 | 314 | XP_065830579.1 bactericidal permeability-increasing protein-like [Oscarella lobularis] | diamond | 1302 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28456366 | 28456366 | PRJNA1025141_P_NODE_4586_length_379_cov_1.196078_g4525_i0 | PRJNA1025141 | 4586 | 379 | 1.196078 | 4.53313562 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 63.5 | 3.88e-9 | NR | XP_065831520.1 | 121494 | g4525 | i0 | 40.8 | 2.52506596306069 | 98 | 38 | 77.6 | 3 | 13 | 306 | 115 | 192 | XP_065831520.1 carbonic anhydrase-like [Oscarella lobularis] | diamond | 957 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28740407 | 28740407 | PRJNA1025141_P_NODE_6827_length_305_cov_1.275862_g6766_i0 | PRJNA1025141 | 6827 | 305 | 1.275862 | 3.8913791 | Oscarella pearsei | 1940113 | Porifera | other_Eukaryota | 63.2 | 5.52e-9 | NR | AEO12553.1 | 1940113 | g6766 | i0 | 37.6 | 0.914754098360656 | 93 | 57 | 91.5 | 1 | 299 | 21 | 1824 | 1915 | AEO12553.1 Lefftyrin, partial [Oscarella pearsei] | diamond | 279 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella pearsei | |
| 29276955 | 29276955 | PRJNA1025141_P_NODE_12989_length_241_cov_0.916667_g12928_i0 | PRJNA1025141 | 12989 | 241 | 0.916667 | 2.20916747 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 53.1 | 7.82e-6 | NR | XP_065884234.1 | 196820 | g12928 | i0 | 40 | 0.809128630705394 | 65 | 38 | 79.7 | 1 | 49 | 240 | 24 | 88 | XP_065884234.1 uncharacterized protein [Dysidea avara] | diamond | 195 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29584690 | 29584690 | PRJNA1025141_P_NODE_12190_length_243_cov_1.358824_g12129_i0 | PRJNA1025141 | 12190 | 243 | 1.358824 | 3.30194232 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 75.9 | 4.59e-14 | NR | XP_064402692.1 | 6063 | g12129 | i0 | 50.6 | 8.80246913580247 | 79 | 32 | 97.5 | 1 | 242 | 6 | 183 | 254 | XP_064402692.1 LOW QUALITY PROTEIN: poly [ADP-ribose] polymerase 1-like [Halichondria panicea] | diamond | 2139 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 29877176 | 29877176 | PRJNA1025141_P_NODE_2591_length_509_cov_1.424312_g2530_i0 | PRJNA1025141 | 2591 | 509 | 1.424312 | 7.24974808 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 71.2 | 8.04e-11 | NR | XP_064401905.1 | 6063 | g2530 | i0 | 36.6 | 1.94499017681729 | 164 | 94 | 94.9 | 5 | 1 | 483 | 5403 | 5559 | XP_064401905.1 uncharacterized protein LOC135347788 isoform X2 [Halichondria panicea] | diamond | 990 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30121772 | 30121772 | PRJNA1025141_P_NODE_8052_length_277_cov_1.044118_g7991_i0 | PRJNA1025141 | 8052 | 277 | 1.044118 | 2.89220686 | Metazoa | 33208 | Porifera | other_Eukaryota | 115 | 2.04e-27 | NR | XP_062502019.1 | 121492 | g7991 | i0 | 61.8 | 6.8014440433213 | 89 | 33 | 96.4 | 1 | 272 | 6 | 78 | 165 | XP_062502019.1 carboxypeptidase D-like [Corticium candelabrum] | diamond | 1884 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30161150 | 30161150 | PRJNA1025141_P_NODE_3672_length_425_cov_1.116477_g3611_i0 | PRJNA1025141 | 3672 | 425 | 1.116477 | 4.74502725 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 65.9 | 2.17e-9 | NR | XP_011409906.2 | 400682 | g3611 | i0 | 38.3 | 2.43529411764706 | 81 | 48 | 57.2 | 1 | 404 | 162 | 205 | 283 | XP_011409906.2 PREDICTED: protein phosphatase 1 regulatory subunit 16A-like [Amphimedon queenslandica] | diamond | 1035 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 30351516 | 30351516 | PRJNA1025141_P_NODE_11412_length_246_cov_0.878613_g11351_i0 | PRJNA1025141 | 11412 | 246 | 0.878613 | 2.16138798 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 50.8 | 5.37e-5 | NR | KAI6657372.1 | 111878 | g11351 | i0 | 33.3 | 0.98780487804878 | 81 | 54 | 98.8 | 0 | 244 | 2 | 390 | 470 | KAI6657372.1 Vacuolar protein sorting-associated protein 35 [Oopsacas minuta] | diamond | 243 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 31804943 | 31804943 | PRJNA1025141_P_NODE_3777_length_418_cov_5.255072_g3716_i0 | PRJNA1025141 | 3777 | 418 | 5.255072 | 21.96620096 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 193 | 6.18e-61 | NR | XP_065826293.1 | 121494 | g3716 | i0 | 73.8 | 9.37320574162679 | 130 | 34 | 93.3 | 0 | 404 | 15 | 1 | 130 | XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] | diamond | 3918 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31836430 | 31836430 | PRJNA1025141_P_NODE_12437_length_243_cov_0.905882_g12376_i0 | PRJNA1025141 | 12437 | 243 | 0.905882 | 2.20129326 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 108 | 2.01e-25 | NR | XP_011403565.1 | 400682 | g12376 | i0 | 81 | 0.777777777777778 | 63 | 12 | 77.8 | 0 | 2 | 190 | 450 | 512 | XP_011403565.1 PREDICTED: inositol-3-phosphate synthase 1-A-like [Amphimedon queenslandica] | diamond | 189 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 31892025 | 31892025 | PRJNA1025141_P_NODE_7837_length_281_cov_1.331731_g7776_i0 | PRJNA1025141 | 7837 | 281 | 1.331731 | 3.74216411 | Metazoa | 33208 | Porifera | other_Eukaryota | 101 | 4.25e-25 | NR | XP_064404999.1 | 6063 | g7776 | i0 | 71.6 | 2.14590747330961 | 67 | 19 | 71.5 | 0 | 2 | 202 | 83 | 149 | XP_064404999.1 uncharacterized protein LOC135350198 [Halichondria panicea] | diamond | 603 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 32018593 | 32018593 | PRJNA1025141_P_NODE_7358_length_292_cov_1.237443_g7297_i0 | PRJNA1025141 | 7358 | 292 | 1.237443 | 3.61333356 | Metazoa | 33208 | Porifera | other_Eukaryota | 185 | 2.8699999999999998e-52 | NR | AZI95706.1 | 6063 | g7297 | i0 | 97.9 | 213 | 96 | 2 | 98.6 | 0 | 291 | 4 | 259 | 354 | AZI95706.1 valosin containing protein, partial [Halichondria panicea] | diamond | 62196 | 186 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 32658492 | 32658492 | PRJNA1025141_P_NODE_2580_length_510_cov_1.791762_g2519_i0 | PRJNA1025141 | 2580 | 510 | 1.791762 | 9.1379862 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 45.4 | 0.049 | NR | KAI6649084.1 | 111878 | g2519 | i0 | 26.4 | 0.647058823529412 | 110 | 67 | 64.1 | 3 | 351 | 25 | 119 | 215 | KAI6649084.1 hypothetical protein LOD99_6805 [Oopsacas minuta] | diamond | 330 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 32690187 | 32690187 | PRJNA1025141_P_NODE_7740_length_283_cov_1.319048_g7679_i0 | PRJNA1025141 | 7740 | 283 | 1.319048 | 3.73290584 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 59.7 | 5.33e-8 | NR | KAI6650732.1 | 111878 | g7679 | i0 | 40.6 | 0.731448763250883 | 69 | 41 | 73.1 | 0 | 36 | 242 | 20 | 88 | KAI6650732.1 Cathepsin L [Oopsacas minuta] | diamond | 207 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta |
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);;