contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1057075" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5279361 | 5279361 | PRJNA1057075_S_NODE_6945_length_178_cov_3.124031_g6846_i0 | PRJNA1057075 | 6945 | 178 | 3.124031 | 5.56077518 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 76.8 | 8.94e-10 | NTclustered | gi|470375882|ref|XM_004333185.1| | 1257118 | g6846 | i0 | 92.453 | 7.17415730337079 | 53 | 4 | 30 | 0 | 1 | 53 | 179 | 231 | Acanthamoeba castellanii str. Neff ubiquitin domain containing protein (ACA1_389410), partial mRNA | blastn | 1277 | 76.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6114453 | 6114453 | PRJNA1057075_S_NODE_2925_length_251_cov_2.237624_g2826_i0 | PRJNA1057075 | 2925 | 251 | 2.237624 | 5.61643624 | Ripella | 1217112 | Discosea | other_Eukaryota | 385 | 1.97e-102 | NTclustered | gi|1269228355|gb|MF683480.1| | 2047821 | g2826 | i0 | 97.768 | 89.593625498008 | 224 | 3 | 89 | 2 | 28 | 250 | 993 | 771 | Ripella platypodia clone 23.4.29 18S ribosomal RNA gene, partial sequence | blastn | 22488 | 387 | 0.994832041343669 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 7829204 | 7829204 | PRJNA1057075_S_NODE_6187_length_186_cov_2.204380_g6088_i0 | PRJNA1057075 | 6187 | 186 | 2.20438 | 4.1001468 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 283 | 5.179999999999999e-72 | NTclustered | gi|659103926|gb|KJ569726.1| | 1512276 | g6088 | i0 | 94.624 | 15.4193548387097 | 186 | 5 | 98 | 4 | 1 | 183 | 379 | 196 | Cochliopodium kieliense clone 9605 18S ribosomal RNA gene, partial sequence | blastn | 2868 | 283 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 9104207 | 9104207 | PRJNA1057075_S_NODE_2248_length_274_cov_2.377778_g2149_i0 | PRJNA1057075 | 2248 | 274 | 2.377778 | 6.51511172 | Ripella sp. PS2 | 1217116 | Discosea | other_Eukaryota | 503 | 5.78e-138 | NTclustered | gi|399764205|gb|JQ271716.1| | 1217116 | g2149 | i0 | 100 | 99.992700729927 | 272 | 0 | 99 | 0 | 1 | 272 | 414 | 143 | Ripella sp. PS2 18S ribosomal RNA gene, partial sequence | blastn | 27398 | 503 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. PS2 | |||
| 12930322 | 12930322 | PRJNA1057075_S_NODE_4211_length_218_cov_58.041420_g4112_i0 | PRJNA1057075 | 4211 | 218 | 58.04142 | 126.5302956 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 211 | 3e-50 | NTclustered | gi|659103927|gb|KJ569727.1| | 1512276 | g4112 | i0 | 86.364 | 25.6422018348624 | 198 | 21 | 90 | 3 | 1 | 196 | 1091 | 1284 | Cochliopodium kieliense clone 9611 18S ribosomal RNA gene, partial sequence | blastn | 5590 | 211 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 18028402 | 18028402 | PRJNA1057075_S_NODE_415_length_449_cov_30446.410000_g329_i0 | PRJNA1057075 | 415 | 449 | 30446.41 | 136704.3809 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 99 | 5.51e-16 | NTclustered | gi|262262904|gb|FJ766447.1| | 472931 | g329 | i0 | 78.344 | 21.913140311804 | 157 | 30 | 35 | 4 | 295 | 449 | 1298 | 1144 | Protostelium mycophagum strain HI06-7A-1 small subunit ribosomal RNA gene, partial sequence | blastn | 9839 | 99 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 19302303 | 19302303 | PRJNA1057075_S_NODE_236_length_511_cov_23265.906926_g176_i0 | PRJNA1057075 | 236 | 511 | 23265.906926 | 118888.78439186 | Cochliopodium kieliense | 1512276 | Discosea | other_Eukaryota | 448 | 5.4599999999999985e-121 | NTclustered | gi|659103927|gb|KJ569727.1| | 1512276 | g176 | i0 | 84.764 | 40.7866927592955 | 466 | 49 | 90 | 21 | 4 | 461 | 592 | 1043 | Cochliopodium kieliense clone 9611 18S ribosomal RNA gene, partial sequence | blastn | 20842 | 448 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium kieliense | |||
| 24402593 | 24402593 | PRJNA1057075_S_NODE_7400_length_174_cov_4.288000_g7301_i0 | PRJNA1057075 | 7400 | 174 | 4.288 | 7.46112 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 97.1 | 6.67e-16 | NTclustered | gi|221185881|gb|FJ577828.1| | 590481 | g7301 | i0 | 91.429 | 23.3505747126437 | 70 | 6 | 40 | 0 | 1 | 70 | 1243 | 1312 | Uncultured Amoebozoa clone Joinv04 18S ribosomal RNA gene, partial sequence | blastn | 4063 | 97.1 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa |
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);;