contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4676468 | 4676468 | PRJNA867519_P_NODE_16144_length_294_cov_2.782805_g15990_i0 | PRJNA867519 | 16144 | 294 | 2.782805 | 8.1814467 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 143 | 1.57e-29 | NTclustered | gi|923136453|ref|XM_013906238.1| | 461836 | g15990 | i0 | 81.818 | 0.833333333333333 | 176 | 26 | 59 | 6 | 62 | 234 | 322 | 150 | Thecamonas trahens ATCC 50062 50S ribosomal protein L36e (AMSG_01644), partial mRNA | blastn | 245 | 143 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 4676639 | 4676639 | PRJNA867519_P_NODE_6684_length_423_cov_6.940000_g6530_i0 | PRJNA867519 | 6684 | 423 | 6.94 | 29.3562 | Karpovia croatica | 2925417 | Root_unresolved | Root_unresolved | 99 | 5.16e-16 | NTclustered | gi|2206682173|gb|OM966646.1| | 2925417 | g6530 | i0 | 88.095 | 13.6146572104019 | 84 | 9 | 20 | 1 | 1 | 84 | 6102 | 6020 | 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 | 5759 | 99 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Karpovia | Karpovia croatica | ||||
| 13601844 | 13601844 | PRJNA867519_P_NODE_31871_length_243_cov_0.905882_g31717_i0 | PRJNA867519 | 31871 | 243 | 0.905882 | 2.20129326 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 294 | 3.3e-75 | NTclustered | gi|923129792|ref|XM_013902908.1| | 461836 | g31717 | i0 | 89.076 | 96.9012345679012 | 238 | 24 | 98 | 2 | 2 | 238 | 266 | 30 | Thecamonas trahens ATCC 50062 Ras-like C3 botulinum toxin substrate 1 (AMSG_04690), mRNA | blastn | 23547 | 294 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 14876159 | 14876159 | PRJNA867519_P_NODE_3192_length_580_cov_1.059172_g3041_i0 | PRJNA867519 | 3192 | 580 | 1.059172 | 6.1431976 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 261 | 8.74e-65 | NTclustered | gi|923130274|ref|XM_013903149.1| | 461836 | g3041 | i0 | 88.584 | 30.448275862069 | 219 | 19 | 37 | 5 | 1 | 216 | 561 | 776 | Thecamonas trahens ATCC 50062 14-3-3 family protein epsilon (AMSG_04940), partial mRNA | blastn | 17660 | 261 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 14876192 | 14876192 | PRJNA867519_P_NODE_4612_length_495_cov_5.995261_g4459_i0 | PRJNA867519 | 4612 | 495 | 5.995261 | 29.67654195 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 152 | 4.6299999999999997e-32 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g4459 | i0 | 88.71 | 25.1393939393939 | 124 | 14 | 25 | 0 | 112 | 235 | 5301 | 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 | 12444 | 152 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 19974582 | 19974582 | PRJNA867519_P_NODE_10336_length_353_cov_22.371429_g10182_i0 | PRJNA867519 | 10336 | 353 | 22.371429 | 78.97114437 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 154 | 8.890000000000001e-33 | NTclustered | gi|923125900|ref|XM_013900964.1| | 461836 | g10182 | i0 | 89.344 | 9.71671388101983 | 122 | 13 | 35 | 0 | 184 | 305 | 156 | 35 | Thecamonas trahens ATCC 50062 60S ribosomal protein L39 (AMSG_06579), partial mRNA | blastn | 3430 | 154 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 21250343 | 21250343 | PRJNA867519_P_NODE_4057_length_524_cov_2.545455_g3905_i0 | PRJNA867519 | 4057 | 524 | 2.545455 | 13.3381842 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 318 | 4.5899999999999983e-82 | NTclustered | gi|923130274|ref|XM_013903149.1| | 461836 | g3905 | i0 | 90.756 | 43.1965648854962 | 238 | 22 | 45 | 0 | 1 | 238 | 505 | 742 | Thecamonas trahens ATCC 50062 14-3-3 family protein epsilon (AMSG_04940), partial mRNA | blastn | 22635 | 318 | 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);;