contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1182301" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1041932 | 1041932 | PRJNA1182301_P_NODE_9561_length_351_cov_1.892086_g9436_i0 | PRJNA1182301 | 9561 | 351 | 1.892086 | 6.64122186 | Didymium | 5792 | Evosea | other_Eukaryota | 627 | 4.329999999999999e-175 | NTclustered | gi|117165666|dbj|AB259388.1| | 289975 | g9436 | i0 | 98.86 | 100.783475783476 | 351 | 4 | 100 | 0 | 1 | 351 | 426 | 76 | Didymium bahiense gene for small subunit ribosomal RNA, partial sequence, specimen_voucher: TNS-M-Y-4948 (TNS) | blastn | 35375 | 627 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium bahiense | ||
| 4869619 | 4869619 | PRJNA1182301_P_NODE_32664_length_271_cov_2.722222_g32539_i0 | PRJNA1182301 | 32664 | 271 | 2.722222 | 7.37722162 | Didymium | 5792 | Evosea | other_Eukaryota | 494 | 3.44e-135 | NTclustered | gi|126508458|gb|EF118757.1| | 428393 | g32539 | i0 | 99.63 | 92.3542435424354 | 270 | 1 | 99 | 0 | 1 | 270 | 481 | 212 | Didymium sp. strain ECH14/I small subunit ribosomal RNA gene, partial sequence | blastn | 25028 | 494 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium sp. ECH14/I | ||
| 10521622 | 10521622 | PRJNA1182301_P_NODE_1149_length_727_cov_2.441896_g1033_i0 | PRJNA1182301 | 1149 | 727 | 2.441896 | 17.75258392 | Amoebozoa sp. | 1892891 | Root_unresolved | Root_unresolved | 1271 | 0 | NTclustered | gi|2651357789|gb|PP174304.1| | 1892891 | g1033 | i0 | 98.212 | 8.85144429160935 | 727 | 13 | 100 | 0 | 1 | 727 | 4164 | 3438 | Amoebozoa sp. isolate 114_WLI small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 6435 | 1271 | 1 | Eukaryota | Amoebozoa | Amoebozoa sp. | |||||||
| 15069331 | 15069331 | PRJNA1182301_P_NODE_38772_length_263_cov_2.431579_g38647_i0 | PRJNA1182301 | 38772 | 263 | 2.431579 | 6.39505277 | Entamoeba | 5758 | Evosea | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|67466604|ref|XM_644358.1| | 294381 | g38647 | i0 | 100 | 0.212927756653992 | 28 | 0 | 11 | 0 | 101 | 128 | 1917 | 1890 | Entamoeba histolytica HM-1:IMSS long-chain-fatty-acid--CoA ligase, putative (EHI_188590), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 15620881 | 15620881 | PRJNA1182301_P_NODE_16813_length_298_cov_2.053333_g16688_i0 | PRJNA1182301 | 16813 | 298 | 2.053333 | 6.11893234 | Didymium sp. CCIKV | 1215981 | Evosea | other_Eukaryota | 529 | 1.0499999999999996e-145 | NTclustered | gi|399764169|gb|JQ271680.1| | 1215981 | g16688 | i0 | 98.658 | 98.4496644295302 | 298 | 4 | 100 | 0 | 1 | 298 | 1116 | 819 | Didymium sp. CCIKV 18S ribosomal RNA gene, partial sequence | blastn | 29338 | 529 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium sp. CCIKV | ||
| 16896506 | 16896506 | PRJNA1182301_P_NODE_7014_length_387_cov_2.452229_g6889_i0 | PRJNA1182301 | 7014 | 387 | 2.452229 | 9.49012623 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 514 | 3.92e-141 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g6889 | i0 | 90.561 | 9.91214470284238 | 392 | 31 | 100 | 6 | 1 | 387 | 5056 | 5446 | D.iridis LSU rRNA gene | blastn | 3836 | 514 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 19444119 | 19444119 | PRJNA1182301_P_NODE_16616_length_300_cov_1.356828_g16491_i0 | PRJNA1182301 | 16616 | 300 | 1.356828 | 4.070484 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 401 | 2.4099999999999992e-107 | NTclustered | gi|116010574|emb|AM407419.1| | 5793 | g16491 | i0 | 90.85 | 45.9 | 306 | 18 | 100 | 10 | 1 | 300 | 814 | 1115 | Didymium iridis partial 26S rRNA gene, isolate Pan3-3 | blastn | 13770 | 401 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis |
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);;