contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJDB3785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2558746 | 2558746 | PRJDB3785_S_NODE_3183_length_435_cov_3.409326_g3030_i0 | PRJDB3785 | 3183 | 435 | 3.409326 | 14.8305681 | Acanthamoeba culbertsoni | 43142 | Discosea | other_Eukaryota | 281 | 4.92e-71 | NTclustered | gi|53829553|gb|AY582829.1| | 43142 | g3030 | i0 | 80.863 | 81.5126436781609 | 371 | 59 | 84 | 11 | 1 | 365 | 874 | 1238 | Acanthamoeba culbertsoni ef1a gene, partial cds | blastn | 35458 | 281 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba culbertsoni | |||
| 4809104 | 4809104 | PRJDB3785_S_NODE_22644_length_168_cov_1.663866_g22491_i0 | PRJDB3785 | 22644 | 168 | 1.663866 | 2.79529488 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 161 | 2.25e-35 | NTclustered | gi|881634|gb|U29610.1|ACU29610 | 5755 | g22491 | i0 | 90.833 | 9.5 | 120 | 11 | 71 | 0 | 1 | 120 | 412 | 293 | Acanthaoeba castellanii actin-related protein 3 Arp3 mRNA, complete cds | blastn | 1596 | 161 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7661191 | 7661191 | PRJDB3785_S_NODE_3107_length_440_cov_1.979540_g2955_i0 | PRJDB3785 | 3107 | 440 | 1.97954 | 8.709976 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 71.3 | 1.17e-7 | NTclustered | gi|470394136|ref|XM_004334911.1| | 1257118 | g2955 | i0 | 100 | 9.4 | 38 | 0 | 9 | 0 | 277 | 314 | 1687 | 1724 | Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_096160), partial mRNA | blastn | 4136 | 71.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 8935782 | 8935782 | PRJDB3785_S_NODE_20328_length_176_cov_2.196850_g20175_i0 | PRJDB3785 | 20328 | 176 | 2.19685 | 3.866456 | Vexillifera bacillipedes | 1105345 | Discosea | other_Eukaryota | 78.7 | 2.45e-10 | NTclustered | gi|354720326|gb|HQ687485.1| | 1105345 | g20175 | i0 | 89.062 | 1.73863636363636 | 64 | 5 | 36 | 2 | 81 | 143 | 904 | 966 | Vexillifera bacillipedes strain CCAP 1590/1 small subunit ribosomal RNA gene, partial sequence | blastn | 306 | 78.7 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera bacillipedes | ||
| 11486862 | 11486862 | PRJDB3785_S_NODE_5390_length_326_cov_1.361011_g5237_i0 | PRJDB3785 | 5390 | 326 | 1.361011 | 4.43689586 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 241 | 6.09e-59 | NTclustered | gi|470514016|ref|XM_004352683.1| | 1257118 | g5237 | i0 | 87.805 | 7.19325153374233 | 205 | 25 | 63 | 0 | 1 | 205 | 134 | 338 | Acanthamoeba castellanii str. Neff ribosomal protein S19, putative (ACA1_067910), partial mRNA | blastn | 2345 | 241 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12762247 | 12762247 | PRJDB3785_S_NODE_12151_length_219_cov_5.147059_g11998_i0 | PRJDB3785 | 12151 | 219 | 5.147059 | 11.27205921 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 261 | 2.96e-65 | NTclustered | gi|470512968|ref|XM_004352512.1| | 1257118 | g11998 | i0 | 90.404 | 85.7168949771689 | 198 | 19 | 90 | 0 | 22 | 219 | 1 | 198 | Acanthamoeba castellanii str. Neff actin-1, putative (ACA1_361250), partial mRNA | blastn | 18772 | 261 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12762508 | 12762508 | PRJDB3785_S_NODE_7171_length_280_cov_2.722944_g7018_i0 | PRJDB3785 | 7171 | 280 | 2.722944 | 7.6242432000000004 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 326 | 1.38e-84 | NTclustered | gi|330902893|gb|JF298271.1| | 313997 | g7018 | i0 | 90.612 | 86.7 | 245 | 23 | 88 | 0 | 33 | 277 | 857 | 1101 | Cochliopodium minus clone 5202 actin gene, partial cds | blastn | 24276 | 326 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 16585742 | 16585742 | PRJDB3785_S_NODE_3674_length_400_cov_1.777778_g3521_i0 | PRJDB3785 | 3674 | 400 | 1.777778 | 7.111112 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 315 | 4.43e-81 | NTclustered | gi|470467440|ref|XM_004341747.1| | 1257118 | g3521 | i0 | 81.771 | 78.8075 | 384 | 63 | 95 | 6 | 1 | 379 | 459 | 840 | Acanthamoeba castellanii str. Neff guanine nucleotide-binding protein beta subunit, putative (ACA1_199990), partial mRNA | blastn | 31523 | 315 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 17860531 | 17860531 | PRJDB3785_S_NODE_11715_length_223_cov_1.172414_g11562_i0 | PRJDB3785 | 11715 | 223 | 1.172414 | 2.61448322 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 95.3 | 3.24e-15 | NTclustered | gi|470519749|ref|XM_004353447.1| | 1257118 | g11562 | i0 | 91.304 | 0.991031390134529 | 69 | 6 | 31 | 0 | 63 | 131 | 156 | 88 | Acanthamoeba castellanii str. Neff ribosomal L29e protein family (ACA1_143310), partial mRNA | blastn | 221 | 95.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21685303 | 21685303 | PRJDB3785_S_NODE_13618_length_209_cov_0.950000_g13465_i0 | PRJDB3785 | 13618 | 209 | 0.95 | 1.9855 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 178 | 2.9e-40 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g13465 | i0 | 83.598 | 62.9377990430622 | 189 | 29 | 90 | 2 | 19 | 206 | 734 | 547 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 13154 | 178 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 22960668 | 22960668 | PRJDB3785_S_NODE_14099_length_206_cov_0.974522_g13946_i0 | PRJDB3785 | 14099 | 206 | 0.974522 | 2.00751532 | Paramoeba perurans | 437603 | Discosea | other_Eukaryota | 163 | 7.97e-36 | NTclustered | gi|2635491373|gb|OR923386.1| | 437603 | g13946 | i0 | 81.592 | 53.6116504854369 | 201 | 33 | 97 | 4 | 1 | 199 | 478 | 280 | Paramoeba perurans clone PPER_00013037 heat shock 90 mRNA, complete cds | blastn | 11044 | 163 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba perurans |
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);;