contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24854457 | 24854457 | PRJNA662254_P_NODE_1280_length_1545_cov_2.959918_g1015_i0 | PRJNA662254 | 1280 | 1545 | 2.959918 | 45.7307331 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 551 | 8.89e-191 | NR | AQM52339.1 | 121494 | g1015 | i0 | 58.6 | 25.7495145631068 | 457 | 175 | 88.3 | 5 | 16 | 1380 | 1 | 445 | AQM52339.1 elongation factor 1 alpha, partial [Oscarella lobularis] | diamond | 39783 | 556 | 0.991007194244604 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 24854500 | 24854500 | PRJNA662254_P_NODE_26620_length_320_cov_2.493927_g25969_i0 | PRJNA662254 | 26620 | 320 | 2.493927 | 7.9805664 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 135 | 5.79e-37 | NR | XP_003382782.1 | 400682 | g25969 | i0 | 74.4 | 3.9 | 82 | 21 | 76.9 | 0 | 247 | 2 | 38 | 119 | XP_003382782.1 PREDICTED: 40S ribosomal protein S2 [Amphimedon queenslandica] | diamond | 1248 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 26701433 | 26701433 | PRJNA662254_P_NODE_58801_length_244_cov_0.900585_g58150_i0 | PRJNA662254 | 58801 | 244 | 0.900585 | 2.1974274 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 44.3 | 0.0111 | NR | XP_062520303.1 | 121492 | g58150 | i0 | 35.1 | 0.94672131147541 | 77 | 50 | 94.7 | 0 | 1 | 231 | 137 | 213 | XP_062520303.1 glutamic acid-rich protein-like [Corticium candelabrum] | diamond | 231 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27302807 | 27302807 | PRJNA662254_P_NODE_18043_length_385_cov_2.233974_g17392_i0 | PRJNA662254 | 18043 | 385 | 2.233974 | 8.6007999 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 178 | 9.139999999999997e-55 | NR | XP_062512596.1 | 121492 | g17392 | i0 | 69.8 | 2.93766233766234 | 126 | 36 | 96.6 | 1 | 14 | 385 | 1 | 126 | XP_062512596.1 large ribosomal subunit protein uL15-like [Corticium candelabrum] | diamond | 1131 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27504598 | 27504598 | PRJNA662254_P_NODE_27583_length_315_cov_1.706612_g26932_i0 | PRJNA662254 | 27583 | 315 | 1.706612 | 5.3758278 | Metazoa | 33208 | Porifera | other_Eukaryota | 114 | 3.0899999999999998e-28 | NR | AAX48841.1 | 55567 | g26932 | i0 | 55.3 | 15.7333333333333 | 103 | 46 | 98.1 | 0 | 5 | 313 | 160 | 262 | AAX48841.1 L10e/P0 [Suberites domuncula] | diamond | 4956 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 27587059 | 27587059 | PRJNA662254_P_NODE_49884_length_249_cov_0.875000_g49233_i0 | PRJNA662254 | 49884 | 249 | 0.875 | 2.17875 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 55.1 | 1.81e-6 | NR | XP_064383853.1 | 6063 | g49233 | i0 | 39.7 | 0.939759036144578 | 78 | 37 | 92.8 | 3 | 18 | 248 | 757 | 825 | XP_064383853.1 uncharacterized protein LOC135332876 [Halichondria panicea] | diamond | 234 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27808206 | 27808206 | PRJNA662254_P_NODE_59004_length_244_cov_0.900585_g58353_i0 | PRJNA662254 | 59004 | 244 | 0.900585 | 2.1974274 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 43.5 | 0.0104 | NR | KAI6649838.1 | 111878 | g58353 | i0 | 77.8 | 0.331967213114754 | 27 | 6 | 33.2 | 0 | 50 | 130 | 128 | 154 | KAI6649838.1 hypothetical protein LOD99_6388 [Oopsacas minuta] | diamond | 81 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 28376189 | 28376189 | PRJNA662254_P_NODE_28066_length_313_cov_0.812500_g27415_i0 | PRJNA662254 | 28066 | 313 | 0.8125 | 2.543125 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 53.5 | 1.36e-5 | NR | XP_065835375.1 | 121494 | g27415 | i0 | 43.8 | 1.22683706070288 | 64 | 35 | 60.4 | 1 | 295 | 107 | 122 | 185 | XP_065835375.1 uncharacterized protein [Oscarella lobularis] | diamond | 384 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28502631 | 28502631 | PRJNA662254_P_NODE_64407_length_241_cov_0.916667_g63756_i0 | PRJNA662254 | 64407 | 241 | 0.916667 | 2.20916747 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 81.6 | 7.56e-16 | NR | XP_065842553.1 | 121494 | g63756 | i0 | 50 | 3.72199170124481 | 76 | 36 | 93.4 | 2 | 240 | 16 | 125 | 199 | XP_065842553.1 protocadherin Fat 4-like [Oscarella lobularis] | diamond | 897 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 28881394 | 28881394 | PRJNA662254_P_NODE_47488_length_250_cov_0.870056_g46837_i0 | PRJNA662254 | 47488 | 250 | 0.870056 | 2.17514 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 43.9 | 0.0153 | NR | XP_065197383.1 | 27933 | g46837 | i0 | 71.4 | 0.336 | 28 | 8 | 33.6 | 0 | 245 | 162 | 266 | 293 | XP_065197383.1 tubulin-specific chaperone E-like [Sycon ciliatum] | diamond | 84 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 28912771 | 28912771 | PRJNA662254_P_NODE_21848_length_352_cov_0.985663_g21197_i0 | PRJNA662254 | 21848 | 352 | 0.985663 | 3.46953376 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 102 | 2.17e-22 | NR | XP_065891500.1 | 196820 | g21197 | i0 | 81.8 | 2.8125 | 66 | 12 | 56.3 | 0 | 1 | 198 | 605 | 670 | XP_065891500.1 major vault protein-like isoform X2 [Dysidea avara] | diamond | 990 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29051719 | 29051719 | PRJNA662254_P_NODE_32648_length_291_cov_1.256881_g31997_i0 | PRJNA662254 | 32648 | 291 | 1.256881 | 3.65752371 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 118 | 2.1e-28 | NR | XP_062514796.1 | 121492 | g31997 | i0 | 57.3 | 3.94845360824742 | 96 | 41 | 99 | 0 | 3 | 290 | 369 | 464 | XP_062514796.1 clathrin heavy chain 1-like [Corticium candelabrum] | diamond | 1149 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 29323369 | 29323369 | PRJNA662254_P_NODE_18069_length_385_cov_1.535256_g17418_i0 | PRJNA662254 | 18069 | 385 | 1.535256 | 5.9107356 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 168 | 1.68e-45 | NR | KAI6646902.1 | 111878 | g17418 | i0 | 62.6 | 1.02077922077922 | 131 | 46 | 99.7 | 1 | 385 | 2 | 403 | 533 | KAI6646902.1 Major vault protein [Oopsacas minuta] | diamond | 393 | 168 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 29461651 | 29461651 | PRJNA662254_P_NODE_22350_length_348_cov_1.120000_g21699_i0 | PRJNA662254 | 22350 | 348 | 1.12 | 3.8976 | Metazoa | 33208 | Porifera | other_Eukaryota | 139 | 1.0299999999999999e-38 | NR | CAI8032315.1 | 519541 | g21699 | i0 | 75.8 | 11.7672413793103 | 91 | 22 | 78.4 | 0 | 275 | 3 | 2 | 92 | CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] | diamond | 4095 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29607284 | 29607284 | PRJNA662254_P_NODE_48110_length_250_cov_0.870056_g47459_i0 | PRJNA662254 | 48110 | 250 | 0.870056 | 2.17514 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 45.4 | 0.00445 | NR | KAI6646662.1 | 111878 | g47459 | i0 | 61.8 | 0.408 | 34 | 12 | 39.6 | 1 | 44 | 142 | 112 | 145 | KAI6646662.1 Aminomethyltransferase, mitochondrial [Oopsacas minuta] | diamond | 102 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 30461012 | 30461012 | PRJNA662254_P_NODE_55233_length_246_cov_0.890173_g54582_i0 | PRJNA662254 | 55233 | 246 | 0.890173 | 2.18982558 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 60.1 | 3.01e-8 | NR | XP_062516270.1 | 121492 | g54582 | i0 | 60 | 0.48780487804878 | 40 | 16 | 48.8 | 0 | 140 | 21 | 170 | 209 | XP_062516270.1 DNA annealing helicase and endonuclease ZRANB3-like isoform X1 [Corticium candelabrum] | diamond | 120 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 30978433 | 30978433 | PRJNA662254_P_NODE_66754_length_226_cov_2.013072_g66103_i0 | PRJNA662254 | 66754 | 226 | 2.013072 | 4.54954272 | root | 1 | Root_unresolved | Root_unresolved | 103 | 1.3299999999999999e-24 | NR | XP_019852469.1 | 400682 | g66103 | i0 | 59.7 | 2.86725663716814 | 72 | 29 | 95.6 | 0 | 226 | 11 | 86 | 157 | XP_019852469.1 PREDICTED: spermidine synthase-like [Amphimedon queenslandica] | diamond | 648 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 31104511 | 31104511 | PRJNA662254_P_NODE_29295_length_306_cov_1.982833_g28644_i0 | PRJNA662254 | 29295 | 306 | 1.982833 | 6.06746898 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 75.9 | 2.06e-14 | NR | XP_065187238.1 | 27933 | g28644 | i0 | 73.1 | 3.51960784313725 | 52 | 14 | 51 | 0 | 150 | 305 | 50 | 101 | XP_065187238.1 nascent polypeptide-associated complex subunit alpha-like [Sycon ciliatum] | diamond | 1077 | 76.6 | 0.990861618798956 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31693262 | 31693262 | PRJNA662254_P_NODE_18317_length_383_cov_0.980645_g17666_i0 | PRJNA662254 | 18317 | 383 | 0.980645 | 3.75587035 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 67.4 | 3.24e-10 | NR | XP_065830202.1 | 121494 | g17666 | i0 | 46.8 | 0.736292428198433 | 94 | 40 | 72.8 | 5 | 2 | 280 | 254 | 338 | XP_065830202.1 uncharacterized protein [Oscarella lobularis] | diamond | 282 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 32199608 | 32199608 | PRJNA662254_P_NODE_61698_length_243_cov_0.905882_g61047_i0 | PRJNA662254 | 61698 | 243 | 0.905882 | 2.20129326 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 51.2 | 3.75e-5 | NR | XP_019855035.1 | 400682 | g61047 | i0 | 37.5 | 0.987654320987654 | 80 | 42 | 98.8 | 3 | 3 | 242 | 491 | 562 | XP_019855035.1 PREDICTED: leishmanolysin-like peptidase [Amphimedon queenslandica] | diamond | 240 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 32579305 | 32579305 | PRJNA662254_P_NODE_11719_length_482_cov_1.112469_g11068_i0 | PRJNA662254 | 11719 | 482 | 1.112469 | 5.36210058 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 53.5 | 7.44e-5 | NR | XP_065897542.1 | 196820 | g11068 | i0 | 38.8 | 0.753112033195021 | 80 | 41 | 44.8 | 3 | 478 | 263 | 553 | 632 | XP_065897542.1 integrin beta-1-like [Dysidea avara] | diamond | 363 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32653930 | 32653930 | PRJNA662254_P_NODE_63100_length_242_cov_0.911243_g62449_i0 | PRJNA662254 | 63100 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 111 | 2.5e-27 | NR | XP_062510655.1 | 121492 | g62449 | i0 | 62 | 18.6074380165289 | 79 | 30 | 97.9 | 0 | 237 | 1 | 22 | 100 | XP_062510655.1 aldo-keto reductase family 1 member A1-like [Corticium candelabrum] | diamond | 4503 | 111 | 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);;