contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192468 | 192468 | PRJNA1078753_P_NODE_20281_length_277_cov_1.509804_g20085_i0 | PRJNA1078753 | 20281 | 277 | 1.509804 | 4.18215708 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 252 | 2.34e-62 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g20085 | i0 | 83.154 | 89.5090252707581 | 279 | 43 | 100 | 4 | 1 | 277 | 279 | 3 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 24794 | 252 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 1467025 | 1467025 | PRJNA1078753_P_NODE_11542_length_337_cov_16.530303_g11346_i0 | PRJNA1078753 | 11542 | 337 | 16.530303 | 55.70712111 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 436 | 7.509999999999999e-118 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g11346 | i0 | 90.208 | 46.8278931750742 | 337 | 29 | 99 | 3 | 3 | 337 | 4342 | 4008 | Vannella septentrionalis 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 | 15781 | 436 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 5295439 | 5295439 | PRJNA1078753_P_NODE_4025_length_513_cov_1.197727_g3831_i0 | PRJNA1078753 | 4025 | 513 | 1.197727 | 6.14433951 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 272 | 3.54e-68 | NTclustered | gi|470482135|ref|XM_004367421.1| | 1257118 | g3831 | i0 | 77.754 | 61.1539961013645 | 463 | 89 | 89 | 11 | 57 | 512 | 2022 | 1567 | Acanthamoeba castellanii str. Neff heat shock protein 90 alpha, putative (ACA1_205910), partial mRNA | blastn | 31372 | 272 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10395811 | 10395811 | PRJNA1078753_P_NODE_21769_length_271_cov_1.550505_g21573_i0 | PRJNA1078753 | 21769 | 271 | 1.550505 | 4.20186855 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|470476036|ref|XM_004342168.1| | 1257118 | g21573 | i0 | 100 | 0.527675276752767 | 30 | 0 | 11 | 0 | 62 | 91 | 556 | 527 | Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_115170), partial mRNA | blastn | 143 | 56.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11671398 | 11671398 | PRJNA1078753_P_NODE_6990_length_407_cov_5.164671_g6794_i0 | PRJNA1078753 | 6990 | 407 | 5.164671 | 21.02021097 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 688 | 0 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g6794 | i0 | 97.066 | 102.34398034398 | 409 | 10 | 100 | 2 | 1 | 407 | 3821 | 3413 | Vannella septentrionalis 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 | 41654 | 688 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 14221217 | 14221217 | PRJNA1078753_P_NODE_20692_length_275_cov_2.287129_g20496_i0 | PRJNA1078753 | 20692 | 275 | 2.287129 | 6.28960475 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 99 | 3.2e-16 | NTclustered | gi|470526295|ref|XM_004356679.1| | 1257118 | g20496 | i0 | 85.263 | 13.4327272727273 | 95 | 14 | 35 | 0 | 101 | 195 | 2369 | 2275 | Acanthamoeba castellanii str. Neff vacuolar proton ATPase, putative (ACA1_175060), partial mRNA | blastn | 3694 | 99 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 18868467 | 18868467 | PRJNA1078753_P_NODE_19015_length_283_cov_0.961905_g18819_i0 | PRJNA1078753 | 19015 | 283 | 0.961905 | 2.72219115 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 202 | 2.4499999999999998e-47 | NTclustered | gi|470466676|ref|XM_004341684.1| | 1257118 | g18819 | i0 | 79.861 | 96.8445229681979 | 288 | 48 | 100 | 8 | 1 | 283 | 440 | 722 | Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_198710), partial mRNA | blastn | 27407 | 202 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 20593654 | 20593654 | PRJNA1078753_P_NODE_3357_length_552_cov_12.501044_g3163_i0 | PRJNA1078753 | 3357 | 552 | 12.501044 | 69.00576288 | Vannella sp. LITHOV | 1215650 | Discosea | other_Eukaryota | 974 | 0 | NTclustered | gi|399764235|gb|JQ271746.1| | 1215650 | g3163 | i0 | 98.553 | 99.0869565217391 | 553 | 5 | 100 | 3 | 1 | 552 | 592 | 42 | Vannella sp. LITHOV 18S ribosomal RNA gene, partial sequence | blastn | 54696 | 974 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. LITHOV | |||
| 24418368 | 24418368 | PRJNA1078753_P_NODE_16600_length_294_cov_1.868778_g16404_i0 | PRJNA1078753 | 16600 | 294 | 1.868778 | 5.49420732 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 150 | 9.399999999999999e-32 | NTclustered | gi|470526398|ref|XM_004356698.1| | 1257118 | g16404 | i0 | 78.298 | 1.67006802721088 | 235 | 49 | 80 | 2 | 53 | 286 | 52 | 285 | Acanthamoeba castellanii str. Neff cytochrome c, putative (ACA1_175250), partial mRNA | blastn | 491 | 150 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 24418393 | 24418393 | PRJNA1078753_P_NODE_2020_length_690_cov_15.403566_g1840_i0 | PRJNA1078753 | 2020 | 690 | 15.403566 | 106.2846054 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 939 | 0 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g1840 | i0 | 94.212 | 47.2246376811594 | 622 | 22 | 89 | 11 | 77 | 690 | 4 | 619 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 32585 | 939 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 24418594 | 24418594 | PRJNA1078753_P_NODE_480_length_1290_cov_7.463435_g372_i0 | PRJNA1078753 | 480 | 1290 | 7.463435 | 96.2783115 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 1834 | 0 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g372 | i0 | 92.629 | 52.6170542635659 | 1316 | 29 | 99 | 42 | 5 | 1290 | 826 | 2103 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 67876 | 1834 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus |
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);;