contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB8827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26074038 | 26074038 | PRJEB8827e_S_NODE_43197_length_151_cov_1.379310_g43169_i0 | PRJEB8827 | 43197 | 151 | 1.37931 | 2.0827581 | Trachemys scripta elegans | 31138 | Chordata | Chordata | 95.1 | 1.13e-23 | NR | XP_034619274.1 | 31138 | g43169 | i0 | 91.5 | 229.76821192053 | 47 | 4 | 93.4 | 0 | 3 | 143 | 61 | 107 | XP_034619274.1 40S ribosomal protein S27-like isoform X2 [Trachemys scripta elegans] | diamond | 34695 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Emydidae | Trachemys | Trachemys scripta | ||
| 26346386 | 26346386 | PRJEB8827f_S_NODE_27311_length_159_cov_2.354839_g27291_i0 | PRJEB8827 | 27311 | 159 | 2.354839 | 3.74419401 | Opisthokonta | 33154 | Chordata | Chordata | 70.9 | 3.98e-13 | NR | XP_064419590.1 | 7897 | g27291 | i0 | 81.4 | 12.1509433962264 | 43 | 8 | 81.1 | 0 | 1 | 129 | 185 | 227 | XP_064419590.1 elongation factor 1-beta [Latimeria chalumnae] | diamond | 1932 | 71.2 | 0.995786516853933 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 32931336 | 32931336 | PRJEB8827g_S_NODE_9793_length_160_cov_2.384000_g9772_i0 | PRJEB8827 | 9793 | 160 | 2.384 | 3.8144 | Alligator mississippiensis | 8496 | Chordata | Chordata | 55.1 | 5.39e-7 | NR | XP_059582170.1 | 8496 | g9772 | i0 | 84.4 | 6.225 | 32 | 5 | 60 | 0 | 160 | 65 | 108 | 139 | XP_059582170.1 uncharacterized protein LOC106740424 [Alligator mississippiensis] | diamond | 996 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Crocodylia | Alligatoridae | Alligator | Alligator mississippiensis | ||
| 32940499 | 32940499 | PRJEB8827b_S_NODE_25977_length_179_cov_1.451389_g25925_i0 | PRJEB8827 | 25977 | 179 | 1.451389 | 2.59798631 | root | 1 | Root_unresolved | Root_unresolved | 43.5 | 0.00829 | NR | GAB1296029.1 | 105296 | g25925 | i0 | 40 | 1.20670391061453 | 50 | 22 | 80.4 | 2 | 27 | 170 | 86 | 129 | GAB1296029.1 Olfactory receptor [Apodemus speciosus] | diamond | 216 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus speciosus | |
| 32948472 | 32948472 | PRJEB8827f_S_NODE_4426_length_218_cov_32.737705_g4406_i0 | PRJEB8827 | 4426 | 218 | 32.737705 | 71.3681969 | Branchiostoma floridae | 7739 | Chordata | Chordata | 44.7 | 0.00389 | NR | XP_035674994.1 | 7739 | g4406 | i0 | 61.5 | 0.357798165137615 | 26 | 10 | 35.8 | 0 | 195 | 118 | 165 | 190 | XP_035674994.1 tubulin alpha-1 chain-like [Branchiostoma floridae] | diamond | 78 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 32948540 | 32948540 | PRJEB8827h_S_NODE_3434_length_210_cov_1.525714_g3415_i0 | PRJEB8827 | 3434 | 210 | 1.525714 | 3.2039994 | Phallusia mammillata | 59560 | Chordata | Chordata | 97.4 | 8.9e-23 | NR | CAB3265762.1 | 59560 | g3415 | i0 | 71.4 | 2.7 | 63 | 18 | 90 | 0 | 208 | 20 | 157 | 219 | CAB3265762.1 40S ribosomal protein S3 [Phallusia mammillata] | diamond | 567 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 33033842 | 33033842 | PRJEB8827h_S_NODE_15780_length_185_cov_11.333333_g15761_i0 | PRJEB8827 | 15780 | 185 | 11.333333 | 20.96666605 | Branchiostoma floridae | 7739 | Chordata | Chordata | 44.3 | 0.00356 | NR | XP_035674994.1 | 7739 | g15761 | i0 | 61.5 | 0.421621621621622 | 26 | 10 | 42.2 | 0 | 27 | 104 | 165 | 190 | XP_035674994.1 tubulin alpha-1 chain-like [Branchiostoma floridae] | diamond | 78 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 33145321 | 33145321 | PRJEB8827f_S_NODE_23439_length_162_cov_1.771654_g23419_i0 | PRJEB8827 | 23439 | 162 | 1.771654 | 2.87007948 | Gymnophiona | 8445 | Chordata | Chordata | 42.7 | 0.00106 | NR | XP_029463224.1 | 194408 | g23419 | i0 | 63.4 | 2.83333333333333 | 41 | 13 | 72.2 | 1 | 122 | 6 | 1 | 41 | XP_029463224.1 thymosin beta-15B [Rhinatrema bivittatum] | diamond | 459 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Rhinatrematidae | Rhinatrema | Rhinatrema bivittatum | |
| 33153215 | 33153215 | PRJEB8827h_S_NODE_15792_length_185_cov_4.533333_g15773_i0 | PRJEB8827 | 15792 | 185 | 4.533333 | 8.38666605 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 78.2 | 3.46e-16 | NR | XP_055194079.1 | 34880 | g15773 | i0 | 62.7 | 74.627027027027 | 59 | 22 | 95.7 | 0 | 2 | 178 | 119 | 177 | XP_055194079.1 60S ribosomal protein L23a-like [Nyctereutes procyonoides] | diamond | 13806 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 33170336 | 33170336 | PRJEB8827h_S_NODE_42856_length_160_cov_1.488000_g42837_i0 | PRJEB8827 | 42856 | 160 | 1.488 | 2.3808 | Petromyzon marinus | 7757 | Chordata | Chordata | 44.3 | 8.97e-4 | NR | XP_032801518.1 | 7757 | g42837 | i0 | 95.2 | 1.18125 | 21 | 1 | 39.4 | 0 | 159 | 97 | 84 | 104 | XP_032801518.1 cytochrome c-like [Petromyzon marinus] | diamond | 189 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 33179538 | 33179538 | PRJEB8827h_S_NODE_38768_length_167_cov_2.113636_g38749_i0 | PRJEB8827 | 38768 | 167 | 2.113636 | 3.52977212 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 89 | 4.09e-19 | NR | XP_035692085.1 | 7739 | g38749 | i0 | 69.1 | 6.89820359281437 | 55 | 17 | 98.8 | 0 | 3 | 167 | 332 | 386 | XP_035692085.1 LOW QUALITY PROTEIN: S-adenosylmethionine synthase-like [Branchiostoma floridae] | diamond | 1152 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae |
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);;