contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1137393" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1559261 | 1559261 | PRJNA1137393_P_NODE_23242_length_193_cov_1.250000_g22726_i0 | PRJNA1137393 | 23242 | 193 | 1.25 | 2.4125 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 132 | 2.08e-26 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g22726 | i0 | 79.787 | 12.7461139896373 | 188 | 32 | 97 | 6 | 6 | 193 | 27854 | 28035 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 2460 | 132 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5387884 | 5387884 | PRJNA1137393_P_NODE_26625_length_187_cov_1.137681_g26109_i0 | PRJNA1137393 | 26625 | 187 | 1.137681 | 2.12746347 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 248 | 1.9e-61 | NTclustered | gi|470423287|ref|XM_004337534.1| | 1257118 | g26109 | i0 | 90.957 | 1.00534759358289 | 188 | 11 | 99 | 3 | 3 | 187 | 1743 | 1927 | Acanthamoeba castellanii str. Neff Phosphatidylinositol-3,4,5-trisphosphate 3-phosphatase (ACA1_164180), partial mRNA | blastn | 188 | 248 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9212665 | 9212665 | PRJNA1137393_P_NODE_26768_length_186_cov_51.445255_g26252_i0 | PRJNA1137393 | 26768 | 186 | 51.445255 | 95.6881743 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 91.6 | 3.37e-14 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g26252 | i0 | 100 | 17.5645161290323 | 49 | 0 | 26 | 0 | 1 | 49 | 5161 | 5209 | Acanthamoeba castellanii 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 | 3267 | 91.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9212846 | 9212846 | PRJNA1137393_P_NODE_75368_length_151_cov_87.470588_g74852_i0 | PRJNA1137393 | 75368 | 151 | 87.470588 | 132.08058788 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 183 | 4.19e-42 | NTclustered | gi|290886108|gb|GU477644.1| | 472931 | g74852 | i0 | 96.396 | 8.35099337748344 | 111 | 4 | 74 | 0 | 41 | 151 | 864 | 754 | Protostelium mycophagum strain HI04-85A-1b 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence | blastn | 1261 | 183 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 10488256 | 10488256 | PRJNA1137393_P_NODE_35489_length_173_cov_41.967742_g34973_i0 | PRJNA1137393 | 35489 | 173 | 41.967742 | 72.60419366 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 298 | 1.69e-76 | NTclustered | gi|262262902|gb|FJ766445.1| | 472931 | g34973 | i0 | 97.688 | 72.728323699422 | 173 | 4 | 100 | 0 | 1 | 173 | 1639 | 1811 | Protostelium mycophagum strain KA-T02-1 small subunit ribosomal RNA gene, partial sequence | blastn | 12582 | 298 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 14313615 | 14313615 | PRJNA1137393_P_NODE_2452_length_619_cov_18.405263_g1965_i0 | PRJNA1137393 | 2452 | 619 | 18.405263 | 113.92857797 | Mycamoeba gemmipara | 1895019 | Discosea | other_Eukaryota | 872 | 0 | NTclustered | gi|1060138309|gb|KX687875.1| | 1895019 | g1965 | i0 | 92.135 | 65.8578352180937 | 623 | 39 | 100 | 7 | 1 | 619 | 457 | 1073 | Mycamoeba gemmipara small subunit ribosomal RNA gene, partial sequence | blastn | 40766 | 872 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Mycamoeba | Mycamoeba gemmipara | ||||
| 16861919 | 16861919 | PRJNA1137393_P_NODE_6614_length_331_cov_16.595745_g6098_i0 | PRJNA1137393 | 6614 | 331 | 16.595745 | 54.93191595 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 411 | 4.459999999999999e-110 | NTclustered | gi|290886107|gb|GU477643.1| | 472931 | g6098 | i0 | 99.123 | 98.8489425981873 | 228 | 2 | 69 | 0 | 1 | 228 | 333 | 106 | Protostelium mycophagum strain BRNFDF05-11a-3 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence | blastn | 32719 | 411 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 19410582 | 19410582 | PRJNA1137393_P_NODE_13156_length_232_cov_11.672131_g12640_i0 | PRJNA1137393 | 13156 | 232 | 11.672131 | 27.07934392 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 422 | 1.37e-113 | NTclustered | gi|262262901|gb|FJ766444.1| | 472931 | g12640 | i0 | 99.567 | 43.5560344827586 | 231 | 1 | 99 | 0 | 1 | 231 | 1243 | 1473 | Protostelium mycophagum strain BRNFDF05-11A-3 small subunit ribosomal RNA gene, partial sequence | blastn | 10105 | 422 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 22708999 | 22708999 | PRJNA1137393_P_NODE_8698_length_282_cov_3.120172_g8182_i0 | PRJNA1137393 | 8698 | 282 | 3.120172 | 8.79888504 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 207 | 5.25e-49 | NTclustered | gi|1772960585|gb|MN240294.1| | 5756 | g8182 | i0 | 80.952 | 85.9964539007092 | 273 | 42 | 95 | 9 | 3 | 270 | 687 | 420 | Acanthamoeba sp. voucher OSU-07-101 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 24251 | 209 | 0.990430622009569 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba sp. | |||
| 24510586 | 24510586 | PRJNA1137393_P_NODE_12220_length_239_cov_14.484211_g11704_i0 | PRJNA1137393 | 12220 | 239 | 14.484211 | 34.61726429 | Mycamoeba gemmipara | 1895019 | Discosea | other_Eukaryota | 414 | 2.38e-111 | NTclustered | gi|1060138309|gb|KX687875.1| | 1895019 | g11704 | i0 | 97.908 | 73 | 239 | 5 | 100 | 0 | 1 | 239 | 1204 | 1442 | Mycamoeba gemmipara small subunit ribosomal RNA gene, partial sequence | blastn | 17447 | 414 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Mycamoeba | Mycamoeba gemmipara |
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);;