contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA453567" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6819470 | 6819470 | PRJNA453567_P_NODE_16426_length_221_cov_1.945652_g16189_i0 | PRJNA453567 | 16426 | 221 | 1.945652 | 4.29989092 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 276 | 1.07e-69 | NTclustered | gi|470484649|ref|XM_004344039.1| | 1257118 | g16189 | i0 | 89.767 | 33.2443438914027 | 215 | 22 | 97 | 0 | 6 | 220 | 5563 | 5777 | Acanthamoeba castellanii str. Neff PremRNA processing splicing factor 8, putative (ACA1_054320), partial mRNA | blastn | 7347 | 276 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7471377 | 7471377 | PRJNA453567_P_NODE_3946_length_536_cov_84.513026_g3715_i0 | PRJNA453567 | 3946 | 536 | 84.513026 | 452.98981936 | Vannellidae | 95227 | Discosea | other_Eukaryota | 813 | 0 | NTclustered | gi|62865947|gb|AY929922.1| | 325065 | g3715 | i0 | 94.413 | 99.9533582089552 | 537 | 17 | 100 | 11 | 1 | 536 | 1682 | 1158 | Platyamoeba sp. strain CAZ7/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 53575 | 813 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba sp. strain CAZ7/I | |||
| 8094925 | 8094925 | PRJNA453567_P_NODE_18527_length_206_cov_2.502959_g18290_i0 | PRJNA453567 | 18527 | 206 | 2.502959 | 5.15609554 | Vexillifera multispinosa | 1105342 | Discosea | other_Eukaryota | 292 | 9.75e-75 | NTclustered | gi|354720322|gb|HQ687481.1| | 1105342 | g18290 | i0 | 92.271 | 75.747572815534 | 207 | 14 | 100 | 2 | 1 | 206 | 452 | 247 | Vexillifera multispinosa strain P124 small subunit ribosomal RNA gene, partial sequence | blastn | 15604 | 292 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera multispinosa | ||
| 9369729 | 9369729 | PRJNA453567_P_NODE_2988_length_636_cov_2.268781_g2784_i0 | PRJNA453567 | 2988 | 636 | 2.268781 | 14.42944716 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 544 | 8.549999999999998e-150 | NTclustered | gi|470484649|ref|XM_004344039.1| | 1257118 | g2784 | i0 | 82.188 | 79.6981132075472 | 640 | 106 | 100 | 7 | 1 | 636 | 6408 | 5773 | Acanthamoeba castellanii str. Neff PremRNA processing splicing factor 8, putative (ACA1_054320), partial mRNA | blastn | 50688 | 544 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10645608 | 10645608 | PRJNA453567_P_NODE_12449_length_262_cov_1.124444_g12212_i0 | PRJNA453567 | 12449 | 262 | 1.124444 | 2.94604328 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 267 | 7.84e-67 | NTclustered | gi|1914009695|gb|MT975597.1| | 313997 | g12212 | i0 | 85.171 | 95.3015267175573 | 263 | 35 | 99 | 4 | 1 | 261 | 84 | 344 | Cochliopodium minus clone 2 actin gene, partial cds | blastn | 24969 | 267 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 19567741 | 19567741 | PRJNA453567_P_NODE_876_length_1243_cov_2.412935_g801_i0 | PRJNA453567 | 876 | 1243 | 2.412935 | 29.99278205 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 226 | 7.069999999999998e-54 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g801 | i0 | 76.586 | 21.875301689461 | 457 | 79 | 36 | 23 | 794 | 1243 | 2295 | 1860 | Vannella septentrionalis 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 | 27191 | 226 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis |
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);;