contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA380660" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 402247 | 402247 | PRJNA380660_P_NODE_11481_length_180_cov_1.622517_g11081_i0 | PRJNA380660 | 11481 | 180 | 1.622517 | 2.9205306 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 305 | 1.06e-78 | NTclustered | gi|77994645|gb|DQ207583.1| | 312471 | g11081 | i0 | 97.222 | 96.8722222222222 | 180 | 5 | 100 | 0 | 1 | 180 | 1293 | 1114 | Neobodo designis strain HFCC306 18S ribosomal RNA gene, partial sequence | blastn | 17437 | 305 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 1074284 | 1074284 | PRJNA380660_P_NODE_5341_length_338_cov_3.809061_g4942_i0 | PRJNA380660 | 5341 | 338 | 3.809061 | 12.87462618 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 614 | 3.2499999999999993e-171 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g4942 | i0 | 99.41 | 21.1804733727811 | 339 | 1 | 100 | 1 | 1 | 338 | 3996 | 3658 | 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 | 7159 | 614 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 9330338 | 9330338 | PRJNA380660_P_NODE_7608_length_259_cov_2.104348_g7208_i0 | PRJNA380660 | 7608 | 259 | 2.104348 | 5.45026132 | Neobodo designis | 312471 | Euglenozoa | other_Eukaryota | 379 | 9.529999999999998e-101 | NTclustered | gi|225216795|gb|FJ176710.1| | 312471 | g7208 | i0 | 98.165 | 178.262548262548 | 218 | 2 | 100 | 1 | 1 | 216 | 1129 | 912 | Neobodo designis HFCC95 28S ribosomal RNA gene, partial sequence | blastn | 46170 | 379 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Neobodo | Neobodo designis | |||
| 11277452 | 11277452 | PRJNA380660_P_NODE_8349_length_239_cov_3.042857_g7949_i0 | PRJNA380660 | 8349 | 239 | 3.042857 | 7.27242823 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 377 | 3.12e-100 | NTclustered | gi|1714016877|gb|MN244156.1| | 67003 | g7949 | i0 | 95.021 | 163.192468619247 | 241 | 10 | 100 | 2 | 1 | 239 | 806 | 566 | Trypanosoma theileri isolate TBC15 large subunit ribosomal RNA gene, partial sequence | blastn | 39003 | 377 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 11277454 | 11277454 | PRJNA380660_P_NODE_9329_length_219_cov_2.047368_g8929_i0 | PRJNA380660 | 9329 | 219 | 2.047368 | 4.48373592 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 364 | 2.19e-96 | NTclustered | gi|2476253407|gb|OQ627480.1| | 51634 | g8929 | i0 | 99.5 | 10.958904109589 | 200 | 1 | 91 | 0 | 10 | 209 | 4343 | 4144 | Naegleria australiensis strain PP397 rDNA-containing extrachromosomal element genomic sequence; small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and non-ribosomal sequence | blastn | 2400 | 364 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria australiensis | ||||
| 11880955 | 11880955 | PRJNA380660_P_NODE_7530_length_262_cov_1.154506_g7130_i0 | PRJNA380660 | 7530 | 262 | 1.154506 | 3.02480572 | Euglena tristella | 161227 | Euglenozoa | other_Eukaryota | 259 | 1.31e-64 | NTclustered | gi|209362331|gb|DQ140109.2| | 161227 | g7130 | i0 | 94.767 | 2.99618320610687 | 172 | 0 | 99 | 1 | 1 | 163 | 359 | 188 | Euglena tristella isolate New Jersey large subunit ribosomal RNA gene, partial sequence | blastn | 785 | 259 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena tristella | ||
| 18925716 | 18925716 | PRJNA380660_P_NODE_4395_length_385_cov_3.384831_g3999_i0 | PRJNA380660 | 4395 | 385 | 3.384831 | 13.03159935 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 702 | 0 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g3999 | i0 | 99.739 | 65.3038961038961 | 383 | 1 | 99 | 0 | 1 | 383 | 3415 | 3033 | 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 | 25142 | 708 | 0.991525423728814 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 18925724 | 18925724 | PRJNA380660_P_NODE_7495_length_263_cov_1.858974_g7095_i0 | PRJNA380660 | 7495 | 263 | 1.858974 | 4.88910162 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 143 | 1.38e-29 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g7095 | i0 | 87.805 | 27.148288973384 | 123 | 14 | 47 | 1 | 132 | 254 | 5057 | 5178 | 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 | 7140 | 143 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 24025995 | 24025995 | PRJNA380660_P_NODE_1299_length_755_cov_9.033058_g1018_i0 | PRJNA380660 | 1299 | 755 | 9.033058 | 68.1995879 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 771 | 0 | NTclustered | gi|32479131|gb|AY321362.1| | 51634 | g1018 | i0 | 99.762 | 98.594701986755 | 420 | 1 | 100 | 0 | 1 | 420 | 1835 | 1416 | Naegleria australiensis isolate TT 18S ribosomal RNA gene, partial sequence | blastn | 74439 | 771 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria australiensis |
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);;