contig_metadata
15 rows where bioproject = "PRJNA400391", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3631887 | 3631887 | PRJNA400391_S_NODE_5243_length_172_cov_12.729927_g5182_i0 | PRJNA400391 | 5243 | 172 | 12.729927 | 21.89547444 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 316 | 4.629999999999998e-82 | NTclustered | gi|11527309|gb|AF293902.1|AF293902 | 136464 | g5182 | i0 | 100 | 96.9476744186046 | 171 | 0 | 99 | 0 | 1 | 171 | 174 | 4 | Saccamoeba limax small subunit ribosomal RNA gene, complete sequence | blastn | 16675 | 318 | 0.993710691823899 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 3631894 | 3631894 | PRJNA400391_S_NODE_5503_length_168_cov_15.458647_g5442_i0 | PRJNA400391 | 5503 | 168 | 15.458647 | 25.97052696 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 307 | 2.73e-79 | NTclustered | gi|11527309|gb|AF293902.1|AF293902 | 136464 | g5442 | i0 | 100 | 98.3571428571429 | 166 | 0 | 99 | 0 | 3 | 168 | 1215 | 1050 | Saccamoeba limax small subunit ribosomal RNA gene, complete sequence | blastn | 16524 | 307 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 4909001 | 4909001 | PRJNA400391_S_NODE_1384_length_320_cov_5.178947_g1323_i0 | PRJNA400391 | 1384 | 320 | 5.178947 | 16.5726304 | Arcellinida | 318493 | Tubulinea | other_Eukaryota | 575 | 1.44e-159 | NTclustered | gi|166203599|gb|EU392157.1| | 499111 | g1323 | i0 | 99.065 | 79.184375 | 321 | 2 | 100 | 1 | 1 | 320 | 164 | 484 | Heleopera rosea from Switzerland small subunit ribosomal RNA gene, partial sequence | blastn | 25339 | 575 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Heleoperidae | Heleopera | Heleopera rosea | ||
| 5517863 | 5517863 | PRJNA400391_S_NODE_5085_length_175_cov_2.378571_g5024_i0 | PRJNA400391 | 5085 | 175 | 2.378571 | 4.16249925 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 318 | 1.32e-82 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g5024 | i0 | 99.429 | 11.4228571428571 | 175 | 1 | 100 | 0 | 1 | 175 | 3503 | 3677 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1999 | 318 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 6184119 | 6184119 | PRJNA400391_S_NODE_2665_length_245_cov_13.957143_g2604_i0 | PRJNA400391 | 2665 | 245 | 13.957143 | 34.19500035 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 448 | 2.41e-121 | NTclustered | gi|11527309|gb|AF293902.1|AF293902 | 136464 | g2604 | i0 | 100 | 97.4326530612245 | 242 | 0 | 99 | 0 | 1 | 242 | 808 | 1049 | Saccamoeba limax small subunit ribosomal RNA gene, complete sequence | blastn | 23871 | 448 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 8067407 | 8067407 | PRJNA400391_S_NODE_4167_length_197_cov_2.623457_g4106_i0 | PRJNA400391 | 4167 | 197 | 2.623457 | 5.16821029 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 267 | 5.599999999999999e-67 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g4106 | i0 | 91.71 | 0.979695431472081 | 193 | 14 | 97 | 1 | 6 | 196 | 2944 | 2752 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 193 | 267 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 9342290 | 9342290 | PRJNA400391_S_NODE_5788_length_163_cov_2.437500_g5727_i0 | PRJNA400391 | 5788 | 163 | 2.4375 | 3.973125 | Paraflabellula hoguae | 136459 | Tubulinea | other_Eukaryota | 241 | 2.7000000000000008e-59 | NTclustered | gi|145386791|gb|EF216916.1| | 136459 | g5727 | i0 | 93.252 | 65.5950920245399 | 163 | 11 | 100 | 0 | 1 | 163 | 333 | 171 | Paraflabellula hoguae 28S large subunit ribosomal RNA gene, partial sequence | blastn | 10692 | 241 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Paraflabellula | Paraflabellula hoguae | ||
| 9342310 | 9342310 | PRJNA400391_S_NODE_688_length_402_cov_3.258856_g628_i0 | PRJNA400391 | 688 | 402 | 3.258856 | 13.10060112 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 671 | 0 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g628 | i0 | 97.015 | 4.12686567164179 | 402 | 7 | 100 | 3 | 1 | 402 | 3937 | 4333 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1659 | 671 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 10009132 | 10009132 | PRJNA400391_S_NODE_4388_length_191_cov_3.083333_g4327_i0 | PRJNA400391 | 4388 | 191 | 3.083333 | 5.88916603 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 353 | 4.02e-93 | NTclustered | gi|11527309|gb|AF293902.1|AF293902 | 136464 | g4327 | i0 | 100 | 97.5916230366492 | 191 | 0 | 100 | 0 | 1 | 191 | 1348 | 1538 | Saccamoeba limax small subunit ribosomal RNA gene, complete sequence | blastn | 18640 | 353 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 15716754 | 15716754 | PRJNA400391_S_NODE_2693_length_244_cov_3.952153_g2632_i0 | PRJNA400391 | 2693 | 244 | 3.952153 | 9.64325332 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 298 | 2.56e-76 | NTclustered | gi|421976368|gb|JQ519502.1| | 160823 | g2632 | i0 | 89.496 | 96.1598360655738 | 238 | 21 | 97 | 4 | 4 | 239 | 1089 | 854 | Chaos carolinense clone JG10.98 18S ribosomal RNA gene, partial sequence | blastn | 23463 | 298 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 19539869 | 19539869 | PRJNA400391_S_NODE_4516_length_188_cov_3.418301_g4455_i0 | PRJNA400391 | 4516 | 188 | 3.418301 | 6.42640588 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 259 | 8.84e-65 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g4455 | i0 | 91.489 | 1.31914893617021 | 188 | 16 | 100 | 0 | 1 | 188 | 4503 | 4690 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 248 | 259 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 22090572 | 22090572 | PRJNA400391_S_NODE_5338_length_171_cov_2.463235_g5277_i0 | PRJNA400391 | 5338 | 171 | 2.463235 | 4.21213185 | Polychaos sp. OK-2023a | 3107887 | Tubulinea | other_Eukaryota | 250 | 4.73e-62 | NTclustered | gi|2634048133|gb|OR947210.1| | 3107887 | g5277 | i0 | 93.976 | 29.6315789473684 | 166 | 9 | 97 | 1 | 2 | 167 | 985 | 821 | Polychaos sp. OK-2023a small subunit ribosomal RNA gene, partial sequence | blastn | 5067 | 250 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Polychaos | Polychaos sp. OK-2023a | ||
| 22090595 | 22090595 | PRJNA400391_S_NODE_658_length_409_cov_5.951872_g598_i0 | PRJNA400391 | 658 | 409 | 5.951872 | 24.34315648 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 739 | 0 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g598 | i0 | 99.267 | 75.4572127139364 | 409 | 3 | 100 | 0 | 1 | 409 | 2675 | 2267 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 30862 | 739 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 23366166 | 23366166 | PRJNA400391_S_NODE_4239_length_195_cov_6.337500_g4178_i0 | PRJNA400391 | 4239 | 195 | 6.3375 | 12.358125 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 344 | 2.48e-90 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g4178 | i0 | 98.462 | 17.2564102564103 | 195 | 3 | 100 | 0 | 1 | 195 | 3083 | 3277 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 3365 | 344 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 23366193 | 23366193 | PRJNA400391_S_NODE_5739_length_164_cov_2.015504_g5678_i0 | PRJNA400391 | 5739 | 164 | 2.015504 | 3.30542656 | Polychaos centronucleolus | 2762048 | Tubulinea | other_Eukaryota | 257 | 2.7e-64 | NTclustered | gi|1887703455|gb|MT874850.1| | 2762048 | g5678 | i0 | 98.621 | 4.23780487804878 | 145 | 2 | 88 | 0 | 20 | 164 | 115 | 259 | Polychaos centronucleolus strain DKis1.1 small subunit ribosomal RNA gene, partial sequence | blastn | 695 | 257 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Polychaos | Polychaos centronucleolus |
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);;