contig_metadata
7 rows where bioproject = "PRJNA1068830" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1457085 | 1457085 | PRJNA1068830_P_NODE_2602_length_1532_cov_22.041809_g2338_i0 | PRJNA1068830 | 2602 | 1532 | 22.041809 | 337.68051388 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 551 | 7.4e-191 | NR | AQM52339.1 | 121494 | g2338 | i0 | 58.6 | 25.9680156657963 | 457 | 175 | 89.1 | 5 | 1514 | 150 | 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 | |
| 9110144 | 9110144 | PRJNA1068830_P_NODE_35508_length_377_cov_2.049342_g34805_i0 | PRJNA1068830 | 35508 | 377 | 2.049342 | 7.72601934 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 52.8 | 0.036 | NTclustered | gi|2732921170|ref|XM_065327437.1| | 27933 | g34805 | i0 | 100 | 0.148541114058355 | 28 | 0 | 7 | 0 | 318 | 345 | 38 | 11 | PREDICTED: Sycon ciliatum intraflagellar transport protein 25 homolog (LOC135814331), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 28962359 | 28962359 | PRJNA1068830_P_NODE_57828_length_286_cov_1.464789_g57125_i0 | PRJNA1068830 | 57828 | 286 | 1.464789 | 4.18929654 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 105 | 4.43e-26 | NR | XP_065829973.1 | 121494 | g57125 | i0 | 62.5 | 11.2132867132867 | 72 | 27 | 75.5 | 0 | 1 | 216 | 83 | 154 | XP_065829973.1 ubiquitin-conjugating enzyme E2 H-like isoform X2 [Oscarella lobularis] | diamond | 3207 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31109825 | 31109825 | PRJNA1068830_P_NODE_78855_length_248_cov_2.674286_g78152_i0 | PRJNA1068830 | 78855 | 248 | 2.674286 | 6.63222928 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 86.7 | 1.87e-19 | NR | CAI8007016.1 | 519541 | g78152 | i0 | 52.7 | 1.69354838709677 | 74 | 35 | 89.5 | 0 | 246 | 25 | 65 | 138 | CAI8007016.1 Casein kinase II subunit beta [Geodia barretti] | diamond | 420 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 31932154 | 31932154 | PRJNA1068830_P_NODE_76477_length_250_cov_0.909605_g75774_i0 | PRJNA1068830 | 76477 | 250 | 0.909605 | 2.2740125 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 97.1 | 7.33e-22 | NR | XP_065843521.1 | 121494 | g75774 | i0 | 51.3 | 0.936 | 78 | 31 | 85.2 | 1 | 3 | 215 | 136 | 213 | XP_065843521.1 cathepsin B-like cysteine proteinase 3 [Oscarella lobularis] | diamond | 234 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 32808532 | 32808532 | PRJNA1068830_P_NODE_90080_length_232_cov_3.364780_g89377_i0 | PRJNA1068830 | 90080 | 232 | 3.36478 | 7.8062896 | Metazoa | 33208 | Porifera | other_Eukaryota | 55.8 | 7.6e-7 | NR | XP_065832864.1 | 121494 | g89377 | i0 | 36.2 | 2.68965517241379 | 69 | 43 | 89.2 | 1 | 4 | 210 | 294 | 361 | XP_065832864.1 solute carrier family 35 member F6-like [Oscarella lobularis] | diamond | 624 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 32816953 | 32816953 | PRJNA1068830_P_NODE_53160_length_299_cov_2.061947_g52457_i0 | PRJNA1068830 | 53160 | 299 | 2.061947 | 6.16522153 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 48.1 | 1.44e-4 | NR | KAI6651473.1 | 111878 | g52457 | i0 | 35.5 | 0.762541806020067 | 76 | 44 | 71.2 | 1 | 67 | 279 | 21 | 96 | KAI6651473.1 hypothetical protein LOD99_5081 [Oopsacas minuta] | diamond | 228 | 48.1 | 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);;