contig_metadata
19 rows where bioproject = "PRJEB39269", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1331343 | 1331343 | PRJEB39269_P_NODE_40662_length_215_cov_2.522727_g40257_i0 | PRJEB39269 | 40662 | 215 | 2.522727 | 5.42386305 | Latimeria chalumnae | 7897 | Chordata | Chordata | 60.2 | 1.13e-4 | NTclustered | gi|2721754178|ref|XM_064552669.1| | 7897 | g40257 | i0 | 97.222 | 0.637209302325581 | 36 | 0 | 16 | 1 | 129 | 163 | 11866 | 11901 | PREDICTED: Latimeria chalumnae periaxin (PRX), mRNA | blastn | 137 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 3883213 | 3883213 | PRJEB39269_P_NODE_78524_length_159_cov_4.666667_g78119_i0 | PRJEB39269 | 78524 | 159 | 4.666667 | 7.42000053 | Sus scrofa | 9823 | Chordata | Chordata | 150 | 4.54e-32 | NTclustered | gi|220682617|gb|EU853705.1| | 9823 | g78119 | i0 | 100 | 265.503144654088 | 81 | 0 | 100 | 0 | 1 | 81 | 107549 | 107629 | Sus scrofa acetyl-coenzyme A carboxylase beta (ACACB) gene, complete cds, alternatively spliced | blastn | 42215 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 3883231 | 3883231 | PRJEB39269_P_NODE_84104_length_155_cov_16.646552_g83699_i0 | PRJEB39269 | 84104 | 155 | 16.646552 | 25.8021556 | Jaculus jaculus | 51337 | Chordata | Chordata | 76.8 | 7.56e-10 | NTclustered | gi|2147875786|ref|XR_006634867.1| | 51337 | g83699 | i0 | 80.556 | 9.65806451612903 | 108 | 13 | 66 | 8 | 2 | 104 | 15 | 119 | PREDICTED: Jaculus jaculus U2 spliceosomal RNA (LOC123457024), ncRNA | blastn | 1497 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Dipodidae | Jaculus | Jaculus jaculus | |
| 6435321 | 6435321 | PRJEB39269_P_NODE_89246_length_151_cov_3.562500_g88841_i0 | PRJEB39269 | 89246 | 151 | 3.5625 | 5.379375 | Canis lupus | 9612 | Chordata | Chordata | 106 | 9.33e-19 | NTclustered | gi|167860228|gb|AC190116.3| | 9615 | g88841 | i0 | 87.234 | 5.32450331125828 | 94 | 11 | 87 | 1 | 43 | 135 | 188275 | 188182 | Canis familiaris chromosome 31, clone XX-443F3, complete sequence | blastn | 804 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 14085341 | 14085341 | PRJEB39269_P_NODE_36492_length_228_cov_1.947090_g36087_i0 | PRJEB39269 | 36492 | 228 | 1.94709 | 4.4393652 | Eretmochelys imbricata | 27787 | Chordata | Chordata | 52.8 | 0.02 | NTclustered | gi|2913380327|emb|OZ223903.1| | 27787 | g36087 | i0 | 100 | 0.12280701754386 | 28 | 0 | 12 | 0 | 114 | 141 | 3387378 | 3387351 | Eretmochelys imbricata isolate rEreImb1 genome assembly, chromosome: 22 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Eretmochelys | Eretmochelys imbricata | ||
| 14085364 | 14085364 | PRJEB39269_P_NODE_63332_length_174_cov_0.962963_g62927_i0 | PRJEB39269 | 63332 | 174 | 0.962963 | 1.67555562 | Scyliorhinus canicula | 7830 | Chordata | Chordata | 86.1 | 1.44e-12 | NTclustered | gi|1952459419|ref|XM_038779474.1| | 7830 | g62927 | i0 | 87.838 | 1.79310344827586 | 74 | 8 | 42 | 1 | 35 | 107 | 809 | 882 | PREDICTED: Scyliorhinus canicula sorting nexin-11-like (LOC119954333), transcript variant X2, mRNA | blastn | 312 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 19182541 | 19182541 | PRJEB39269_P_NODE_43996_length_207_cov_1.220238_g43591_i0 | PRJEB39269 | 43996 | 207 | 1.220238 | 2.52589266 | Mus musculus | 10090 | Chordata | Chordata | 374 | 3.4e-99 | NTclustered | gi|2548330513|gb|OQ915115.1| | 10090 | g43591 | i0 | 99.512 | 41.1932367149758 | 205 | 1 | 99 | 0 | 3 | 207 | 3264 | 3468 | Mus musculus clone BAC JH_40 45S ribosomal RNA and 18S ribosomal RNA genes, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, 3' and 5' external transcribed spacers, complete sequence; and 18S ribosomal RNA gene, partial sequence | blastn | 8527 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 19182586 | 19182586 | PRJEB39269_P_NODE_83156_length_156_cov_2.452991_g82751_i0 | PRJEB39269 | 83156 | 156 | 2.452991 | 3.82666596 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 52.8 | 0.013 | NTclustered | gi|2327560703|ref|XM_051934506.1| | 27687 | g82751 | i0 | 100 | 3.07692307692308 | 28 | 0 | 18 | 0 | 1 | 28 | 10287 | 10260 | PREDICTED: Erpetoichthys calabaricus ectodysplasin A2 receptor (eda2r), mRNA | blastn | 480 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 23009156 | 23009156 | PRJEB39269_P_NODE_87839_length_152_cov_4.575221_g87434_i0 | PRJEB39269 | 87839 | 152 | 4.575221 | 6.95433592 | Ailuropoda melanoleuca | 9646 | Chordata | Chordata | 62.1 | 2.06e-5 | NTclustered | gi|1845353832|ref|XM_034642189.1| | 9646 | g87434 | i0 | 85.965 | 0.375 | 57 | 8 | 38 | 0 | 96 | 152 | 4886 | 4942 | PREDICTED: Ailuropoda melanoleuca uncharacterized LOC117795940 (LOC117795940), mRNA | blastn | 57 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Ursidae | Ailuropoda | Ailuropoda melanoleuca | |
| 28012702 | 28012702 | PRJEB39269_P_NODE_65325_length_171_cov_2.250000_g64920_i0 | PRJEB39269 | 65325 | 171 | 2.25 | 3.8475 | Staurois parvus | 386267 | Chordata | Chordata | 51.6 | 1.4e-6 | NR | CAI9618505.1 | 386267 | g64920 | i0 | 43.9 | 1 | 57 | 31 | 98.2 | 1 | 171 | 4 | 38 | 94 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 171 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28738735 | 28738735 | PRJEB39269_P_NODE_64907_length_172_cov_1.120301_g64502_i0 | PRJEB39269 | 64907 | 172 | 1.120301 | 1.92691772 | Staurois parvus | 386267 | Chordata | Chordata | 62 | 1.16e-10 | NR | CAI9618505.1 | 386267 | g64502 | i0 | 53.5 | 1.5 | 43 | 20 | 75 | 0 | 1 | 129 | 9 | 51 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 258 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28770234 | 28770234 | PRJEB39269_P_NODE_58367_length_180_cov_2.531915_g57962_i0 | PRJEB39269 | 58367 | 180 | 2.531915 | 4.557447 | Polypterus senegalus | 55291 | Chordata | Chordata | 49.3 | 6.43e-5 | NR | XP_039600642.1 | 55291 | g57962 | i0 | 64.7 | 1.16666666666667 | 34 | 12 | 56.7 | 0 | 178 | 77 | 199 | 232 | XP_039600642.1 E3 SUMO-protein ligase ZBED1-like [Polypterus senegalus] | diamond | 210 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 29243963 | 29243963 | PRJEB39269_P_NODE_80149_length_159_cov_0.941667_g79744_i0 | PRJEB39269 | 80149 | 159 | 0.941667 | 1.49725053 | Pseudophryne corroboree | 495146 | Chordata | Chordata | 61.6 | 2.54e-9 | NR | XP_063810519.1 | 495146 | g79744 | i0 | 56 | 0.943396226415094 | 50 | 22 | 94.3 | 0 | 9 | 158 | 208 | 257 | XP_063810519.1 toll-like receptor 7 [Pseudophryne corroboree] | diamond | 150 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Myobatrachidae | Pseudophryne | Pseudophryne corroboree | |
| 29426582 | 29426582 | PRJEB39269_P_NODE_90429_length_151_cov_1.098214_g90024_i0 | PRJEB39269 | 90429 | 151 | 1.098214 | 1.65830314 | root | 1 | Root_unresolved | Root_unresolved | 110 | 1.07e-26 | NR | XP_030109804.2 | 10090 | g90024 | i0 | 100 | 10.9271523178808 | 50 | 0 | 99.3 | 0 | 1 | 150 | 90 | 139 | XP_030109804.2 uncharacterized protein Gm52666 [Mus musculus] | diamond | 1650 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 30191207 | 30191207 | PRJEB39269_P_NODE_71292_length_167_cov_0.898438_g70887_i0 | PRJEB39269 | 71292 | 167 | 0.898438 | 1.50039146 | Engystomops pustulosus | 76066 | Chordata | Chordata | 59.7 | 6.53e-10 | NR | KAG8573553.1 | 76066 | g70887 | i0 | 65.5 | 0.988023952095808 | 55 | 19 | 98.8 | 0 | 2 | 166 | 1 | 55 | KAG8573553.1 hypothetical protein GDO81_012454 [Engystomops pustulosus] | diamond | 165 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 30854785 | 30854785 | PRJEB39269_P_NODE_59834_length_178_cov_2.266187_g59429_i0 | PRJEB39269 | 59834 | 178 | 2.266187 | 4.03381286 | Suricata suricatta | 37032 | Chordata | Chordata | 98.6 | 2.66e-22 | NR | XP_029793673.1 | 37032 | g59429 | i0 | 98 | 27.7921348314607 | 50 | 1 | 84.3 | 0 | 178 | 29 | 438 | 487 | XP_029793673.1 transmembrane protein 87B isoform X3 [Suricata suricatta] | diamond | 4947 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Herpestidae | Suricata | Suricata suricatta | |
| 31455495 | 31455495 | PRJEB39269_P_NODE_14776_length_365_cov_2.346626_g14371_i0 | PRJEB39269 | 14776 | 365 | 2.346626 | 8.5651849 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.5 | 0.0266 | NR | KAG2471189.1 | 55291 | g14371 | i0 | 57.1 | 0.287671232876712 | 35 | 15 | 28.8 | 0 | 208 | 312 | 92 | 126 | KAG2471189.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 105 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31859881 | 31859881 | PRJEB39269_P_NODE_75997_length_162_cov_1.146341_g75592_i0 | PRJEB39269 | 75997 | 162 | 1.146341 | 1.85707242 | Vespertilionidae | 9431 | Chordata | Chordata | 68.9 | 6.45e-12 | NR | XP_054581941.1 | 29078 | g75592 | i0 | 94.3 | 1.94444444444444 | 35 | 2 | 64.8 | 0 | 57 | 161 | 84 | 118 | XP_054581941.1 cytosolic 5'-nucleotidase 3A isoform X1 [Eptesicus fuscus] | diamond | 315 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Eptesicus | Eptesicus fuscus | |
| 32081436 | 32081436 | PRJEB39269_P_NODE_77838_length_160_cov_1.355372_g77433_i0 | PRJEB39269 | 77838 | 160 | 1.355372 | 2.1685952 | Mammalia | 40674 | Chordata | Chordata | 51.6 | 9.13e-6 | NR | KAG5195681.1 | 9940 | g77433 | i0 | 93.3 | 1.6875 | 30 | 2 | 56.3 | 0 | 2 | 91 | 1184 | 1213 | KAG5195681.1 hypothetical protein JEQ12_011976 [Ovis aries] | diamond | 270 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries |
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);;