contig_metadata
8 rows where bioproject = "PRJNA643700" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4445816 | 4445816 | PRJNA643700_P_NODE_273884_length_224_cov_2.080000_g272328_i0 | PRJNA643700 | 273884 | 224 | 2.08 | 4.6592 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|66808720|ref|XM_632991.1| | 352472 | g272328 | i0 | 100 | 0.129464285714286 | 29 | 0 | 13 | 0 | 91 | 119 | 112 | 140 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0285483) mRNA, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 6996914 | 6996914 | PRJNA643700_P_NODE_56146_length_556_cov_1.268245_g54657_i0 | PRJNA643700 | 56146 | 556 | 1.268245 | 7.0514422 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|470264596|ref|XM_004361195.1| | 261658 | g54657 | i0 | 100 | 0.0539568345323741 | 30 | 0 | 5 | 0 | 299 | 328 | 185 | 156 | Cavenderia fasciculata acid ceramidase-like protein (dcd1A), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 8271497 | 8271497 | PRJNA643700_P_NODE_369107_length_176_cov_2.850394_g367551_i0 | PRJNA643700 | 369107 | 176 | 2.850394 | 5.01669344 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|66807904|ref|XM_632583.1| | 352472 | g367551 | i0 | 94.286 | 0.198863636363636 | 35 | 2 | 20 | 0 | 13 | 47 | 5168 | 5134 | Dictyostelium discoideum AX4 vacuolar protein sorting-associated protein 13 family protein (vps13D) mRNA, complete cds | blastn | 35 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 13372378 | 13372378 | PRJNA643700_P_NODE_430451_length_155_cov_2.160377_g428895_i0 | PRJNA643700 | 430451 | 155 | 2.160377 | 3.34858435 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|1160552810|ref|XM_020571739.1| | 670386 | g428895 | i0 | 100 | 0.361290322580645 | 28 | 0 | 18 | 0 | 128 | 155 | 3887 | 3914 | Polysphondylium pallidum PN500 inositol 1,4,5-trisphosphate receptor-like protein (iplA), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 15187233 | 15187233 | PRJNA643700_P_NODE_67612_length_509_cov_1.547826_g66084_i0 | PRJNA643700 | 67612 | 509 | 1.547826 | 7.87843434 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|330790870|ref|XM_003283471.1| | 5786 | g66084 | i0 | 97.059 | 0.18467583497053 | 34 | 0 | 6 | 1 | 96 | 128 | 262 | 229 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_74487), partial mRNA | blastn | 94 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 17196041 | 17196041 | PRJNA643700_P_NODE_277774_length_222_cov_1.502890_g276218_i0 | PRJNA643700 | 277774 | 222 | 1.50289 | 3.3364158 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|66806462|ref|XM_631862.1| | 352472 | g276218 | i0 | 100 | 0.126126126126126 | 28 | 0 | 13 | 0 | 7 | 34 | 1308 | 1281 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0288045) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 21020482 | 21020482 | PRJNA643700_P_NODE_201877_length_277_cov_1.070175_g200321_i0 | PRJNA643700 | 201877 | 277 | 1.070175 | 2.96438475 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|470237675|ref|XM_004350744.1| | 261658 | g200321 | i0 | 100 | 0.101083032490975 | 28 | 0 | 10 | 0 | 166 | 193 | 97 | 124 | Cavenderia fasciculata uncharacterized protein (DFA_11851), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 24844666 | 24844666 | PRJNA643700_P_NODE_425380_length_162_cov_0.920354_g423824_i0 | PRJNA643700 | 425380 | 162 | 0.920354 | 1.49097348 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|66800378|ref|XM_629113.1| | 352472 | g423824 | i0 | 100 | 0.172839506172839 | 28 | 0 | 17 | 0 | 66 | 93 | 3446 | 3473 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0293476) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum |
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);;