contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA942359" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6026008 | 6026008 | PRJNA942359_P_NODE_11425_length_266_cov_2.528497_g11310_i0 | PRJNA942359 | 11425 | 266 | 2.528497 | 6.72580202 | Vexillifera fluvialis | 1105343 | Discosea | other_Eukaryota | 425 | 1.24e-114 | NTclustered | gi|354720323|gb|HQ687482.1| | 1105343 | g11310 | i0 | 95.506 | 3.03007518796993 | 267 | 11 | 100 | 1 | 1 | 266 | 301 | 35 | Vexillifera fluvialis strain RR1 small subunit ribosomal RNA gene, partial sequence | blastn | 806 | 425 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Vexilliferidae | Vexillifera | Vexillifera fluvialis | ||
| 14951066 | 14951066 | PRJNA942359_P_NODE_6292_length_336_cov_1.292776_g6177_i0 | PRJNA942359 | 6292 | 336 | 1.292776 | 4.34372736 | Phalansterium filosum | 857046 | Evosea | other_Eukaryota | 185 | 2.9999999999999996e-42 | NTclustered | gi|300078501|gb|GU001163.1| | 857046 | g6177 | i0 | 78.378 | 99.6964285714286 | 296 | 56 | 87 | 7 | 2 | 292 | 2843 | 2551 | Phalansterium sp. EEG-2010/THA 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 33498 | 185 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium filosum | ||||
| 17501266 | 17501266 | PRJNA942359_P_NODE_4714_length_378_cov_1.711475_g4599_i0 | PRJNA942359 | 4714 | 378 | 1.711475 | 6.4693755 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 616 | 1.0199999999999997e-171 | NTclustered | gi|1812585648|gb|MT109102.1| | 590481 | g4599 | i0 | 96.032 | 73.6428571428571 | 378 | 15 | 100 | 0 | 1 | 378 | 39 | 416 | Uncultured Amoebozoa isolate PC:01/16 P437_Un small subunit ribosomal RNA gene, partial sequence | blastn | 27837 | 616 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 18774713 | 18774713 | PRJNA942359_P_NODE_16855_length_247_cov_0.896552_g16740_i0 | PRJNA942359 | 16855 | 247 | 0.896552 | 2.21448344 | Entamoeba suis | 359305 | Evosea | other_Eukaryota | 457 | 4.05e-124 | NTclustered | gi|2724186440|gb|PP735752.1| | 359305 | g16740 | i0 | 100 | 88.7570850202429 | 247 | 0 | 100 | 0 | 1 | 247 | 383 | 137 | Entamoeba suis isolate S009 small subunit ribosomal RNA gene, partial sequence | blastn | 21923 | 457 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba suis | |||
| 20049469 | 20049469 | PRJNA942359_P_NODE_11736_length_263_cov_2.221053_g11621_i0 | PRJNA942359 | 11736 | 263 | 2.221053 | 5.84136939 | Didymium azorellae | 2059306 | Evosea | other_Eukaryota | 285 | 2.1699999999999997e-72 | NTclustered | gi|2329703668|gb|MW240316.1| | 2059306 | g11621 | i0 | 86.364 | 99.9125475285171 | 264 | 33 | 100 | 3 | 1 | 263 | 93 | 354 | Didymium azorellae strain MA-Fungi 91159 small subunit ribosomal RNA gene, partial sequence | blastn | 26277 | 285 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium azorellae | ||
| 20049708 | 20049708 | PRJNA942359_P_NODE_4936_length_371_cov_1.677852_g4821_i0 | PRJNA942359 | 4936 | 371 | 1.677852 | 6.22483092 | Squamamoeba japonica | 1167875 | Evosea | other_Eukaryota | 161 | 5.619999999999998e-35 | NTclustered | gi|381423465|gb|JN638030.1| | 1167875 | g4821 | i0 | 76.218 | 26.9407008086253 | 349 | 58 | 89 | 17 | 43 | 371 | 1636 | 1979 | Squamamoeba japonica strain CCAP 1593/1 clone 2218 18S ribosomal RNA gene, partial sequence | blastn | 9995 | 161 | 1 | Eukaryota | Amoebozoa | Evosea | Squamamoeba | Squamamoeba japonica | |||||
| 24210372 | 24210372 | PRJNA942359_P_NODE_11679_length_264_cov_1.376963_g11564_i0 | PRJNA942359 | 11679 | 264 | 1.376963 | 3.63518232 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 479 | 9.33e-131 | NTclustered | gi|399764278|gb|JQ271789.1| | 1215998 | g11564 | i0 | 99.618 | 14.875 | 262 | 1 | 99 | 0 | 1 | 262 | 504 | 243 | Tubulinea group 04 sp. P18 18S ribosomal RNA gene, partial sequence | blastn | 3927 | 479 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. P18 |
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);;