contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 364645 | 364645 | PRJNA168635_P_NODE_4561_length_394_cov_10.133333_g4157_i0 | PRJNA168635 | 4561 | 394 | 10.133333 | 39.92533202 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 145 | 6.05e-30 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g4157 | i0 | 88.889 | 29.7817258883249 | 117 | 13 | 30 | 0 | 68 | 184 | 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 | 11734 | 145 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 1639194 | 1639194 | PRJNA168635_P_NODE_1662_length_621_cov_3.361888_g1308_i0 | PRJNA168635 | 1662 | 621 | 3.361888 | 20.87732448 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 174 | 1.26e-38 | NTclustered | gi|761380055|ref|NC_026452.1| | 529818 | g1308 | i0 | 77.188 | 20.7342995169082 | 320 | 60 | 51 | 12 | 308 | 621 | 1493 | 1805 | Thecamonas trahens strain ATCC 50062 mitochondrion, complete genome | blastn | 12876 | 174 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 11843126 | 11843126 | PRJNA168635_P_NODE_24090_length_171_cov_2.204918_g23674_i0 | PRJNA168635 | 24090 | 171 | 2.204918 | 3.77040978 | Podomonas capensis | 2925399 | Root_unresolved | Root_unresolved | 111 | 2.33e-20 | NTclustered | gi|2206682168|gb|OM966641.1| | 2925399 | g23674 | i0 | 86.869 | 0.578947368421053 | 99 | 13 | 58 | 0 | 2 | 100 | 5978 | 5880 | 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 | 99 | 111 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Podomonas | Podomonas capensis | ||||
| 11843212 | 11843212 | PRJNA168635_P_NODE_31370_length_162_cov_6.442478_g30954_i0 | PRJNA168635 | 31370 | 162 | 6.442478 | 10.43681436 | Podomonas capensis | 2925399 | Root_unresolved | Root_unresolved | 250 | 4.45e-62 | NTclustered | gi|2206682168|gb|OM966641.1| | 2925399 | g30954 | i0 | 94.444 | 75.6543209876543 | 162 | 9 | 100 | 0 | 1 | 162 | 2000 | 2161 | 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 | 12256 | 250 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Podomonas | Podomonas capensis | ||||
| 13118470 | 13118470 | PRJNA168635_P_NODE_3731_length_433_cov_11.421875_g3331_i0 | PRJNA168635 | 3731 | 433 | 11.421875 | 49.45671875 | Podomonas magna | 2925398 | Root_unresolved | Root_unresolved | 263 | 1.77e-65 | NTclustered | gi|2206682163|gb|OM966636.1| | 2925398 | g3331 | i0 | 80.857 | 51.3233256351039 | 350 | 54 | 80 | 12 | 88 | 432 | 3399 | 3740 | Podomonas magna strain CCAP19014 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 | 22223 | 263 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Podomonas | Podomonas magna | ||||
| 15667099 | 15667099 | PRJNA168635_P_NODE_11533_length_241_cov_2.625000_g11117_i0 | PRJNA168635 | 11533 | 241 | 2.625 | 6.32625 | Singekia franciliensis | 2925418 | Root_unresolved | Root_unresolved | 351 | 1.91e-92 | NTclustered | gi|2206682165|gb|OM966638.1| | 2925418 | g11117 | i0 | 92.975 | 72.7676348547718 | 242 | 15 | 100 | 2 | 1 | 241 | 4319 | 4559 | 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 | 17537 | 351 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Singekia | Singekia franciliensis | ||||
| 16356807 | 16356807 | PRJNA168635_P_NODE_9453_length_271_cov_6.171171_g9038_i0 | PRJNA168635 | 9453 | 271 | 6.171171 | 16.72387341 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 128 | 4.01e-25 | NTclustered | gi|2206682162|gb|OM966635.1| | 1314681 | g9038 | i0 | 79.487 | 32.9077490774908 | 195 | 28 | 70 | 9 | 1 | 190 | 2447 | 2634 | 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 | 8918 | 128 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Mylnikovia | Mylnikovia oxoniensis | ||||
| 16941757 | 16941757 | PRJNA168635_P_NODE_25094_length_169_cov_1.650000_g24678_i0 | PRJNA168635 | 25094 | 169 | 1.65 | 2.7885 | Singekia franciliensis | 2925418 | Root_unresolved | Root_unresolved | 267 | 4.63e-67 | NTclustered | gi|2206682165|gb|OM966638.1| | 2925418 | g24678 | i0 | 95.238 | 55.0355029585799 | 168 | 8 | 99 | 0 | 2 | 169 | 5080 | 5247 | 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 | 9301 | 267 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Singekia | Singekia franciliensis | ||||
| 19490264 | 19490264 | PRJNA168635_P_NODE_13336_length_222_cov_1.705202_g12920_i0 | PRJNA168635 | 13336 | 222 | 1.705202 | 3.78554844 | Singekia franciliensis | 2925418 | Root_unresolved | Root_unresolved | 296 | 8.24e-76 | NTclustered | gi|2206682165|gb|OM966638.1| | 2925418 | g12920 | i0 | 91.628 | 0.968468468468468 | 215 | 16 | 96 | 2 | 2 | 215 | 6864 | 6651 | 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 | 215 | 296 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Singekia | Singekia franciliensis | ||||
| 19490361 | 19490361 | PRJNA168635_P_NODE_18216_length_188_cov_9.769784_g17800_i0 | PRJNA168635 | 18216 | 188 | 9.769784 | 18.36719392 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 108 | 3.39e-19 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g17800 | i0 | 92.208 | 29.6702127659574 | 77 | 5 | 41 | 1 | 112 | 188 | 6798 | 6873 | 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 | 5578 | 108 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 20765826 | 20765826 | PRJNA168635_P_NODE_11617_length_240_cov_2.769634_g11201_i0 | PRJNA168635 | 11617 | 240 | 2.769634 | 6.6471216 | Podomonas capensis | 2925399 | Root_unresolved | Root_unresolved | 73.1 | 1.66e-8 | NTclustered | gi|2206682168|gb|OM966641.1| | 2925399 | g11201 | i0 | 82.353 | 0.354166666666667 | 85 | 13 | 35 | 1 | 137 | 221 | 5878 | 5960 | 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 | 85 | 73.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Podomonas | Podomonas capensis | ||||
| 20765903 | 20765903 | PRJNA168635_P_NODE_15197_length_206_cov_2.343949_g14781_i0 | PRJNA168635 | 15197 | 206 | 2.343949 | 4.82853494 | Singekia franciliensis | 2925418 | Root_unresolved | Root_unresolved | 250 | 5.9499999999999995e-62 | NTclustered | gi|2206682165|gb|OM966638.1| | 2925418 | g14781 | i0 | 88.835 | 41.0873786407767 | 206 | 19 | 99 | 4 | 3 | 206 | 5369 | 5166 | 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 | 8464 | 250 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Singekia | Singekia franciliensis | ||||
| 22041036 | 22041036 | PRJNA168635_P_NODE_18558_length_187_cov_2.840580_g18142_i0 | PRJNA168635 | 18558 | 187 | 2.84058 | 5.3118846 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 219 | 1.4899999999999999e-52 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g18142 | i0 | 97.638 | 69.7647058823529 | 127 | 3 | 68 | 0 | 23 | 149 | 5304 | 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 | 13046 | 219 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis |
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);;