contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA667863" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1910194 | 1910194 | PRJNA667863_P_NODE_1942_length_399_cov_2.263804_g1908_i0 | PRJNA667863 | 1942 | 399 | 2.263804 | 9.03257796 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 556 | 6.64e-154 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g1908 | i0 | 92.269 | 35.4035087719298 | 401 | 17 | 99 | 8 | 6 | 399 | 7818 | 7425 | 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 | 14126 | 556 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5737336 | 5737336 | PRJNA667863_P_NODE_12925_length_248_cov_0.880000_g12891_i0 | PRJNA667863 | 12925 | 248 | 0.88 | 2.1824 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 135 | 2.17e-27 | NTclustered | gi|470509261|ref|XM_004349682.1| | 1257118 | g12891 | i0 | 86.29 | 3.40322580645161 | 124 | 17 | 50 | 0 | 1 | 124 | 171 | 48 | Acanthamoeba castellanii str. Neff ribosomal protein S10p/S20e, putative (ACA1_034550), partial mRNA | blastn | 844 | 135 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5737503 | 5737503 | PRJNA667863_P_NODE_7345_length_275_cov_2.287129_g7311_i0 | PRJNA667863 | 7345 | 275 | 2.287129 | 6.28960475 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 387 | 6.1e-103 | NTclustered | gi|470484649|ref|XM_004344039.1| | 1257118 | g7311 | i0 | 92 | 99.8436363636364 | 275 | 22 | 100 | 0 | 1 | 275 | 5293 | 5567 | Acanthamoeba castellanii str. Neff PremRNA processing splicing factor 8, putative (ACA1_054320), partial mRNA | blastn | 27457 | 387 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7012566 | 7012566 | PRJNA667863_P_NODE_3306_length_340_cov_3.779026_g3272_i0 | PRJNA667863 | 3306 | 340 | 3.779026 | 12.8486884 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 361 | 4.7e-95 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g3272 | i0 | 85.794 | 13.2058823529412 | 359 | 30 | 100 | 15 | 1 | 340 | 6464 | 6108 | 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 | 4490 | 361 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7012586 | 7012586 | PRJNA667863_P_NODE_5406_length_295_cov_6.360360_g5372_i0 | PRJNA667863 | 5406 | 295 | 6.36036 | 18.763062 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 333 | 8.729999999999999e-87 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g5372 | i0 | 87.291 | 13.7254237288136 | 299 | 28 | 100 | 9 | 1 | 295 | 7066 | 6774 | 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 | 4049 | 333 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 22840890 | 22840890 | PRJNA667863_P_NODE_10478_length_255_cov_1.565934_g10444_i0 | PRJNA667863 | 10478 | 255 | 1.565934 | 3.9931317 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 455 | 1.51e-123 | NTclustered | gi|2044079936|gb|MZ272128.1| | 5756 | g10444 | i0 | 98.824 | 100.937254901961 | 255 | 3 | 100 | 0 | 1 | 255 | 1424 | 1170 | Acanthamoeba sp. isolate AcW149 small subunit ribosomal RNA gene, partial sequence | blastn | 25739 | 455 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba sp. | |||
| 23586839 | 23586839 | PRJNA667863_P_NODE_819_length_545_cov_9.779661_g787_i0 | PRJNA667863 | 819 | 545 | 9.779661 | 53.29915245 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 737 | 0 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g787 | i0 | 91.15 | 18.5376146788991 | 565 | 18 | 100 | 19 | 1 | 545 | 5925 | 5373 | 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 | 10103 | 737 | 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);;