contig_metadata
12 rows where bioproject = "PRJNA999747" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12753463 | 12753463 | PRJNA999747_S_NODE_1690_length_231_cov_5.860000_g1658_i0 | PRJNA999747 | 1690 | 231 | 5.86 | 13.5366 | Chordata | 7711 | Chordata | Chordata | 52.8 | 0.021 | NTclustered | gi|2721460824|emb|HG999682.4| | 9103 | g1658 | i0 | 100 | 0.242424242424242 | 28 | 0 | 12 | 0 | 94 | 121 | 32418365 | 32418392 | Meleagris gallopavo genome assembly, chromosome: 3 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Meleagris | Meleagris gallopavo | |
| 17558491 | 17558491 | PRJNA999747_S_NODE_4154_length_156_cov_1.904000_g4122_i0 | PRJNA999747 | 4154 | 156 | 1.904 | 2.97024 | Mus musculus | 10090 | Chordata | Chordata | 265 | 1.52e-66 | NTclustered | gi|2510669837|gb|OQ871514.1| | 10090 | g4122 | i0 | 97.436 | 63.224358974359 | 156 | 2 | 99 | 2 | 2 | 156 | 4854 | 4700 | Mus musculus clone BAC 18_2 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 | 9863 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 22657602 | 22657602 | PRJNA999747_S_NODE_2218_length_205_cov_2.936782_g2186_i0 | PRJNA999747 | 2218 | 205 | 2.936782 | 6.0204031 | Lampetra planeri | 7750 | Chordata | Chordata | 62.1 | 2.97e-5 | NTclustered | gi|2805746514|emb|OZ078535.1| | 7750 | g2186 | i0 | 100 | 0.658536585365854 | 33 | 0 | 16 | 0 | 3 | 35 | 3598062 | 3598030 | Lampetra planeri genome assembly, chromosome: 50 | blastn | 135 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra planeri | |
| 22657609 | 22657609 | PRJNA999747_S_NODE_2778_length_186_cov_66.554839_g2746_i0 | PRJNA999747 | 2778 | 186 | 66.554839 | 123.79200054 | Mus musculus | 10090 | Chordata | Chordata | 305 | 1.11e-78 | NTclustered | gi|2904934889|gb|PQ737812.1| | 10090 | g2746 | i0 | 96.237 | 103.376344086022 | 186 | 7 | 100 | 0 | 1 | 186 | 5 | 190 | Mus musculus lncRNA222 lncRNA, complete sequence | blastn | 19228 | 305 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 22951898 | 22951898 | PRJNA999747_S_NODE_2478_length_196_cov_3.054545_g2446_i0 | PRJNA999747 | 2478 | 196 | 3.054545 | 5.9869082 | root | 1 | Root_unresolved | Root_unresolved | 361 | 2.48e-95 | NTclustered | gi|2645168801|gb|OR992004.1| | 10090 | g2446 | i0 | 100 | 99.9897959183673 | 195 | 0 | 99 | 0 | 1 | 195 | 1032 | 838 | Mus musculus transgenic puromycin-resistant protein (Puro) gene, complete cds; red fluorescence protein (RFP) gene, complete sequence; and GFP-I-SceI (GFP-I-SceI) gene, complete cds | blastn | 19598 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 27095537 | 27095537 | PRJNA999747_S_NODE_1782_length_226_cov_2.825641_g1750_i0 | PRJNA999747 | 1782 | 226 | 2.825641 | 6.38594866 | Metazoa | 33208 | Chordata | Chordata | 91.3 | 2.48e-19 | NR | XP_051824300.1 | 38775 | g1750 | i0 | 61.6 | 3.88938053097345 | 73 | 26 | 96.9 | 1 | 5 | 223 | 293 | 363 | XP_051824300.1 polyadenylate-binding protein 4-like [Antechinus flavipes] | diamond | 879 | 92 | 0.992391304347826 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Dasyuromorphia | Dasyuridae | Antechinus | Antechinus flavipes | |
| 28611487 | 28611487 | PRJNA999747_S_NODE_4487_length_151_cov_1.591667_g4455_i0 | PRJNA999747 | 4487 | 151 | 1.591667 | 2.40341717 | Opisthokonta | 33154 | Chordata | Chordata | 66.6 | 1.42e-12 | NR | XP_019615044.1 | 7741 | g4455 | i0 | 62.5 | 8.3046357615894 | 48 | 18 | 95.4 | 0 | 4 | 147 | 8 | 55 | XP_019615044.1 PREDICTED: eukaryotic translation initiation factor 1-like isoform X2 [Branchiostoma belcheri] | diamond | 1254 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 29963409 | 29963409 | PRJNA999747_S_NODE_3571_length_166_cov_3.962963_g3539_i0 | PRJNA999747 | 3571 | 166 | 3.962963 | 6.57851858 | Staurois parvus | 386267 | Chordata | Chordata | 40.4 | 0.0338 | NR | CAI9594042.1 | 386267 | g3539 | i0 | 65 | 0.36144578313253 | 20 | 7 | 36.1 | 0 | 149 | 90 | 3 | 22 | CAI9594042.1 unnamed protein product [Staurois parvus] | diamond | 60 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30500488 | 30500488 | PRJNA999747_S_NODE_533_length_368_cov_2.531157_g501_i0 | PRJNA999747 | 533 | 368 | 2.531157 | 9.31465776 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 125 | 2.13e-30 | NR | CAK8689709.1 | 159417 | g501 | i0 | 64.7 | 0.970108695652174 | 119 | 42 | 97 | 0 | 3 | 359 | 628 | 746 | CAK8689709.1 unnamed protein product [Clavelina lepadiformis] | diamond | 357 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 31543554 | 31543554 | PRJNA999747_S_NODE_3556_length_167_cov_1.750000_g3524_i0 | PRJNA999747 | 3556 | 167 | 1.75 | 2.9225 | Varanus komodoensis | 61221 | Chordata | Chordata | 67 | 1.93e-11 | NR | KAF7248073.1 | 61221 | g3524 | i0 | 64.2 | 0.952095808383233 | 53 | 18 | 93.4 | 1 | 164 | 9 | 86 | 138 | KAF7248073.1 Neuronal vesicle trafficking-associated protein 1 [Varanus komodoensis] | diamond | 159 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Varanidae | Varanus | Varanus komodoensis | |
| 32303068 | 32303068 | PRJNA999747_S_NODE_1739_length_229_cov_2.878788_g1707_i0 | PRJNA999747 | 1739 | 229 | 2.878788 | 6.59242452 | Rana temporaria | 8407 | Chordata | Chordata | 82.4 | 3.02e-16 | NR | XP_040201177.1 | 8407 | g1707 | i0 | 52.9 | 2.75109170305677 | 70 | 32 | 91.7 | 1 | 14 | 223 | 93 | 161 | XP_040201177.1 peptidyl-prolyl cis-trans isomerase FKBP4 [Rana temporaria] | diamond | 630 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria | |
| 32908008 | 32908008 | PRJNA999747_S_NODE_2540_length_194_cov_2.325153_g2508_i0 | PRJNA999747 | 2540 | 194 | 2.325153 | 4.51079682 | Chordata | 7711 | Chordata | Chordata | 63.5 | 8.83e-10 | NR | XP_032805637.1 | 7757 | g2508 | i0 | 80.6 | 4.7319587628866 | 36 | 7 | 55.7 | 0 | 189 | 82 | 472 | 507 | XP_032805637.1 inositol-3-phosphate synthase 1 [Petromyzon marinus] | diamond | 918 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus |
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);;