contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA657343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1898986 | 1898986 | PRJNA657343_P_NODE_1502_length_534_cov_3.746392_g1479_i0 | PRJNA657343 | 1502 | 534 | 3.746392 | 20.00573328 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 793 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g1479 | i0 | 94.275 | 98.2565543071161 | 524 | 21 | 97 | 9 | 4 | 523 | 519 | 1 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 52469 | 793 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 2435589 | 2435589 | PRJNA657343_P_NODE_21922_length_200_cov_3.139073_g21898_i0 | PRJNA657343 | 21922 | 200 | 3.139073 | 6.278146 | Ripella | 1217112 | Discosea | other_Eukaryota | 300 | 5.62e-77 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g21898 | i0 | 98.817 | 79.79 | 169 | 1 | 84 | 1 | 31 | 198 | 718 | 886 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 15958 | 300 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 4450935 | 4450935 | PRJNA657343_P_NODE_33164_length_172_cov_1.975610_g33140_i0 | PRJNA657343 | 33164 | 172 | 1.97561 | 3.3980492 | Ripella tribonemae | 2047823 | Discosea | other_Eukaryota | 254 | 3.68e-63 | NTclustered | gi|1269228471|gb|MF683596.1| | 2047823 | g33140 | i0 | 95.062 | 95.046511627907 | 162 | 6 | 94 | 2 | 4 | 165 | 1132 | 1291 | Ripella tribonemae clone 22.1.14 18S ribosomal RNA gene, partial sequence | blastn | 16348 | 254 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae | |||
| 5726486 | 5726486 | PRJNA657343_P_NODE_32685_length_173_cov_1.903226_g32661_i0 | PRJNA657343 | 32685 | 173 | 1.903226 | 3.29258098 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 128 | 2.35e-25 | NTclustered | gi|470486807|ref|XM_004344593.1| | 1257118 | g32661 | i0 | 81.646 | 1.24277456647399 | 158 | 25 | 90 | 4 | 16 | 171 | 267 | 422 | Acanthamoeba castellanii str. Neff MC family transporter: phosphate, putative (ACA1_278610), partial mRNA | blastn | 215 | 128 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 8276249 | 8276249 | PRJNA657343_P_NODE_25667_length_189_cov_1.935714_g25643_i0 | PRJNA657343 | 25667 | 189 | 1.935714 | 3.65849946 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 261 | 2.4800000000000002e-65 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g25643 | i0 | 100 | 90.984126984127 | 141 | 0 | 75 | 0 | 3 | 143 | 545 | 685 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 17196 | 261 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 10827195 | 10827195 | PRJNA657343_P_NODE_23289_length_196_cov_1.074830_g23265_i0 | PRJNA657343 | 23289 | 196 | 1.07483 | 2.1066668 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 124 | 3.5399999999999995e-24 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g23265 | i0 | 78.646 | 85.6632653061225 | 192 | 37 | 97 | 4 | 5 | 194 | 1009 | 820 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 16790 | 124 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 14653377 | 14653377 | PRJNA657343_S_NODE_7252_length_321_cov_8.522059_g7227_i0 | PRJNA657343 | 7252 | 321 | 8.522059 | 27.35580939 | Ripella sp. PS2 | 1217116 | Discosea | other_Eukaryota | 579 | 1.1199999999999997e-160 | NTclustered | gi|399764205|gb|JQ271716.1| | 1217116 | g7227 | i0 | 99.684 | 98.6417445482866 | 316 | 1 | 98 | 0 | 1 | 316 | 878 | 563 | Ripella sp. PS2 18S ribosomal RNA gene, partial sequence | blastn | 31664 | 579 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. PS2 | |||
| 15189038 | 15189038 | PRJNA657343_S_NODE_31232_length_157_cov_5.898148_g31207_i0 | PRJNA657343 | 31232 | 157 | 5.898148 | 9.26009236 | Vannellidae | 95227 | Discosea | other_Eukaryota | 257 | 2.5600000000000003e-64 | NTclustered | gi|399764216|gb|JQ271727.1| | 1215631 | g31207 | i0 | 96.203 | 100.993630573248 | 158 | 5 | 100 | 1 | 1 | 157 | 569 | 412 | Vannella sp. BEN3V 18S ribosomal RNA gene, partial sequence | blastn | 15856 | 257 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. BEN3V | |||
| 15926143 | 15926143 | PRJNA657343_P_NODE_45913_length_157_cov_21.564815_g45889_i0 | PRJNA657343 | 45913 | 157 | 21.564815 | 33.85675955 | Vannella sp. strain CAZ6/I | 325077 | Discosea | other_Eukaryota | 233 | 4.31e-57 | NTclustered | gi|62865939|gb|AY929914.1| | 325077 | g45889 | i0 | 94.702 | 96.3375796178344 | 151 | 6 | 95 | 2 | 4 | 152 | 1504 | 1654 | Vannella sp. strain CAZ6/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 15125 | 233 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain CAZ6/I | |||
| 15926159 | 15926159 | PRJNA657343_P_NODE_4793_length_351_cov_15.456954_g4770_i0 | PRJNA657343 | 4793 | 351 | 15.456954 | 54.25390854 | Platyamoeba sp. strain CAZ7/I | 325065 | Discosea | other_Eukaryota | 427 | 4.72e-115 | NTclustered | gi|62865947|gb|AY929922.1| | 325065 | g4770 | i0 | 96.887 | 74.0968660968661 | 257 | 4 | 73 | 4 | 3 | 257 | 1318 | 1572 | Platyamoeba sp. strain CAZ7/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 26008 | 427 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba sp. strain CAZ7/I | |||
| 21025793 | 21025793 | PRJNA657343_P_NODE_917_length_621_cov_6.094406_g899_i0 | PRJNA657343 | 917 | 621 | 6.094406 | 37.84626126 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 255 | 4.37e-63 | NTclustered | gi|470483818|ref|XM_004343959.1| | 1257118 | g899 | i0 | 78.45 | 5.02093397745572 | 413 | 73 | 66 | 13 | 52 | 459 | 55 | 456 | Acanthamoeba castellanii str. Neff Vtype ATPase, C subunit (ACA1_053290), partial mRNA | blastn | 3118 | 255 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 23575947 | 23575947 | PRJNA657343_P_NODE_899_length_625_cov_2.531250_g881_i0 | PRJNA657343 | 899 | 625 | 2.53125 | 15.8203125 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 364 | 7.009999999999998e-96 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g881 | i0 | 79.423 | 79.3392 | 520 | 101 | 83 | 6 | 106 | 622 | 1042 | 526 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 49587 | 364 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila |
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);;