contig_metadata
15 rows where bioproject = "PRJNA675042", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1168200 | 1168200 | PRJNA675042_P_NODE_41361_length_341_cov_0.970149_g40911_i0 | PRJNA675042 | 41361 | 341 | 0.970149 | 3.30820809 | Metazoa | 33208 | Nematoda | Nematoda | 52.8 | 0.032 | NTclustered | gi|690018845|emb|LM526138.1| | 174720 | g40911 | i0 | 100 | 1.29325513196481 | 28 | 0 | 8 | 0 | 256 | 283 | 11501 | 11528 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000495 | blastn | 441 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 4473752 | 4473752 | PRJNA675042_P_NODE_108744_length_251_cov_0.865169_g108294_i0 | PRJNA675042 | 108744 | 251 | 0.865169 | 2.17157419 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|687865308|emb|LK927579.1| | 6239 | g108294 | i0 | 100 | 0.223107569721116 | 28 | 0 | 11 | 0 | 215 | 242 | 91773 | 91746 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000046 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 9574473 | 9574473 | PRJNA675042_P_NODE_116108_length_250_cov_0.870056_g115658_i0 | PRJNA675042 | 116108 | 250 | 0.870056 | 2.17514 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|690019508|emb|LM527023.1| | 174720 | g115658 | i0 | 96.97 | 0.132 | 33 | 0 | 13 | 1 | 119 | 150 | 175 | 207 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0001362 | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 10851504 | 10851504 | PRJNA675042_P_NODE_84269_length_276_cov_0.817734_g83819_i0 | PRJNA675042 | 84269 | 276 | 0.817734 | 2.25694584 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.007 | NTclustered | gi|687022731|emb|LM525645.1| | 174720 | g83819 | i0 | 90.476 | 0.152173913043478 | 42 | 2 | 14 | 2 | 142 | 181 | 8113 | 8154 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000052 | blastn | 42 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 13399848 | 13399848 | PRJNA675042_P_NODE_107631_length_251_cov_0.865169_g107181_i0 | PRJNA675042 | 107631 | 251 | 0.865169 | 2.17157419 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 60.2 | 1.36e-4 | NTclustered | gi|690018778|emb|LM526074.1| | 174720 | g107181 | i0 | 100 | 0.127490039840637 | 32 | 0 | 13 | 0 | 179 | 210 | 5373 | 5342 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000436 | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 13400009 | 13400009 | PRJNA675042_P_NODE_121611_length_249_cov_0.875000_g121161_i0 | PRJNA675042 | 121611 | 249 | 0.875 | 2.17875 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|687022762|emb|LM525676.1| | 174720 | g121161 | i0 | 96.774 | 0.124497991967871 | 31 | 1 | 12 | 0 | 51 | 81 | 46288 | 46318 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000074 | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 13400860 | 13400860 | PRJNA675042_P_NODE_29631_length_374_cov_1.023256_g29181_i0 | PRJNA675042 | 29631 | 374 | 1.023256 | 3.82697744 | Cylicocyclus auriculatus | 71428 | Nematoda | Nematoda | 52.8 | 0.036 | NTclustered | gi|1707510884|ref|NC_043849.1| | 71428 | g29181 | i0 | 100 | 0.0748663101604278 | 28 | 0 | 7 | 0 | 18 | 45 | 5251 | 5278 | Cylicocyclus auriculatus mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Cylicocyclus | Cylicocyclus auriculatus | |
| 14675654 | 14675654 | PRJNA675042_P_NODE_177292_length_241_cov_0.916667_g176842_i0 | PRJNA675042 | 177292 | 241 | 0.916667 | 2.20916747 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.022 | NTclustered | gi|687022675|emb|LM525589.1| | 174720 | g176842 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 107 | 134 | 9226 | 9253 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000012 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 17746254 | 17746254 | PRJNA675042_P_NODE_78474_length_282_cov_5.612440_g78024_i0 | PRJNA675042 | 78474 | 282 | 5.61244 | 15.8270808 | Rhabditida | 6236 | Nematoda | Nematoda | 119 | 2.5300000000000003e-22 | NTclustered | gi|2547219|gb|AF023856.1|AF023856 | 6304 | g78024 | i0 | 97.143 | 18.9255319148936 | 70 | 2 | 25 | 0 | 6 | 75 | 420 | 489 | Meloidogyne arenaria | blastn | 5337 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne arenaria | |
| 19772827 | 19772827 | PRJNA675042_P_NODE_120416_length_249_cov_0.875000_g119966_i0 | PRJNA675042 | 120416 | 249 | 0.875 | 2.17875 | Spirocerca lupi | 304461 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|482651442|ref|NC_021135.1| | 304461 | g119966 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 118 | 145 | 5576 | 5603 | Spirocerca lupi mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Thelaziidae | Spirocerca | Spirocerca lupi | |
| 21049133 | 21049133 | PRJNA675042_P_NODE_180477_length_241_cov_0.916667_g180027_i0 | PRJNA675042 | 180477 | 241 | 0.916667 | 2.20916747 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|690018478|emb|LM525716.1| | 174720 | g180027 | i0 | 100 | 0.120331950207469 | 29 | 0 | 12 | 0 | 195 | 223 | 34946 | 34974 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000112 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 22323182 | 22323182 | PRJNA675042_P_NODE_110218_length_251_cov_0.865169_g109768_i0 | PRJNA675042 | 110218 | 251 | 0.865169 | 2.17157419 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|687022647|emb|LM525561.1| | 174720 | g109768 | i0 | 100 | 0.227091633466135 | 29 | 0 | 12 | 0 | 153 | 181 | 139482 | 139510 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000006 | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 22324750 | 22324750 | PRJNA675042_P_NODE_72398_length_290_cov_1.092166_g71948_i0 | PRJNA675042 | 72398 | 290 | 1.092166 | 3.1672814 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.027 | NTclustered | gi|687022764|emb|LM525678.1| | 174720 | g71948 | i0 | 94.286 | 0.120689655172414 | 35 | 1 | 12 | 1 | 112 | 146 | 20278 | 20311 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000076 | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 22324816 | 22324816 | PRJNA675042_P_NODE_77338_length_284_cov_1.094787_g76888_i0 | PRJNA675042 | 77338 | 284 | 1.094787 | 3.10919508 | Trichostrongylus vitrinus | 40352 | Nematoda | Nematoda | 52.8 | 0.026 | NTclustered | gi|288900692|ref|NC_013807.1| | 40352 | g76888 | i0 | 100 | 0.0985915492957746 | 28 | 0 | 10 | 0 | 249 | 276 | 6308 | 6335 | Trichostrongylus vitrinus mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Trichostrongylus | Trichostrongylus vitrinus | |
| 24872640 | 24872640 | PRJNA675042_P_NODE_168820_length_242_cov_0.911243_g168370_i0 | PRJNA675042 | 168820 | 242 | 0.911243 | 2.20520806 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|690018572|emb|LM525810.1| | 174720 | g168370 | i0 | 96.875 | 0.132231404958678 | 32 | 1 | 13 | 0 | 211 | 242 | 33699 | 33730 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000194 | blastn | 32 | 54.7 | 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);;