contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA546018" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1119263 | 1119263 | PRJNA546018_S_NODE_7821_length_633_cov_12.405594_g7515_i0 | PRJNA546018 | 7821 | 633 | 12.405594 | 78.52741002 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1066 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g7515 | i0 | 98.2 | 62.4170616113744 | 611 | 9 | 96 | 2 | 24 | 633 | 5177 | 5786 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 39510 | 1072 | 0.994402985074627 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 1786777 | 1786777 | PRJNA546018_S_NODE_55102_length_205_cov_2.840278_g54777_i0 | PRJNA546018 | 55102 | 205 | 2.840278 | 5.8225699 | Angulamoeba microcystivorans | 1654978 | Evosea | other_Eukaryota | 239 | 1.28e-58 | NTclustered | gi|961557578|gb|KP719182.2| | 1654978 | g54777 | i0 | 90.27 | 15.6780487804878 | 185 | 15 | 89 | 3 | 1 | 183 | 1089 | 906 | Angulamoeba microcystivorans strain A4WVB clone 2 small subunit ribosomal RNA gene, partial sequence | blastn | 3214 | 239 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Angulamoeba | Angulamoeba microcystivorans | ||||
| 4338413 | 4338413 | PRJNA546018_S_NODE_7604_length_643_cov_5.896907_g7301_i0 | PRJNA546018 | 7604 | 643 | 5.896907 | 37.91711201 | Squamamoeba japonica | 1167875 | Evosea | other_Eukaryota | 265 | 7.539999999999999e-66 | NTclustered | gi|381423467|gb|JN638032.1| | 1167875 | g7301 | i0 | 83.746 | 36.4043545878694 | 283 | 42 | 44 | 4 | 140 | 419 | 1179 | 1460 | Squamamoeba japonica strain CCAP 1593/1 clone 2224 18S ribosomal RNA gene, partial sequence | blastn | 23408 | 265 | 1 | Eukaryota | Amoebozoa | Evosea | Squamamoeba | Squamamoeba japonica | |||||
| 9438974 | 9438974 | PRJNA546018_S_NODE_14328_length_440_cov_10.311346_g14003_i0 | PRJNA546018 | 14328 | 440 | 10.311346 | 45.3699224 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 579 | 1.5799999999999993e-160 | NTclustered | gi|659103923|gb|KJ569725.1| | 1512276 | g14003 | i0 | 90.38 | 44.2363636363636 | 447 | 34 | 100 | 9 | 1 | 440 | 604 | 1048 | Cochliopodium kieliense clone 9601 18S ribosomal RNA gene, partial sequence | blastn | 19464 | 579 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 13264966 | 13264966 | PRJNA546018_S_NODE_41571_length_238_cov_4.225989_g41246_i0 | PRJNA546018 | 41571 | 238 | 4.225989 | 10.05785382 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 429 | 8.45e-116 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g41246 | i0 | 99.16 | 33.4033613445378 | 238 | 2 | 100 | 0 | 1 | 238 | 3677 | 3440 | Hartmannella vermiformis 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 | 7950 | 429 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 15814248 | 15814248 | PRJNA546018_S_NODE_7653_length_641_cov_8.181034_g7349_i0 | PRJNA546018 | 7653 | 641 | 8.181034 | 52.44042794 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 254 | 1.63e-62 | NTclustered | gi|470424971|ref|XM_004337710.1| | 1257118 | g7349 | i0 | 79.275 | 53.4477379095164 | 386 | 63 | 58 | 12 | 20 | 392 | 2644 | 2263 | Acanthamoeba castellanii str. Neff coatmer subunit, putative (ACA1_379260), partial mRNA | blastn | 34260 | 254 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19637461 | 19637461 | PRJNA546018_S_NODE_51976_length_210_cov_1.617450_g51651_i0 | PRJNA546018 | 51976 | 210 | 1.61745 | 3.396645 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 335 | 1.6299999999999994e-87 | NTclustered | gi|221185864|gb|FJ577811.1| | 590481 | g51651 | i0 | 98.438 | 0.914285714285714 | 192 | 0 | 90 | 1 | 2 | 190 | 743 | 552 | Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence | blastn | 192 | 335 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 19637651 | 19637651 | PRJNA546018_S_NODE_8516_length_602_cov_8.238447_g8204_i0 | PRJNA546018 | 8516 | 602 | 8.238447 | 49.59545094 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 207 | 1.1999999999999998e-48 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g8204 | i0 | 83.945 | 68.6395348837209 | 218 | 34 | 36 | 1 | 69 | 285 | 28057 | 27840 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 41321 | 207 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23463409 | 23463409 | PRJNA546018_S_NODE_44379_length_230_cov_1.153846_g44054_i0 | PRJNA546018 | 44379 | 230 | 1.153846 | 2.6538458 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 211 | 3.2e-50 | NTclustered | gi|85062628|gb|DQ340386.1| | 5786 | g44054 | i0 | 88.571 | 48.1608695652174 | 175 | 18 | 76 | 2 | 1 | 174 | 8297 | 8124 | Dictyostelium purpureum 17S ribosomal RNA, 5.8S ribosomal RNA, 26S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence | blastn | 11077 | 211 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 24736794 | 24736794 | PRJNA546018_S_NODE_23620_length_329_cov_2.414179_g23295_i0 | PRJNA546018 | 23620 | 329 | 2.414179 | 7.94264891 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 501 | 2.56e-137 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g23295 | i0 | 94.242 | 59.3768996960486 | 330 | 14 | 99 | 4 | 1 | 327 | 619 | 292 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 19535 | 501 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus |
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);;