contig_metadata
13 rows where bioproject = "PRJNA493828", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1106597 | 1106597 | PRJNA493828_P_NODE_46881_length_205_cov_6.136364_g46462_i0 | PRJNA493828 | 46881 | 205 | 6.136364 | 12.5795462 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 379 | 7.229999999999999e-101 | NTclustered | gi|89243398|gb|DQ407529.1| | 5778 | g46462 | i0 | 100 | 100.034146341463 | 205 | 0 | 100 | 0 | 1 | 205 | 238 | 442 | Hartmannella vermiformis isolate WWS1.5 18S ribosomal RNA gene gene, partial sequence | blastn | 20507 | 379 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 1749469 | 1749469 | PRJNA493828_P_NODE_18162_length_295_cov_4.027027_g17743_i0 | PRJNA493828 | 18162 | 295 | 4.027027 | 11.87972965 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 387 | 6.61e-103 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g17743 | i0 | 90.572 | 1.00677966101695 | 297 | 21 | 100 | 6 | 1 | 295 | 620 | 329 | 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 | 297 | 387 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 1749965 | 1749965 | PRJNA493828_P_NODE_7262_length_414_cov_418.568915_g6850_i0 | PRJNA493828 | 7262 | 414 | 418.568915 | 1732.8753081 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 737 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g6850 | i0 | 98.792 | 36.9903381642512 | 414 | 5 | 100 | 0 | 1 | 414 | 6691 | 7104 | 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 | 15314 | 737 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6852084 | 6852084 | PRJNA493828_P_NODE_11766_length_337_cov_3.147727_g11347_i0 | PRJNA493828 | 11766 | 337 | 3.147727 | 10.60783999 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 182 | 3.89e-41 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g11347 | i0 | 77.532 | 39.2670623145401 | 316 | 62 | 93 | 8 | 1 | 312 | 3006 | 2696 | 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 | 13233 | 182 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 8127672 | 8127672 | PRJNA493828_P_NODE_23447_length_275_cov_5.584158_g23028_i0 | PRJNA493828 | 23447 | 275 | 5.584158 | 15.3564345 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 377 | 3.67e-100 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g23028 | i0 | 91.367 | 24.6472727272727 | 278 | 20 | 100 | 3 | 1 | 275 | 19373 | 19097 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 6778 | 377 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13859944 | 13859944 | PRJNA493828_P_NODE_10611_length_352_cov_1.462366_g10192_i0 | PRJNA493828 | 10611 | 352 | 1.462366 | 5.14752832 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 499 | 9.89e-137 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g10192 | i0 | 92.179 | 97.2414772727273 | 358 | 21 | 100 | 5 | 1 | 352 | 1217 | 1573 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 34229 | 499 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 14503772 | 14503772 | PRJNA493828_P_NODE_8132_length_394_cov_5.816199_g7717_i0 | PRJNA493828 | 8132 | 394 | 5.816199 | 22.91582406 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 601 | 2.9799999999999993e-167 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g7717 | i0 | 94.015 | 73.8984771573604 | 401 | 16 | 100 | 6 | 1 | 394 | 19990 | 20389 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 29116 | 601 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17052317 | 17052317 | PRJNA493828_P_NODE_5114_length_486_cov_1.673123_g4724_i0 | PRJNA493828 | 5114 | 486 | 1.673123 | 8.13137778 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 569 | 1.0599999999999997e-157 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g4724 | i0 | 88.115 | 2.0679012345679 | 488 | 47 | 100 | 6 | 1 | 486 | 26636 | 27114 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 1005 | 569 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17684165 | 17684165 | PRJNA493828_P_NODE_1514_length_867_cov_231.651134_g1212_i0 | PRJNA493828 | 1514 | 867 | 231.651134 | 2008.41533178 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1524 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g1212 | i0 | 98.385 | 46.8650519031142 | 867 | 14 | 100 | 0 | 1 | 867 | 3138 | 2272 | 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 | 40632 | 1524 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19600795 | 19600795 | PRJNA493828_P_NODE_41856_length_234_cov_2.602484_g41437_i0 | PRJNA493828 | 41856 | 234 | 2.602484 | 6.08981256 | Amoeba leningradensis | 160820 | Tubulinea | other_Eukaryota | 156 | 1.55e-33 | NTclustered | gi|17897590|emb|AJ314605.1| | 160820 | g41437 | i0 | 89.6 | 21.8162393162393 | 125 | 10 | 53 | 3 | 108 | 230 | 225 | 102 | Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6 | blastn | 5105 | 156 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba leningradensis | ||
| 22151014 | 22151014 | PRJNA493828_P_NODE_13898_length_314_cov_3.087137_g13479_i0 | PRJNA493828 | 13898 | 314 | 3.087137 | 9.69361018 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 333 | 9.37e-87 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g13479 | i0 | 86.076 | 1.00636942675159 | 316 | 36 | 100 | 8 | 1 | 314 | 896 | 587 | 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 | 316 | 333 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22151511 | 22151511 | PRJNA493828_P_NODE_45538_length_214_cov_6.936170_g45119_i0 | PRJNA493828 | 45538 | 214 | 6.93617 | 14.8434038 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 265 | 2.22e-66 | NTclustered | gi|493091586|gb|KC161965.1| | 5778 | g45119 | i0 | 100 | 48.1588785046729 | 143 | 0 | 67 | 0 | 69 | 211 | 1837 | 1695 | Vermamoeba vermiformis strain CCAP 1534/16 18S ribosomal RNA gene, partial sequence | blastn | 10306 | 265 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23427352 | 23427352 | PRJNA493828_P_NODE_43679_length_227_cov_4.337662_g43260_i0 | PRJNA493828 | 43679 | 227 | 4.337662 | 9.84649274 | Copromyxa sp. PKD 2011 | 1215977 | Tubulinea | other_Eukaryota | 420 | 4.81e-113 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g43260 | i0 | 100 | 101.418502202643 | 227 | 0 | 100 | 0 | 1 | 227 | 1717 | 1491 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 23022 | 420 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 |
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);;