contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax_clade = "Apusozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3398013 | 3398013 | PRJNA864829_S_NODE_3003_length_317_cov_1.309701_g2917_i0 | PRJNA864829 | 3003 | 317 | 1.309701 | 4.15175217 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 351 | 2.61e-92 | NTclustered | gi|761380055|ref|NC_026452.1| | 529818 | g2917 | i0 | 88.737 | 59.9747634069401 | 293 | 25 | 91 | 5 | 21 | 310 | 923 | 636 | Thecamonas trahens strain ATCC 50062 mitochondrion, complete genome | blastn | 19012 | 351 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12326422 | 12326422 | PRJNA864829_S_NODE_1910_length_372_cov_1.928793_g1824_i0 | PRJNA864829 | 1910 | 372 | 1.928793 | 7.17510996 | Karpovia croatica | 2925417 | Root_unresolved | Root_unresolved | 130 | 1.59e-25 | NTclustered | gi|2206682173|gb|OM966646.1| | 2925417 | g1824 | i0 | 84.615 | 26.744623655914 | 130 | 20 | 35 | 0 | 190 | 319 | 5868 | 5739 | Karpovia croatica strain CRO19P6 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 | 9949 | 130 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Karpovia | Karpovia croatica | ||||
| 12326431 | 12326431 | PRJNA864829_S_NODE_3770_length_292_cov_1.572016_g3684_i0 | PRJNA864829 | 3770 | 292 | 1.572016 | 4.59028672 | uncultured Apusomonadidae | 1675541 | Root_unresolved | Root_unresolved | 292 | 1.46e-74 | NTclustered | gi|1110843318|gb|KY077731.1| | 1675541 | g3684 | i0 | 87.259 | 62.3253424657534 | 259 | 30 | 88 | 3 | 1 | 256 | 864 | 606 | Uncultured Apusomonadidae clone Apu_SA-7 18S ribosomal RNA gene, partial sequence | blastn | 18199 | 292 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | uncultured Apusomonadidae | |||||
| 13600993 | 13600993 | PRJNA864829_S_NODE_5871_length_248_cov_10.115578_g5785_i0 | PRJNA864829 | 5871 | 248 | 10.115578 | 25.08663344 | Apusomonas proboscidea | 41120 | Root_unresolved | Root_unresolved | 320 | 5.57e-83 | NTclustered | gi|2206682169|gb|OM966642.1| | 41120 | g5785 | i0 | 95.5 | 80.7782258064516 | 200 | 9 | 81 | 0 | 24 | 223 | 5268 | 5467 | Apusomonas proboscidea strain MPSANABRIA15 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 | 20033 | 320 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Apusomonas | Apusomonas proboscidea | ||||
| 14875265 | 14875265 | PRJNA864829_S_NODE_10712_length_193_cov_8.090278_g10626_i0 | PRJNA864829 | 10712 | 193 | 8.090278 | 15.61423654 | Singekia franciliensis | 2925418 | Root_unresolved | Root_unresolved | 217 | 5.5799999999999996e-52 | NTclustered | gi|2206682165|gb|OM966638.1| | 2925418 | g10626 | i0 | 87.179 | 101.119170984456 | 195 | 19 | 99 | 5 | 1 | 191 | 5126 | 5318 | Singekia franciliensis strain ORSAYFEB19APU1 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 | 19516 | 217 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Singekia | Singekia franciliensis | ||||
| 21249417 | 21249417 | PRJNA864829_S_NODE_10477_length_195_cov_4.376712_g10391_i0 | PRJNA864829 | 10477 | 195 | 4.376712 | 8.5345884 | Singekia montserratensis | 2925341 | Root_unresolved | Root_unresolved | 182 | 2.06e-41 | NTclustered | gi|2206682174|gb|OM966647.1| | 2925341 | g10391 | i0 | 86.471 | 87.8923076923077 | 170 | 18 | 87 | 4 | 2 | 170 | 3382 | 3217 | Singekia montserratensis strain MONTSE19P8 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 | 17139 | 182 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Singekia | Singekia montserratensis | ||||
| 25073373 | 25073373 | PRJNA864829_S_NODE_3280_length_307_cov_1.166667_g3194_i0 | PRJNA864829 | 3280 | 307 | 1.166667 | 3.58166769 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 237 | 7.37e-58 | NTclustered | gi|761380055|ref|NC_026452.1| | 529818 | g3194 | i0 | 89.005 | 63.6514657980456 | 191 | 21 | 62 | 0 | 16 | 206 | 1693 | 1503 | Thecamonas trahens strain ATCC 50062 mitochondrion, complete genome | blastn | 19541 | 237 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens |
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);;