contig_metadata
11 rows where bioproject = "PRJNA1111077", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1489274 | 1489274 | PRJNA1111077_P_NODE_19802_length_287_cov_3.308411_g19581_i0 | PRJNA1111077 | 19802 | 287 | 3.308411 | 9.49513957 | Cochliopodium spiniferum | 313558 | Discosea | other_Eukaryota | 412 | 1.0599999999999996e-110 | NTclustered | gi|330902897|gb|JF298273.1| | 313558 | g19581 | i0 | 92.657 | 95.4216027874565 | 286 | 21 | 99 | 0 | 2 | 287 | 259 | 544 | Cochliopodium spiniferum clone 5102 actin gene, partial cds | blastn | 27386 | 412 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium spiniferum | |||
| 2765541 | 2765541 | PRJNA1111077_P_NODE_31303_length_249_cov_1.670455_g31082_i0 | PRJNA1111077 | 31303 | 249 | 1.670455 | 4.15943295 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 102 | 1.48e-25 | NR | XP_004353558.1 | 1257118 | g31082 | i0 | 70 | 1.67469879518072 | 70 | 21 | 84.3 | 0 | 248 | 39 | 98 | 167 | XP_004353558.1 uncharacterized protein ACA1_144210 [Acanthamoeba castellanii str. Neff] | diamond | 417 | 102 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 4041451 | 4041451 | PRJNA1111077_P_NODE_21124_length_283_cov_1.514286_g20903_i0 | PRJNA1111077 | 21124 | 283 | 1.514286 | 4.28542938 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 496 | 1e-135 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g20903 | i0 | 98.239 | 13.1095406360424 | 284 | 3 | 100 | 2 | 1 | 283 | 80 | 362 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 3710 | 496 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 7398995 | 7398995 | PRJNA1111077_P_NODE_4346_length_542_cov_1.321962_g4125_i0 | PRJNA1111077 | 4346 | 542 | 1.321962 | 7.16503404 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 641 | 2.49e-179 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g4125 | i0 | 88.007 | 99.4059040590406 | 542 | 65 | 100 | 0 | 1 | 542 | 376 | 917 | Platyamoeba placida actin mRNA, partial cds | blastn | 53878 | 641 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 7867536 | 7867536 | PRJNA1111077_P_NODE_28127_length_258_cov_2.102703_g27906_i0 | PRJNA1111077 | 28127 | 258 | 2.102703 | 5.42497374 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 107 | 1.0799999999999999e-24 | NR | XP_004336225.1 | 1257118 | g27906 | i0 | 65.9 | 7.62790697674419 | 82 | 28 | 95.3 | 0 | 250 | 5 | 262 | 343 | XP_004336225.1 gammaadaptin 1, putative [Acanthamoeba castellanii str. Neff] | diamond | 1968 | 107 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11693190 | 11693190 | PRJNA1111077_P_NODE_18390_length_292_cov_5.013699_g18169_i0 | PRJNA1111077 | 18390 | 292 | 5.013699 | 14.64000108 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 375 | 1.4099999999999998e-99 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g18169 | i0 | 89.375 | 14.1917808219178 | 320 | 5 | 100 | 13 | 1 | 292 | 6142 | 6460 | Acanthamoeba castellanii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 4144 | 375 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11693294 | 11693294 | PRJNA1111077_P_NODE_22870_length_277_cov_2.215686_g22649_i0 | PRJNA1111077 | 22870 | 277 | 2.215686 | 6.13745022 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 124 | 3.56e-31 | NR | XP_004334355.1 | 1257118 | g22649 | i0 | 56 | 1.9927797833935 | 91 | 40 | 98.6 | 0 | 276 | 4 | 315 | 405 | XP_004334355.1 protein disulfideisomerase domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 552 | 124 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 20615750 | 20615750 | PRJNA1111077_P_NODE_20797_length_284_cov_1.706161_g20576_i0 | PRJNA1111077 | 20797 | 284 | 1.706161 | 4.84549724 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 440 | 4.789999999999998e-119 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g20576 | i0 | 94.257 | 1.04225352112676 | 296 | 4 | 100 | 4 | 1 | 284 | 5925 | 5631 | Acanthamoeba castellanii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 296 | 440 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27162375 | 27162375 | PRJNA1111077_P_NODE_34242_length_245_cov_0.895349_g34021_i0 | PRJNA1111077 | 34242 | 245 | 0.895349 | 2.19360505 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 89.7 | 1.58e-21 | NR | XP_004352995.1 | 1257118 | g34021 | i0 | 62.1 | 1.7265306122449 | 66 | 25 | 80.8 | 0 | 2 | 199 | 5 | 70 | XP_004352995.1 uncharacterized protein ACA1_070880 [Acanthamoeba castellanii str. Neff] | diamond | 423 | 89.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27636591 | 27636591 | PRJNA1111077_P_NODE_36244_length_242_cov_0.911243_g36023_i0 | PRJNA1111077 | 36244 | 242 | 0.911243 | 2.20520806 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 72 | 1.79e-12 | NR | XP_004341420.1 | 1257118 | g36023 | i0 | 48.1 | 0.954545454545455 | 77 | 37 | 95.5 | 1 | 6 | 236 | 478 | 551 | XP_004341420.1 vacuolar sorting protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 231 | 72 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29878349 | 29878349 | PRJNA1111077_P_NODE_25011_length_270_cov_1.375635_g24790_i0 | PRJNA1111077 | 25011 | 270 | 1.375635 | 3.7142145 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 97.4 | 3.18e-21 | NR | XP_004339747.1 | 1257118 | g24790 | i0 | 52.7 | 1.01111111111111 | 91 | 42 | 100 | 1 | 270 | 1 | 923 | 1013 | XP_004339747.1 leucine rich repeat domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 273 | 97.4 | 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);;