contig_metadata
14 rows where bioproject = "PRJNA833575" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4652873 | 4652873 | PRJNA833575_P_NODE_39064_length_234_cov_1.309091_g38927_i0 | PRJNA833575 | 39064 | 234 | 1.309091 | 3.06327294 | Aplysina fulva | 289401 | Porifera | other_Eukaryota | 176 | 1.19e-39 | NTclustered | gi|258690453|gb|GQ330987.1| | 289401 | g38927 | i0 | 87.919 | 71.0726495726496 | 149 | 18 | 64 | 0 | 9 | 157 | 371 | 223 | Aplysina fulva ATP synthase beta subunit (ATPB) mRNA, partial cds | blastn | 16631 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Verongiida | Aplysinidae | Aplysina | Aplysina fulva | |
| 25455379 | 25455379 | PRJNA833575_P_NODE_19480_length_334_cov_1.464151_g19343_i0 | PRJNA833575 | 19480 | 334 | 1.464151 | 4.89026434 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 187 | 8.12e-59 | NR | XP_065899758.1 | 196820 | g19343 | i0 | 85.4 | 29.6047904191617 | 103 | 15 | 92.5 | 0 | 1 | 309 | 28 | 130 | XP_065899758.1 small ribosomal subunit protein uS8 [Dysidea avara] | diamond | 9888 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 28033909 | 28033909 | PRJNA833575_P_NODE_37905_length_236_cov_1.293413_g37768_i0 | PRJNA833575 | 37905 | 236 | 1.293413 | 3.05245468 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 47 | 9.29e-4 | NR | XP_065839451.1 | 121494 | g37768 | i0 | 31.8 | 0.838983050847458 | 66 | 42 | 83.9 | 2 | 3 | 200 | 122 | 184 | XP_065839451.1 uncharacterized protein [Oscarella lobularis] | diamond | 198 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 29052774 | 29052774 | PRJNA833575_P_NODE_9468_length_465_cov_1.553030_g9331_i0 | PRJNA833575 | 9468 | 465 | 1.55303 | 7.2215895 | Metazoa | 33208 | Porifera | other_Eukaryota | 225 | 9.280000000000001e-66 | NR | XP_065194361.1 | 27933 | g9331 | i0 | 71.8 | 5.03870967741936 | 156 | 38 | 99.4 | 2 | 3 | 464 | 424 | 575 | XP_065194361.1 major vault protein-like [Sycon ciliatum] | diamond | 2343 | 226 | 0.995575221238938 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29328214 | 29328214 | PRJNA833575_P_NODE_7969_length_505_cov_1.167431_g7832_i0 | PRJNA833575 | 7969 | 505 | 1.167431 | 5.89552655 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 219 | 1.25e-66 | NR | XP_065833345.1 | 121494 | g7832 | i0 | 64.2 | 1.91881188118812 | 162 | 58 | 96.2 | 0 | 3 | 488 | 272 | 433 | XP_065833345.1 uncharacterized protein [Oscarella lobularis] | diamond | 969 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 29422785 | 29422785 | PRJNA833575_P_NODE_44829_length_228_cov_0.905660_g44692_i0 | PRJNA833575 | 44829 | 228 | 0.90566 | 2.0649048 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 47.4 | 6.93e-4 | NR | CAI8033083.1 | 519541 | g44692 | i0 | 32.2 | 1.55263157894737 | 59 | 40 | 77.6 | 0 | 221 | 45 | 47 | 105 | CAI8033083.1 TNF receptor-associated factor 3 [Geodia barretti] | diamond | 354 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 30023224 | 30023224 | PRJNA833575_P_NODE_43051_length_230_cov_0.894410_g42914_i0 | PRJNA833575 | 43051 | 230 | 0.89441 | 2.057143 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 45.1 | 0.00472 | NR | CAI8033083.1 | 519541 | g42914 | i0 | 53.1 | 0.417391304347826 | 32 | 15 | 41.7 | 0 | 193 | 98 | 74 | 105 | CAI8033083.1 TNF receptor-associated factor 3 [Geodia barretti] | diamond | 96 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 30347997 | 30347997 | PRJNA833575_P_NODE_7292_length_527_cov_1.100437_g7155_i0 | PRJNA833575 | 7292 | 527 | 1.100437 | 5.79930299 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 72.4 | 2.8e-11 | NR | CAI7994046.1 | 519541 | g7155 | i0 | 34.7 | 2.33396584440228 | 124 | 52 | 55.2 | 3 | 525 | 235 | 275 | 396 | CAI7994046.1 Leishmanolysin-like peptidase [Geodia barretti] | diamond | 1230 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 30821439 | 30821439 | PRJNA833575_P_NODE_25134_length_297_cov_1.078947_g24997_i0 | PRJNA833575 | 25134 | 297 | 1.078947 | 3.20447259 | Metazoa | 33208 | Porifera | other_Eukaryota | 132 | 2.74e-34 | NR | XP_064403113.1 | 6063 | g24997 | i0 | 61 | 26.1919191919192 | 105 | 35 | 100 | 2 | 297 | 1 | 78 | 182 | XP_064403113.1 uncharacterized protein LOC135348743 [Halichondria panicea] | diamond | 7779 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31160064 | 31160064 | PRJNA833575_P_NODE_40635_length_233_cov_0.878049_g40498_i0 | PRJNA833575 | 40635 | 233 | 0.878049 | 2.04585417 | Suberites domuncula | 55567 | Porifera | other_Eukaryota | 128 | 3.1e-34 | NR | Q4KTI3.1 | 55567 | g40498 | i0 | 79.2 | 3.93991416309013 | 77 | 16 | 99.1 | 0 | 233 | 3 | 4 | 80 | Q4KTI3.1 RecName: Full=Large ribosomal subunit protein uL18; AltName: Full=60S ribosomal protein L5 [Suberites domuncula] | diamond | 918 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 31191715 | 31191715 | PRJNA833575_P_NODE_40715_length_232_cov_1.564417_g40578_i0 | PRJNA833575 | 40715 | 232 | 1.564417 | 3.62944744 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 97.4 | 1.81e-21 | NR | KAI6647359.1 | 111878 | g40578 | i0 | 57.9 | 0.982758620689655 | 76 | 32 | 98.3 | 0 | 228 | 1 | 103 | 178 | KAI6647359.1 Fimbrin [Oopsacas minuta] | diamond | 228 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 31255263 | 31255263 | PRJNA833575_P_NODE_34575_length_251_cov_1.192308_g34438_i0 | PRJNA833575 | 34575 | 251 | 1.192308 | 2.99269308 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 45.1 | 0.00645 | NR | XP_064401596.1 | 6063 | g34438 | i0 | 39.7 | 0.812749003984064 | 68 | 39 | 78.9 | 1 | 212 | 15 | 153 | 220 | XP_064401596.1 uncharacterized protein LOC135347509 [Halichondria panicea] | diamond | 204 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 32267747 | 32267747 | PRJNA833575_P_NODE_39718_length_234_cov_0.872727_g39581_i0 | PRJNA833575 | 39718 | 234 | 0.872727 | 2.04218118 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 114 | 9.2e-28 | NR | XP_064399911.1 | 6063 | g39581 | i0 | 67.5 | 3.94871794871795 | 77 | 22 | 98.7 | 2 | 3 | 233 | 239 | 312 | XP_064399911.1 rab GDP dissociation inhibitor beta-like [Halichondria panicea] | diamond | 924 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 32835710 | 32835710 | PRJNA833575_P_NODE_40480_length_233_cov_0.878049_g40343_i0 | PRJNA833575 | 40480 | 233 | 0.878049 | 2.04585417 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 51.6 | 2.23e-5 | NR | XP_065839224.1 | 121494 | g40343 | i0 | 36.1 | 0.927038626609442 | 72 | 46 | 92.7 | 0 | 226 | 11 | 159 | 230 | XP_065839224.1 hsp70-binding protein 1-like [Oscarella lobularis] | diamond | 216 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis |
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);;