contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1174207" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 315964 | 315964 | PRJNA1174207_P_NODE_41321_length_241_cov_0.916667_g40792_i0 | PRJNA1174207 | 41321 | 241 | 0.916667 | 2.20916747 | Entamoeba gingivalis | 38877 | Evosea | other_Eukaryota | 438 | 1.4299999999999999e-118 | NTclustered | gi|2781670152|dbj|LC832224.1| | 38877 | g40792 | i0 | 99.585 | 97.2946058091286 | 241 | 0 | 99 | 1 | 2 | 241 | 558 | 318 | Entamoeba gingivalis ST1-1_human_Ishikawa_H118_2017 gene for 18S ribosomal RNA, partial sequence | blastn | 23448 | 438 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba gingivalis | |||
| 2866304 | 2866304 | PRJNA1174207_P_NODE_18943_length_326_cov_1.683794_g18414_i0 | PRJNA1174207 | 18943 | 326 | 1.683794 | 5.48916844 | Physarum cinereum | 289951 | Evosea | other_Eukaryota | 597 | 3.139999999999999e-166 | NTclustered | gi|224228205|dbj|AB435347.1| | 289951 | g18414 | i0 | 99.693 | 100.328220858896 | 326 | 1 | 100 | 0 | 1 | 326 | 46 | 371 | Physarum cinereum gene for small subunit ribosomal RNA, partial sequence, specimen_voucher: AK-06067 | blastn | 32707 | 597 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum cinereum | ||
| 4142643 | 4142643 | PRJNA1174207_P_NODE_33024_length_252_cov_1.290503_g32495_i0 | PRJNA1174207 | 33024 | 252 | 1.290503 | 3.25206756 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|831754232|ref|XM_012892599.1| | 1410327 | g32495 | i0 | 100 | 0.111111111111111 | 28 | 0 | 11 | 0 | 107 | 134 | 285 | 258 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 8693316 | 8693316 | PRJNA1174207_P_NODE_11927_length_431_cov_1.159218_g11400_i0 | PRJNA1174207 | 11927 | 431 | 1.159218 | 4.99622958 | Physarum | 5790 | Evosea | other_Eukaryota | 660 | 0 | NTclustered | gi|374255699|emb|HE614599.1| | 289951 | g11400 | i0 | 94.432 | 59.5568445475638 | 431 | 20 | 100 | 3 | 1 | 431 | 655 | 1081 | Physarum cinereum partial 18S rRNA gene, strain Idn-2 | blastn | 25669 | 660 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum cinereum | ||
| 11794422 | 11794422 | PRJNA1174207_P_NODE_37470_length_246_cov_0.890173_g36941_i0 | PRJNA1174207 | 37470 | 246 | 0.890173 | 2.18982558 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 156 | 1.65e-33 | NTclustered | gi|467633|emb|Z29969.1| | 5759 | g36941 | i0 | 78.846 | 43.9268292682927 | 260 | 33 | 99 | 10 | 3 | 246 | 2274 | 2021 | E.histolytica plasmid genes for ribosomal RNA and hemolysins HLY1, HLY5mc1 HLY5mc2 HLY4 | blastn | 10806 | 156 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 14344338 | 14344338 | PRJNA1174207_P_NODE_13112_length_404_cov_3.178248_g12584_i0 | PRJNA1174207 | 13112 | 404 | 3.178248 | 12.84012192 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 741 | 0 | NTclustered | gi|262262921|gb|FJ766464.1| | 472931 | g12584 | i0 | 99.752 | 48.990099009901 | 404 | 1 | 100 | 0 | 1 | 404 | 596 | 999 | Protostelium mycophagum strain KA-T15-2 small subunit ribosomal RNA gene, partial sequence | blastn | 19792 | 741 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 19441720 | 19441720 | PRJNA1174207_P_NODE_32276_length_255_cov_1.681319_g31747_i0 | PRJNA1174207 | 32276 | 255 | 1.681319 | 4.28736345 | Stemonitopsis subcaespitosa | 1048528 | Evosea | other_Eukaryota | 326 | 1.2399999999999999e-84 | NTclustered | gi|426281760|gb|JX681133.1| | 1048528 | g31747 | i0 | 90.04 | 82.2666666666667 | 251 | 25 | 98 | 0 | 1 | 251 | 244 | 494 | Stemonitopsis subcaespitosa actin gene, partial cds | blastn | 20978 | 326 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Stemonitopsis | Stemonitopsis subcaespitosa |
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);;