contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1204310" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2320354 | 2320354 | PRJNA1204310_P_NODE_36682_length_308_cov_0.995745_g36385_i0 | PRJNA1204310 | 36682 | 308 | 0.995745 | 3.0668946 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 564 | 2.99e-156 | NTclustered | gi|399764264|gb|JQ271775.1| | 1215986 | g36385 | i0 | 99.675 | 49.2402597402597 | 308 | 1 | 100 | 0 | 1 | 308 | 575 | 268 | Tubulinea group 02 sp. 1HFKJ 18S ribosomal RNA gene, partial sequence | blastn | 15166 | 569 | 0.991212653778559 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 02 sp. 1HFKJ | ||||||
| 4156355 | 4156355 | PRJNA1204310_P_NODE_43324_length_281_cov_4.538462_g43027_i0 | PRJNA1204310 | 43324 | 281 | 4.538462 | 12.75307822 | Glaeseria mira | 242547 | Tubulinea | other_Eukaryota | 335 | 2.3e-87 | NTclustered | gi|33946352|gb|AY294155.1| | 242547 | g43027 | i0 | 88.489 | 91.1138790035587 | 278 | 31 | 99 | 1 | 1 | 277 | 296 | 19 | Glaeseria mira actin mRNA, partial cds | blastn | 25603 | 335 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Glaeseria | Glaeseria mira | ||
| 5431756 | 5431756 | PRJNA1204310_P_NODE_1005_length_1408_cov_3.402996_g886_i0 | PRJNA1204310 | 1005 | 1408 | 3.402996 | 47.91418368 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 1557 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g886 | i0 | 87.15 | 27.1732954545455 | 1393 | 153 | 97 | 16 | 14 | 1384 | 1 | 1389 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 38260 | 1557 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 5432241 | 5432241 | PRJNA1204310_P_NODE_29085_length_344_cov_2.140221_g28788_i0 | PRJNA1204310 | 29085 | 344 | 2.140221 | 7.36236024 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 636 | 7.059999999999998e-178 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g28788 | i0 | 100 | 83.1482558139535 | 344 | 0 | 100 | 0 | 1 | 344 | 1083 | 740 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 28603 | 636 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 6707350 | 6707350 | PRJNA1204310_P_NODE_51246_length_253_cov_0.866667_g50949_i0 | PRJNA1204310 | 51246 | 253 | 0.866667 | 2.19266751 | Copromyxa sp. PKD 2011 | 1215977 | Tubulinea | other_Eukaryota | 468 | 1.92e-127 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g50949 | i0 | 100 | 26.6837944664032 | 253 | 0 | 100 | 0 | 1 | 253 | 1655 | 1403 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 6751 | 468 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 9256823 | 9256823 | PRJNA1204310_P_NODE_21628_length_391_cov_1.116352_g21331_i0 | PRJNA1204310 | 21628 | 391 | 1.116352 | 4.36493632 | Copromyxa laresi | 1789826 | Tubulinea | other_Eukaryota | 640 | 6.27e-179 | NTclustered | gi|1042160931|dbj|LC102272.1| | 1789826 | g21331 | i0 | 96.164 | 99.3222506393862 | 391 | 15 | 100 | 0 | 1 | 391 | 57 | 447 | Copromyxa sp. MK-2016 gene for actin, partial cds, strain: ZEB1_cl1 | blastn | 38835 | 640 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa laresi | ||
| 12523606 | 12523606 | PRJNA1204310_P_NODE_14070_length_472_cov_6.263158_g13773_i0 | PRJNA1204310 | 14070 | 472 | 6.263158 | 29.56210576 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 872 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g13773 | i0 | 100 | 95.2733050847458 | 472 | 0 | 100 | 0 | 1 | 472 | 1652 | 1181 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 44969 | 872 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 18180207 | 18180207 | PRJNA1204310_P_NODE_11855_length_511_cov_1.958904_g11558_i0 | PRJNA1204310 | 11855 | 511 | 1.958904 | 10.00999944 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 364 | 5.6599999999999985e-96 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g11558 | i0 | 80.04 | 1.09784735812133 | 496 | 95 | 97 | 4 | 1 | 494 | 494 | 1 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 561 | 364 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea |
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);;