contig_metadata
5 rows where bioproject = "PRJNA1098727" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2761801 | 2761801 | PRJNA1098727_P_NODE_14403_length_165_cov_0.896552_g14162_i0 | PRJNA1098727 | 14403 | 165 | 0.896552 | 1.4793108 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 291 | 2.69e-74 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g14162 | i0 | 98.78 | 11.5151515151515 | 164 | 0 | 99 | 1 | 1 | 164 | 1420 | 1259 | D.iridis LSU rRNA gene | blastn | 1900 | 291 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 9947978 | 9947978 | PRJNA1098727_P_NODE_12628_length_169_cov_1.716667_g12387_i0 | PRJNA1098727 | 12628 | 169 | 1.716667 | 2.90116723 | Acanthamoebidae | 33677 | Discosea | other_Eukaryota | 287 | 3.55e-73 | NTclustered | gi|2979663|gb|AF019063.1|AF019063 | 28015 | g12387 | i0 | 97.605 | 89.810650887574 | 167 | 4 | 99 | 0 | 2 | 168 | 751 | 917 | Acanthamoeba palestinensis 2802 18S ribosomal RNA gene, partial sequence | blastn | 15178 | 287 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba palestinensis | |||
| 19336913 | 19336913 | PRJNA1098727_P_NODE_9176_length_201_cov_3.013158_g8935_i0 | PRJNA1098727 | 9176 | 201 | 3.013158 | 6.05644758 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 235 | 1.62e-57 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g8935 | i0 | 94.771 | 0.761194029850746 | 153 | 5 | 75 | 3 | 1 | 151 | 5926 | 5775 | Acanthamoeba castellanii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 153 | 235 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27383821 | 27383821 | PRJNA1098727_P_NODE_7623_length_224_cov_0.874286_g7382_i0 | PRJNA1098727 | 7623 | 224 | 0.874286 | 1.95840064 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 42.4 | 0.0408 | NR | XP_004339867.1 | 1257118 | g7382 | i0 | 32.9 | 0.977678571428571 | 73 | 44 | 91.1 | 3 | 18 | 221 | 426 | 498 | XP_004339867.1 Fbox domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 219 | 42.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30320948 | 30320948 | PRJNA1098727_P_NODE_13272_length_168_cov_0.873950_g13031_i0 | PRJNA1098727 | 13272 | 168 | 0.87395 | 1.468236 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 59.3 | 1.26e-8 | NR | XP_003294366.1 | 5786 | g13031 | i0 | 43.6 | 0.982142857142857 | 55 | 31 | 98.2 | 0 | 2 | 166 | 168 | 222 | XP_003294366.1 uncharacterized protein DICPUDRAFT_43294 [Dictyostelium purpureum] | diamond | 165 | 59.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum |
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);;