contig_metadata
8 rows where bioproject = "PRJNA1188114", tax_clade = "Amoebozoa" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 320134 | 320134 | PRJNA1188114_P_NODE_8561_length_181_cov_1.931818_g8509_i0 | PRJNA1188114 | 8561 | 181 | 1.931818 | 3.49659058 | Cochliopodium actinophorum | 703021 | Discosea | other_Eukaryota | 254 | 3.93e-63 | NTclustered | gi|330902866|gb|JF298259.1| | 703021 | g8509 | i0 | 92.222 | 98.5635359116022 | 180 | 12 | 99 | 2 | 1 | 179 | 960 | 782 | Cochliopodium actinophorum clone 2101 actin gene, partial cds | blastn | 17840 | 254 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium actinophorum | |||
| 4870156 | 4870156 | PRJNA1188114_P_NODE_11584_length_169_cov_1.125000_g11532_i0 | PRJNA1188114 | 11584 | 169 | 1.125 | 1.90125 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 111 | 2.3e-20 | NTclustered | gi|372290523|gb|JQ239425.1| | 5755 | g11532 | i0 | 80.667 | 9.49112426035503 | 150 | 23 | 87 | 6 | 1 | 147 | 867 | 1013 | Acanthamoeba castellanii catalase 1 mRNA, complete cds | blastn | 1604 | 111 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14348972 | 14348972 | PRJNA1188114_P_NODE_10832_length_172_cov_1.341463_g10780_i0 | PRJNA1188114 | 10832 | 172 | 1.341463 | 2.30731636 | root | 1 | Root_unresolved | Root_unresolved | 112 | 9.21e-28 | NR | P53490.1 | 5755 | g10780 | i0 | 78.9 | 6.94186046511628 | 57 | 12 | 99.4 | 0 | 171 | 1 | 77 | 133 | P53490.1 RecName: Full=Actin-related protein 3; AltName: Full=Actin-like protein 3 [Acanthamoeba castellanii] | diamond | 1194 | 113 | 0.991150442477876 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19445986 | 19445986 | PRJNA1188114_P_NODE_12796_length_167_cov_0.864407_g12744_i0 | PRJNA1188114 | 12796 | 167 | 0.864407 | 1.44355969 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|470452598|ref|XM_004340584.1| | 1257118 | g12744 | i0 | 94.444 | 0.215568862275449 | 36 | 2 | 22 | 0 | 1 | 36 | 1717 | 1752 | Acanthamoeba castellanii str. Neff Cofactor of BRCA1 (COBRA1) (ACA1_155500), partial mRNA | blastn | 36 | 56.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19446009 | 19446009 | PRJNA1188114_P_NODE_15036_length_165_cov_0.879310_g14984_i0 | PRJNA1188114 | 15036 | 165 | 0.87931 | 1.4508615 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 68.9 | 7.24e-12 | NR | XP_004368318.1 | 1257118 | g14984 | i0 | 58.2 | 3.83636363636364 | 55 | 21 | 96.4 | 1 | 5 | 163 | 284 | 338 | XP_004368318.1 peptidase C19 family protein [Acanthamoeba castellanii str. Neff] | diamond | 633 | 69.3 | 0.994227994227994 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19446039 | 19446039 | PRJNA1188114_P_NODE_19996_length_161_cov_0.910714_g19944_i0 | PRJNA1188114 | 19996 | 161 | 0.910714 | 1.46624954 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 193 | 7.55e-45 | NTclustered | gi|470504026|ref|XM_004348289.1| | 1257118 | g19944 | i0 | 89.032 | 93.5341614906832 | 155 | 17 | 96 | 0 | 4 | 158 | 946 | 1100 | Acanthamoeba castellanii str. Neff H(+)-transporting atpase family protein (ACA1_022710), partial mRNA | blastn | 15059 | 193 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27641200 | 27641200 | PRJNA1188114_P_NODE_12344_length_167_cov_0.864407_g12292_i0 | PRJNA1188114 | 12344 | 167 | 0.864407 | 1.44355969 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 97.1 | 9.93e-22 | NR | XP_004335439.1 | 1257118 | g12292 | i0 | 76.4 | 0.988023952095808 | 55 | 13 | 98.8 | 0 | 1 | 165 | 358 | 412 | XP_004335439.1 P protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 165 | 97.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28177534 | 28177534 | PRJNA1188114_P_NODE_4526_length_211_cov_3.660494_g4474_i0 | PRJNA1188114 | 4526 | 211 | 3.660494 | 7.72364234 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 79.7 | 3.67e-17 | NR | 1F2K_A | 5755 | g4474 | i0 | 74.5 | 1.45023696682464 | 51 | 13 | 72.5 | 0 | 210 | 58 | 75 | 125 | 1F2K_A Chain A, PROFILIN II [Acanthamoeba castellanii] | diamond | 306 | 79.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;