contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1558204 | 1558204 | PRJNA1132896_P_NODE_3182_length_315_cov_1.272727_g3091_i0 | PRJNA1132896 | 3182 | 315 | 1.272727 | 4.00909005 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 130 | 1.32e-25 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g3091 | i0 | 87.611 | 31.7460317460317 | 113 | 13 | 36 | 1 | 9 | 120 | 219 | 107 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 10000 | 130 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 2834331 | 2834331 | PRJNA1132896_P_NODE_863_length_554_cov_44.110187_g772_i0 | PRJNA1132896 | 863 | 554 | 44.110187 | 244.37043598 | Vannella sp. strain CAZ6/I | 325077 | Discosea | other_Eukaryota | 931 | 0 | NTclustered | gi|62865939|gb|AY929914.1| | 325077 | g772 | i0 | 97.107 | 101.675090252708 | 553 | 15 | 99 | 1 | 2 | 554 | 1091 | 540 | Vannella sp. strain CAZ6/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 56328 | 931 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain CAZ6/I | |||
| 16860795 | 16860795 | PRJNA1132896_P_NODE_2114_length_373_cov_1.903333_g2023_i0 | PRJNA1132896 | 2114 | 373 | 1.903333 | 7.09943209 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 303 | 8.87e-78 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g2023 | i0 | 82.123 | 20.8525469168901 | 358 | 60 | 95 | 4 | 1 | 356 | 2117 | 1762 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 7778 | 303 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16860796 | 16860796 | PRJNA1132896_P_NODE_214_length_1114_cov_21.984630_g160_i0 | PRJNA1132896 | 214 | 1114 | 21.98463 | 244.9087782 | Vannella sp. strain CAZ6/I | 325077 | Discosea | other_Eukaryota | 926 | 0 | NTclustered | gi|62865939|gb|AY929914.1| | 325077 | g160 | i0 | 96.931 | 49.9174147217235 | 554 | 13 | 49 | 3 | 563 | 1113 | 3 | 555 | Vannella sp. strain CAZ6/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 55608 | 926 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain CAZ6/I | |||
| 19409514 | 19409514 | PRJNA1132896_P_NODE_3676_length_296_cov_2.932735_g3585_i0 | PRJNA1132896 | 3676 | 296 | 2.932735 | 8.6808956 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 388 | 1.84e-103 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g3585 | i0 | 90.429 | 66.4560810810811 | 303 | 17 | 99 | 10 | 3 | 296 | 3492 | 3791 | 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 | 19671 | 388 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 21960381 | 21960381 | PRJNA1132896_P_NODE_1538_length_427_cov_3.104520_g1447_i0 | PRJNA1132896 | 1538 | 427 | 3.10452 | 13.2563004 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 472 | 2.67e-128 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g1447 | i0 | 90.476 | 85.2693208430913 | 357 | 34 | 84 | 0 | 69 | 425 | 538 | 894 | Platyamoeba placida actin mRNA, partial cds | blastn | 36410 | 472 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 21960463 | 21960463 | PRJNA1132896_P_NODE_938_length_533_cov_43.550000_g847_i0 | PRJNA1132896 | 938 | 533 | 43.55 | 232.1215 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 835 | 0 | NTclustered | gi|1269228425|gb|MF683550.1| | 2047822 | g847 | i0 | 95.31 | 100.373358348968 | 533 | 13 | 99 | 11 | 1 | 529 | 1133 | 1657 | Ripella decalvata clone 26.2.4 18S ribosomal RNA gene, partial sequence | blastn | 53499 | 835 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata |
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);;