contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB2925" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1300310 | 1300310 | PRJEB2925_P_NODE_11522_length_324_cov_1.913495_g10247_i0 | PRJEB2925 | 11522 | 324 | 1.913495 | 6.1997238 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 206 | 2.21e-48 | NTclustered | gi|423291978|gb|JQ519434.1| | 5778 | g10247 | i0 | 92.908 | 40.8611111111111 | 141 | 10 | 79 | 0 | 1 | 141 | 740 | 600 | Vermamoeba vermiformis clone JG10.93_e2 actin gene, partial cds | blastn | 13239 | 206 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 1300449 | 1300449 | PRJEB2925_P_NODE_9482_length_383_cov_3.591954_g8212_i0 | PRJEB2925 | 9482 | 383 | 3.591954 | 13.75718382 | Tubulinea group 04 sp. CAL5 | 1215995 | Tubulinea | other_Eukaryota | 702 | 0 | NTclustered | gi|399764275|gb|JQ271786.1| | 1215995 | g8212 | i0 | 99.739 | 14.3080939947781 | 383 | 1 | 100 | 0 | 1 | 383 | 577 | 195 | Tubulinea group 04 sp. CAL5 18S ribosomal RNA gene, partial sequence | blastn | 5480 | 702 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. CAL5 | ||||||
| 7365678 | 7365678 | PRJEB2925_P_NODE_14066_length_274_cov_2.121339_g12788_i0 | PRJEB2925 | 14066 | 274 | 2.121339 | 5.81246886 | root | 1 | Root_unresolved | Root_unresolved | 418 | 2.15e-112 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g12788 | i0 | 95.42 | 52.8357664233577 | 262 | 12 | 96 | 0 | 13 | 274 | 19574 | 19835 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 14477 | 418 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 16290765 | 16290765 | PRJEB2925_P_NODE_17273_length_213_cov_12.696629_g15995_i0 | PRJEB2925 | 17273 | 213 | 12.696629 | 27.04381977 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 394 | 2.7e-105 | NTclustered | gi|1345606837|gb|MG969829.1| | 5778 | g15995 | i0 | 100 | 99.9953051643192 | 213 | 0 | 100 | 0 | 1 | 213 | 216 | 428 | Vermamoeba vermiformis isolate Hart1f small subunit ribosomal RNA gene, partial sequence | blastn | 21299 | 394 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 16602956 | 16602956 | PRJEB2925_P_NODE_5574_length_565_cov_5.128302_g4522_i0 | PRJEB2925 | 5574 | 565 | 5.128302 | 28.9749063 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 568 | 4.469999999999999e-157 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g4522 | i0 | 95.265 | 63.9769911504425 | 359 | 16 | 64 | 1 | 207 | 565 | 1139 | 1496 | Hartmannella vermiformis 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 | 36147 | 568 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19151613 | 19151613 | PRJEB2925_P_NODE_14056_length_274_cov_2.527197_g12778_i0 | PRJEB2925 | 14056 | 274 | 2.527197 | 6.92451978 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 193 | 1.4200000000000001e-44 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g12778 | i0 | 95.082 | 29.5948905109489 | 122 | 6 | 79 | 0 | 153 | 274 | 19264 | 19385 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 8109 | 193 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21702865 | 21702865 | PRJEB2925_P_NODE_4438_length_655_cov_4.350000_g3496_i0 | PRJEB2925 | 4438 | 655 | 4.35 | 28.4925 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 363 | 2.65e-95 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g3496 | i0 | 80.864 | 31.4595419847328 | 486 | 71 | 73 | 20 | 88 | 565 | 1 | 472 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 20606 | 363 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 25214191 | 25214191 | PRJEB2925_P_NODE_7080_length_479_cov_43.927928_g5915_i0 | PRJEB2925 | 7080 | 479 | 43.927928 | 210.41477512 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 885 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g5915 | i0 | 100 | 94.5574112734864 | 479 | 0 | 100 | 0 | 1 | 479 | 1654 | 1176 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 45293 | 885 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 |
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);;