contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA1035005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7821228 | 7821228 | PRJNA1035005_P_NODE_10607_length_358_cov_1.091228_g10202_i0 | PRJNA1035005 | 10607 | 358 | 1.091228 | 3.90659624 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 401 | 2.9199999999999995e-107 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g10202 | i0 | 87.079 | 98.3184357541899 | 356 | 45 | 99 | 1 | 4 | 358 | 796 | 441 | Platyamoeba placida actin mRNA, partial cds | blastn | 35198 | 401 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 14197828 | 14197828 | PRJNA1035005_P_NODE_9992_length_364_cov_2.144330_g9587_i0 | PRJNA1035005 | 9992 | 364 | 2.14433 | 7.8053612 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 562 | 1.29e-155 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g9587 | i0 | 94.55 | 72.0164835164835 | 367 | 14 | 100 | 6 | 1 | 364 | 1467 | 1104 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 26214 | 562 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 21845705 | 21845705 | PRJNA1035005_P_NODE_32718_length_279_cov_1.368932_g32312_i0 | PRJNA1035005 | 32718 | 279 | 1.368932 | 3.81932028 | Vexillifera bacillipedes | 1105345 | Discosea | other_Eukaryota | 490 | 4.59e-134 | NTclustered | gi|399764261|gb|JQ271772.1| | 1105345 | g32312 | i0 | 98.221 | 31.3799283154122 | 281 | 3 | 100 | 1 | 1 | 279 | 446 | 166 | Vexillifera bacillipedes strain 6HZM 18S ribosomal RNA gene, partial sequence | blastn | 8755 | 490 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera bacillipedes | ||
| 23960305 | 23960305 | PRJNA1035005_P_NODE_799_length_1602_cov_12.758012_g616_i0 | PRJNA1035005 | 799 | 1602 | 12.758012 | 204.38335224 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 289 | 1.15e-72 | NTclustered | gi|28194618|gb|AF479562.1| | 29195 | g616 | i0 | 73.042 | 24.6011235955056 | 983 | 201 | 59 | 50 | 509 | 1453 | 433 | 1389 | Acanthamoeba griffini strain S7 16S small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 39411 | 291 | 0.993127147766323 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba griffini |
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);;