contig_metadata
7 rows where bioproject = "PRJNA1237888" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1049744 | 1049744 | PRJNA1237888_S_NODE_4901_length_186_cov_1.510949_g4851_i0 | PRJNA1237888 | 4901 | 186 | 1.510949 | 2.81036514 | Flamella | 490353 | Evosea | other_Eukaryota | 344 | 2.34e-90 | NTclustered | gi|163943978|gb|EU186022.1| | 490515 | g4851 | i0 | 100 | 101.413978494624 | 186 | 0 | 100 | 0 | 1 | 186 | 1505 | 1690 | Flamella arnhemensis 18S ribosomal RNA gene, partial sequence | blastn | 18863 | 344 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Flamella | Flamella arnhemensis | |||
| 2325178 | 2325178 | PRJNA1237888_S_NODE_62_length_1065_cov_13.092520_g46_i0 | PRJNA1237888 | 62 | 1065 | 13.09252 | 139.435338 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 348 | 1.23e-90 | NTclustered | gi|2250222329|gb|ON713412.1| | 1182205 | g46 | i0 | 88.475 | 49.124882629108 | 295 | 24 | 54 | 7 | 562 | 852 | 746 | 458 | Dianema subretisporum voucher MM31413 small subunit ribosomal RNA gene, partial sequence | blastn | 52318 | 351 | 0.991452991452991 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Dianemataceae | Dianema | Dianema subretisporum | ||
| 4877895 | 4877895 | PRJNA1237888_S_NODE_3024_length_233_cov_1.130435_g2974_i0 | PRJNA1237888 | 3024 | 233 | 1.130435 | 2.63391355 | Flamella | 490353 | Evosea | other_Eukaryota | 431 | 2.2899999999999996e-116 | NTclustered | gi|163943978|gb|EU186022.1| | 490515 | g2974 | i0 | 100 | 97.1630901287554 | 233 | 0 | 100 | 0 | 1 | 233 | 994 | 762 | Flamella arnhemensis 18S ribosomal RNA gene, partial sequence | blastn | 22639 | 431 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Flamella | Flamella arnhemensis | |||
| 6152573 | 6152573 | PRJNA1237888_S_NODE_625_length_495_cov_7.008969_g575_i0 | PRJNA1237888 | 625 | 495 | 7.008969 | 34.69439655 | root | 1 | Root_unresolved | Root_unresolved | 75 | 1.03e-8 | NTclustered | gi|66826570|ref|XM_641548.1| | 352472 | g575 | i0 | 92.308 | 9.02828282828283 | 52 | 4 | 11 | 0 | 220 | 271 | 1427 | 1376 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0270238) mRNA, complete cds | blastn | 4469 | 75 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 9977916 | 9977916 | PRJNA1237888_S_NODE_628_length_494_cov_9.408989_g578_i0 | PRJNA1237888 | 628 | 494 | 9.408989 | 46.48040566 | Trichiidae | 208472 | Evosea | other_Eukaryota | 200 | 1.63e-46 | NTclustered | gi|501417099|gb|JX481313.1| | 647301 | g578 | i0 | 80.989 | 68.412955465587 | 263 | 41 | 71 | 9 | 235 | 494 | 1491 | 1747 | Trichia decipiens voucher AMFD159 18S ribosomal RNA gene, partial sequence | blastn | 33796 | 202 | 0.99009900990099 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Trichia | Trichia decipiens | ||
| 14375659 | 14375659 | PRJNA1237888_S_NODE_172_length_802_cov_7.857902_g147_i0 | PRJNA1237888 | 172 | 802 | 7.857902 | 63.02037404 | Arcyria sp. 'tenuissima' | 3129282 | Evosea | other_Eukaryota | 86.1 | 7.94e-12 | NTclustered | gi|2698738389|gb|PP491458.1| | 3129282 | g147 | i0 | 88.889 | 7.74064837905237 | 72 | 5 | 9 | 3 | 726 | 795 | 3514 | 3444 | Arcyria sp. 'tenuissima' voucher sc32644 internal transcribed spacer region, partial sequence | blastn | 6208 | 86.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Arcyria | Arcyria sp. 'tenuissima' | ||
| 22023450 | 22023450 | PRJNA1237888_S_NODE_2698_length_248_cov_1.281407_g2648_i0 | PRJNA1237888 | 2698 | 248 | 1.281407 | 3.17788936 | Phalansterium solitarium | 136499 | Evosea | other_Eukaryota | 337 | 5.53e-88 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g2648 | i0 | 91.2 | 52.1008064516129 | 250 | 18 | 100 | 3 | 1 | 248 | 2948 | 3195 | Phalansterium solitarium 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 | 12921 | 337 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium |
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);;