contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA728642" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 713004 | 713004 | PRJNA728642_P_NODE_9581_length_328_cov_5.839216_g9310_i0 | PRJNA728642 | 9581 | 328 | 5.839216 | 19.15262848 | Naegleria australiensis | 51634 | Heterolobosea | other_Eukaryota | 590 | 5.29e-164 | NTclustered | gi|2476253407|gb|OQ627480.1| | 51634 | g9310 | i0 | 99.689 | 43.6585365853659 | 322 | 1 | 98 | 0 | 7 | 328 | 2664 | 2343 | Naegleria australiensis strain PP397 rDNA-containing extrachromosomal element genomic sequence; small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and non-ribosomal sequence | blastn | 14320 | 590 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria australiensis | ||||
| 3264298 | 3264298 | PRJNA728642_P_NODE_7143_length_383_cov_0.993548_g6872_i0 | PRJNA728642 | 7143 | 383 | 0.993548 | 3.80528884 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 617 | 2.8699999999999997e-172 | NTclustered | gi|11466174|ref|NC_002573.1| | 5762 | g6872 | i0 | 95.833 | 1.00261096605744 | 384 | 13 | 100 | 3 | 1 | 383 | 525 | 144 | Naegleria gruberi mitochondrion, complete genome | blastn | 384 | 617 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 5023116 | 5023116 | PRJNA728642_P_NODE_12204_length_288_cov_2.148837_g11933_i0 | PRJNA728642 | 12204 | 288 | 2.148837 | 6.18865056 | Allovahlkampfia | 1217108 | Heterolobosea | other_Eukaryota | 516 | 7.86e-142 | NTclustered | gi|198250379|gb|EU696948.1| | 556273 | g11933 | i0 | 98.958 | 76.1631944444444 | 288 | 3 | 100 | 0 | 1 | 288 | 1253 | 966 | Allovahlkampfia spelaea strain SK1 18S ribosomal RNA gene, complete sequence | blastn | 21935 | 516 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia spelaea | ||||
| 8365991 | 8365991 | PRJNA728642_P_NODE_12227_length_288_cov_1.432558_g11956_i0 | PRJNA728642 | 12227 | 288 | 1.432558 | 4.12576704 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 488 | 1.7099999999999998e-133 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g11956 | i0 | 97.232 | 59.4791666666667 | 289 | 6 | 100 | 2 | 1 | 288 | 3082 | 2795 | Allovahlkampfia sp. isolate S28D2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17130 | 488 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 12674420 | 12674420 | PRJNA728642_P_NODE_12110_length_289_cov_2.138889_g11839_i0 | PRJNA728642 | 12110 | 289 | 2.138889 | 6.18138921 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 529 | 1.01e-145 | NTclustered | gi|2618963742|gb|OR769034.1| | 5762 | g11839 | i0 | 99.654 | 10.1280276816609 | 289 | 1 | 100 | 0 | 1 | 289 | 5794 | 5506 | Naegleria gruberi strain NEG-M rDNA-containing extrachromosomal element genomic sequence; and 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 2927 | 529 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13466717 | 13466717 | PRJNA728642_P_NODE_7451_length_375_cov_0.956954_g7180_i0 | PRJNA728642 | 7451 | 375 | 0.956954 | 3.5885775 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 680 | 0 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g7180 | i0 | 99.465 | 56.0186666666667 | 374 | 2 | 99 | 0 | 1 | 374 | 3427 | 3054 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 21007 | 680 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 17290810 | 17290810 | PRJNA728642_P_NODE_15374_length_255_cov_0.917582_g15103_i0 | PRJNA728642 | 15374 | 255 | 0.917582 | 2.3398341 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 355 | 1.58e-93 | NTclustered | gi|290987763|ref|XM_002676546.1| | 5762 | g15103 | i0 | 92.4 | 190.058823529412 | 250 | 17 | 98 | 2 | 1 | 249 | 280 | 32 | Naegleria gruberi polyubiquitin (NAEGRDRAFT_55791), mRNA | blastn | 48465 | 355 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 18564450 | 18564450 | PRJNA728642_P_NODE_10935_length_306_cov_1.708155_g10664_i0 | PRJNA728642 | 10935 | 306 | 1.708155 | 5.2269543 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 459 | 1.4399999999999999e-124 | NTclustered | gi|2651357779|gb|PP174295.1| | 1874883 | g10664 | i0 | 93.791 | 5.56862745098039 | 306 | 17 | 100 | 2 | 1 | 306 | 3614 | 3917 | Allovahlkampfia sp. isolate P10 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1704 | 459 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 18564529 | 18564529 | PRJNA728642_P_NODE_14995_length_258_cov_5.464865_g14724_i0 | PRJNA728642 | 14995 | 258 | 5.464865 | 14.0993517 | Allovahlkampfia sp. strain SO/1P | 500012 | Heterolobosea | other_Eukaryota | 477 | 3.2699999999999985e-130 | NTclustered | gi|529154115|gb|EU266548.2| | 500012 | g14724 | i0 | 100 | 71.7945736434109 | 258 | 0 | 100 | 0 | 1 | 258 | 1711 | 1454 | Allovahlkampfia sp. strain SO/1P small subunit ribosomal RNA gene, complete sequence | blastn | 18523 | 477 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. strain SO/1P | ||||
| 19839990 | 19839990 | PRJNA728642_P_NODE_9216_length_335_cov_1.396947_g8945_i0 | PRJNA728642 | 9216 | 335 | 1.396947 | 4.67977245 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 346 | 1.2899999999999999e-90 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g8945 | i0 | 85.46 | 3.85671641791045 | 337 | 44 | 100 | 2 | 1 | 335 | 2423 | 2756 | Allovahlkampfia sp. isolate S28D2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1292 | 346 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 20321299 | 20321299 | PRJNA728642_P_NODE_10616_length_311_cov_1.382353_g10345_i0 | PRJNA728642 | 10616 | 311 | 1.382353 | 4.29911783 | Allovahlkampfia | 1217108 | Heterolobosea | other_Eukaryota | 540 | 5.09e-149 | NTclustered | gi|529154115|gb|EU266548.2| | 500012 | g10345 | i0 | 98.077 | 25.7942122186495 | 312 | 3 | 100 | 3 | 1 | 311 | 461 | 152 | Allovahlkampfia sp. strain SO/1P small subunit ribosomal RNA gene, complete sequence | blastn | 8022 | 540 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. strain SO/1P |
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);;