contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3074976 | 3074976 | PRJNA556992_P_NODE_125143_length_378_cov_5.554098_g122956_i0 | PRJNA556992 | 125143 | 378 | 5.554098 | 20.99449044 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 52.8 | 0.036 | NTclustered | gi|2158436204|ref|XM_045240039.1| | 6238 | g122956 | i0 | 100 | 0.0740740740740741 | 28 | 0 | 7 | 0 | 5 | 32 | 1803 | 1776 | Caenorhabditis briggsae Protein CBG27839 (CBG27839), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 5630407 | 5630407 | PRJNA556992_P_NODE_277045_length_294_cov_1.832579_g274856_i0 | PRJNA556992 | 277045 | 294 | 1.832579 | 5.38778226 | Oscheius dolichura | 473156 | Nematoda | Nematoda | 544 | 3.69e-150 | NTclustered | gi|300379472|gb|HM355811.1| | 473156 | g274856 | i0 | 100 | 62.3503401360544 | 294 | 0 | 100 | 0 | 1 | 294 | 2633 | 2926 | Oscheius dolichura isolate LDY30 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 18331 | 544 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius dolichura | |
| 6229115 | 6229115 | PRJNA556992_P_NODE_220305_length_316_cov_4.707819_g218117_i0 | PRJNA556992 | 220305 | 316 | 4.707819 | 14.87670804 | Caenorhabditis | 6237 | Nematoda | Nematoda | 584 | 2.359999999999999e-162 | NTclustered | gi|2500298834|gb|OQ921601.1| | 6238 | g218117 | i0 | 100 | 100.914556962025 | 316 | 0 | 100 | 0 | 1 | 316 | 377 | 62 | Caenorhabditis briggsae strain CFB270 small subunit ribosomal RNA gene, partial sequence | blastn | 31889 | 584 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 9453774 | 9453774 | PRJNA556992_P_NODE_201708_length_326_cov_2.525692_g199520_i0 | PRJNA556992 | 201708 | 326 | 2.525692 | 8.23375592 | Meloidogyne incognita | 6306 | Nematoda | Nematoda | 555 | 1.9199999999999994e-153 | NTclustered | gi|18147017|dbj|AB047764.1| | 6306 | g199520 | i0 | 97.531 | 50.6748466257669 | 324 | 8 | 99 | 0 | 1 | 324 | 972 | 649 | Meloidogyne incognita DNA, polymorphic marker for virulence, isolate:MIGD-VI | blastn | 16520 | 555 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne incognita | |
| 12010352 | 12010352 | PRJNA556992_P_NODE_65830_length_464_cov_0.923274_g63658_i0 | PRJNA556992 | 65830 | 464 | 0.923274 | 4.28399136 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 52.8 | 0.045 | NTclustered | gi|1376136953|ref|XM_024648592.1| | 34506 | g63658 | i0 | 100 | 0.0603448275862069 | 28 | 0 | 6 | 0 | 94 | 121 | 1530 | 1503 | Strongyloides ratti Hypothetical protein (SRAE_1000161400), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 13879168 | 13879168 | PRJNA556992_P_NODE_17451_length_807_cov_1.713896_g15618_i0 | PRJNA556992 | 17451 | 807 | 1.713896 | 13.83114072 | Metazoa | 33208 | Nematoda | Nematoda | 1469 | 0 | NTclustered | gi|158821895|gb|EU195959.1| | 479134 | g15618 | i0 | 99.504 | 84.0483271375465 | 807 | 2 | 100 | 2 | 1 | 807 | 1546 | 2350 | Diploscapter sp. JU359 28S ribosomal RNA gene, partial sequence | blastn | 67827 | 1480 | 0.992567567567568 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. JU359 | |
| 15152962 | 15152962 | PRJNA556992_P_NODE_123492_length_380_cov_2.208469_g121305_i0 | PRJNA556992 | 123492 | 380 | 2.208469 | 8.3921822 | Metazoa | 33208 | Nematoda | Nematoda | 697 | 0 | NTclustered | gi|158821895|gb|EU195959.1| | 479134 | g121305 | i0 | 99.737 | 76.8631578947368 | 380 | 1 | 100 | 0 | 1 | 380 | 990 | 611 | Diploscapter sp. JU359 28S ribosomal RNA gene, partial sequence | blastn | 29208 | 697 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. JU359 | |
| 17111493 | 17111493 | PRJNA556992_P_NODE_842714_length_244_cov_0.877193_g840524_i0 | PRJNA556992 | 842714 | 244 | 0.877193 | 2.14035092 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|145279689|gb|AC189672.3| | 6334 | g840524 | i0 | 100 | 0.122950819672131 | 30 | 0 | 12 | 0 | 115 | 144 | 47281 | 47310 | Trichinella spiralis BAC clone TS195-18H12 from chromosome unknown, complete sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 19652717 | 19652717 | PRJNA556992_P_NODE_265136_length_298_cov_3.795556_g262947_i0 | PRJNA556992 | 265136 | 298 | 3.795556 | 11.31075688 | Plectus minimus | 446301 | Nematoda | Nematoda | 399 | 8.589999999999998e-107 | NTclustered | gi|148614851|gb|EF417148.1| | 446301 | g262947 | i0 | 90.97 | 23.3825503355705 | 299 | 24 | 100 | 3 | 1 | 298 | 406 | 702 | Plectus minimus large subunit ribosomal RNA gene, partial sequence | blastn | 6968 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Plectida | Plectidae | Plectus | Plectus minimus | |
| 19655419 | 19655419 | PRJNA556992_P_NODE_46936_length_525_cov_2.789823_g44778_i0 | PRJNA556992 | 46936 | 525 | 2.789823 | 14.64657075 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 381 | 5.779999999999999e-101 | NTclustered | gi|1376154927|ref|XM_024651418.1| | 34506 | g44778 | i0 | 83.831 | 96.6685714285714 | 402 | 63 | 76 | 2 | 48 | 448 | 1 | 401 | Strongyloides ratti Histone H3 (SRAE_X000165500), partial mRNA | blastn | 50751 | 381 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 19658982 | 19658982 | PRJNA556992_P_NODE_756516_length_248_cov_2.034286_g754327_i0 | PRJNA556992 | 756516 | 248 | 2.034286 | 5.04502928 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 89.8 | 1.71e-13 | NTclustered | gi|1376152387|ref|XM_024644732.1| | 34506 | g754327 | i0 | 92.063 | 0.520161290322581 | 63 | 5 | 25 | 0 | 31 | 93 | 297 | 359 | Strongyloides ratti Peptidyl-prolyl cis-trans isomerase B (SRAE_X000039200), partial mRNA | blastn | 129 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 20931910 | 20931910 | PRJNA556992_P_NODE_532137_length_264_cov_3.178010_g529948_i0 | PRJNA556992 | 532137 | 264 | 3.17801 | 8.3899464 | Necator americanus | 51031 | Nematoda | Nematoda | 54.7 | 0.007 | NTclustered | gi|2707546240|ref|XM_064179716.1| | 51031 | g529948 | i0 | 85.185 | 0.409090909090909 | 54 | 6 | 20 | 2 | 208 | 260 | 1816 | 1868 | Necator americanus uncharacterized protein (RB195_006559), partial mRNA | blastn | 108 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 23479098 | 23479098 | PRJNA556992_P_NODE_289799_length_290_cov_3.152074_g287610_i0 | PRJNA556992 | 289799 | 290 | 3.152074 | 9.1410146 | Meloidogyne arenaria | 6304 | Nematoda | Nematoda | 503 | 6.17e-138 | NTclustered | gi|18147020|dbj|AB047767.1| | 6304 | g287610 | i0 | 97.931 | 25.3551724137931 | 290 | 6 | 100 | 0 | 1 | 290 | 1275 | 986 | Meloidogyne arenaria DNA, polymorphic marker for virulence, isolate:MAMG-AV | blastn | 7353 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne arenaria | |
| 23480242 | 23480242 | PRJNA556992_P_NODE_371619_length_279_cov_6.242718_g369430_i0 | PRJNA556992 | 371619 | 279 | 6.242718 | 17.41718322 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 510 | 3.5299999999999996e-140 | NTclustered | gi|11094896|gb|AC084446.1|AC084446 | 6238 | g369430 | i0 | 99.642 | 19.3333333333333 | 279 | 1 | 100 | 0 | 1 | 279 | 16497 | 16219 | Caenorhabditis briggsae cosmid CB018G16, complete sequence | blastn | 5394 | 510 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 24754113 | 24754113 | PRJNA556992_P_NODE_371120_length_280_cov_1.053140_g368931_i0 | PRJNA556992 | 371120 | 280 | 1.05314 | 2.948792 | Bursaphelenchus kiyoharai | 913098 | Nematoda | Nematoda | 100 | 9.08e-17 | NTclustered | gi|354681840|dbj|AB597253.1| | 913098 | g368931 | i0 | 83.186 | 20.5142857142857 | 113 | 16 | 40 | 3 | 158 | 269 | 962 | 852 | Bursaphelenchus sp. NK-2010b gene for 18S ribosomal RNA, partial sequence, strain: NK221 | blastn | 5744 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus kiyoharai |
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);;