contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 287612 | 287612 | PRJNA1144090_P_NODE_70321_length_301_cov_3.811404_g69786_i0 | PRJNA1144090 | 70321 | 301 | 3.811404 | 11.47232604 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 254 | 7.15e-63 | NTclustered | gi|923132712|ref|XM_013904368.1| | 461836 | g69786 | i0 | 82 | 13.2458471760797 | 300 | 52 | 99 | 2 | 3 | 301 | 635 | 933 | Thecamonas trahens ATCC 50062 actin-like protein 3 (AMSG_03466), partial mRNA | blastn | 3987 | 254 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 1561456 | 1561456 | PRJNA1144090_P_NODE_101442_length_250_cov_0.870056_g100907_i0 | PRJNA1144090 | 101442 | 250 | 0.870056 | 2.17514 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 141 | 4.7e-29 | NTclustered | gi|923123658|ref|XM_013899844.1| | 461836 | g100907 | i0 | 83.23 | 3.324 | 161 | 19 | 64 | 7 | 68 | 227 | 421 | 268 | Thecamonas trahens ATCC 50062 ubiquitin/ribosomal protein S27 fusion protein (AMSG_08067), partial mRNA | blastn | 831 | 141 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 4114494 | 4114494 | PRJNA1144090_P_NODE_59944_length_328_cov_1.521569_g59409_i0 | PRJNA1144090 | 59944 | 328 | 1.521569 | 4.99074632 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 228 | 4.7799999999999986e-55 | NTclustered | gi|923138884|ref|XM_013907453.1| | 461836 | g59409 | i0 | 80.678 | 18.5640243902439 | 295 | 55 | 90 | 2 | 7 | 300 | 1271 | 978 | Thecamonas trahens ATCC 50062 elongation factor 2 (AMSG_00036), mRNA | blastn | 6089 | 228 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 15590415 | 15590415 | PRJNA1144090_P_NODE_62713_length_320_cov_2.311741_g62178_i0 | PRJNA1144090 | 62713 | 320 | 2.311741 | 7.3975712 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 298 | 3.49e-76 | NTclustered | gi|923138884|ref|XM_013907453.1| | 461836 | g62178 | i0 | 88.306 | 48.91875 | 248 | 29 | 78 | 0 | 71 | 318 | 324 | 571 | Thecamonas trahens ATCC 50062 elongation factor 2 (AMSG_00036), mRNA | blastn | 15654 | 298 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 20688502 | 20688502 | PRJNA1144090_P_NODE_17997_length_645_cov_9.284965_g17477_i0 | PRJNA1144090 | 17997 | 645 | 9.284965 | 59.88802425 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 494 | 8.86e-135 | NTclustered | gi|923129792|ref|XM_013902908.1| | 461836 | g17477 | i0 | 83.549 | 55.2542635658915 | 541 | 76 | 83 | 9 | 101 | 635 | 545 | 12 | Thecamonas trahens ATCC 50062 Ras-like C3 botulinum toxin substrate 1 (AMSG_04690), mRNA | blastn | 35639 | 494 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 20688590 | 20688590 | PRJNA1144090_P_NODE_25797_length_524_cov_5.796009_g25264_i0 | PRJNA1144090 | 25797 | 524 | 5.796009 | 30.37108716 | Catacumbia lutetiensis | 2925415 | Root_unresolved | Root_unresolved | 154 | 1.37e-32 | NTclustered | gi|2206682166|gb|OM966639.1| | 2925415 | g25264 | i0 | 88.8 | 21.2671755725191 | 125 | 14 | 24 | 0 | 134 | 258 | 5302 | 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 | 11144 | 154 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Catacumbia | Catacumbia lutetiensis | ||||
| 20688927 | 20688927 | PRJNA1144090_P_NODE_56857_length_337_cov_1.458333_g56322_i0 | PRJNA1144090 | 56857 | 337 | 1.458333 | 4.91458221 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 246 | 1.36e-60 | NTclustered | gi|923120800|ref|XM_013898418.1| | 461836 | g56322 | i0 | 80.24 | 89.2670623145401 | 334 | 60 | 98 | 6 | 1 | 331 | 510 | 840 | Thecamonas trahens ATCC 50062 isocitrate dehydrogenase (AMSG_10027), mRNA | blastn | 30083 | 246 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 23239446 | 23239446 | PRJNA1144090_P_NODE_18239_length_640_cov_4.051146_g17718_i0 | PRJNA1144090 | 18239 | 640 | 4.051146 | 25.9273344 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 455 | 4.1500000000000006e-123 | NTclustered | gi|923128656|ref|XM_013902341.1| | 461836 | g17718 | i0 | 79.656 | 90.3671875 | 639 | 124 | 99 | 5 | 7 | 640 | 1187 | 550 | Thecamonas trahens ATCC 50062 actin-like protein 2 (AMSG_05368), mRNA | blastn | 57835 | 455 | 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);;