contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4499214 | 4499214 | PRJNA690592_S_NODE_168064_length_263_cov_1.305263_g167050_i0 | PRJNA690592 | 168064 | 263 | 1.305263 | 3.43284169 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 128 | 3.88e-25 | NTclustered | gi|2732912578|ref|XM_065323078.1| | 27933 | g167050 | i0 | 86.066 | 37.467680608365 | 122 | 13 | 46 | 4 | 1 | 120 | 1260 | 1379 | PREDICTED: Sycon ciliatum actin CyI, cytoplasmic (LOC135809674), mRNA | blastn | 9854 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 4499517 | 4499517 | PRJNA690592_S_NODE_208464_length_243_cov_1.358824_g207450_i0 | PRJNA690592 | 208464 | 243 | 1.358824 | 3.30194232 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2732926566|ref|XM_065330294.1| | 27933 | g207450 | i0 | 100 | 0.119341563786008 | 29 | 0 | 12 | 0 | 110 | 138 | 2861 | 2889 | PREDICTED: Sycon ciliatum probable serine/threonine-protein kinase DDB_G0268642 (LOC135817168), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 4499934 | 4499934 | PRJNA690592_S_NODE_64884_length_393_cov_1.187500_g63870_i0 | PRJNA690592 | 64884 | 393 | 1.1875 | 4.666875 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 191 | 7.63e-44 | NTclustered | gi|2732895309|ref|XM_065318989.1| | 27933 | g63870 | i0 | 83.415 | 1.27735368956743 | 205 | 34 | 52 | 0 | 26 | 230 | 2929 | 3133 | PREDICTED: Sycon ciliatum dihydropyrimidine dehydrogenase [NADP(+)]-like (LOC135805003), mRNA | blastn | 502 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 5775309 | 5775309 | PRJNA690592_S_NODE_42145_length_473_cov_4.335000_g41131_i0 | PRJNA690592 | 42145 | 473 | 4.335 | 20.50455 | Leucosolenia complicata | 433461 | Porifera | other_Eukaryota | 204 | 1.2e-47 | NTclustered | gi|460417256|emb|HF583285.1| | 433461 | g41131 | i0 | 76.902 | 57.5052854122622 | 368 | 79 | 77 | 6 | 107 | 471 | 1154 | 790 | Leucosolenia complicata mRNA for methionine adenosyltransferase homolog A (MATA gene) | blastn | 27200 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Leucosoleniidae | Leucosolenia | Leucosolenia complicata | |
| 8324739 | 8324739 | PRJNA690592_S_NODE_28287_length_567_cov_2.520243_g27289_i0 | PRJNA690592 | 28287 | 567 | 2.520243 | 14.28977781 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 159 | 3.2e-34 | NTclustered | gi|1133457937|ref|XM_003385437.3| | 400682 | g27289 | i0 | 75.904 | 1.72839506172839 | 332 | 68 | 57 | 10 | 202 | 527 | 360 | 35 | PREDICTED: Amphimedon queenslandica PHD finger-like domain-containing protein 5A (LOC100636995), mRNA | blastn | 980 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 12151130 | 12151130 | PRJNA690592_S_NODE_64150_length_394_cov_4.529595_g63136_i0 | PRJNA690592 | 64150 | 394 | 4.529595 | 17.8466043 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 248 | 4.48e-61 | NTclustered | gi|2732923563|ref|XM_065328709.1| | 27933 | g63136 | i0 | 78.962 | 66.010152284264 | 366 | 75 | 93 | 2 | 1 | 365 | 440 | 76 | PREDICTED: Sycon ciliatum ubiquitin-ribosomal protein eL40 fusion protein-like (LOC135815416), mRNA | blastn | 26008 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 16481954 | 16481954 | PRJNA690592_S_NODE_92153_length_338_cov_2.430189_g91139_i0 | PRJNA690592 | 92153 | 338 | 2.430189 | 8.21403882 | Tetractinellida | 1779164 | Porifera | other_Eukaryota | 132 | 3.98e-26 | NTclustered | gi|512765374|gb|KC869612.1| | 1183873 | g91139 | i0 | 86.777 | 34.3786982248521 | 121 | 13 | 36 | 2 | 131 | 250 | 2026 | 2144 | Stelletta fibrosa voucher P24 28S ribosomal RNA gene, partial sequence | blastn | 11620 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia fibrosa | |
| 19798483 | 19798483 | PRJNA690592_S_NODE_218056_length_234_cov_4.757764_g217042_i0 | PRJNA690592 | 218056 | 234 | 4.757764 | 11.13316776 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 58.4 | 4.5e-4 | NTclustered | gi|2746752524|ref|XM_065980190.1| | 121494 | g217042 | i0 | 97.059 | 0.290598290598291 | 34 | 1 | 15 | 0 | 173 | 206 | 1271 | 1238 | PREDICTED: Oscarella lobularis uncharacterized protein (LOC136191769), transcript variant X2, mRNA | blastn | 68 | 58.4 | 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);;