contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1126198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6659008 | 6659008 | PRJNA1126198_P_NODE_191586_length_295_cov_3.058559_g190866_i0 | PRJNA1126198 | 191586 | 295 | 3.058559 | 9.02274905 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 108 | 5.76e-19 | NTclustered | gi|470458637|ref|XM_004341224.1| | 1257118 | g190866 | i0 | 95.522 | 0.430508474576271 | 67 | 3 | 43 | 0 | 19 | 85 | 1611 | 1545 | Acanthamoeba castellanii str. Neff Flavinbinding monooxygenase-like subfamily protein (ACA1_262350), partial mRNA | blastn | 127 | 108 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7934049 | 7934049 | PRJNA1126198_P_NODE_119527_length_329_cov_2.214844_g118808_i0 | PRJNA1126198 | 119527 | 329 | 2.214844 | 7.28683676 | Thecamoeba foliovenanda | 2653195 | Discosea | other_Eukaryota | 603 | 6.819999999999999e-168 | NTclustered | gi|1758284524|gb|MN544291.1| | 2653195 | g118808 | i0 | 99.697 | 44.7629179331307 | 330 | 0 | 100 | 1 | 1 | 329 | 590 | 919 | Thecamoeba foliovenanda strain Ta68 small subunit ribosomal RNA gene, partial sequence | blastn | 14727 | 603 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba foliovenanda | |||
| 9209205 | 9209205 | PRJNA1126198_P_NODE_2228_length_1255_cov_3.491540_g1849_i0 | PRJNA1126198 | 2228 | 1255 | 3.49154 | 43.818827 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 942 | 0 | NTclustered | gi|470484553|ref|XM_004344028.1| | 1257118 | g1849 | i0 | 80.614 | 63.6326693227092 | 1238 | 224 | 98 | 14 | 1 | 1230 | 184 | 1413 | Acanthamoeba castellanii str. Neff Sadenosyl-L-homocysteine hydrolase, putative (ACA1_054200), partial mRNA | blastn | 79859 | 942 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9209895 | 9209895 | PRJNA1126198_P_NODE_86188_length_354_cov_1.103203_g85470_i0 | PRJNA1126198 | 86188 | 354 | 1.103203 | 3.90533862 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 276 | 1.83e-69 | NTclustered | gi|470521902|ref|XM_004353878.1| | 1257118 | g85470 | i0 | 81.006 | 86.4237288135593 | 358 | 58 | 99 | 9 | 1 | 353 | 1507 | 1859 | Acanthamoeba castellanii str. Neff integral membrane protein 1 isoform 5, putative (ACA1_169070), partial mRNA | blastn | 30594 | 276 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 14310717 | 14310717 | PRJNA1126198_P_NODE_494812_length_210_cov_4.218978_g494090_i0 | PRJNA1126198 | 494812 | 210 | 4.218978 | 8.8598538 | Thecamoeba foliovenanda | 2653195 | Discosea | other_Eukaryota | 388 | 1.24e-103 | NTclustered | gi|1758284524|gb|MN544291.1| | 2653195 | g494090 | i0 | 100 | 30.7238095238095 | 210 | 0 | 100 | 0 | 1 | 210 | 1314 | 1105 | Thecamoeba foliovenanda strain Ta68 small subunit ribosomal RNA gene, partial sequence | blastn | 6452 | 388 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba foliovenanda | |||
| 18881741 | 18881741 | PRJNA1126198_P_NODE_15595_length_524_cov_13.771619_g14910_i0 | PRJNA1126198 | 15595 | 524 | 13.771619 | 72.16328356 | Vannellidae | 95227 | Discosea | other_Eukaryota | 797 | 0 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g14910 | i0 | 94.14 | 100.81106870229 | 529 | 21 | 100 | 9 | 1 | 524 | 1693 | 1170 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 52825 | 802 | 0.993765586034913 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 19406964 | 19406964 | PRJNA1126198_P_NODE_13496_length_545_cov_5.527542_g12815_i0 | PRJNA1126198 | 13496 | 545 | 5.527542 | 30.1251039 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 231 | 6.41e-56 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g12815 | i0 | 80.464 | 55.0990825688073 | 302 | 59 | 55 | 0 | 103 | 404 | 422 | 121 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 30029 | 231 | 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);;