contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1022139" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161605 | 161605 | PRJNA1022139_P_NODE_2381_length_797_cov_8.785912_g2296_i0 | PRJNA1022139 | 2381 | 797 | 8.785912 | 70.02371864 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 970 | 0 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g2296 | i0 | 90.871 | 94.0639899623588 | 723 | 66 | 91 | 0 | 75 | 797 | 1182 | 460 | Platyamoeba placida actin mRNA, partial cds | blastn | 74969 | 970 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 1436292 | 1436292 | PRJNA1022139_P_NODE_10282_length_415_cov_4.301170_g10177_i0 | PRJNA1022139 | 10282 | 415 | 4.30117 | 17.8498555 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 351 | 3.51e-92 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g10177 | i0 | 82.143 | 44.5253012048193 | 420 | 65 | 100 | 8 | 1 | 415 | 1902 | 2316 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 18478 | 351 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 1436573 | 1436573 | PRJNA1022139_P_NODE_5922_length_534_cov_2.770065_g5818_i0 | PRJNA1022139 | 5922 | 534 | 2.7700650000000002 | 14.7921471 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 852 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g5818 | i0 | 95.531 | 101.432584269663 | 537 | 16 | 99 | 8 | 1 | 533 | 543 | 11 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 54165 | 852 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 1436591 | 1436591 | PRJNA1022139_P_NODE_7962_length_466_cov_4.134860_g7857_i0 | PRJNA1022139 | 7962 | 466 | 4.13486 | 19.2684476 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 215 | 5.46e-51 | NTclustered | gi|470467440|ref|XM_004341747.1| | 1257118 | g7857 | i0 | 78.035 | 26.9763948497854 | 346 | 72 | 74 | 4 | 62 | 405 | 379 | 36 | Acanthamoeba castellanii str. Neff guanine nucleotide-binding protein beta subunit, putative (ACA1_199990), partial mRNA | blastn | 12571 | 215 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6539752 | 6539752 | PRJNA1022139_P_NODE_12066_length_387_cov_1.789809_g11961_i0 | PRJNA1022139 | 12066 | 387 | 1.789809 | 6.92656083 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 207 | 7.45e-49 | NTclustered | gi|470486807|ref|XM_004344593.1| | 1257118 | g11961 | i0 | 81.496 | 1.57105943152455 | 254 | 45 | 65 | 2 | 53 | 305 | 318 | 66 | Acanthamoeba castellanii str. Neff MC family transporter: phosphate, putative (ACA1_278610), partial mRNA | blastn | 608 | 207 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6539887 | 6539887 | PRJNA1022139_P_NODE_32546_length_257_cov_1.429348_g32441_i0 | PRJNA1022139 | 32546 | 257 | 1.429348 | 3.67342436 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 65.8 | 3e-6 | NTclustered | gi|470375882|ref|XM_004333185.1| | 1257118 | g32441 | i0 | 91.489 | 3.0272373540856 | 47 | 4 | 18 | 0 | 211 | 257 | 231 | 185 | Acanthamoeba castellanii str. Neff ubiquitin domain containing protein (ACA1_389410), partial mRNA | blastn | 778 | 65.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6539958 | 6539958 | PRJNA1022139_P_NODE_40686_length_244_cov_0.859649_g40581_i0 | PRJNA1022139 | 40686 | 244 | 0.859649 | 2.09754356 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 165 | 2.71e-36 | NTclustered | gi|470403960|ref|XM_004335710.1| | 1257118 | g40581 | i0 | 82.888 | 1.80737704918033 | 187 | 28 | 76 | 4 | 52 | 236 | 738 | 554 | Acanthamoeba castellanii str. Neff leucine-tRNA ligase (ACA1_018140), partial mRNA | blastn | 441 | 165 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6540024 | 6540024 | PRJNA1022139_P_NODE_8266_length_458_cov_3.314286_g8161_i0 | PRJNA1022139 | 8266 | 458 | 3.314286 | 15.17942988 | Ripella platypodia | 2047821 | Discosea | other_Eukaryota | 704 | 0 | NTclustered | gi|1269228359|gb|MF683484.1| | 2047821 | g8161 | i0 | 94.577 | 97.1921397379913 | 461 | 15 | 100 | 7 | 1 | 458 | 1185 | 1638 | Ripella platypodia clone 23.4.34 18S ribosomal RNA gene, partial sequence | blastn | 44514 | 704 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 9089155 | 9089155 | PRJNA1022139_P_NODE_1848_length_894_cov_2.261876_g1774_i0 | PRJNA1022139 | 1848 | 894 | 2.261876 | 20.22117144 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 547 | 9.439999999999999e-151 | NTclustered | gi|470423206|ref|XM_004337526.1| | 1257118 | g1774 | i0 | 78.043 | 55.0190156599553 | 920 | 167 | 99 | 26 | 3 | 894 | 1073 | 161 | Acanthamoeba castellanii str. Neff 3oxoacid CoA transferase 1 isoform 3, putative (ACA1_164100), partial mRNA | blastn | 49187 | 547 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10364800 | 10364800 | PRJNA1022139_P_NODE_22849_length_293_cov_3.977273_g22744_i0 | PRJNA1022139 | 22849 | 293 | 3.977273 | 11.65340989 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 424 | 4.999999999999999e-114 | NTclustered | gi|1269228409|gb|MF683534.1| | 2047822 | g22744 | i0 | 92.977 | 83.3037542662116 | 299 | 8 | 100 | 11 | 1 | 293 | 646 | 937 | Ripella decalvata clone 26.1.45 18S ribosomal RNA gene, partial sequence | blastn | 24408 | 424 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 11640372 | 11640372 | PRJNA1022139_P_NODE_5950_length_533_cov_2.628261_g5846_i0 | PRJNA1022139 | 5950 | 533 | 2.628261 | 14.00863113 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 231 | 6.2599999999999985e-56 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g5846 | i0 | 80.464 | 56.3395872420263 | 302 | 59 | 57 | 0 | 111 | 412 | 422 | 121 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 30029 | 231 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14190210 | 14190210 | PRJNA1022139_P_NODE_16832_length_336_cov_2.304183_g16727_i0 | PRJNA1022139 | 16832 | 336 | 2.304183 | 7.74205488 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 239 | 2.27e-58 | NTclustered | gi|470525569|ref|XM_004356569.1| | 1257118 | g16727 | i0 | 79.888 | 1.97916666666667 | 358 | 46 | 100 | 13 | 1 | 336 | 916 | 563 | Acanthamoeba castellanii str. Neff mitochondrial phosphate transporter, putative (ACA1_173800), partial mRNA | blastn | 665 | 239 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 15464265 | 15464265 | PRJNA1022139_P_NODE_12413_length_382_cov_5.022654_g12308_i0 | PRJNA1022139 | 12413 | 382 | 5.022654 | 19.18653828 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 510 | 5e-140 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g12308 | i0 | 90.814 | 98.1806282722513 | 381 | 35 | 99 | 0 | 1 | 381 | 91 | 471 | Platyamoeba placida actin mRNA, partial cds | blastn | 37505 | 510 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 15464423 | 15464423 | PRJNA1022139_P_NODE_3393_length_682_cov_3.773399_g3293_i0 | PRJNA1022139 | 3393 | 682 | 3.773399 | 25.73458118 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 374 | 1.28e-98 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g3293 | i0 | 79.235 | 68.0014662756598 | 549 | 104 | 80 | 8 | 26 | 569 | 1 | 544 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 46377 | 374 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21838467 | 21838467 | PRJNA1022139_P_NODE_26718_length_279_cov_0.932039_g26613_i0 | PRJNA1022139 | 26718 | 279 | 0.932039 | 2.60038881 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 63.9 | 1.19e-5 | NTclustered | gi|470423488|ref|XM_004337555.1| | 1257118 | g26613 | i0 | 87.273 | 0.681003584229391 | 55 | 7 | 20 | 0 | 131 | 185 | 73 | 19 | Acanthamoeba castellanii str. Neff ribosomal protein L23, putative (ACA1_164710), partial mRNA | blastn | 190 | 63.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21838640 | 21838640 | PRJNA1022139_P_NODE_5438_length_555_cov_3.271784_g5334_i0 | PRJNA1022139 | 5438 | 555 | 3.271784 | 18.1584012 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 278 | 8.28e-70 | NTclustered | gi|470442906|ref|XM_004339540.1| | 1257118 | g5334 | i0 | 84.507 | 22.3675675675676 | 284 | 40 | 51 | 4 | 227 | 508 | 302 | 21 | Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA | blastn | 12414 | 278 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;