contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA611476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 589280 | 589280 | PRJNA611476_P_NODE_25881_length_398_cov_5.381538_g25090_i0 | PRJNA611476 | 25881 | 398 | 5.381538 | 21.41852124 | Karpovia croatica | 2925417 | Root_unresolved | Root_unresolved | 102 | 3.73e-17 | NTclustered | gi|2206682173|gb|OM966646.1| | 2925417 | g25090 | i0 | 87.64 | 15.3291457286432 | 89 | 9 | 22 | 2 | 272 | 359 | 6020 | 6107 | 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 | 6101 | 102 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Karpovia | Karpovia croatica | ||||
| 589749 | 589749 | PRJNA611476_P_NODE_61601_length_282_cov_1.358852_g60810_i0 | PRJNA611476 | 61601 | 282 | 1.358852 | 3.83196264 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 167 | 8.9e-37 | NTclustered | gi|923129143|ref|XM_013902584.1| | 461836 | g60810 | i0 | 83.708 | 47.2482269503546 | 178 | 27 | 63 | 2 | 76 | 252 | 1792 | 1968 | Thecamonas trahens ATCC 50062 DEAD/DEAH box RNA helicase (AMSG_05329), partial mRNA | blastn | 13324 | 167 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 589765 | 589765 | PRJNA611476_P_NODE_62681_length_280_cov_1.449275_g61890_i0 | PRJNA611476 | 62681 | 280 | 1.449275 | 4.05797 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 52.8 | 0.026 | NTclustered | gi|923124044|ref|XM_013900037.1| | 461836 | g61890 | i0 | 100 | 0.1 | 28 | 0 | 10 | 0 | 180 | 207 | 477 | 504 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_08435), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 8243163 | 8243163 | PRJNA611476_P_NODE_8667_length_660_cov_1.279387_g7892_i0 | PRJNA611476 | 8667 | 660 | 1.279387 | 8.4439542 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 67.6 | 2.35e-6 | NTclustered | gi|923125467|ref|XM_013900748.1| | 461836 | g7892 | i0 | 91.837 | 1.94393939393939 | 49 | 2 | 7 | 2 | 1 | 48 | 2716 | 2669 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_07278), partial mRNA | blastn | 1283 | 67.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 8243231 | 8243231 | PRJNA611476_P_NODE_9127_length_643_cov_2.056140_g8345_i0 | PRJNA611476 | 9127 | 643 | 2.05614 | 13.2209802 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 292 | 3.46e-74 | NTclustered | gi|923135942|ref|XM_013905983.1| | 461836 | g8345 | i0 | 76.88 | 2.6407465007776 | 532 | 113 | 82 | 9 | 82 | 608 | 321 | 847 | Thecamonas trahens ATCC 50062 sperm-associated antigen 6 (AMSG_01939), mRNA | blastn | 1698 | 292 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 10793461 | 10793461 | PRJNA611476_P_NODE_2549_length_1243_cov_5.332479_g1992_i0 | PRJNA611476 | 2549 | 1243 | 5.332479 | 66.28271397 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 62.1 | 2.11e-4 | NTclustered | gi|923120088|ref|XM_013898063.1| | 461836 | g1992 | i0 | 100 | 0.0265486725663717 | 33 | 0 | 3 | 0 | 289 | 321 | 82 | 114 | Thecamonas trahens ATCC 50062 CAMKK protein kinase (AMSG_10592), partial mRNA | blastn | 33 | 62.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 10793538 | 10793538 | PRJNA611476_P_NODE_30489_length_373_cov_1.540000_g29698_i0 | PRJNA611476 | 30489 | 373 | 1.54 | 5.7442 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 62.1 | 5.9e-5 | NTclustered | gi|923125776|ref|XM_013900902.1| | 461836 | g29698 | i0 | 91.304 | 0.246648793565684 | 46 | 2 | 12 | 2 | 27 | 71 | 1122 | 1078 | Thecamonas trahens ATCC 50062 hypothetical protein, variant (AMSG_06504), mRNA | blastn | 92 | 62.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 17167225 | 17167225 | PRJNA611476_P_NODE_3554_length_1037_cov_3.226141_g2909_i0 | PRJNA611476 | 3554 | 1037 | 3.226141 | 33.45508217 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 401 | 9.069999999999998e-107 | NTclustered | gi|923126576|ref|XM_013901301.1| | 461836 | g2909 | i0 | 76.671 | 39.877531340405 | 793 | 144 | 74 | 32 | 1 | 771 | 377 | 1150 | Thecamonas trahens ATCC 50062 S-adenosylmethionine synthase (AMSG_06698), mRNA | blastn | 41353 | 401 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 18441765 | 18441765 | PRJNA611476_P_NODE_5935_length_793_cov_4.820833_g5188_i0 | PRJNA611476 | 5935 | 793 | 4.820833 | 38.22920569 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 139 | 5.94e-28 | NTclustered | gi|923136453|ref|XM_013906238.1| | 461836 | g5188 | i0 | 84.028 | 0.465321563682219 | 144 | 23 | 18 | 0 | 137 | 280 | 147 | 290 | Thecamonas trahens ATCC 50062 50S ribosomal protein L36e (AMSG_01644), partial mRNA | blastn | 369 | 139 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 23542082 | 23542082 | PRJNA611476_P_NODE_52859_length_300_cov_2.193833_g52068_i0 | PRJNA611476 | 52859 | 300 | 2.193833 | 6.581499 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 270 | 7.08e-68 | NTclustered | gi|923123076|ref|XM_013899554.1| | 461836 | g52068 | i0 | 85.075 | 110.646666666667 | 268 | 36 | 89 | 4 | 2 | 267 | 4174 | 3909 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_12222), partial mRNA | blastn | 33194 | 270 | 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);;