contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2893853 | 2893853 | PRJNA1237347_P_NODE_43183_length_1154_cov_3.436633_g38652_i0 | PRJNA1237347 | 43183 | 1154 | 3.436633 | 39.65874482 | Podomonas capensis | 2925399 | Root_unresolved | Root_unresolved | 174 | 2.41e-38 | NTclustered | gi|2206682168|gb|OM966641.1| | 2925399 | g38652 | i0 | 82.039 | 18.2729636048527 | 206 | 35 | 18 | 2 | 393 | 598 | 3908 | 3705 | 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 | 21087 | 174 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Podomonas | Podomonas capensis | ||||
| 5445780 | 5445780 | PRJNA1237347_P_NODE_395125_length_282_cov_0.971292_g388552_i0 | PRJNA1237347 | 395125 | 282 | 0.971292 | 2.73904344 | Amastigomonas marina | 234594 | Root_unresolved | Root_unresolved | 165 | 3.1999999999999995e-36 | NTclustered | gi|31982973|gb|AY236711.1| | 234594 | g388552 | i0 | 82.703 | 26.3971631205674 | 185 | 32 | 66 | 0 | 90 | 274 | 536 | 352 | Amastigomonas marina heat shock protein 90 (Hsp90) gene, partial cds | blastn | 7444 | 165 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Amastigomonas | Amastigomonas marina | ||||
| 7995562 | 7995562 | PRJNA1237347_P_NODE_385967_length_285_cov_18.320755_g379394_i0 | PRJNA1237347 | 385967 | 285 | 18.320755 | 52.21415175 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 527 | 3.59e-145 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g379394 | i0 | 100 | 79.9719298245614 | 285 | 0 | 100 | 0 | 1 | 285 | 4123 | 3839 | 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 | 22792 | 527 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 14371037 | 14371037 | PRJNA1237347_P_NODE_37572_length_1253_cov_2.754237_g33491_i0 | PRJNA1237347 | 37572 | 1253 | 2.754237 | 34.51058961 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 60.2 | 7.65e-4 | NTclustered | gi|923135816|ref|XM_013905920.1| | 461836 | g33491 | i0 | 90.909 | 0.0837988826815642 | 44 | 4 | 4 | 0 | 731 | 774 | 1415 | 1372 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_01870), partial mRNA | blastn | 105 | 60.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 15644137 | 15644137 | PRJNA1237347_P_NODE_333353_length_312_cov_67.104603_g326780_i0 | PRJNA1237347 | 333353 | 312 | 67.104603 | 209.36636136 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 577 | 3.89e-160 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g326780 | i0 | 100 | 101.342948717949 | 312 | 0 | 100 | 0 | 1 | 312 | 396 | 85 | 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 | 31619 | 577 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 15645036 | 15645036 | PRJNA1237347_P_NODE_381333_length_287_cov_5.266355_g374760_i0 | PRJNA1237347 | 381333 | 287 | 5.266355 | 15.11443885 | Mylnikovia oxoniensis | 1314681 | Root_unresolved | Root_unresolved | 313 | 1.1e-80 | NTclustered | gi|2206682162|gb|OM966635.1| | 1314681 | g374760 | i0 | 88.258 | 94.390243902439 | 264 | 27 | 92 | 3 | 24 | 287 | 3549 | 3808 | 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 | 27090 | 313 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Mylnikovia | Mylnikovia oxoniensis | ||||
| 17627381 | 17627381 | PRJNA1237347_P_NODE_64754_length_899_cov_4.044794_g59112_i0 | PRJNA1237347 | 64754 | 899 | 4.0447939999999996 | 36.36269806 | root | 1 | Root_unresolved | Root_unresolved | 281 | 1.06e-70 | NTclustered | gi|761380055|ref|NC_026452.1| | 529818 | g59112 | i0 | 77.018 | 54.6195773081201 | 570 | 81 | 62 | 32 | 292 | 847 | 284 | 817 | Thecamonas trahens strain ATCC 50062 mitochondrion, complete genome | blastn | 49103 | 281 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 19471628 | 19471628 | PRJNA1237347_P_NODE_566456_length_226_cov_3.392157_g559882_i0 | PRJNA1237347 | 566456 | 226 | 3.392157 | 7.66627482 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 158 | 4.14e-34 | NTclustered | gi|761380055|ref|NC_026452.1| | 529818 | g559882 | i0 | 79.654 | 102.933628318584 | 231 | 38 | 98 | 5 | 4 | 225 | 2102 | 2332 | Thecamonas trahens strain ATCC 50062 mitochondrion, complete genome | blastn | 23263 | 158 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 20743692 | 20743692 | PRJNA1237347_P_NODE_385977_length_285_cov_9.750000_g379404_i0 | PRJNA1237347 | 385977 | 285 | 9.75 | 27.7875 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 527 | 3.59e-145 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g379404 | i0 | 100 | 97.5824561403509 | 285 | 0 | 100 | 0 | 1 | 285 | 1656 | 1372 | 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 | 27811 | 527 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 22015151 | 22015151 | PRJNA1237347_P_NODE_197138_length_437_cov_42.686813_g190566_i0 | PRJNA1237347 | 197138 | 437 | 42.686813 | 186.54137281 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 808 | 0 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g190566 | i0 | 100 | 82.812356979405 | 437 | 0 | 100 | 0 | 1 | 437 | 724 | 1160 | 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 | 36189 | 808 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 23288888 | 23288888 | PRJNA1237347_P_NODE_115659_length_620_cov_90.367459_g109170_i0 | PRJNA1237347 | 115659 | 620 | 90.367459 | 560.2782458 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 145 | 9.86e-30 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g109170 | i0 | 88.889 | 18.6403225806452 | 117 | 13 | 19 | 0 | 172 | 288 | 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 | 11557 | 145 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 23297977 | 23297977 | PRJNA1237347_P_NODE_568059_length_214_cov_652.163121_g561485_i0 | PRJNA1237347 | 568059 | 214 | 652.163121 | 1395.62907894 | Mylnikovia oxoniensis | 1314681 | Root_unresolved | Root_unresolved | 226 | 1.0499999999999999e-54 | NTclustered | gi|2206682162|gb|OM966635.1| | 1314681 | g561485 | i0 | 88 | 92.9252336448598 | 200 | 12 | 93 | 9 | 17 | 214 | 3704 | 3515 | 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 | 19886 | 226 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Mylnikovia | Mylnikovia oxoniensis |
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);;