contig_metadata
12 rows where bioproject = "PRJEB81463" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140643 | 140643 | PRJEB81463_P_NODE_441_length_1438_cov_7.337729_g323_i0 | PRJEB81463 | 441 | 1438 | 7.337729 | 105.51654302 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 1266 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g323 | i0 | 83.297 | 27.5785813630042 | 1389 | 217 | 96 | 11 | 17 | 1393 | 1 | 1386 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 39658 | 1266 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 5243273 | 5243273 | PRJEB81463_P_NODE_6105_length_405_cov_2.680723_g5833_i0 | PRJEB81463 | 6105 | 405 | 2.680723 | 10.85692815 | Saccamoeba lacustris | 704142 | Tubulinea | other_Eukaryota | 647 | 0 | NTclustered | gi|423292025|gb|JQ519458.1| | 704142 | g5833 | i0 | 95.545 | 99.1506172839506 | 404 | 18 | 99 | 0 | 1 | 404 | 199 | 602 | Saccamoeba lacustris clone JG10.115_b9 actin gene, partial cds | blastn | 40156 | 647 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba lacustris | ||
| 5243276 | 5243276 | PRJEB81463_P_NODE_6525_length_392_cov_1.457680_g6253_i0 | PRJEB81463 | 6525 | 392 | 1.45768 | 5.7141056 | Copromyxa sp. PKD 2011 | 1215977 | Tubulinea | other_Eukaryota | 725 | 0 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g6253 | i0 | 100 | 77.4591836734694 | 392 | 0 | 100 | 0 | 1 | 392 | 1062 | 671 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 30364 | 725 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 6100537 | 6100537 | PRJEB81463_P_NODE_28505_length_241_cov_3.279762_g28233_i0 | PRJEB81463 | 28505 | 241 | 3.279762 | 7.90422642 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 222 | 1.56e-53 | NTclustered | gi|1042160947|dbj|LC102280.1| | 239731 | g28233 | i0 | 85.253 | 1.82572614107884 | 217 | 30 | 90 | 2 | 26 | 241 | 348 | 133 | Hartmannella cantabrigiensis gene for elongation factor 2 alpha, partial cds, strain: ALC3 | blastn | 440 | 224 | 0.991071428571429 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 9068005 | 9068005 | PRJEB81463_P_NODE_6868_length_381_cov_5.766234_g6596_i0 | PRJEB81463 | 6868 | 381 | 5.766234 | 21.96935154 | Saccamoeba limax | 136464 | Tubulinea | other_Eukaryota | 697 | 0 | NTclustered | gi|213950421|gb|EU869301.1| | 136464 | g6596 | i0 | 99.737 | 23.0997375328084 | 380 | 1 | 99 | 0 | 2 | 381 | 1874 | 1495 | Saccamoeba limax strain NTSHR small subunit ribosomal RNA gene, partial sequence | blastn | 8801 | 697 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 12894182 | 12894182 | PRJEB81463_P_NODE_491_length_1382_cov_3.245989_g366_i0 | PRJEB81463 | 491 | 1382 | 3.245989 | 44.85956798 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 1548 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g366 | i0 | 87.192 | 27.5586107091172 | 1382 | 151 | 98 | 16 | 1 | 1360 | 1378 | 1 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 38086 | 1548 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 12894193 | 12894193 | PRJEB81463_P_NODE_5771_length_416_cov_5.107872_g5499_i0 | PRJEB81463 | 5771 | 416 | 5.107872 | 21.24874752 | Saccamoeba limax | 136464 | Tubulinea | other_Eukaryota | 739 | 0 | NTclustered | gi|213950421|gb|EU869301.1| | 136464 | g5499 | i0 | 98.801 | 42.1201923076923 | 417 | 2 | 99 | 1 | 2 | 415 | 745 | 1161 | Saccamoeba limax strain NTSHR small subunit ribosomal RNA gene, partial sequence | blastn | 17522 | 739 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 17992013 | 17992013 | PRJEB81463_P_NODE_2275_length_670_cov_4.340034_g2012_i0 | PRJEB81463 | 2275 | 670 | 4.340034 | 29.0782278 | Saccamoeba limax | 136464 | Tubulinea | other_Eukaryota | 1055 | 0 | NTclustered | gi|213950421|gb|EU869301.1| | 136464 | g2012 | i0 | 99.653 | 49.6880597014925 | 577 | 2 | 86 | 0 | 93 | 669 | 1 | 577 | Saccamoeba limax strain NTSHR small subunit ribosomal RNA gene, partial sequence | blastn | 33291 | 1055 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 20541243 | 20541243 | PRJEB81463_P_NODE_11037_length_306_cov_1.330472_g10765_i0 | PRJEB81463 | 11037 | 306 | 1.330472 | 4.07124432 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 566 | 8.239999999999998e-157 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g10765 | i0 | 100 | 61.7941176470588 | 306 | 0 | 100 | 0 | 1 | 306 | 6365 | 6060 | 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 | 18909 | 566 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 27192180 | 27192180 | PRJEB81463_P_NODE_12642_length_290_cov_0.958525_g12370_i0 | PRJEB81463 | 12642 | 290 | 0.958525 | 2.7797225 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 143 | 5.45e-40 | NR | AKN09692.1 | 5775 | g12370 | i0 | 76 | 0.993103448275862 | 96 | 23 | 99.3 | 0 | 2 | 289 | 19 | 114 | AKN09692.1 Tom40 [Amoeba proteus] | diamond | 288 | 143 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 30729384 | 30729384 | PRJEB81463_P_NODE_24754_length_246_cov_2.976879_g24482_i0 | PRJEB81463 | 24754 | 246 | 2.976879 | 7.32312234 | Saccamoeba lacustris | 704142 | Tubulinea | other_Eukaryota | 164 | 1.7099999999999998e-48 | NR | AFX73097.1 | 704142 | g24482 | i0 | 96.3 | 0.98780487804878 | 81 | 3 | 98.8 | 0 | 3 | 245 | 90 | 170 | AFX73097.1 elongation factor 2 alpha, partial [Saccamoeba lacustris] | diamond | 243 | 164 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba lacustris | ||
| 31899205 | 31899205 | PRJEB81463_P_NODE_20357_length_253_cov_0.866667_g20085_i0 | PRJEB81463 | 20357 | 253 | 0.866667 | 2.19266751 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 135 | 6.36e-37 | NR | AKN09689.1 | 5775 | g20085 | i0 | 73.8 | 0.99604743083004 | 84 | 22 | 99.6 | 0 | 1 | 252 | 88 | 171 | AKN09689.1 Tom20 [Amoeba proteus] | diamond | 252 | 135 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus |
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);;