contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA603943" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2418281 | 2418281 | PRJNA603943_P_NODE_12742_length_457_cov_1.809896_g12550_i0 | PRJNA603943 | 12742 | 457 | 1.809896 | 8.27122472 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 174 | 9.07e-39 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g12550 | i0 | 84.971 | 27.9956236323851 | 173 | 25 | 38 | 1 | 221 | 393 | 5057 | 5228 | Naegleria gruberi strain NEG-M rDNA-containing extrachromosomal element genomic sequence; and 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 12794 | 174 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 6955505 | 6955505 | PRJNA603943_P_NODE_3826_length_756_cov_4.632504_g3650_i0 | PRJNA603943 | 3826 | 756 | 4.632504 | 35.02173024 | Acrasis rosea | 43695 | Heterolobosea | other_Eukaryota | 699 | 0 | NTclustered | gi|12083876|gb|AF190771.1|AF190771 | 43695 | g3650 | i0 | 84.714 | 64.0648148148148 | 700 | 105 | 92 | 2 | 56 | 754 | 1204 | 506 | Acrasis rosea elongation factor 1 alpha (tef1) gene, partial cds | blastn | 48433 | 699 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis rosea | ||||
| 9505143 | 9505143 | PRJNA603943_P_NODE_24768_length_353_cov_2.200000_g24576_i0 | PRJNA603943 | 24768 | 353 | 2.2 | 7.766 | Tsukubamonas globosa | 875863 | Root_unresolved | Root_unresolved | 287 | 8.410000000000001e-73 | NTclustered | gi|323575411|dbj|AB576859.1| | 875863 | g24576 | i0 | 85.818 | 84.8243626062323 | 275 | 33 | 77 | 6 | 79 | 351 | 1349 | 1079 | Tsukubamonas globosa EF2 mRNA for elongation factor 2, partial cds | blastn | 29943 | 287 | 1 | Eukaryota | Discoba | Tsukubamonadida | Tsukubamonadidae | Tsukubamonas | Tsukubamonas globosa | ||||
| 19703476 | 19703476 | PRJNA603943_P_NODE_28616_length_335_cov_1.114504_g28424_i0 | PRJNA603943 | 28616 | 335 | 1.114504 | 3.7335884 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 464 | 3.4199999999999996e-126 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g28424 | i0 | 91.642 | 3.74925373134328 | 335 | 28 | 100 | 0 | 1 | 335 | 2593 | 2259 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1256 | 464 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 20979101 | 20979101 | PRJNA603943_P_NODE_26737_length_343_cov_2.062963_g26545_i0 | PRJNA603943 | 26737 | 343 | 2.062963 | 7.07596309 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 595 | 1.1899999999999999e-165 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g26545 | i0 | 97.965 | 24.9679300291545 | 344 | 6 | 100 | 1 | 1 | 343 | 3689 | 4032 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 8564 | 595 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 22253828 | 22253828 | PRJNA603943_P_NODE_23598_length_360_cov_1.073171_g23406_i0 | PRJNA603943 | 23598 | 360 | 1.073171 | 3.8634156 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 610 | 4.489999999999999e-170 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g23406 | i0 | 97.222 | 28.7388888888889 | 360 | 10 | 100 | 0 | 1 | 360 | 2223 | 1864 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 10346 | 610 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 23530349 | 23530349 | PRJNA603943_P_NODE_61719_length_246_cov_0.890173_g61527_i0 | PRJNA603943 | 61719 | 246 | 0.890173 | 2.18982558 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 137 | 5.96e-28 | NTclustered | gi|2124402762|ref|XM_044685787.1| | 51637 | g61527 | i0 | 82.209 | 2.02032520325203 | 163 | 25 | 65 | 3 | 13 | 173 | 568 | 728 | Naegleria lovaniensis uncharacterized protein (C9374_010262), partial mRNA | blastn | 497 | 137 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 24802793 | 24802793 | PRJNA603943_P_NODE_17560_length_402_cov_3.674772_g17368_i0 | PRJNA603943 | 17560 | 402 | 3.674772 | 14.77258344 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 244 | 5.92e-60 | NTclustered | gi|1002449054|ref|XM_015802556.1| | 157538 | g17368 | i0 | 82.168 | 25.1169154228856 | 286 | 49 | 71 | 2 | 97 | 381 | 84 | 368 | Leptomonas pyrrhocoris putative mitochondrial 40s ribosomal protein S15a mRNA | blastn | 10097 | 244 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris |
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);;