contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA770826" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4575108 | 4575108 | PRJNA770826_P_NODE_12264_length_229_cov_3.177778_g12093_i0 | PRJNA770826 | 12264 | 229 | 3.177778 | 7.27711162 | Hartmannella cantabrigiensis | 239731 | Tubulinea | other_Eukaryota | 285 | 1.85e-72 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g12093 | i0 | 89.083 | 88.9912663755458 | 229 | 25 | 100 | 0 | 1 | 229 | 254 | 26 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 20379 | 285 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 4575234 | 4575234 | PRJNA770826_P_NODE_504_length_1114_cov_28.676056_g425_i0 | PRJNA770826 | 504 | 1114 | 28.676056 | 319.45126384 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 809 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g425 | i0 | 80.993 | 2.38330341113106 | 1047 | 176 | 93 | 18 | 84 | 1114 | 1382 | 343 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2655 | 809 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 5850427 | 5850427 | PRJNA770826_P_NODE_2585_length_540_cov_5.336049_g2417_i0 | PRJNA770826 | 2585 | 540 | 5.336049 | 28.8146646 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 841 | 0 | NTclustered | gi|345452598|gb|JF694317.1| | 1078852 | g2417 | i0 | 95.292 | 98.9888888888889 | 531 | 24 | 98 | 1 | 10 | 540 | 640 | 111 | Pyxidicula operculata clone 2 actin gene, partial cds | blastn | 53454 | 841 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata | |||
| 13500715 | 13500715 | PRJNA770826_P_NODE_5131_length_375_cov_3.134969_g4960_i0 | PRJNA770826 | 5131 | 375 | 3.134969 | 11.75613375 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 693 | 0 | NTclustered | gi|345294028|gb|JF694284.1| | 1078852 | g4960 | i0 | 100 | 69.6293333333333 | 375 | 0 | 100 | 0 | 1 | 375 | 901 | 1275 | Pyxidicula operculata small subunit ribosomal RNA gene, partial sequence | blastn | 26111 | 693 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata | |||
| 16049573 | 16049573 | PRJNA770826_P_NODE_513_length_1105_cov_29.258523_g425_i1 | PRJNA770826 | 513 | 1105 | 29.258523 | 323.30667915 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 837 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g425 | i1 | 81.429 | 2.4316742081448 | 1050 | 172 | 94 | 18 | 72 | 1105 | 1385 | 343 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2687 | 837 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 16049602 | 16049602 | PRJNA770826_P_NODE_873_length_896_cov_30.332940_g425_i4 | PRJNA770826 | 873 | 896 | 30.33294 | 271.7831424 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 667 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g425 | i4 | 80.562 | 2.63839285714286 | 890 | 154 | 98 | 17 | 21 | 896 | 1227 | 343 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2364 | 667 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 17325288 | 17325288 | PRJNA770826_P_NODE_574_length_1061_cov_28.289526_g425_i2 | PRJNA770826 | 574 | 1061 | 28.289526 | 300.15187086 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 832 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g425 | i2 | 81.322 | 7.4062205466541 | 1044 | 178 | 97 | 15 | 4 | 1034 | 1040 | 1 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 7858 | 832 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 18598704 | 18598704 | PRJNA770826_P_NODE_4135_length_424_cov_2.080000_g3964_i0 | PRJNA770826 | 4135 | 424 | 2.08 | 8.8192 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 556 | 7.099999999999998e-154 | NTclustered | gi|345452598|gb|JF694317.1| | 1078852 | g3964 | i0 | 90.521 | 99.6556603773585 | 422 | 38 | 99 | 2 | 4 | 424 | 526 | 106 | Pyxidicula operculata clone 2 actin gene, partial cds | blastn | 42254 | 556 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata | |||
| 22424281 | 22424281 | PRJNA770826_P_NODE_618_length_1031_cov_28.478615_g425_i3 | PRJNA770826 | 618 | 1031 | 28.478615 | 293.61452065 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 821 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g425 | i3 | 81.172 | 3.64403491755577 | 1041 | 179 | 99 | 15 | 4 | 1031 | 1040 | 4 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 3757 | 821 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 23699858 | 23699858 | PRJNA770826_P_NODE_2419_length_559_cov_3.031373_g2252_i0 | PRJNA770826 | 2419 | 559 | 3.031373 | 16.94537507 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 1005 | 0 | NTclustered | gi|345294028|gb|JF694284.1| | 1078852 | g2252 | i0 | 99.106 | 76.5366726296959 | 559 | 5 | 100 | 0 | 1 | 559 | 771 | 213 | Pyxidicula operculata small subunit ribosomal RNA gene, partial sequence | blastn | 42784 | 1005 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata |
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);;