contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1108009" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 212930 | 212930 | PRJNA1108009_P_NODE_20461_length_284_cov_1.118483_g20143_i0 | PRJNA1108009 | 20461 | 284 | 1.118483 | 3.17649172 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 196 | 1.14e-45 | NTclustered | gi|470381496|ref|XM_004333736.1| | 1257118 | g20143 | i0 | 80 | 39.5492957746479 | 270 | 50 | 94 | 3 | 3 | 270 | 388 | 655 | Acanthamoeba castellanii str. Neff methylmalonatesemialdehyde dehydrogenase (acylating), putative (ACA1_362550), partial mRNA | blastn | 11232 | 196 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6590835 | 6590835 | PRJNA1108009_P_NODE_13506_length_360_cov_2.069686_g13188_i0 | PRJNA1108009 | 13506 | 360 | 2.069686 | 7.4508696 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 189 | 2.4899999999999996e-43 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g13188 | i0 | 84.375 | 53.6194444444444 | 192 | 30 | 53 | 0 | 28 | 219 | 312 | 121 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 19303 | 189 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9140738 | 9140738 | PRJNA1108009_P_NODE_27988_length_246_cov_1.115607_g27670_i0 | PRJNA1108009 | 27988 | 246 | 1.115607 | 2.74439322 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 233 | 7.39e-57 | NTclustered | gi|470439766|ref|XM_004339180.1| | 1257118 | g27670 | i0 | 84.082 | 7.72764227642276 | 245 | 36 | 99 | 3 | 1 | 243 | 1167 | 924 | Acanthamoeba castellanii str. Neff Inositol3-phosphate synthase (ACA1_058810), partial mRNA | blastn | 1901 | 233 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9948697 | 9948697 | PRJNA1108009_P_NODE_5448_length_597_cov_3.463740_g5137_i0 | PRJNA1108009 | 5448 | 597 | 3.46374 | 20.6785278 | Vannellidae | 95227 | Discosea | other_Eukaryota | 979 | 0 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g5137 | i0 | 96.321 | 100.904522613065 | 598 | 19 | 100 | 3 | 1 | 597 | 1092 | 1687 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 60240 | 981 | 0.99796126401631 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 10416408 | 10416408 | PRJNA1108009_P_NODE_2209_length_915_cov_2.358670_g1962_i0 | PRJNA1108009 | 2209 | 915 | 2.35867 | 21.5818305 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 545 | 3.48e-150 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g1962 | i0 | 79.09 | 80.8142076502732 | 813 | 155 | 88 | 11 | 2 | 808 | 1717 | 2520 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 73945 | 545 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10416703 | 10416703 | PRJNA1108009_P_NODE_5329_length_604_cov_5.551789_g5019_i0 | PRJNA1108009 | 5329 | 604 | 5.551789 | 33.53280556 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 891 | 0 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g5019 | i0 | 95.382 | 91.135761589404 | 563 | 20 | 93 | 5 | 44 | 604 | 3 | 561 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 55046 | 891 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 16323081 | 16323081 | PRJNA1108009_P_NODE_7833_length_491_cov_5.827751_g7516_i0 | PRJNA1108009 | 7833 | 491 | 5.827751 | 28.61425741 | Ripella | 1217112 | Discosea | other_Eukaryota | 721 | 0 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g7516 | i0 | 93.306 | 100.757637474542 | 493 | 25 | 99 | 6 | 2 | 491 | 1073 | 586 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 49472 | 721 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 19339129 | 19339129 | PRJNA1108009_P_NODE_5436_length_598_cov_1.982857_g5125_i0 | PRJNA1108009 | 5436 | 598 | 1.982857 | 11.85748486 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 503 | 1.36e-137 | NTclustered | gi|470447963|ref|XM_004340066.1| | 1257118 | g5125 | i0 | 83.456 | 66.561872909699 | 544 | 86 | 91 | 4 | 1 | 542 | 1057 | 1598 | Acanthamoeba castellanii str. Neff ATP synthase, putative (ACA1_367940), partial mRNA | blastn | 39804 | 503 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;