contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA459724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2993703 | 2993703 | PRJNA459724_P_NODE_3043_length_272_cov_44.222222_g2652_i0 | PRJNA459724 | 3043 | 272 | 44.222222 | 120.28444384 | Naegleria andersoni | 5764 | Heterolobosea | other_Eukaryota | 309 | 1.3400000000000002e-79 | NTclustered | gi|292659331|gb|GU597049.1| | 5764 | g2652 | i0 | 91.981 | 95.2095588235294 | 212 | 11 | 78 | 1 | 1 | 212 | 36 | 241 | Naegleria andersoni isolate B31/FB1 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 | 25897 | 309 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria andersoni | ||||
| 4922081 | 4922081 | PRJNA459724_P_NODE_2164_length_359_cov_3.742424_g1776_i0 | PRJNA459724 | 2164 | 359 | 3.742424 | 13.43530216 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 586 | 7.539999999999998e-163 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g1776 | i0 | 96.1 | 10.3704735376045 | 359 | 14 | 100 | 0 | 1 | 359 | 5442 | 5800 | 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 | 3723 | 586 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 5546731 | 5546731 | PRJNA459724_P_NODE_5725_length_156_cov_2.149606_g5333_i0 | PRJNA459724 | 5725 | 156 | 2.149606 | 3.35338536 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 134 | 4.4600000000000006e-27 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g5333 | i0 | 92.553 | 1.01282051282051 | 94 | 6 | 98 | 1 | 4 | 96 | 377 | 284 | Naegleria gruberi mitochondrion, complete genome | blastn | 158 | 134 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 6820732 | 6820732 | PRJNA459724_S_NODE_906_length_207_cov_2.366279_g903_i0 | PRJNA459724 | 906 | 207 | 2.366279 | 4.89819753 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 276 | 9.87e-70 | NTclustered | gi|290991940|ref|XM_002678547.1| | 5762 | g903 | i0 | 97.531 | 77.231884057971 | 162 | 3 | 78 | 1 | 1 | 161 | 1009 | 1170 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_56107), mRNA | blastn | 15987 | 276 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 17020385 | 17020385 | PRJNA459724_P_NODE_1954_length_388_cov_8.005571_g1571_i0 | PRJNA459724 | 1954 | 388 | 8.005571 | 31.06161548 | Naegleria andersoni | 5764 | Heterolobosea | other_Eukaryota | 715 | 0 | NTclustered | gi|2351569|gb|U80057.1|NAU80057 | 5764 | g1571 | i0 | 100 | 90.6572164948454 | 387 | 0 | 99 | 0 | 1 | 387 | 38 | 424 | Naegleria andersoni 18S ribosomal RNA gene, partial sequence | blastn | 35175 | 715 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria andersoni | ||||
| 17671578 | 17671578 | PRJNA459724_P_NODE_1254_length_521_cov_5.979675_g941_i0 | PRJNA459724 | 1254 | 521 | 5.979675 | 31.15410675 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 824 | 0 | NTclustered | gi|2476253407|gb|OQ627480.1| | 51634 | g941 | i0 | 95.202 | 19.9596928982726 | 521 | 25 | 100 | 0 | 1 | 521 | 4347 | 3827 | 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 | 10399 | 830 | 0.992771084337349 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria australiensis | ||||
| 17671587 | 17671587 | PRJNA459724_P_NODE_5174_length_173_cov_10.687500_g4782_i0 | PRJNA459724 | 5174 | 173 | 10.6875 | 18.489375 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 254 | 3.71e-63 | NTclustered | gi|440222388|gb|JX030056.1| | 5659 | g4782 | i0 | 93.529 | 87.4277456647399 | 170 | 11 | 98 | 0 | 2 | 171 | 13 | 182 | Leishmania amazonensis isolate LaPH8.rRNA.32 28S ribosomal RNA (LSU-delta M2), partial sequence | blastn | 15125 | 254 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania amazonensis | ||
| 20220267 | 20220267 | PRJNA459724_P_NODE_4036_length_213_cov_62.413043_g3644_i0 | PRJNA459724 | 4036 | 213 | 62.413043 | 132.93978159 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 270 | 4.75e-68 | NTclustered | gi|2414483|emb|Y00055.1| | 5656 | g3644 | i0 | 91.414 | 113 | 198 | 16 | 93 | 1 | 1 | 198 | 7031 | 6835 | Crithidia fasciculata ribosomal DNA repeat (complete) | blastn | 24069 | 272 | 0.992647058823529 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Crithidia | Crithidia fasciculata | ||
| 20844736 | 20844736 | PRJNA459724_S_NODE_457_length_235_cov_14.520000_g454_i0 | PRJNA459724 | 457 | 235 | 14.52 | 34.122 | Stygiella incarcerata | 1712417 | Root_unresolved | Root_unresolved | 75 | 4.49e-9 | NTclustered | gi|1039091306|gb|KX235465.1| | 1712417 | g454 | i0 | 83.133 | 0.353191489361702 | 83 | 12 | 35 | 2 | 40 | 121 | 1196 | 1277 | Stygiella incarcerata 60S ribosomal protein L3-2 (Rpl3) mRNA, complete cds | blastn | 83 | 75 | 1 | Eukaryota | Discoba | Jakobida | Stygiellidae | Stygiella | Stygiella incarcerata | ||||
| 22770959 | 22770959 | PRJNA459724_P_NODE_1378_length_494_cov_4.668817_g1048_i0 | PRJNA459724 | 1378 | 494 | 4.668817 | 23.06395598 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 907 | 0 | NTclustered | gi|2351569|gb|U80057.1|NAU80057 | 5764 | g1048 | i0 | 100 | 98.1255060728745 | 491 | 0 | 99 | 0 | 1 | 491 | 720 | 1210 | Naegleria andersoni 18S ribosomal RNA gene, partial sequence | blastn | 48474 | 907 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria andersoni | ||||
| 23395256 | 23395256 | PRJNA459724_P_NODE_599_length_766_cov_34.830393_g401_i0 | PRJNA459724 | 599 | 766 | 34.830393 | 266.80081038 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 1031 | 0 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g401 | i0 | 94.118 | 28.7545691906005 | 680 | 36 | 99 | 3 | 91 | 766 | 3030 | 2351 | 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 | 22026 | 1031 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 24045876 | 24045876 | PRJNA459724_P_NODE_1579_length_454_cov_4.811765_g1048_i1 | PRJNA459724 | 1579 | 454 | 4.811765 | 21.8454131 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 715 | 0 | NTclustered | gi|2351569|gb|U80057.1|NAU80057 | 5764 | g1048 | i1 | 100 | 97.9669603524229 | 387 | 0 | 99 | 0 | 1 | 387 | 720 | 1106 | Naegleria andersoni 18S ribosomal RNA gene, partial sequence | blastn | 44477 | 715 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria andersoni |
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);;