contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 711892 | 711892 | PRJNA725806_P_NODE_46361_length_254_cov_5.741935_g46064_i0 | PRJNA725806 | 46361 | 254 | 5.741935 | 14.5845149 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|687022701|emb|LM525615.1| | 174720 | g46064 | i0 | 100 | 0.118110236220472 | 30 | 0 | 12 | 0 | 121 | 150 | 124200 | 124229 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000025 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 1987883 | 1987883 | PRJNA725806_P_NODE_29962_length_287_cov_3.348000_g29665_i0 | PRJNA725806 | 29962 | 287 | 3.348 | 9.60876 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.027 | NTclustered | gi|687022642|emb|LM525556.1| | 174720 | g29665 | i0 | 100 | 0.0975609756097561 | 28 | 0 | 10 | 0 | 129 | 156 | 1284322 | 1284349 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000002 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 3263023 | 3263023 | PRJNA725806_P_NODE_117103_length_186_cov_2.093960_g116801_i0 | PRJNA725806 | 117103 | 186 | 2.09396 | 3.8947656 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 78.7 | 2.6200000000000003e-10 | NTclustered | gi|687865803|emb|LK927963.1| | 6239 | g116801 | i0 | 78.462 | 2.52688172043011 | 130 | 20 | 67 | 6 | 62 | 186 | 10680 | 10806 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000367 | blastn | 470 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 4540379 | 4540379 | PRJNA725806_P_NODE_73524_length_219_cov_10.351648_g73223_i0 | PRJNA725806 | 73524 | 219 | 10.351648 | 22.67010912 | Brugia malayi | 6279 | Nematoda | Nematoda | 152 | 1.8599999999999998e-32 | NTclustered | gi|2082293650|ref|XM_043074288.1| | 6279 | g73223 | i0 | 86.331 | 3.87671232876712 | 139 | 19 | 63 | 0 | 36 | 174 | 10474 | 10612 | Brugia malayi Start codon is not identified, putative (Bma-eel-1), partial mRNA | blastn | 849 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 5815517 | 5815517 | PRJNA725806_P_NODE_49345_length_249_cov_8.773585_g49048_i0 | PRJNA725806 | 49345 | 249 | 8.773585 | 21.84622665 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|104295117|gb|AC187040.1| | 6334 | g49048 | i0 | 100 | 0.457831325301205 | 30 | 0 | 12 | 0 | 23 | 52 | 65333 | 65362 | Trichinella spiralis chromosome UNK clone TS195-35H12, complete sequence | blastn | 114 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 7090674 | 7090674 | PRJNA725806_P_NODE_52326_length_245_cov_3.495192_g52029_i0 | PRJNA725806 | 52326 | 245 | 3.495192 | 8.5632204 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.022 | NTclustered | gi|690018488|emb|LM525726.1| | 174720 | g52029 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 160 | 187 | 47559 | 47532 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000121 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 8364993 | 8364993 | PRJNA725806_P_NODE_101487_length_196_cov_4.025157_g101185_i0 | PRJNA725806 | 101487 | 196 | 4.025157 | 7.88930772 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 56.5 | 0.001 | NTclustered | gi|373218521|emb|FO080101.1| | 6239 | g101185 | i0 | 92.5 | 0.408163265306122 | 40 | 2 | 20 | 1 | 22 | 61 | 24879 | 24917 | Caenorhabditis elegans Cosmid C27A12, complete sequence | blastn | 80 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 8365181 | 8365181 | PRJNA725806_P_NODE_32207_length_282_cov_1.216327_g31910_i0 | PRJNA725806 | 32207 | 282 | 1.216327 | 3.43004214 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.026 | NTclustered | gi|687022679|emb|LM525593.1| | 174720 | g31910 | i0 | 100 | 0.099290780141844 | 28 | 0 | 10 | 0 | 17 | 44 | 144087 | 144114 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000027 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 8365237 | 8365237 | PRJNA725806_P_NODE_60507_length_234_cov_4.934010_g60209_i0 | PRJNA725806 | 60507 | 234 | 4.93401 | 11.5455834 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|1767288484|ref|NM_001029151.4| | 6239 | g60209 | i0 | 90.698 | 0.551282051282051 | 43 | 1 | 18 | 3 | 88 | 129 | 1403 | 1443 | Caenorhabditis elegans DUF148 domain-containing protein (B0403.5), mRNA | blastn | 129 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 9640364 | 9640364 | PRJNA725806_P_NODE_189508_length_152_cov_3.078261_g189206_i0 | PRJNA725806 | 189508 | 152 | 3.078261 | 4.67895672 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.012 | NTclustered | gi|690018493|emb|LM525731.1| | 174720 | g189206 | i0 | 100 | 0.184210526315789 | 28 | 0 | 18 | 0 | 44 | 71 | 26366 | 26339 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000053 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 10915991 | 10915991 | PRJNA725806_P_NODE_5229_length_437_cov_10.212500_g4951_i0 | PRJNA725806 | 5229 | 437 | 10.2125 | 44.628625 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.042 | NTclustered | gi|690021316|emb|LM529018.1| | 174720 | g4951 | i0 | 100 | 0.0640732265446224 | 28 | 0 | 6 | 0 | 350 | 377 | 862 | 889 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0003337 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 17289722 | 17289722 | PRJNA725806_P_NODE_11034_length_366_cov_4.392097_g10746_i0 | PRJNA725806 | 11034 | 366 | 4.392097 | 16.07507502 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.035 | NTclustered | gi|687865763|emb|LK927532.1| | 6239 | g10746 | i0 | 100 | 0.153005464480874 | 28 | 0 | 8 | 0 | 121 | 148 | 301374 | 301401 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000003 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 18563666 | 18563666 | PRJNA725806_P_NODE_4455_length_454_cov_5.201439_g4181_i0 | PRJNA725806 | 4455 | 454 | 5.201439 | 23.61453306 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.044 | NTclustered | gi|687865440|emb|LK927606.1| | 6239 | g4181 | i0 | 100 | 0.123348017621145 | 28 | 0 | 6 | 0 | 48 | 75 | 159473 | 159446 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000071 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 19838982 | 19838982 | PRJNA725806_P_NODE_99456_length_197_cov_11.143750_g99154_i0 | PRJNA725806 | 99456 | 197 | 11.14375 | 21.9531875 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 56.5 | 0.001 | NTclustered | gi|412977122|emb|AL132898.3| | 6239 | g99154 | i0 | 100 | 0.304568527918782 | 30 | 0 | 15 | 0 | 100 | 129 | 104662 | 104633 | Caenorhabditis elegans YAC Y59A8B, complete sequence | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 21114309 | 21114309 | PRJNA725806_P_NODE_126157_length_180_cov_15.000000_g125855_i0 | PRJNA725806 | 126157 | 180 | 15 | 27 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 62.1 | 2.54e-5 | NTclustered | gi|2158422651|ref|XM_045237862.1| | 6238 | g125855 | i0 | 94.872 | 0.433333333333333 | 39 | 2 | 22 | 0 | 72 | 110 | 1573 | 1535 | Caenorhabditis briggsae Protein CBR-MEC-1 (Cbr-mec-1), partial mRNA | blastn | 78 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 22389407 | 22389407 | PRJNA725806_P_NODE_67978_length_225_cov_6.441489_g67677_i0 | PRJNA725806 | 67978 | 225 | 6.441489 | 14.49335025 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 58.4 | 4.3e-4 | NTclustered | gi|687022696|emb|LM525610.1| | 174720 | g67677 | i0 | 94.737 | 0.168888888888889 | 38 | 1 | 16 | 1 | 174 | 210 | 27990 | 28027 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000020 | blastn | 38 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 22389477 | 22389477 | PRJNA725806_P_NODE_91358_length_204_cov_1.520958_g91056_i0 | PRJNA725806 | 91358 | 204 | 1.520958 | 3.10275432 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 56.5 | 0.001 | NTclustered | gi|412976773|emb|AL032654.2| | 6239 | g91056 | i0 | 96.97 | 0.308823529411765 | 33 | 1 | 16 | 0 | 79 | 111 | 71348 | 71316 | Caenorhabditis elegans YAC Y52B11A, complete sequence | blastn | 63 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 23664783 | 23664783 | PRJNA725806_P_NODE_137139_length_175_cov_1.608696_g136837_i0 | PRJNA725806 | 137139 | 175 | 1.608696 | 2.815218 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.015 | NTclustered | gi|690018606|emb|LM525844.1| | 174720 | g136837 | i0 | 100 | 0.16 | 28 | 0 | 16 | 0 | 57 | 84 | 20243 | 20216 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000223 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus |
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);;