contig_metadata
9 rows where bioproject = "PRJNA290839" and tax_phylum = "Chordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11851577 | 11851577 | PRJNA290839_P_NODE_1650_length_242_cov_0.911243_g1629_i0 | PRJNA290839 | 1650 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 131 | 4.5e-35 | NR | NP_001025589.1 | 8364 | g1629 | i0 | 86.1 | 65.3181818181818 | 79 | 11 | 97.9 | 0 | 1 | 237 | 57 | 135 | NP_001025589.1 succinate--CoA ligase [ADP/GDP-forming] subunit alpha, mitochondrial [Xenopus tropicalis] | diamond | 15807 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 15087093 | 15087093 | PRJNA290839_P_NODE_1332_length_247_cov_0.896552_g1311_i0 | PRJNA290839 | 1332 | 247 | 0.896552 | 2.21448344 | Elephantidae | 9780 | Chordata | Chordata | 241 | 4.44e-59 | NTclustered | gi|2710901988|ref|XM_064293858.1| | 9785 | g1311 | i0 | 84.874 | 46.1336032388664 | 238 | 36 | 96 | 0 | 2 | 239 | 155 | 392 | PREDICTED: Loxodonta africana calmodulin 3 (CALM3), mRNA | blastn | 11395 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Proboscidea | Elephantidae | Loxodonta | Loxodonta africana | |
| 23324954 | 23324954 | PRJNA290839_P_NODE_1479_length_245_cov_0.901163_g1458_i0 | PRJNA290839 | 1479 | 245 | 0.901163 | 2.20784935 | Mus musculus | 10090 | Chordata | Chordata | 453 | 5.1900000000000006e-123 | NTclustered | gi|18606171|gb|BC022986.1| | 10090 | g1458 | i0 | 100 | 66.9755102040816 | 245 | 0 | 100 | 0 | 1 | 245 | 2 | 246 | Mus musculus transferrin, mRNA (cDNA clone MGC:29918 IMAGE:5123741), complete cds | blastn | 16409 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 26757533 | 26757533 | PRJNA290839_P_NODE_1361_length_247_cov_0.885057_g1340_i0 | PRJNA290839 | 1361 | 247 | 0.885057 | 2.18609079 | Geotrypetes seraphini | 260995 | Chordata | Chordata | 110 | 4.3e-26 | NR | XP_033798422.1 | 260995 | g1340 | i0 | 65.9 | 0.995951417004049 | 82 | 28 | 99.6 | 0 | 2 | 247 | 1112 | 1193 | XP_033798422.1 multidrug resistance-associated protein 1-like isoform X2 [Geotrypetes seraphini] | diamond | 246 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Dermophiidae | Geotrypetes | Geotrypetes seraphini | |
| 28337505 | 28337505 | PRJNA290839_P_NODE_1106_length_251_cov_0.876404_g1085_i0 | PRJNA290839 | 1106 | 251 | 0.876404 | 2.19977404 | Dromiciops gliroides | 33562 | Chordata | Chordata | 64.3 | 2.14e-10 | NR | XP_043826057.1 | 33562 | g1085 | i0 | 54.8 | 3.50199203187251 | 73 | 33 | 87.3 | 0 | 15 | 233 | 111 | 183 | XP_043826057.1 60S ribosomal protein L17-like [Dromiciops gliroides] | diamond | 879 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Microbiotheria | Microbiotheriidae | Dromiciops | Dromiciops gliroides | |
| 30136988 | 30136988 | PRJNA290839_P_NODE_1232_length_249_cov_0.880682_g1211_i0 | PRJNA290839 | 1232 | 249 | 0.880682 | 2.19289818 | Hypanus sabinus | 79690 | Chordata | Chordata | 61.2 | 1.2e-8 | NR | XP_059823631.1 | 79690 | g1211 | i0 | 46 | 0.602409638554217 | 50 | 27 | 60.2 | 0 | 80 | 229 | 558 | 607 | XP_059823631.1 IQ calmodulin-binding motif-containing protein 1 isoform X1 [Hypanus sabinus] | diamond | 150 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 30359047 | 30359047 | PRJNA290839_P_NODE_1132_length_251_cov_0.865169_g1111_i0 | PRJNA290839 | 1132 | 251 | 0.865169 | 2.17157419 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 64.3 | 1.01e-9 | NR | XP_002720903.2 | 9986 | g1111 | i0 | 42.5 | 0.956175298804781 | 80 | 40 | 88.4 | 1 | 222 | 1 | 192 | 271 | XP_002720903.2 uncharacterized protein [Oryctolagus cuniculus] | diamond | 240 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 31450780 | 31450780 | PRJNA290839_P_NODE_1536_length_243_cov_1.082353_g1515_i0 | PRJNA290839 | 1536 | 243 | 1.082353 | 2.63011779 | Xenopus | 8353 | Chordata | Chordata | 75.9 | 5.06e-15 | NR | NP_001084009.1 | 8355 | g1515 | i0 | 57.4 | 43.4074074074074 | 68 | 29 | 84 | 0 | 206 | 3 | 32 | 99 | NP_001084009.1 myosin light chain 11 [Xenopus laevis] | diamond | 10548 | 76.6 | 0.990861618798956 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 32255947 | 32255947 | PRJNA290839_P_NODE_1098_length_251_cov_0.876404_g1077_i0 | PRJNA290839 | 1098 | 251 | 0.876404 | 2.19977404 | Protopterus annectens | 7888 | Chordata | Chordata | 73.2 | 8.07e-13 | NR | XP_043929618.1 | 7888 | g1077 | i0 | 48.8 | 2.77290836653386 | 80 | 37 | 95.6 | 1 | 246 | 7 | 887 | 962 | XP_043929618.1 protein mono-ADP-ribosyltransferase PARP14-like [Protopterus annectens] | diamond | 696 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens |
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);;