contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJEB75230" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1412140 | 1412140 | PRJEB75230_P_NODE_6242_length_561_cov_14.157787_g6060_i0 | PRJEB75230 | 6242 | 561 | 14.157787 | 79.42518507 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 255 | 3.93e-63 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g6060 | i0 | 81.329 | 55.3529411764706 | 316 | 58 | 56 | 1 | 128 | 442 | 107 | 422 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 31053 | 255 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 3964107 | 3964107 | PRJEB75230_P_NODE_88664_length_272_cov_1.763819_g88482_i0 | PRJEB75230 | 88664 | 272 | 1.763819 | 4.79758768 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 385 | 2.17e-102 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g88482 | i0 | 92.251 | 100.003676470588 | 271 | 21 | 99 | 0 | 1 | 271 | 812 | 542 | Platyamoeba placida actin mRNA, partial cds | blastn | 27201 | 385 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 5238562 | 5238562 | PRJEB75230_P_NODE_123645_length_250_cov_1.299435_g123463_i0 | PRJEB75230 | 123645 | 250 | 1.299435 | 3.2485875 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 206 | 1.6399999999999998e-48 | NTclustered | gi|470523596|ref|XM_004354991.1| | 1257118 | g123463 | i0 | 84.541 | 50.748 | 207 | 32 | 83 | 0 | 1 | 207 | 207 | 1 | Acanthamoeba castellanii str. Neff rasrelated protein Rab-7, putative (ACA1_346040), partial mRNA | blastn | 12687 | 206 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9064329 | 9064329 | PRJEB75230_P_NODE_3308_length_745_cov_2.032738_g3141_i0 | PRJEB75230 | 3308 | 745 | 2.032738 | 15.1438981 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 933 | 0 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g3141 | i0 | 89.262 | 97.938255033557 | 745 | 80 | 100 | 0 | 1 | 745 | 1049 | 305 | Platyamoeba placida actin mRNA, partial cds | blastn | 72964 | 933 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 9064509 | 9064509 | PRJEB75230_P_NODE_4348_length_656_cov_12.096055_g4171_i0 | PRJEB75230 | 4348 | 656 | 12.096055 | 79.3501208 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 56.5 | 0.005 | NTclustered | gi|470378920|ref|XM_004333477.1| | 1257118 | g4171 | i0 | 94.444 | 0.0548780487804878 | 36 | 2 | 5 | 0 | 93 | 128 | 78 | 43 | Acanthamoeba castellanii str. Neff Actobindin, putative (ACA1_256510), partial mRNA | blastn | 36 | 56.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9064959 | 9064959 | PRJEB75230_P_NODE_73008_length_286_cov_1.084507_g72826_i0 | PRJEB75230 | 73008 | 286 | 1.084507 | 3.10169002 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 111 | 4.3e-20 | NTclustered | gi|470380148|ref|XM_004333613.1| | 1257118 | g72826 | i0 | 83.74 | 0.43006993006993 | 123 | 14 | 42 | 5 | 18 | 137 | 567 | 686 | Acanthamoeba castellanii str. Neff actin bundling protein (ACA1_260120), partial mRNA | blastn | 123 | 111 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9065208 | 9065208 | PRJEB75230_P_NODE_89968_length_271_cov_1.555556_g89786_i0 | PRJEB75230 | 89968 | 271 | 1.555556 | 4.21555676 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 211 | 3.87e-50 | NTclustered | gi|470406900|ref|XM_004335952.1| | 1257118 | g89786 | i0 | 81.132 | 56.9889298892989 | 265 | 48 | 97 | 2 | 5 | 268 | 226 | 489 | Acanthamoeba castellanii str. Neff ribosomal protein S4, putative (ACA1_365780), partial mRNA | blastn | 15444 | 211 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12475133 | 12475133 | PRJEB75230_P_NODE_650_length_1467_cov_3.942611_g568_i0 | PRJEB75230 | 650 | 1467 | 3.942611 | 57.83810337 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 760 | 0 | NTclustered | gi|881634|gb|U29610.1|ACU29610 | 5755 | g568 | i0 | 79.342 | 37.4935241990457 | 1094 | 216 | 74 | 7 | 105 | 1193 | 1312 | 224 | Acanthaoeba castellanii actin-related protein 3 Arp3 mRNA, complete cds | blastn | 55003 | 760 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12890715 | 12890715 | PRJEB75230_P_NODE_3731_length_705_cov_14.590190_g3557_i0 | PRJEB75230 | 3731 | 705 | 14.59019 | 102.8608395 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 379 | 2.84e-100 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g3557 | i0 | 78.176 | 69.6510638297872 | 614 | 120 | 86 | 13 | 81 | 687 | 607 | 1 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 49104 | 379 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12890824 | 12890824 | PRJEB75230_P_NODE_4531_length_645_cov_2.103147_g4353_i0 | PRJEB75230 | 4531 | 645 | 2.103147 | 13.56529815 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 346 | 2.63e-90 | NTclustered | gi|470504026|ref|XM_004348289.1| | 1257118 | g4353 | i0 | 79.079 | 63.5968992248062 | 521 | 95 | 80 | 12 | 4 | 517 | 572 | 59 | Acanthamoeba castellanii str. Neff H(+)-transporting atpase family protein (ACA1_022710), partial mRNA | blastn | 41020 | 346 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12891603 | 12891603 | PRJEB75230_P_NODE_991_length_1234_cov_6.360034_g885_i0 | PRJEB75230 | 991 | 1234 | 6.360034 | 78.48281956 | Vannella ebro | 207334 | Discosea | other_Eukaryota | 1369 | 0 | NTclustered | gi|33946344|gb|AY294151.1| | 207334 | g885 | i0 | 88.642 | 88.4789303079417 | 1127 | 124 | 91 | 4 | 13 | 1137 | 13 | 1137 | Vannella ebro actin mRNA, complete cds | blastn | 109183 | 1369 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella ebro | |||
| 19262404 | 19262404 | PRJEB75230_P_NODE_20496_length_382_cov_1.291262_g20314_i0 | PRJEB75230 | 20496 | 382 | 1.291262 | 4.93262084 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 111 | 5.93e-20 | NTclustered | gi|470428251|ref|XM_004338026.1| | 1257118 | g20314 | i0 | 76.812 | 0.541884816753927 | 207 | 43 | 54 | 3 | 123 | 328 | 708 | 506 | Acanthamoeba castellanii str. Neff TolAlike protein (ACA1_224400), partial mRNA | blastn | 207 | 111 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19262518 | 19262518 | PRJEB75230_P_NODE_26856_length_359_cov_0.860140_g26674_i0 | PRJEB75230 | 26856 | 359 | 0.86014 | 3.0879026 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 440 | 6.209999999999997e-119 | NTclustered | gi|470484649|ref|XM_004344039.1| | 1257118 | g26674 | i0 | 89.625 | 90.3899721448468 | 347 | 34 | 96 | 2 | 14 | 359 | 5757 | 5412 | Acanthamoeba castellanii str. Neff PremRNA processing splicing factor 8, putative (ACA1_054320), partial mRNA | blastn | 32450 | 440 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 20538987 | 20538987 | PRJEB75230_P_NODE_96377_length_266_cov_1.569948_g96195_i0 | PRJEB75230 | 96377 | 266 | 1.569948 | 4.17606168 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 165 | 2.99e-36 | NTclustered | gi|470431752|ref|XM_004338384.1| | 1257118 | g96195 | i0 | 81.5 | 32.5263157894737 | 200 | 37 | 75 | 0 | 1 | 200 | 830 | 1029 | Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_320830), partial mRNA | blastn | 8652 | 165 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21812746 | 21812746 | PRJEB75230_P_NODE_11998_length_443_cov_3.256757_g11816_i0 | PRJEB75230 | 11998 | 443 | 3.256757 | 14.42743351 | Acanthamoeba sp. 4b3 | 242128 | Discosea | other_Eukaryota | 499 | 1.27e-136 | NTclustered | gi|1107480|emb|X87156.1| | 242128 | g11816 | i0 | 88.152 | 227.067720090293 | 422 | 47 | 95 | 3 | 23 | 442 | 1862 | 2282 | Acanthamoeba sp. 4b3 polyubiquitin gene | blastn | 100591 | 499 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba sp. 4b3 |
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);;