contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1186363" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2870550 | 2870550 | PRJNA1186363_P_NODE_29523_length_320_cov_1.902834_g28635_i0 | PRJNA1186363 | 29523 | 320 | 1.902834 | 6.0890688 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 337 | 7.4e-88 | NTclustered | gi|470458047|ref|XM_004341152.1| | 1257118 | g28635 | i0 | 85.849 | 191.103125 | 318 | 43 | 99 | 2 | 4 | 320 | 510 | 194 | Acanthamoeba castellanii str. Neff polyubiquitin, putative (ACA1_335920), partial mRNA | blastn | 61153 | 337 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7972907 | 7972907 | PRJNA1186363_P_NODE_16987_length_471_cov_2.497487_g16100_i0 | PRJNA1186363 | 16987 | 471 | 2.497487 | 11.76316377 | Coronamoeba villafranca | 2936289 | Discosea | other_Eukaryota | 435 | 3.89e-117 | NTclustered | gi|2254079205|gb|ON260836.1| | 2936289 | g16100 | i0 | 83.404 | 98.2547770700637 | 470 | 76 | 99 | 2 | 3 | 471 | 662 | 194 | Dermamoebida sp. AKudryavtsev-2022a strain ZIN.2022.02 clone 6 actin gene, partial cds | blastn | 46278 | 435 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Coronamoeba | Coronamoeba villafranca | ||||
| 7973059 | 7973059 | PRJNA1186363_P_NODE_39327_length_251_cov_0.876404_g38439_i0 | PRJNA1186363 | 39327 | 251 | 0.876404 | 2.19977404 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 387 | 5.489999999999998e-103 | NTclustered | gi|470395276|ref|XM_004335009.1| | 1257118 | g38439 | i0 | 94.422 | 1 | 251 | 14 | 100 | 0 | 1 | 251 | 490 | 740 | Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_097280), partial mRNA | blastn | 251 | 387 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7973077 | 7973077 | PRJNA1186363_P_NODE_41987_length_246_cov_0.901734_g41099_i0 | PRJNA1186363 | 41987 | 246 | 0.901734 | 2.21826564 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 372 | 1.5e-98 | NTclustered | gi|470507538|ref|XM_004367569.1| | 1257118 | g41099 | i0 | 93.902 | 1 | 246 | 15 | 100 | 0 | 1 | 246 | 176 | 421 | Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_253670), partial mRNA | blastn | 246 | 372 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11798424 | 11798424 | PRJNA1186363_P_NODE_36570_length_265_cov_1.218750_g35682_i0 | PRJNA1186363 | 36570 | 265 | 1.21875 | 3.2296875 | Thecamoeba similis | 242545 | Discosea | other_Eukaryota | 291 | 4.71e-74 | NTclustered | gi|33946350|gb|AY294154.1| | 242545 | g35682 | i0 | 87.352 | 90.5056603773585 | 253 | 32 | 95 | 0 | 13 | 265 | 36 | 288 | Thecamoeba similis actin mRNA, complete cds | blastn | 23984 | 291 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba similis | |||
| 15622471 | 15622471 | PRJNA1186363_P_NODE_20473_length_417_cov_1.912791_g19585_i0 | PRJNA1186363 | 20473 | 417 | 1.912791 | 7.97633847 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 582 | 1.1499999999999996e-161 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g19585 | i0 | 91.866 | 96.9640287769784 | 418 | 32 | 100 | 2 | 1 | 417 | 516 | 932 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 40434 | 582 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 15622573 | 15622573 | PRJNA1186363_P_NODE_39373_length_251_cov_0.876404_g38485_i0 | PRJNA1186363 | 39373 | 251 | 0.876404 | 2.19977404 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 448 | 2.48e-121 | NTclustered | gi|470525862|ref|XM_004356613.1| | 1257118 | g38485 | i0 | 98.805 | 65.7729083665339 | 251 | 3 | 100 | 0 | 1 | 251 | 949 | 699 | Acanthamoeba castellanii str. Neff asparagine-tRNA ligase (ACA1_174260), partial mRNA | blastn | 16509 | 448 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16896839 | 16896839 | PRJNA1186363_P_NODE_22294_length_394_cov_0.968847_g21406_i0 | PRJNA1186363 | 22294 | 394 | 0.968847 | 3.81725718 | Paramoeba branchiphila | 308475 | Discosea | other_Eukaryota | 374 | 7.079999999999998e-99 | NTclustered | gi|226347442|gb|FJ807261.1| | 308475 | g21406 | i0 | 84.293 | 87.761421319797 | 382 | 58 | 97 | 2 | 1 | 381 | 808 | 428 | Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds | blastn | 34578 | 374 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba branchiphila | ||
| 16896945 | 16896945 | PRJNA1186363_P_NODE_41754_length_246_cov_0.901734_g40866_i0 | PRJNA1186363 | 41754 | 246 | 0.901734 | 2.21826564 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 422 | 1.47e-113 | NTclustered | gi|470506274|ref|XM_004348681.1| | 1257118 | g40866 | i0 | 97.561 | 1 | 246 | 6 | 100 | 0 | 1 | 246 | 1414 | 1169 | Acanthamoeba castellanii str. Neff cation exchanger, putative (ACA1_035470), partial mRNA | blastn | 246 | 422 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21996471 | 21996471 | PRJNA1186363_P_NODE_32458_length_296_cov_1.322870_g31570_i0 | PRJNA1186363 | 32458 | 296 | 1.32287 | 3.9156952 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 375 | 1.4399999999999995e-99 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g31570 | i0 | 89.761 | 87.7837837837838 | 293 | 30 | 99 | 0 | 4 | 296 | 807 | 515 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 25984 | 375 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 |
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);;