contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax_phylum = "Nematoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181092 | 181092 | PRJNA1067370_P_NODE_72521_length_261_cov_1.186170_g71972_i0 | PRJNA1067370 | 72521 | 261 | 1.18617 | 3.0959037 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.024 | NTclustered | gi|687865513|emb|LK927530.1| | 6239 | g71972 | i0 | 100 | 0.21455938697318 | 28 | 0 | 11 | 0 | 45 | 72 | 91312 | 91285 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000001 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 1455194 | 1455194 | PRJNA1067370_P_NODE_102622_length_244_cov_1.350877_g102073_i0 | PRJNA1067370 | 102622 | 244 | 1.350877 | 3.29613988 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 150 | 7.589999999999999e-32 | NTclustered | gi|1972232684|ref|NM_060327.8| | 6239 | g102073 | i0 | 79.263 | 27.155737704918 | 217 | 43 | 89 | 2 | 5 | 220 | 250 | 35 | Caenorhabditis elegans Large ribosomal subunit protein eL30 (rpl-30), mRNA | blastn | 6626 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 4007159 | 4007159 | PRJNA1067370_P_NODE_20864_length_412_cov_1.817109_g20316_i0 | PRJNA1067370 | 20864 | 412 | 1.817109 | 7.48648908 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 283 | 1.29e-71 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g20316 | i0 | 81.481 | 5.09223300970874 | 351 | 59 | 84 | 6 | 3 | 350 | 384 | 37 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2098 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 4007512 | 4007512 | PRJNA1067370_P_NODE_69424_length_265_cov_2.187500_g68875_i0 | PRJNA1067370 | 69424 | 265 | 2.1875 | 5.796875 | Leptojacobus dorci | 1463561 | Nematoda | Nematoda | 150 | 8.349999999999998e-32 | NTclustered | gi|675118843|gb|KJ877301.1| | 1463561 | g68875 | i0 | 84.314 | 15.9849056603774 | 153 | 24 | 58 | 0 | 29 | 181 | 207 | 55 | Leptojacobus dorci strain RS9005 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 4236 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Leptojacobus | Leptojacobus dorci | |
| 5283586 | 5283586 | PRJNA1067370_P_NODE_27365_length_368_cov_3.033898_g26817_i0 | PRJNA1067370 | 27365 | 368 | 3.033898 | 11.16474464 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 680 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g26817 | i0 | 100 | 52.3478260869565 | 368 | 0 | 100 | 0 | 1 | 368 | 2677 | 3044 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 19264 | 680 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 5283807 | 5283807 | PRJNA1067370_P_NODE_64805_length_272_cov_2.211055_g64256_i0 | PRJNA1067370 | 64805 | 272 | 2.211055 | 6.0140696 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 187 | 6.559999999999998e-43 | NTclustered | gi|2445366864|ref|XM_003111767.2| | 31234 | g64256 | i0 | 79.259 | 24.4889705882353 | 270 | 54 | 99 | 2 | 1 | 269 | 868 | 1136 | Caenorhabditis remanei uncharacterized protein (GCK72_010694), partial mRNA | blastn | 6661 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 11659526 | 11659526 | PRJNA1067370_P_NODE_48650_length_299_cov_2.044248_g48102_i0 | PRJNA1067370 | 48650 | 299 | 2.044248 | 6.11230152 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 150 | 9.58e-32 | NTclustered | gi|1376144539|ref|XM_024652732.1| | 34506 | g48102 | i0 | 82.456 | 0.819397993311037 | 171 | 30 | 57 | 0 | 33 | 203 | 243 | 73 | Strongyloides ratti 40S ribosomal protein S14 (SRAE_2000174400), partial mRNA | blastn | 245 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 12934503 | 12934503 | PRJNA1067370_P_NODE_28751_length_361_cov_3.868056_g28203_i0 | PRJNA1067370 | 28751 | 361 | 3.868056 | 13.96368216 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 303 | 8.56e-78 | NTclustered | gi|268537031|ref|XM_002633606.1| | 6238 | g28203 | i0 | 85.324 | 76.3351800554017 | 293 | 43 | 81 | 0 | 67 | 359 | 55 | 347 | Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA | blastn | 27557 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 12934798 | 12934798 | PRJNA1067370_P_NODE_72151_length_261_cov_1.638298_g71602_i0 | PRJNA1067370 | 72151 | 261 | 1.638298 | 4.27595778 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 198 | 2.89e-46 | NTclustered | gi|1376154927|ref|XM_024651418.1| | 34506 | g71602 | i0 | 82.328 | 168.114942528736 | 232 | 37 | 88 | 4 | 1 | 230 | 230 | 1 | Strongyloides ratti Histone H3 (SRAE_X000165500), partial mRNA | blastn | 43878 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 14209375 | 14209375 | PRJNA1067370_P_NODE_15832_length_466_cov_0.987277_g15284_i0 | PRJNA1067370 | 15832 | 466 | 0.987277 | 4.60071082 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 311 | 6.770000000000001e-80 | NTclustered | gi|1376155483|ref|XM_024654540.1| | 34506 | g15284 | i0 | 79.015 | 72.9206008583691 | 467 | 88 | 99 | 10 | 5 | 466 | 2746 | 2285 | Strongyloides ratti Plasma membrane calcium-transporting ATPase 3 (SRAE_X000193300), partial mRNA | blastn | 33981 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 14209694 | 14209694 | PRJNA1067370_P_NODE_63352_length_275_cov_0.995050_g62803_i0 | PRJNA1067370 | 63352 | 275 | 0.99505 | 2.7363875 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 172 | 1.86e-38 | NTclustered | gi|1376151557|ref|XM_024644287.1| | 34506 | g62803 | i0 | 81.951 | 4.07636363636364 | 205 | 35 | 74 | 2 | 70 | 273 | 909 | 706 | Strongyloides ratti Zinc finger protein sens (SRAE_2000529000), partial mRNA | blastn | 1121 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 15483802 | 15483802 | PRJNA1067370_P_NODE_70933_length_263_cov_1.473684_g70384_i0 | PRJNA1067370 | 70933 | 263 | 1.473684 | 3.87578892 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 76.8 | 1.42e-9 | NTclustered | gi|687022665|emb|LM525579.1| | 174720 | g70384 | i0 | 85.915 | 0.269961977186312 | 71 | 10 | 27 | 0 | 16 | 86 | 243529 | 243599 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000019 | blastn | 71 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 16757582 | 16757582 | PRJNA1067370_P_NODE_16454_length_458_cov_1.400000_g15906_i0 | PRJNA1067370 | 16454 | 458 | 1.4 | 6.412 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.044 | NTclustered | gi|690018461|emb|LM525699.1| | 174720 | g15906 | i0 | 100 | 0.0611353711790393 | 28 | 0 | 6 | 0 | 51 | 78 | 19086 | 19059 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000095 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 18032423 | 18032423 | PRJNA1067370_P_NODE_21875_length_404_cov_3.486405_g21327_i0 | PRJNA1067370 | 21875 | 404 | 3.486405 | 14.0850762 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 215 | 4.67e-51 | NTclustered | gi|268537031|ref|XM_002633606.1| | 6238 | g21327 | i0 | 80.882 | 13.7747524752475 | 272 | 52 | 67 | 0 | 17 | 288 | 377 | 106 | Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA | blastn | 5565 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 20581979 | 20581979 | PRJNA1067370_P_NODE_38597_length_323_cov_2.192000_g38049_i0 | PRJNA1067370 | 38597 | 323 | 2.192 | 7.08016 | Onchocerca volvulus | 6282 | Nematoda | Nematoda | 230 | 1.3099999999999995e-55 | NTclustered | gi|546000|gb|S70027.1| | 6282 | g38049 | i0 | 81.919 | 36.0278637770898 | 271 | 49 | 84 | 0 | 20 | 290 | 324 | 54 | hsp70 [Onchocerca volvulus, mRNA Partial, 324 nt] | blastn | 11637 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Onchocerca | Onchocerca volvulus | |
| 23133383 | 23133383 | PRJNA1067370_P_NODE_78859_length_251_cov_2.089888_g78310_i0 | PRJNA1067370 | 78859 | 251 | 2.089888 | 5.24561888 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|412976662|emb|AL110487.2| | 6239 | g78310 | i0 | 100 | 0.223107569721116 | 28 | 0 | 11 | 0 | 44 | 71 | 69531 | 69504 | Caenorhabditis elegans YAC Y39E4B, complete sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans |
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);;