contig_metadata
8 rows where bioproject = "PRJNA1002816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12906491 | 12906491 | PRJNA1002816_P_NODE_12171_length_317_cov_1.893443_g12011_i0 | PRJNA1002816 | 12171 | 317 | 1.893443 | 6.00221431 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 154 | 1.18e-45 | NR | XP_064384635.1 | 6063 | g12011 | i0 | 76.2 | 0.993690851735016 | 105 | 25 | 99.4 | 0 | 316 | 2 | 44 | 148 | XP_064384635.1 large ribosomal subunit protein uL11-like [Halichondria panicea] | diamond | 315 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 23953262 | 23953262 | PRJNA1002816_P_NODE_16999_length_256_cov_1.683060_g16839_i0 | PRJNA1002816 | 16999 | 256 | 1.68306 | 4.3086336 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2746788537|ref|XM_065978325.1| | 121494 | g16839 | i0 | 96.774 | 1.10546875 | 31 | 1 | 12 | 0 | 147 | 177 | 1539 | 1509 | PREDICTED: Oscarella lobularis uncharacterized protein (LOC136190225), mRNA | blastn | 283 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 26837273 | 26837273 | PRJNA1002816_P_NODE_12301_length_315_cov_2.227273_g12141_i0 | PRJNA1002816 | 12301 | 315 | 2.227273 | 7.01590995 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 132 | 1.03e-35 | NR | XP_065186579.1 | 27933 | g12141 | i0 | 63.7 | 27.3428571428571 | 102 | 35 | 95.2 | 1 | 300 | 1 | 1 | 102 | XP_065186579.1 small ribosomal subunit protein eS1-like [Sycon ciliatum] | diamond | 8613 | 133 | 0.992481203007519 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27097598 | 27097598 | PRJNA1002816_P_NODE_16582_length_261_cov_1.638298_g16422_i0 | PRJNA1002816 | 16582 | 261 | 1.638298 | 4.27595778 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 76.3 | 6.53e-14 | NR | XP_062510894.1 | 121492 | g16422 | i0 | 45.5 | 2.02298850574713 | 88 | 42 | 94.3 | 1 | 259 | 14 | 74 | 161 | XP_062510894.1 histone-binding protein RBBP7-like [Corticium candelabrum] | diamond | 528 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27121510 | 27121510 | PRJNA1002816_P_NODE_18422_length_248_cov_1.308571_g18262_i0 | PRJNA1002816 | 18422 | 248 | 1.308571 | 3.24525608 | Metazoa | 33208 | Porifera | other_Eukaryota | 51.2 | 4.1e-5 | NR | QIA61838.1 | 6063 | g18262 | i0 | 57.5 | 3.16935483870968 | 40 | 17 | 48.4 | 0 | 124 | 5 | 260 | 299 | QIA61838.1 ATP-binding cassette sub-family B member 6 [Halichondria panicea] | diamond | 786 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27729811 | 27729811 | PRJNA1002816_P_NODE_18184_length_249_cov_0.875000_g18024_i0 | PRJNA1002816 | 18184 | 249 | 0.875 | 2.17875 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 94 | 2.02e-20 | NR | XP_003387983.1 | 400682 | g18024 | i0 | 52.4 | 2.96385542168675 | 82 | 39 | 98.8 | 0 | 2 | 247 | 139 | 220 | XP_003387983.1 PREDICTED: dnaJ homolog subfamily A member 1-like [Amphimedon queenslandica] | diamond | 738 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 31234948 | 31234948 | PRJNA1002816_P_NODE_10795_length_339_cov_1.248120_g10635_i0 | PRJNA1002816 | 10795 | 339 | 1.24812 | 4.2311268 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 70.9 | 5.59e-12 | NR | XP_065842422.1 | 121494 | g10635 | i0 | 50 | 2.0353982300885 | 70 | 35 | 61.9 | 0 | 14 | 223 | 128 | 197 | XP_065842422.1 COP9 signalosome complex subunit 7b-like isoform X2 [Oscarella lobularis] | diamond | 690 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31930894 | 31930894 | PRJNA1002816_P_NODE_17797_length_250_cov_0.870056_g17637_i0 | PRJNA1002816 | 17797 | 250 | 0.870056 | 2.17514 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 81.3 | 3.81e-17 | NR | KAI6660932.1 | 111878 | g17637 | i0 | 64.1 | 1.464 | 64 | 21 | 76.8 | 1 | 248 | 57 | 30 | 91 | KAI6660932.1 60S ribosomal protein L17-like isoform 1 [Oopsacas minuta] | diamond | 366 | 81.3 | 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);;