contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA534016" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 507588 | 507588 | PRJNA534016_P_NODE_2361_length_534_cov_1.624729_g2272_i0 | PRJNA534016 | 2361 | 534 | 1.624729 | 8.67605286 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 374 | 9.849999999999999e-99 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g2272 | i0 | 79.707 | 32.9625468164794 | 547 | 88 | 100 | 20 | 1 | 534 | 41592 | 42128 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 17602 | 374 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 5611336 | 5611336 | PRJNA534016_P_NODE_3905_length_416_cov_2.297376_g3815_i0 | PRJNA534016 | 3905 | 416 | 2.297376 | 9.55708416 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 268 | 3.6499999999999996e-67 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g3815 | i0 | 85.882 | 10.7908653846154 | 255 | 33 | 61 | 3 | 118 | 371 | 42634 | 42382 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 4489 | 268 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 11986299 | 11986299 | PRJNA534016_P_NODE_5890_length_344_cov_1.638376_g5800_i0 | PRJNA534016 | 5890 | 344 | 1.638376 | 5.63601344 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|66826106|ref|XM_641316.1| | 352472 | g5800 | i0 | 100 | 0.0813953488372093 | 28 | 0 | 8 | 0 | 78 | 105 | 1976 | 1949 | Dictyostelium discoideum AX4 7-fold repeat in clathrin and VPS proteins repeat-containing protein (vps18) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 13261259 | 13261259 | PRJNA534016_P_NODE_13031_length_255_cov_1.692308_g12941_i0 | PRJNA534016 | 13031 | 255 | 1.692308 | 4.3153854 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|66802076|ref|XM_629830.1| | 352472 | g12941 | i0 | 100 | 0.117647058823529 | 30 | 0 | 12 | 0 | 84 | 113 | 512 | 541 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0292106) mRNA, complete cds | blastn | 30 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 14536253 | 14536253 | PRJNA534016_P_NODE_11972_length_263_cov_2.942105_g11882_i0 | PRJNA534016 | 11972 | 263 | 2.942105 | 7.73773615 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 320 | 5.96e-83 | NTclustered | gi|221185864|gb|FJ577811.1| | 590481 | g11882 | i0 | 94.286 | 74.0342205323194 | 210 | 10 | 79 | 2 | 52 | 259 | 786 | 995 | Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence | blastn | 19471 | 320 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 14536266 | 14536266 | PRJNA534016_P_NODE_13292_length_253_cov_1.711111_g13202_i0 | PRJNA534016 | 13292 | 253 | 1.711111 | 4.32911083 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 281 | 2.69e-71 | NTclustered | gi|167394534|ref|XM_001740954.1| | 370354 | g13202 | i0 | 87.654 | 97.9604743083004 | 243 | 28 | 96 | 2 | 5 | 246 | 235 | 476 | Entamoeba dispar SAW760 actin, putative (EDI_043510), partial mRNA | blastn | 24784 | 281 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 17696250 | 17696250 | PRJNA534016_P_NODE_8974_length_287_cov_1.443925_g8884_i0 | PRJNA534016 | 8974 | 287 | 1.443925 | 4.14406475 | Amoebidae | 35218 | Tubulinea | other_Eukaryota | 303 | 6.64e-78 | NTclustered | gi|17897590|emb|AJ314605.1| | 160820 | g8884 | i0 | 89.344 | 51.3728222996516 | 244 | 22 | 84 | 3 | 47 | 287 | 1507 | 1749 | Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6 | blastn | 14744 | 303 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba leningradensis |
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);;