contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2781347 | 2781347 | PRJNA1118794_P_NODE_4563_length_663_cov_26.940678_g3843_i0 | PRJNA1118794 | 4563 | 663 | 26.940678 | 178.61669514 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 854 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g3843 | i0 | 95.229 | 82.4811463046757 | 545 | 17 | 82 | 9 | 1 | 541 | 540 | 1 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 54685 | 854 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 5333786 | 5333786 | PRJNA1118794_P_NODE_43905_length_260_cov_1.647059_g43155_i0 | PRJNA1118794 | 43905 | 260 | 1.647059 | 4.2823534 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 91.6 | 5.02e-14 | NTclustered | gi|470375882|ref|XM_004333185.1| | 1257118 | g43155 | i0 | 93.443 | 5.93076923076923 | 61 | 4 | 23 | 0 | 198 | 258 | 231 | 171 | Acanthamoeba castellanii str. Neff ubiquitin domain containing protein (ACA1_389410), partial mRNA | blastn | 1542 | 91.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5334178 | 5334178 | PRJNA1118794_P_NODE_8605_length_480_cov_1.186732_g7861_i0 | PRJNA1118794 | 8605 | 480 | 1.186732 | 5.6963136 | Vexillifera bacillipedes | 1105345 | Discosea | other_Eukaryota | 593 | 6.189999999999998e-165 | NTclustered | gi|399764261|gb|JQ271772.1| | 1105345 | g7861 | i0 | 89.3 | 33.5166666666667 | 486 | 35 | 99 | 11 | 1 | 479 | 1460 | 1935 | Vexillifera bacillipedes strain 6HZM 18S ribosomal RNA gene, partial sequence | blastn | 16088 | 593 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera bacillipedes | ||
| 6609018 | 6609018 | PRJNA1118794_P_NODE_6346_length_558_cov_2.519588_g5607_i0 | PRJNA1118794 | 6346 | 558 | 2.519588 | 14.05930104 | Vexillifera bacillipedes | 1105345 | Discosea | other_Eukaryota | 737 | 0 | NTclustered | gi|354720326|gb|HQ687485.1| | 1105345 | g5607 | i0 | 90.78 | 37.8458781362007 | 564 | 35 | 99 | 12 | 3 | 558 | 566 | 12 | Vexillifera bacillipedes strain CCAP 1590/1 small subunit ribosomal RNA gene, partial sequence | blastn | 21118 | 737 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera bacillipedes | ||
| 9158910 | 9158910 | PRJNA1118794_P_NODE_7728_length_505_cov_22.074074_g6985_i0 | PRJNA1118794 | 7728 | 505 | 22.074074 | 111.4740737 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 804 | 0 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g6985 | i0 | 95.464 | 100.958415841584 | 507 | 18 | 100 | 5 | 1 | 505 | 1072 | 569 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 50984 | 804 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 10434276 | 10434276 | PRJNA1118794_P_NODE_47289_length_253_cov_1.711111_g46539_i0 | PRJNA1118794 | 47289 | 253 | 1.711111 | 4.32911083 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 158 | 4.729999999999999e-34 | NTclustered | gi|470384206|ref|XM_004333979.1| | 1257118 | g46539 | i0 | 79.149 | 1.98418972332016 | 235 | 44 | 92 | 5 | 4 | 235 | 708 | 476 | Acanthamoeba castellanii str. Neff alphaactinin, putative (ACA1_321210), partial mRNA | blastn | 502 | 158 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10434627 | 10434627 | PRJNA1118794_P_NODE_8349_length_487_cov_2.743961_g7606_i0 | PRJNA1118794 | 8349 | 487 | 2.743961 | 13.36309007 | Vexillifera bacillipedes | 1105345 | Discosea | other_Eukaryota | 556 | 8.25e-154 | NTclustered | gi|399764261|gb|JQ271772.1| | 1105345 | g7606 | i0 | 89.865 | 42.9425051334702 | 444 | 29 | 90 | 13 | 43 | 481 | 793 | 1225 | Vexillifera bacillipedes strain 6HZM 18S ribosomal RNA gene, partial sequence | blastn | 20913 | 556 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera bacillipedes | ||
| 14259681 | 14259681 | PRJNA1118794_P_NODE_37612_length_274_cov_1.293532_g36862_i0 | PRJNA1118794 | 37612 | 274 | 1.293532 | 3.54427768 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 150 | 8.68e-32 | NTclustered | gi|470517203|ref|XM_004353125.1| | 1257118 | g36862 | i0 | 81.026 | 20.3175182481752 | 195 | 31 | 70 | 5 | 36 | 227 | 1213 | 1404 | Acanthamoeba castellanii str. Neff alanineglyoxylate aminotransferase (ACA1_072820), partial mRNA | blastn | 5567 | 150 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14259866 | 14259866 | PRJNA1118794_P_NODE_5392_length_608_cov_1.801869_g4661_i0 | PRJNA1118794 | 5392 | 608 | 1.801869 | 10.95536352 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 577 | 8.04e-160 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g4661 | i0 | 84.08 | 98.0493421052632 | 603 | 90 | 99 | 5 | 3 | 602 | 1171 | 1770 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 59614 | 577 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19356976 | 19356976 | PRJNA1118794_P_NODE_72036_length_241_cov_2.863095_g71286_i0 | PRJNA1118794 | 72036 | 241 | 2.863095 | 6.90005895 | Vexillifera westveldii | 1678067 | Discosea | other_Eukaryota | 429 | 8.58e-116 | NTclustered | gi|861553791|gb|KP719187.1| | 1678067 | g71286 | i0 | 98.76 | 86.6887966804979 | 242 | 2 | 100 | 1 | 1 | 241 | 974 | 733 | Vexillifera westveldii strain A18WVB clone 10 small subunit ribosomal RNA gene, partial sequence | blastn | 20892 | 429 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera westveldii | ||
| 20631972 | 20631972 | PRJNA1118794_P_NODE_5457_length_604_cov_2.359699_g4726_i0 | PRJNA1118794 | 5457 | 604 | 2.359699 | 14.25258196 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 778 | 0 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g4726 | i0 | 89.901 | 99.521523178808 | 604 | 61 | 100 | 0 | 1 | 604 | 1126 | 523 | Platyamoeba placida actin mRNA, partial cds | blastn | 60111 | 778 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 21907660 | 21907660 | PRJNA1118794_P_NODE_4178_length_697_cov_4.173077_g3467_i0 | PRJNA1118794 | 4178 | 697 | 4.173077 | 29.08634669 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 379 | 2.81e-100 | NTclustered | gi|470380222|ref|XM_004333620.1| | 1257118 | g3467 | i0 | 81.466 | 60.2109038737446 | 464 | 84 | 66 | 2 | 59 | 521 | 12 | 474 | Acanthamoeba castellanii str. Neff ran, putative (ACA1_260190), partial mRNA | blastn | 41967 | 379 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 24457339 | 24457339 | PRJNA1118794_P_NODE_7480_length_513_cov_18.218182_g6739_i0 | PRJNA1118794 | 7480 | 513 | 18.218182 | 93.45927366 | Ripella platypodia | 2047821 | Discosea | other_Eukaryota | 798 | 0 | NTclustered | gi|1269228373|gb|MF683498.1| | 2047821 | g6739 | i0 | 94.798 | 101.251461988304 | 519 | 15 | 100 | 9 | 1 | 513 | 1139 | 1651 | Ripella platypodia clone 26.9.30 18S ribosomal RNA gene, partial sequence | blastn | 51942 | 798 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 24457386 | 24457386 | PRJNA1118794_P_NODE_9160_length_466_cov_1.625954_g8412_i0 | PRJNA1118794 | 9160 | 466 | 1.625954 | 7.57694564 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 231 | 5.419999999999999e-56 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g8412 | i0 | 80.464 | 64.4399141630901 | 302 | 59 | 65 | 0 | 103 | 404 | 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 |
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);;