contig_metadata
10 rows where bioproject = "PRJEB73599", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2685242 | 2685242 | PRJEB73599_P_NODE_2823_length_433_cov_3.841584_g2544_i0 | PRJEB73599 | 2823 | 433 | 3.841584 | 16.63405872 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 492 | 2.0799999999999995e-134 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g2544 | i0 | 87.471 | 37.7528868360277 | 431 | 48 | 99 | 6 | 1 | 428 | 66 | 493 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 16347 | 492 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 2685282 | 2685282 | PRJEB73599_P_NODE_823_length_834_cov_31.795031_g407_i1 | PRJEB73599 | 823 | 834 | 31.795031 | 265.17055854 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 1083 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g407 | i1 | 99.662 | 126.717026378897 | 592 | 2 | 71 | 0 | 243 | 834 | 1206 | 1797 | 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 | 105682 | 1083 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5237772 | 5237772 | PRJEB73599_P_NODE_9225_length_167_cov_1.702899_g8938_i0 | PRJEB73599 | 9225 | 167 | 1.702899 | 2.84384133 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 211 | 2.18e-50 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g8938 | i0 | 91.083 | 0.940119760479042 | 157 | 12 | 94 | 2 | 1 | 157 | 472 | 626 | 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 | 157 | 211 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6513262 | 6513262 | PRJEB73599_P_NODE_3466_length_381_cov_28.218750_g3180_i0 | PRJEB73599 | 3466 | 381 | 28.21875 | 107.5134375 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 671 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g3180 | i0 | 98.425 | 35.7296587926509 | 381 | 6 | 100 | 0 | 1 | 381 | 6720 | 7100 | 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 | 13613 | 671 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12474458 | 12474458 | PRJEB73599_P_NODE_5690_length_262_cov_13.725322_g5403_i0 | PRJEB73599 | 5690 | 262 | 13.725322 | 35.96034364 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 484 | 1.99e-132 | NTclustered | gi|421976371|gb|JQ519505.1| | 5778 | g5403 | i0 | 100 | 99.9923664122137 | 262 | 0 | 100 | 0 | 1 | 262 | 126 | 387 | Vermamoeba vermiformis clone JG10.99 18S ribosomal RNA gene, partial sequence | blastn | 26198 | 484 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12888768 | 12888768 | PRJEB73599_P_NODE_8411_length_182_cov_9.496732_g8124_i0 | PRJEB73599 | 8411 | 182 | 9.496732 | 17.28405224 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 296 | 6.48e-76 | NTclustered | gi|46393848|gb|AY502960.1| | 5778 | g8124 | i0 | 100 | 87.8791208791209 | 160 | 0 | 88 | 0 | 1 | 160 | 1819 | 1660 | Hartmannella vermiformis isolate KWR-2 18S ribosomal RNA gene, partial sequence | blastn | 15994 | 296 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17573438 | 17573438 | PRJEB73599_P_NODE_9114_length_169_cov_2.114286_g8827_i0 | PRJEB73599 | 9114 | 169 | 2.114286 | 3.57314334 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 302 | 1.27e-77 | NTclustered | gi|24527245|gb|AY145442.1| | 211864 | g8827 | i0 | 98.817 | 17.4319526627219 | 169 | 2 | 100 | 0 | 1 | 169 | 248 | 416 | Hartmannellidae sp. LOS7N/I small subunit ribosomal RNA gene, complete sequence | blastn | 2946 | 302 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannellidae sp. LOS7N/I | |||
| 20122017 | 20122017 | PRJEB73599_P_NODE_3716_length_363_cov_28.356287_g3430_i0 | PRJEB73599 | 3716 | 363 | 28.356287 | 102.93332181 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 671 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g3430 | i0 | 100 | 54.5619834710744 | 363 | 0 | 100 | 0 | 1 | 363 | 872 | 1234 | 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 | 19806 | 671 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20536115 | 20536115 | PRJEB73599_P_NODE_9177_length_168_cov_1.899281_g8890_i0 | PRJEB73599 | 9177 | 168 | 1.899281 | 3.19079208 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 311 | 2.11e-80 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g8890 | i0 | 100 | 41.3035714285714 | 168 | 0 | 100 | 0 | 1 | 168 | 19372 | 19205 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 6939 | 311 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25221636 | 25221636 | PRJEB73599_P_NODE_1540_length_598_cov_36.117750_g1322_i0 | PRJEB73599 | 1540 | 598 | 36.11775 | 215.984145 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1048 | 0 | NTclustered | gi|2777861736|gb|PQ072230.1| | 5778 | g1322 | i0 | 97.826 | 83.061872909699 | 598 | 12 | 100 | 1 | 1 | 598 | 902 | 306 | Vermamoeba vermiformis strain CCAP_1534_12_consensus_sequence small subunit ribosomal RNA gene, partial sequence | blastn | 49671 | 1048 | 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);;