contig_metadata
15 rows where bioproject = "PRJNA983838", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4792748 | 4792748 | PRJNA983838_P_NODE_110724_length_248_cov_0.891429_g108357_i0 | PRJNA983838 | 110724 | 248 | 0.891429 | 2.21074392 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 459 | 1.13e-124 | NTclustered | gi|922582372|ref|NR_132584.1| | 6239 | g108357 | i0 | 100 | 7.00806451612903 | 248 | 0 | 100 | 0 | 1 | 248 | 956 | 709 | Caenorhabditis elegans Non-coding transcript of protein-coding gene plpp-1.2 (plpp-1.2), miscRNA | blastn | 1738 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 4792858 | 4792858 | PRJNA983838_P_NODE_116804_length_243_cov_1.835294_g114437_i0 | PRJNA983838 | 116804 | 243 | 1.835294 | 4.45976442 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 449 | 6.65e-122 | NTclustered | gi|1972267560|ref|NM_070234.7| | 6239 | g114437 | i0 | 100 | 3.0082304526749 | 243 | 0 | 100 | 0 | 1 | 243 | 271 | 29 | Caenorhabditis elegans UPF0375 protein ule-4 (ule-4), mRNA | blastn | 731 | 449 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 6068051 | 6068051 | PRJNA983838_P_NODE_112845_length_246_cov_1.803468_g110478_i0 | PRJNA983838 | 112845 | 246 | 1.803468 | 4.43653128 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 449 | 6.74e-122 | NTclustered | gi|6923|emb|X56212.1| | 6239 | g110478 | i0 | 99.593 | 11.3130081300813 | 246 | 1 | 100 | 0 | 1 | 246 | 669 | 914 | C.elegans gene for vitellogenin | blastn | 2783 | 449 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 6068997 | 6068997 | PRJNA983838_P_NODE_75745_length_312_cov_2.301255_g73378_i0 | PRJNA983838 | 75745 | 312 | 2.301255 | 7.1799156 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 577 | 3.89e-160 | NTclustered | gi|1972265609|ref|NM_066610.8| | 6239 | g73378 | i0 | 100 | 5.83653846153846 | 312 | 0 | 100 | 0 | 1 | 312 | 525 | 214 | Caenorhabditis elegans Fatty-acid and retinol-binding protein 2 (far-2), mRNA | blastn | 1821 | 577 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 8617811 | 8617811 | PRJNA983838_P_NODE_115947_length_244_cov_0.912281_g113580_i0 | PRJNA983838 | 115947 | 244 | 0.912281 | 2.22596564 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 451 | 1.86e-122 | NTclustered | gi|1972230411|ref|NM_059657.6| | 6239 | g113580 | i0 | 100 | 3 | 244 | 0 | 100 | 0 | 1 | 244 | 220 | 463 | Caenorhabditis elegans putative prefoldin subunit 6 (pfd-6), mRNA | blastn | 732 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 13719317 | 13719317 | PRJNA983838_P_NODE_75631_length_312_cov_3.895397_g73264_i0 | PRJNA983838 | 75631 | 312 | 3.895397 | 12.15363864 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 577 | 3.89e-160 | NTclustered | gi|1831519982|ref|NM_001380933.1| | 6239 | g73264 | i0 | 100 | 21.6410256410256 | 312 | 0 | 100 | 0 | 1 | 312 | 4480 | 4169 | Caenorhabditis elegans Vitellogenin-3 (vit-3), mRNA | blastn | 6752 | 577 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 13719433 | 13719433 | PRJNA983838_P_NODE_82391_length_294_cov_1.357466_g80024_i0 | PRJNA983838 | 82391 | 294 | 1.357466 | 3.99095004 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 544 | 3.69e-150 | NTclustered | gi|687865758|emb|LK927604.1| | 6239 | g80024 | i0 | 100 | 3.87414965986395 | 294 | 0 | 100 | 0 | 1 | 294 | 109626 | 109919 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000069 | blastn | 1139 | 544 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 13719715 | 13719715 | PRJNA983838_P_NODE_98651_length_262_cov_1.640212_g96284_i0 | PRJNA983838 | 98651 | 262 | 1.640212 | 4.29735544 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 481 | 2.57e-131 | NTclustered | gi|1972294089|ref|NM_001047635.7| | 6239 | g96284 | i0 | 100 | 6.99236641221374 | 260 | 0 | 99 | 0 | 1 | 260 | 1074 | 815 | Caenorhabditis elegans putative elongation factor 1-gamma (eef-1G), partial mRNA | blastn | 1832 | 481 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 14025229 | 14025229 | PRJNA983838_P_NODE_51731_length_418_cov_5.675362_g49364_i0 | PRJNA983838 | 51731 | 418 | 5.675362 | 23.72301316 | Caenorhabditis | 6237 | Nematoda | Nematoda | 320 | 9.99e-83 | NTclustered | gi|268559799|ref|XM_002646027.1| | 6238 | g49364 | i0 | 86.598 | 71.6555023923445 | 291 | 37 | 69 | 2 | 126 | 415 | 1307 | 1018 | Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA | blastn | 29952 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 14992572 | 14992572 | PRJNA983838_P_NODE_107772_length_250_cov_1.757062_g105405_i0 | PRJNA983838 | 107772 | 250 | 1.757062 | 4.392655 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 462 | 8.83e-126 | NTclustered | gi|1734340879|ref|NM_077518.5| | 6239 | g105405 | i0 | 100 | 2.972 | 250 | 0 | 100 | 0 | 1 | 250 | 4856 | 5105 | Caenorhabditis elegans C-type LECtin (T25C12.3), mRNA | blastn | 743 | 462 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 18817240 | 18817240 | PRJNA983838_P_NODE_64955_length_350_cov_1.516245_g62588_i0 | PRJNA983838 | 64955 | 350 | 1.516245 | 5.3068575 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 641 | 1.5399999999999996e-179 | NTclustered | gi|1972230085|ref|NM_059543.8| | 6239 | g62588 | i0 | 99.714 | 23.9342857142857 | 350 | 1 | 100 | 0 | 1 | 350 | 357 | 8 | Caenorhabditis elegans Large ribosomal subunit protein P2 (rplp-2.1), mRNA | blastn | 8377 | 641 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 21367997 | 21367997 | PRJNA983838_P_NODE_84057_length_290_cov_1.437788_g81690_i0 | PRJNA983838 | 84057 | 290 | 1.437788 | 4.1695852 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 536 | 6.079999999999999e-148 | NTclustered | gi|351059519|emb|FO080771.1| | 6239 | g81690 | i0 | 100 | 3 | 290 | 0 | 100 | 0 | 1 | 290 | 32951 | 33240 | Caenorhabditis elegans Cosmid C42D4, complete sequence | blastn | 870 | 536 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 22643013 | 22643013 | PRJNA983838_P_NODE_88458_length_281_cov_1.365385_g86091_i0 | PRJNA983838 | 88458 | 281 | 1.365385 | 3.83673185 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 520 | 5.909999999999999e-143 | NTclustered | gi|1972262849|ref|NM_065559.8| | 6239 | g86091 | i0 | 100 | 3.02135231316726 | 281 | 0 | 100 | 0 | 1 | 281 | 165 | 445 | Caenorhabditis elegans Rad60/SUMO-like domain-containing protein (T04A8.8), mRNA | blastn | 849 | 520 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 23917287 | 23917287 | PRJNA983838_P_NODE_109219_length_249_cov_1.318182_g106852_i0 | PRJNA983838 | 109219 | 249 | 1.318182 | 3.28227318 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 460 | 3.16e-125 | NTclustered | gi|1972266897|ref|NM_001028103.4| | 6239 | g106852 | i0 | 100 | 5.94779116465863 | 249 | 0 | 100 | 0 | 1 | 249 | 4895 | 4647 | Caenorhabditis elegans Vitellogenin-6 (vit-6), mRNA | blastn | 1481 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25497840 | 25497840 | PRJNA983838_P_NODE_32400_length_623_cov_2.800000_g30066_i0 | PRJNA983838 | 32400 | 623 | 2.8 | 17.444 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 298 | 6.02e-100 | NR | XP_003139952.1 | 7209 | g30066 | i0 | 69.5 | 29.9373996789727 | 200 | 61 | 96.3 | 0 | 605 | 6 | 1 | 200 | XP_003139952.1 50S ribosomal protein L16 [Loa loa] | diamond | 18651 | 301 | 0.990033222591362 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa |
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);;