contig_metadata
9 rows where bioproject = "PRJEB11748", tax_clade = "Amoebozoa" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 984073 | 984073 | PRJEB11748_P_NODE_289621_length_224_cov_16.018405_g287438_i0 | PRJEB11748 | 289621 | 224 | 16.018405 | 35.8812272 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 204 | 5.19e-48 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g287438 | i0 | 88.439 | 76.3571428571429 | 173 | 14 | 75 | 4 | 34 | 201 | 172 | 1 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 17104 | 204 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 6393662 | 6393662 | PRJEB11748_P_NODE_182446_length_299_cov_11.945378_g180263_i0 | PRJEB11748 | 182446 | 299 | 11.945378 | 35.71668022 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 490 | 4.97e-134 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g180263 | i0 | 98.556 | 31.6086956521739 | 277 | 4 | 93 | 0 | 23 | 299 | 2876 | 3152 | 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 | 9451 | 490 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 11497177 | 11497177 | PRJEB11748_P_NODE_400850_length_165_cov_4.826923_g398667_i0 | PRJEB11748 | 400850 | 165 | 4.826923 | 7.96442295 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 93.5 | 8.13e-15 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g398667 | i0 | 88.608 | 39.4121212121212 | 79 | 6 | 46 | 3 | 12 | 87 | 1179 | 1101 | Rhizamoeba saxonica 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 | 6503 | 93.5 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 12463476 | 12463476 | PRJEB11748_P_NODE_317550_length_211_cov_6.700000_g315367_i0 | PRJEB11748 | 317550 | 211 | 6.7 | 14.137 | Elardia | 2681632 | Tubulinea | other_Eukaryota | 182 | 2.27e-41 | NTclustered | gi|145386791|gb|EF216916.1| | 136459 | g315367 | i0 | 89.583 | 59.3696682464455 | 144 | 13 | 67 | 1 | 49 | 190 | 1511 | 1368 | Paraflabellula hoguae 28S large subunit ribosomal RNA gene, partial sequence | blastn | 12527 | 182 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Paraflabellula | Paraflabellula hoguae | ||
| 16288153 | 16288153 | PRJEB11748_P_NODE_92433_length_435_cov_7.163102_g90265_i0 | PRJEB11748 | 92433 | 435 | 7.163102 | 31.1594937 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 761 | 0 | NTclustered | gi|11527309|gb|AF293902.1|AF293902 | 136464 | g90265 | i0 | 98.605 | 92.9287356321839 | 430 | 6 | 99 | 0 | 6 | 435 | 789 | 1218 | Saccamoeba limax small subunit ribosomal RNA gene, complete sequence | blastn | 40424 | 767 | 0.992177314211212 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 16591638 | 16591638 | PRJEB11748_P_NODE_145314_length_341_cov_4.667857_g143134_i0 | PRJEB11748 | 145314 | 341 | 4.667857 | 15.91739237 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 195 | 5.0599999999999995e-45 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g143134 | i0 | 85.263 | 40.7859237536657 | 190 | 27 | 55 | 1 | 1 | 189 | 4137 | 4326 | Rhizamoeba saxonica 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 | 13908 | 195 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 18834884 | 18834884 | PRJEB11748_P_NODE_156615_length_327_cov_5.879699_g154433_i0 | PRJEB11748 | 156615 | 327 | 5.879699 | 19.22661573 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 558 | 1.49e-154 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g154433 | i0 | 99.672 | 56.434250764526 | 305 | 1 | 93 | 0 | 23 | 327 | 931 | 1235 | 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 | 18454 | 558 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22965975 | 22965975 | PRJEB11748_P_NODE_113419_length_390_cov_11.547112_g111245_i0 | PRJEB11748 | 113419 | 390 | 11.547112 | 45.0337368 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 678 | 0 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g111245 | i0 | 100 | 0.941025641025641 | 367 | 0 | 94 | 0 | 24 | 390 | 14983 | 14617 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 367 | 678 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25210220 | 25210220 | PRJEB11748_P_NODE_288700_length_225_cov_2.353659_g286517_i0 | PRJEB11748 | 288700 | 225 | 2.353659 | 5.29573275 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 329 | 8.25e-86 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g286517 | i0 | 96.098 | 2.72888888888889 | 205 | 3 | 90 | 4 | 4 | 205 | 5772 | 5570 | 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 | 614 | 329 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;