contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA870096" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3401050 | 3401050 | PRJNA870096_S_NODE_58043_length_230_cov_2.518717_g56379_i0 | PRJNA870096 | 58043 | 230 | 2.518717 | 5.7930491 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|66814031|ref|XM_636103.1| | 352472 | g56379 | i0 | 96.875 | 0.139130434782609 | 32 | 1 | 14 | 0 | 123 | 154 | 1850 | 1819 | Dictyostelium discoideum AX4 hypothetical protein (hbx9) mRNA, complete cds | blastn | 32 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 4678476 | 4678476 | PRJNA870096_S_NODE_41804_length_274_cov_2.095238_g40140_i0 | PRJNA870096 | 41804 | 274 | 2.095238 | 5.74095212 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 219 | 2.3399999999999994e-52 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g40140 | i0 | 85.577 | 2.97080291970803 | 208 | 30 | 76 | 0 | 67 | 274 | 1 | 208 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 814 | 219 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 7615351 | 7615351 | PRJNA870096_S_NODE_65586_length_216_cov_2.046243_g63922_i0 | PRJNA870096 | 65586 | 216 | 2.046243 | 4.41988488 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.019 | NTclustered | gi|330794640|ref|XM_003285338.1| | 5786 | g63922 | i0 | 100 | 0.833333333333333 | 28 | 0 | 13 | 0 | 147 | 174 | 233 | 206 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_149290), partial mRNA | blastn | 180 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 11053582 | 11053582 | PRJNA870096_S_NODE_19869_length_406_cov_76.776860_g18213_i0 | PRJNA870096 | 19869 | 406 | 76.77686 | 311.7140516 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 691 | 0 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g18213 | i0 | 99.475 | 66.8374384236453 | 381 | 1 | 94 | 1 | 26 | 406 | 588 | 967 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 27136 | 691 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 11053799 | 11053799 | PRJNA870096_S_NODE_42149_length_273_cov_1.560870_g40485_i0 | PRJNA870096 | 42149 | 273 | 1.56087 | 4.2611751 | Copromyxa laresi | 1789826 | Tubulinea | other_Eukaryota | 195 | 3.94e-45 | NTclustered | gi|1042160952|dbj|LC102283.1| | 1789826 | g40485 | i0 | 81.07 | 85.4249084249084 | 243 | 46 | 89 | 0 | 6 | 248 | 515 | 273 | Copromyxa sp. MK-2016 mitochondrial COXI gene, cytochrome oxidase subunit I, partial sequence, strain: ZEB1 | blastn | 23321 | 195 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa laresi | ||
| 12329062 | 12329062 | PRJNA870096_S_NODE_2570_length_1150_cov_8.616079_g1863_i0 | PRJNA870096 | 2570 | 1150 | 8.616079 | 99.0849085 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 420 | 2.7899999999999992e-112 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g1863 | i0 | 76.163 | 70.4947826086957 | 860 | 170 | 73 | 30 | 53 | 887 | 3676 | 4525 | Paravannella minima mitochondrion, complete genome | blastn | 81069 | 420 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima | |||
| 13603624 | 13603624 | PRJNA870096_S_NODE_27331_length_344_cov_2.392027_g25667_i0 | PRJNA870096 | 27331 | 344 | 2.392027 | 8.22857288 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 241 | 6.47e-59 | NTclustered | gi|330845446|ref|XM_003294549.1| | 5786 | g25667 | i0 | 83.794 | 11.0232558139535 | 253 | 41 | 74 | 0 | 2 | 254 | 284 | 536 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_93248), mRNA | blastn | 3792 | 241 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 13604367 | 13604367 | PRJNA870096_S_NODE_88051_length_187_cov_2.000000_g86387_i0 | PRJNA870096 | 88051 | 187 | 2 | 3.74 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|66800340|ref|XM_629094.1| | 352472 | g86387 | i0 | 92.5 | 0.213903743315508 | 40 | 2 | 21 | 1 | 4 | 43 | 2149 | 2111 | Dictyostelium discoideum AX4 Vps52 / Sac2 family protein (vps52B) mRNA, complete cds | blastn | 40 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 14878652 | 14878652 | PRJNA870096_S_NODE_87832_length_187_cov_32.840278_g86168_i0 | PRJNA870096 | 87832 | 187 | 32.840278 | 61.41131986 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 340 | 3.0499999999999998e-89 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g86168 | i0 | 99.465 | 98.9411764705882 | 187 | 1 | 100 | 0 | 1 | 187 | 1127 | 941 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 18502 | 340 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 17428430 | 17428430 | PRJNA870096_S_NODE_5314_length_810_cov_13.572360_g4132_i0 | PRJNA870096 | 5314 | 810 | 13.57236 | 109.936116 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 431 | 8.949999999999998e-116 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g4132 | i0 | 79.967 | 1.47407407407407 | 599 | 108 | 73 | 11 | 1 | 593 | 797 | 1389 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 1194 | 431 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 18701237 | 18701237 | PRJNA870096_S_NODE_18175_length_426_cov_6.436031_g16523_i0 | PRJNA870096 | 18175 | 426 | 6.436031 | 27.41749206 | Hartmannella cantabrigiensis | 239731 | Tubulinea | other_Eukaryota | 420 | 9.77e-113 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g16523 | i0 | 85.969 | 86.31220657277 | 392 | 55 | 92 | 0 | 26 | 417 | 712 | 1103 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 36769 | 420 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 20363677 | 20363677 | PRJNA870096_S_NODE_4356_length_894_cov_34.159812_g3314_i0 | PRJNA870096 | 4356 | 894 | 34.159812 | 305.38871928 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 1218 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g3314 | i0 | 98.972 | 59.1733780760626 | 681 | 6 | 76 | 1 | 189 | 869 | 1808 | 1129 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 52901 | 1218 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 |
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);;