contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA980587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3506080 | 3506080 | PRJNA980587_P_NODE_34763_length_402_cov_1.854103_g33970_i0 | PRJNA980587 | 34763 | 402 | 1.854103 | 7.45349406 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 163 | 1.7099999999999998e-35 | NTclustered | gi|470531480|ref|XM_004358015.1| | 1257118 | g33970 | i0 | 78.486 | 17.1940298507463 | 251 | 52 | 62 | 2 | 102 | 351 | 296 | 47 | Acanthamoeba castellanii str. Neff ribosomal protein L31e, putative (ACA1_119160), partial mRNA | blastn | 6912 | 163 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12434839 | 12434839 | PRJNA980587_P_NODE_43830_length_349_cov_2.655797_g43037_i0 | PRJNA980587 | 43830 | 349 | 2.655797 | 9.26873153 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 555 | 2.0599999999999994e-153 | NTclustered | gi|1269228437|gb|MF683562.1| | 2047822 | g43037 | i0 | 95.442 | 95.9140401146132 | 351 | 11 | 99 | 5 | 2 | 349 | 985 | 637 | Ripella decalvata clone 15101 18S ribosomal RNA gene, partial sequence | blastn | 33474 | 555 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 18807165 | 18807165 | PRJNA980587_P_NODE_18655_length_595_cov_8.406130_g17872_i0 | PRJNA980587 | 18655 | 595 | 8.40613 | 50.0164735 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 756 | 0 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g17872 | i0 | 89.58 | 98.8890756302521 | 595 | 62 | 100 | 0 | 1 | 595 | 1127 | 533 | Platyamoeba placida actin mRNA, partial cds | blastn | 58839 | 756 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 18807450 | 18807450 | PRJNA980587_P_NODE_44835_length_345_cov_1.790441_g44042_i0 | PRJNA980587 | 44835 | 345 | 1.790441 | 6.17702145 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 444 | 4.6099999999999996e-120 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g44042 | i0 | 90.294 | 96.2608695652174 | 340 | 32 | 98 | 1 | 7 | 345 | 85 | 424 | Platyamoeba placida actin mRNA, partial cds | blastn | 33210 | 444 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 20082597 | 20082597 | PRJNA980587_P_NODE_73836_length_261_cov_1.281915_g73043_i0 | PRJNA980587 | 73836 | 261 | 1.281915 | 3.34579815 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 431 | 2.62e-116 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g73043 | i0 | 96.538 | 0.996168582375479 | 260 | 9 | 99 | 0 | 1 | 260 | 1358 | 1617 | 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 | 260 | 431 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 23908277 | 23908277 | PRJNA980587_P_NODE_52999_length_315_cov_1.272727_g52206_i0 | PRJNA980587 | 52999 | 315 | 1.272727 | 4.00909005 | Acanthamoeba astronyxis | 65658 | Discosea | other_Eukaryota | 99 | 3.73e-16 | NTclustered | gi|28194602|gb|AF479546.1| | 65658 | g52206 | i0 | 77.401 | 12.4920634920635 | 177 | 33 | 55 | 6 | 142 | 314 | 682 | 855 | Acanthamoeba astronyxis strain ATCC 30137 16S small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 3935 | 99 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba astronyxis |
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);;