contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA896554" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5972965 | 5972965 | PRJNA896554_P_NODE_115165_length_299_cov_2.044248_g107625_i0 | PRJNA896554 | 115165 | 299 | 2.044248 | 6.11230152 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 62.1 | 4.62e-5 | NTclustered | gi|66810116|ref|XM_633690.1| | 352472 | g107625 | i0 | 75.806 | 0.983277591973244 | 124 | 28 | 41 | 2 | 162 | 284 | 1403 | 1281 | Dictyostelium discoideum AX4 protein kinase 4 (DDB_G0284029) mRNA, partial cds | blastn | 294 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 7621827 | 7621827 | PRJNA896554_P_NODE_166126_length_244_cov_2.076023_g158586_i0 | PRJNA896554 | 166126 | 244 | 2.076023 | 5.06549612 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.2 | 1.32e-4 | NTclustered | gi|831766796|ref|XM_012896450.1| | 1410327 | g158586 | i0 | 88 | 1.14754098360656 | 50 | 6 | 20 | 0 | 67 | 116 | 402 | 353 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 280 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 17449738 | 17449738 | PRJNA896554_P_NODE_47534_length_714_cov_2.394696_g40190_i0 | PRJNA896554 | 47534 | 714 | 2.394696 | 17.09812944 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 588 | 4.3999999999999996e-163 | NTclustered | gi|470237759|ref|XM_004350786.1| | 261658 | g40190 | i0 | 81.513 | 96.7647058823529 | 714 | 132 | 100 | 0 | 1 | 714 | 265 | 978 | Cavenderia fasciculata actin (DFA_11894), partial mRNA | blastn | 69090 | 588 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 18723612 | 18723612 | PRJNA896554_P_NODE_74975_length_425_cov_2.017045_g67435_i0 | PRJNA896554 | 74975 | 425 | 2.017045 | 8.57244125 | Planoprotostelium aurantium | 65008 | Evosea | other_Eukaryota | 366 | 1.29e-96 | NTclustered | gi|2367628|gb|AF016241.1| | 65008 | g67435 | i0 | 82.311 | 97.1552941176471 | 424 | 73 | 99 | 2 | 3 | 425 | 563 | 141 | Planoprotostelium aurantium protein synthesis elongation factor 1-alpha (tef2) gene, partial cds | blastn | 41291 | 366 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium aurantium | ||
| 21271284 | 21271284 | PRJNA896554_P_NODE_104017_length_322_cov_1.236948_g96477_i0 | PRJNA896554 | 104017 | 322 | 1.236948 | 3.98297256 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 97.1 | 1.38e-15 | NTclustered | gi|66820157|ref|XM_638626.1| | 352472 | g96477 | i0 | 77.987 | 1.21428571428571 | 159 | 31 | 49 | 4 | 65 | 221 | 211 | 55 | Dictyostelium discoideum AX4 FKBP-type peptidylprolyl cis-trans isomerase (DDB_G0275227) mRNA, complete cds | blastn | 391 | 97.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 22547582 | 22547582 | PRJNA896554_P_NODE_159638_length_247_cov_0.885057_g152098_i0 | PRJNA896554 | 159638 | 247 | 0.885057 | 2.18609079 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|66821162|ref|XM_639000.1| | 352472 | g152098 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 16 | 43 | 260 | 233 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0274877) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 22549166 | 22549166 | PRJNA896554_P_NODE_83058_length_387_cov_0.980892_g75518_i0 | PRJNA896554 | 83058 | 387 | 0.980892 | 3.79605204 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 161 | 5.889999999999998e-35 | NTclustered | gi|66802102|ref|XM_629843.1| | 352472 | g75518 | i0 | 80.66 | 1.66925064599483 | 212 | 37 | 54 | 4 | 172 | 381 | 558 | 349 | Dictyostelium discoideum AX4 proteasome subunit alpha type 2 (psmA2) mRNA, complete cds | blastn | 646 | 161 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 23822881 | 23822881 | PRJNA896554_P_NODE_159779_length_247_cov_0.885057_g152239_i0 | PRJNA896554 | 159779 | 247 | 0.885057 | 2.18609079 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|66810983|ref|XM_634107.1| | 352472 | g152239 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 72 | 99 | 302 | 275 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0283177) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum |
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);;