contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1215813" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4158833 | 4158833 | PRJNA1215813_P_NODE_8264_length_272_cov_1.648241_g8184_i0 | PRJNA1215813 | 8264 | 272 | 1.648241 | 4.48321552 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 215 | 3.01e-51 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g8184 | i0 | 80.882 | 98.9338235294118 | 272 | 52 | 100 | 0 | 1 | 272 | 149 | 420 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 26910 | 215 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10535578 | 10535578 | PRJNA1215813_P_NODE_2329_length_488_cov_1.918072_g2249_i0 | PRJNA1215813 | 2329 | 488 | 1.918072 | 9.36019136 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 255 | 3.38e-63 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g2249 | i0 | 81.329 | 63.2377049180328 | 316 | 58 | 65 | 1 | 48 | 362 | 422 | 107 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 30860 | 255 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 13085400 | 13085400 | PRJNA1215813_P_NODE_2971_length_439_cov_1.224044_g2891_i0 | PRJNA1215813 | 2971 | 439 | 1.224044 | 5.37355316 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 292 | 2.3e-74 | NTclustered | gi|927486|emb|X79205.1| | 5755 | g2891 | i0 | 81.117 | 64.3371298405467 | 376 | 61 | 84 | 6 | 3 | 370 | 773 | 1146 | A.castellanii mRNA for methionine adenosyltransferase | blastn | 28244 | 292 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14360760 | 14360760 | PRJNA1215813_P_NODE_412_length_1029_cov_105.780335_g349_i1 | PRJNA1215813 | 412 | 1029 | 105.780335 | 1088.47964715 | Vannella sp. GERL14 | 1002217 | Discosea | other_Eukaryota | 673 | 0 | NTclustered | gi|327391632|gb|HM363630.1| | 1002217 | g349 | i1 | 95.54 | 39.8726919339164 | 426 | 9 | 41 | 6 | 2 | 418 | 427 | 3 | Vannella sp. GERL14 small subunit ribosomal RNA gene, partial sequence | blastn | 41029 | 673 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. GERL14 | |||
| 15634655 | 15634655 | PRJNA1215813_P_NODE_1333_length_636_cov_1.944938_g1256_i0 | PRJNA1215813 | 1333 | 636 | 1.944938 | 12.36980568 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 372 | 4.27e-98 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g1256 | i0 | 78.109 | 77.0911949685535 | 603 | 120 | 94 | 11 | 39 | 635 | 607 | 11 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 49030 | 372 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19457805 | 19457805 | PRJNA1215813_P_NODE_396_length_1052_cov_103.213483_g349_i0 | PRJNA1215813 | 396 | 1052 | 103.213483 | 1085.80584116 | Vannella sp. GERL14 | 1002217 | Discosea | other_Eukaryota | 673 | 0 | NTclustered | gi|327391632|gb|HM363630.1| | 1002217 | g349 | i0 | 95.54 | 39.0009505703422 | 426 | 9 | 40 | 6 | 2 | 418 | 427 | 3 | Vannella sp. GERL14 small subunit ribosomal RNA gene, partial sequence | blastn | 41029 | 673 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. GERL14 | |||
| 22008446 | 22008446 | PRJNA1215813_P_NODE_3478_length_407_cov_5.517964_g3398_i0 | PRJNA1215813 | 3478 | 407 | 5.517964 | 22.45811348 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 582 | 1.1199999999999999e-161 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g3398 | i0 | 92.326 | 94.4398034398034 | 417 | 20 | 100 | 9 | 1 | 407 | 3414 | 3828 | 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 | 38437 | 582 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 22008547 | 22008547 | PRJNA1215813_P_NODE_9778_length_252_cov_0.871508_g9698_i0 | PRJNA1215813 | 9778 | 252 | 0.871508 | 2.19620016 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 187 | 6e-43 | NTclustered | gi|470525569|ref|XM_004356569.1| | 1257118 | g9698 | i0 | 81.176 | 1.20634920634921 | 255 | 28 | 94 | 5 | 16 | 251 | 944 | 691 | Acanthamoeba castellanii str. Neff mitochondrial phosphate transporter, putative (ACA1_173800), partial mRNA | blastn | 304 | 187 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;