contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192684 | 192684 | PRJNA1078753_P_NODE_44481_length_209_cov_4.058824_g44285_i0 | PRJNA1078753 | 44481 | 209 | 4.058824 | 8.48294216 | Arcella discoides | 1078856 | Tubulinea | other_Eukaryota | 195 | 2.88e-45 | NTclustered | gi|345452546|gb|JF694291.1| | 1078856 | g44285 | i0 | 86.264 | 62.2535885167464 | 182 | 22 | 86 | 3 | 1 | 180 | 709 | 529 | Arcella discoides isolate DL3_98 clone 5 actin gene, partial cds | blastn | 13011 | 195 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella discoides | ||
| 2743411 | 2743411 | PRJNA1078753_P_NODE_6003_length_434_cov_6.800554_g5807_i0 | PRJNA1078753 | 6003 | 434 | 6.800554 | 29.51440436 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 329 | 1.73e-85 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g5807 | i0 | 83.646 | 37.9308755760369 | 373 | 38 | 83 | 17 | 74 | 432 | 1 | 364 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 16462 | 329 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 2743418 | 2743418 | PRJNA1078753_P_NODE_6783_length_412_cov_15.587021_g6587_i0 | PRJNA1078753 | 6783 | 412 | 15.587021 | 64.21852652 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 750 | 0 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g6587 | i0 | 99.515 | 94.5291262135922 | 412 | 2 | 100 | 0 | 1 | 412 | 721 | 1132 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 38946 | 750 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 9945145 | 9945145 | PRJNA1078753_P_NODE_3928_length_518_cov_1.604494_g3734_i0 | PRJNA1078753 | 3928 | 518 | 1.604494 | 8.31127892 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 941 | 0 | NTclustered | gi|399764274|gb|JQ271785.1| | 1215994 | g3734 | i0 | 99.421 | 38.6003861003861 | 518 | 3 | 100 | 0 | 1 | 518 | 278 | 795 | Tubulinea group 04 sp. BCHM5 18S ribosomal RNA gene, partial sequence | blastn | 19995 | 946 | 0.994714587737844 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. BCHM5 | ||||||
| 16319410 | 16319410 | PRJNA1078753_P_NODE_2673_length_609_cov_21.001866_g2482_i0 | PRJNA1078753 | 2673 | 609 | 21.001866 | 127.90136394 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 1075 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g2482 | i0 | 98.522 | 83.3300492610837 | 609 | 9 | 100 | 0 | 1 | 609 | 1783 | 1175 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 50748 | 1075 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 18044305 | 18044305 | PRJNA1078753_P_NODE_255_length_1594_cov_24.317554_g187_i2 | PRJNA1078753 | 255 | 1594 | 24.317554 | 387.62181076 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 780 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g187 | i2 | 77.19 | 7.17252195734002 | 1381 | 287 | 85 | 22 | 208 | 1565 | 1376 | 1 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 11433 | 780 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea |
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);;