contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6356774 | 6356774 | PRJNA928559_P_NODE_148145_length_290_cov_0.843318_g146576_i0 | PRJNA928559 | 148145 | 290 | 0.843318 | 2.4456222 | root | 1 | Root_unresolved | Root_unresolved | 335 | 2.379999999999999e-87 | NTclustered | gi|18147015|dbj|AB047762.1| | 6303 | g146576 | i0 | 87.986 | 40.8344827586207 | 283 | 34 | 98 | 0 | 8 | 290 | 482 | 200 | Meloidogyne javanica DNA, polymorphic marker for virulence, isolate:MJON-VI | blastn | 11842 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne javanica | |
| 7282120 | 7282120 | PRJNA928559_P_NODE_46806_length_497_cov_3.226415_g45244_i0 | PRJNA928559 | 46806 | 497 | 3.226415 | 16.03528255 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 292 | 2.63e-74 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g45244 | i0 | 81.492 | 5.22736418511066 | 362 | 61 | 72 | 6 | 64 | 422 | 395 | 37 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2598 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 8554760 | 8554760 | PRJNA928559_P_NODE_101947_length_353_cov_2.378571_g100378_i0 | PRJNA928559 | 101947 | 353 | 2.378571 | 8.39635563 | Tylopharynx sp. WEM-2009 | 669147 | Nematoda | Nematoda | 219 | 3.1099999999999993e-52 | NTclustered | gi|256709136|gb|GQ422220.1| | 669147 | g100378 | i0 | 78.592 | 26.3767705382436 | 341 | 65 | 95 | 7 | 9 | 345 | 375 | 711 | Tylopharynx sp. WEM-2009 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 9311 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Tylopharyngidae | Tylopharynx | Tylopharynx sp. WEM-2009 | |
| 11107669 | 11107669 | PRJNA928559_P_NODE_49189_length_487_cov_100.483092_g47627_i0 | PRJNA928559 | 49189 | 487 | 100.483092 | 489.35265804 | Metarhabditis rainai | 2735107 | Nematoda | Nematoda | 124 | 9.92e-24 | NTclustered | gi|158821902|gb|EU195966.1| | 2735107 | g47627 | i0 | 78.404 | 14.1026694045175 | 213 | 30 | 42 | 15 | 284 | 487 | 3111 | 2906 | Metarhabditis rainai strain DF5091 28S ribosomal RNA gene, partial sequence | blastn | 6868 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Metarhabditis | Metarhabditis rainai | |
| 11456517 | 11456517 | PRJNA928559_P_NODE_154489_length_283_cov_1.561905_g152920_i0 | PRJNA928559 | 154489 | 283 | 1.561905 | 4.42019115 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1288864914|gb|KY468850.1| | 45934 | g152920 | i0 | 100 | 10.7420494699647 | 29 | 0 | 10 | 0 | 190 | 218 | 435 | 407 | Pratylenchus crenatus isolate D12-3 28S ribosomal RNA gene, partial sequence | blastn | 3040 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus crenatus | |
| 16205415 | 16205415 | PRJNA928559_P_NODE_138873_length_300_cov_2.207048_g137304_i0 | PRJNA928559 | 138873 | 300 | 2.207048 | 6.621144 | Meloidogyne javanica | 6303 | Nematoda | Nematoda | 381 | 3.1299999999999995e-101 | NTclustered | gi|18147019|dbj|AB047766.1| | 6303 | g137304 | i0 | 89.967 | 11.6233333333333 | 299 | 24 | 99 | 3 | 2 | 300 | 817 | 525 | Meloidogyne javanica DNA, polymorphic marker for virulence, isolate:MJON-AV | blastn | 3487 | 381 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne javanica | |
| 17482831 | 17482831 | PRJNA928559_P_NODE_93414_length_368_cov_18.105085_g91845_i0 | PRJNA928559 | 93414 | 368 | 18.105085 | 66.6267128 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 62.1 | 5.81e-5 | NTclustered | gi|1972228531|ref|NM_001383003.2| | 6239 | g91845 | i0 | 97.222 | 0.271739130434783 | 36 | 1 | 10 | 0 | 48 | 83 | 85 | 120 | Caenorhabditis elegans 60S ribosomal protein L41 (rpl-41.1), mRNA | blastn | 100 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 20029242 | 20029242 | PRJNA928559_P_NODE_153756_length_284_cov_1.336493_g152187_i0 | PRJNA928559 | 153756 | 284 | 1.336493 | 3.79564012 | Caenorhabditis sp. 21 LS-2015 | 1737332 | Nematoda | Nematoda | 134 | 9.1e-27 | NTclustered | gi|1465390354|emb|LS992474.1| | 1737332 | g152187 | i0 | 78.151 | 45.1408450704225 | 238 | 32 | 78 | 11 | 61 | 282 | 4214 | 3981 | Caenorhabditis sp. 21 LS-2015 partial 18S rRNA gene, strain NIC534 | blastn | 12820 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis sp. 21 LS-2015 | |
| 20029658 | 20029658 | PRJNA928559_P_NODE_182956_length_256_cov_3.923497_g181387_i0 | PRJNA928559 | 182956 | 256 | 3.923497 | 10.04415232 | Meloidogyne arenaria | 6304 | Nematoda | Nematoda | 468 | 1.95e-127 | NTclustered | gi|18147020|dbj|AB047767.1| | 6304 | g181387 | i0 | 99.609 | 45.8046875 | 256 | 1 | 100 | 0 | 1 | 256 | 1056 | 801 | Meloidogyne arenaria DNA, polymorphic marker for virulence, isolate:MAMG-AV | blastn | 11726 | 468 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne arenaria | |
| 20030845 | 20030845 | PRJNA928559_P_NODE_62796_length_440_cov_5.989101_g61227_i0 | PRJNA928559 | 62796 | 440 | 5.989101 | 26.3520444 | Pristionchus racemosae | 1756234 | Nematoda | Nematoda | 71.3 | 1.17e-7 | NTclustered | gi|953064353|gb|KT188888.1| | 1756234 | g61227 | i0 | 88.333 | 3.99090909090909 | 60 | 5 | 13 | 2 | 7 | 65 | 1981 | 1923 | Pristionchus racemosae 28S ribosomal RNA gene, partial sequence | blastn | 1756 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus racemosae | |
| 22930984 | 22930984 | PRJNA928559_P_NODE_80778_length_394_cov_4.654206_g79209_i0 | PRJNA928559 | 80778 | 394 | 4.654206 | 18.33757164 | root | 1 | Root_unresolved | Root_unresolved | 460 | 5.29e-125 | NTclustered | gi|18147015|dbj|AB047762.1| | 6303 | g79209 | i0 | 88.281 | 64.8883248730965 | 384 | 45 | 97 | 0 | 1 | 384 | 9 | 392 | Meloidogyne javanica DNA, polymorphic marker for virulence, isolate:MJON-VI | blastn | 25566 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne javanica | |
| 25130855 | 25130855 | PRJNA928559_P_NODE_98340_length_359_cov_6.335664_g96771_i0 | PRJNA928559 | 98340 | 359 | 6.335664 | 22.74503376 | Caenorhabditis plicata | 281681 | Nematoda | Nematoda | 167 | 1.16e-36 | NTclustered | gi|356605901|gb|JN636145.1| | 281681 | g96771 | i0 | 82.323 | 46.158774373259 | 198 | 29 | 55 | 6 | 164 | 359 | 3059 | 2866 | Caenorhabditis plicata strain SB355 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 16571 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis plicata |
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);;