contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1655454 | 1655454 | PRJNA315314_S_NODE_13322_length_223_cov_4.634021_g13001_i0 | PRJNA315314 | 13322 | 223 | 4.634021 | 10.33386683 | Podomonas capensis | 2925399 | Root_unresolved | Root_unresolved | 115 | 2.4900000000000004e-21 | NTclustered | gi|2206682168|gb|OM966641.1| | 2925399 | g13001 | i0 | 83.594 | 28.8116591928251 | 128 | 15 | 57 | 6 | 97 | 223 | 4166 | 4288 | Podomonas capensis strain SPRINTER 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 | 6425 | 115 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Podomonas | Podomonas capensis | ||||
| 5484507 | 5484507 | PRJNA315314_S_NODE_5245_length_350_cov_23.457944_g4924_i0 | PRJNA315314 | 5245 | 350 | 23.457944 | 82.102804 | Mylnikovia oxoniensis | 1314681 | Root_unresolved | Root_unresolved | 272 | 2.33e-68 | NTclustered | gi|2206682162|gb|OM966635.1| | 1314681 | g4924 | i0 | 81.127 | 101.157142857143 | 355 | 53 | 100 | 11 | 1 | 350 | 3835 | 3490 | Mylnikovia oxoniensis strain CCAP19012 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 | 35405 | 272 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Mylnikovia | Mylnikovia oxoniensis | ||||
| 6168237 | 6168237 | PRJNA315314_S_NODE_8005_length_285_cov_36.121094_g7684_i0 | PRJNA315314 | 8005 | 285 | 36.121094 | 102.9451179 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 230 | 1.1299999999999995e-55 | NTclustered | gi|2206682169|gb|OM966642.1| | 41120 | g7684 | i0 | 89.944 | 63.2105263157895 | 179 | 16 | 62 | 2 | 107 | 284 | 5246 | 5423 | 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 | 18015 | 231 | 0.995670995670996 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Apusomonas | Apusomonas proboscidea | ||||
| 6758654 | 6758654 | PRJNA315314_S_NODE_4206_length_390_cov_75.055402_g3885_i0 | PRJNA315314 | 4206 | 390 | 75.055402 | 292.7160678 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 150 | 1.2799999999999999e-31 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g3885 | i0 | 89.744 | 33.4410256410256 | 117 | 12 | 30 | 0 | 1 | 117 | 5294 | 5178 | Catacumbia lutetiensis strain ORSAYFEB19APU2 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 | 13042 | 150 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 10584548 | 10584548 | PRJNA315314_S_NODE_13829_length_219_cov_68.705263_g13508_i0 | PRJNA315314 | 13829 | 219 | 68.705263 | 150.46452597 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 145 | 3.11e-30 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g13508 | i0 | 88.889 | 52.7168949771689 | 117 | 13 | 53 | 0 | 103 | 219 | 5178 | 5294 | Catacumbia lutetiensis strain ORSAYFEB19APU2 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 | 11545 | 145 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 15683588 | 15683588 | PRJNA315314_S_NODE_3093_length_451_cov_48.793839_g2775_i0 | PRJNA315314 | 3093 | 451 | 48.793839 | 220.06021389 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 150 | 1.51e-31 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g2775 | i0 | 89.744 | 25.2971175166297 | 117 | 12 | 26 | 0 | 1 | 117 | 5294 | 5178 | Catacumbia lutetiensis strain ORSAYFEB19APU2 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 | 11409 | 150 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 16958475 | 16958475 | PRJNA315314_S_NODE_7874_length_287_cov_59.728682_g7553_i0 | PRJNA315314 | 7874 | 287 | 59.728682 | 171.42131734 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 143 | 1.53e-29 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g7553 | i0 | 88.793 | 38.4529616724739 | 116 | 13 | 40 | 0 | 3 | 118 | 5187 | 5302 | Catacumbia lutetiensis strain ORSAYFEB19APU2 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 | 11036 | 143 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 19507067 | 19507067 | PRJNA315314_S_NODE_7876_length_287_cov_57.531008_g7555_i0 | PRJNA315314 | 7876 | 287 | 57.531008 | 165.11399296 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 148 | 3.2899999999999996e-31 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g7555 | i0 | 89.655 | 39.1602787456446 | 116 | 12 | 40 | 0 | 3 | 118 | 5187 | 5302 | Catacumbia lutetiensis strain ORSAYFEB19APU2 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 | 11239 | 148 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 20782446 | 20782446 | PRJNA315314_S_NODE_28777_length_157_cov_41.804688_g28456_i0 | PRJNA315314 | 28777 | 157 | 41.804688 | 65.63336016 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 196 | 5.66e-46 | NTclustered | gi|761380055|ref|NC_026452.1| | 529818 | g28456 | i0 | 89.241 | 101.273885350318 | 158 | 15 | 100 | 2 | 1 | 157 | 1805 | 1961 | Thecamonas trahens strain ATCC 50062 mitochondrion, complete genome | blastn | 15900 | 196 | 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);;